Key Mapping

Key Mapping


This step is mandatory if master data records already exist in the branch companies.
Some objects in SAP Business One have an internal primary key which differ from that displayed in SAP GUI (for example, freight, length and width UOM, weight UOM, payment terms, item group). To successfully replicate master data for these objects, the internal keys of all branch companies must be mapped to each other. 
Complete this step for all masters that have master data records existing in the registered SAP Business One companies.
Caution
Before initiating this step, you must manually ensure that all master data which are replicated by the intercompany integration solution have an equal number of records in each branch company (that is, identical records exist in each company).
Figure 1 shows an example of data recorded in key-mapped master records. 
 

Example
Three branch companies have the following freight: 


Freight



Company – IC001



Company – IC002



Company – IC003



AAA















BBB















CCC















DDD















EEE















FFF














To map the internal keys of the branch companies, you must create the following records:

Company – IC001
BBB
FFF

Company – IC002
EEE

Company – IC003
AAA

Once you perform this step for all key-mapped masters, you can start the key mapping step in the Administration Console.

Refer administration guide Appendix I for the list of masters replicated by the intercompany integration solution and Appendix II for field level details. 
See Appendix V for the list of all key mapping masters. 

Caution
Key Mapping master should not have special characters (! @# &*:;) in the description.

To undertake the key mapping procedure, perform the following steps:
Alternatively, key mapping can also be imported from a Microsoft Excel template.
  1. In the top menu bar of the Administration Console, choose the Setup option. In the left frame, choose the Key Mapping option.
  2. In case if you would like to import the data for particular company, choose the (…) (Browse) button next to Branch Company field in Process Company Data section.
  3. In the selection window, in the Choose entry field, select a company from the dropdown list. Alternatively, to import data from all branch companies, select ALL from the dropdown list and then choose the Select button. 
  4. In case, if you would like to import the data for particular object, select the object from the Object Name field. By default, ALL is displayed in this field.
  5. To Import the data, In the Process Company Data section, choose the Import Object Data button.
  6. To view the summary of import data status based on branch company and object selected above in Steps 3 and 4, choose the View Summary button.
  1. In Summary Report, Under Import Status, 
    1. field Not Initiated denotes that import process is not yet started for the object. 
    2. field N/A for any combination of branch and object denotes that key mapping data is not required to be imported. 
    3. Under Status field,
    4. hyphen (-) character denotes that import of data is not yet initiated for this object, 
    5. Consistent denotes that the imported data has same number of records for that object across all the participating companies and Inconsistent denotes that the imported data does not have same number of records for that object across all the participating companies.
  1. To view the details of import data status based on branch company and object selected above in Steps 3 and 4, choose the View Object Data button.
  2. In Object Summary, Under Import Status field
    1. Not Initiated denotes that import process is not yet started for the object
    2. N/A for any combination of branch and object denotes that key mapping data is not required to be imported. 
    3. Under Status field 
    4. hyphen (-) character denotes that import of data is not yet initiated for this object, 
    5. Consistent denotes that the imported data has same number of records for that object across all the participating companies and Inconsistent denotes that the imported data does not have same number of records for that object across all the participating companies.
  1. In case if you would like to view the existing Key Mapping data, go to the Keymapping Object Selection section.
  2. To view the summary of the existing Key Mapping data, choose Summary in the (…) (Browse) button next to Key Mapping Data View field and an object or ALL (for all objects) in the (…) (Browse) button next to Object Name – Object Id field. 
  3. To view the detail of the existing Key Mapping data, choose Detail in the (…) (Browse) button next to Key Mapping Data View field and an object in the (…) (Browse) button next to Object Name – Object Id field. Alternatively, select ALL from the dropdown list to map all objects simultaneously. 
  4. In case if you would like to perform the Key Mapping of the data, go to the Keymapping Object Selection section.
  5. Choose a branch company in the (…) (Browse) button next to Base Company field to act as a reference for the mapping of master data records.
  6. Choose Detail in the (…) (Browse) button next to Key Mapping Data View field and an object or ALL (for all objects) in the (…) (Browse) button next to Object Name – Object Id field. 
Note
By default, the head office (HO) company is preselected as the base company.
Recommendation
In case of cross localization, if there is a Brazil localization company, then choose any brazil localization company as a base company. 

    1. The Key Mapping Data table appears and displays the master data records for the base company.
    2. In the Key Mapping Data table, choose the (…) (Browse) button next to each branch code. 
    3. In the selection window, in the Choose entry field, select the matching record from the dropdown list. Repeat the procedure for all master data records.
    4. To automatically map records with matching display keys, choose the AutoMap button.

Recommendation
For best performance, run the AutoMap feature for each object.
  1. Choose the Save button.
  1. After you save the key mapping for the currency master, the Configure Currency Details window is displayed. Ensure that the currencies are synchronized successfully for all branch and consolidation companies. 
  2. The application may take some time to display the Configure Currency Details window.
  3. Repeat steps 2–16 for each object in the master record list.
  4. Be sure to perform key mapping for all new companies registered in the solution after implementation. 
  5. In Summary view, under Key Mapping Data section, in Keymapping Status field, 
    1. hyphen (-) character denotes that either key mapping data does not exist or is not required for this object.
    2. consistent denotes that key mapping data has been completed successfully for this object across all the participating companies and Inconsistent denotes that key mapping is still pending for this object across all the participating companies.
Caution
If you make any changes in the company template which is configured in the Company Details window (in the Administration Console, choose Setup → Landscape), be sure to do the key mapping for all new masters configured for replication in the company template.


    • Related Articles

    • Encryption Key Setup of Intercompany Solution

      This window enables you to set up a 16 digit encryption key which is used to encrypt the passwords saved in the intercompany setups. To display the Encryption key window, choose the Administration → Setup → Intercompany → Encryption key Encryption ...

    • B1i Server Details Setup of Intercompany Solution

      This window enables you to enter the B1i Server details. The details in this setup are used when running intercompany reports. Note This setup must be performed in all branch companies. To display the B1i Server Details window, ...

    • Define Average Rates Setup of Intercompany Solution

       Note This setup must be performed in the consolidation company. This window enables you to define the average currency exchange rates. This setup is only used in the consolidation company. When consolidating account balances are based on average ...

    • Account Classification Setup Tool of Intercompany Solution

      Enables you to map a G/L account to the account classifications defined in the system. This tool updates the Intercompany Account Classification by Balance Sheet and Account Classification by Profit & Loss Setup windows. To display the Account ...

    • Default Account Setup of Intercompany Solution

      The Default Accounts Setup window enables you to define the default accounts that are used when posting interbranch transactions. You must choose accounts that are defined as All Currencies accounts in the chart of accounts.  Note This setup must be ...