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

    • Consolidation Setup in Intercompany Solution

      To setup the consolidation process, perform the following tasks: Define the consolidation companies in the Intercompany Landscape application and set their Company Type as Consolidation. In the Administration Console, on the Company Registration ...

    • Deploy and initialize the intercompany integration solution

      To deploy and initialize the intercompany integration solution, in the Company Registration table (in the Administration Console, choose Setup → Landscape), choose the Deploy button. The Deployment Status table displays the progress and status of ...

    • Copy Initialization Setup in all branch companies

      Copy initialization setup allows user to perform the initialization setups in all branch companies from the intercompany administration console. This enables the user to perform initialization steps in one go in all branch companies there by ...

    • Monitoring and Managing Intercompany Landscape

      Intercompany Solution Cockpit The intercompany solution cockpit allows user to view all intercompany relevant information from the single screen. To open the cockpit, in the top menu bar of the Administration Console, choose the Cockpit option. The ...

    • Template for Mapping Master Data Records

      To download a Microsoft Excel template for mapping master data records, use the following steps: Note To use Microsoft Excel template, ensure that no key mapping data should start with hyphen (‐) In the top menu bar of the Administration Console, ...