Product Information
Data Migration – Import mappings from Q to P system
Why Mapping values:
A migration object contains mapping information for the relevant fields, as well as any rules used to convert values that are migrated from source fields to target fields. The source file data values and target system field values need to be maintained and confirmed.
Example: The value in the source value column for country code is ‘Canada’ and the target column it has been truncated to ‘CAN’, because SAP S/4HANA allows a maximum of 3 characters for this field. But this does not match the format expected by SAP S/4HANA as this value is mapped to ISO codes for country code which is ‘CA’. Therefore, either change ‘CAN’ to ‘CA’ or select ‘CA’ from the target search list by selecting it from the value help options.
Considerations for moving Mappings to P system:
- Mappings are applied at migration project level
- All mappings are maintained andn confirmed in Q system
-
Data migration for all objects is completed successffully and validated
How to Export Mappings:
1. Click on the Export Content button
2. Click on Execute button and a .zip file will be generated, file could be found in Downloads folder
How to Import Mapping Values in P system:
1. Create new migration project
2. Make sure Mass Transfer ID is same as Q-system
3. Click on Import Content button and provide the file path for the generated file in Export mappings step above
4. Click on Execute and you should see a success message
5. Check the imported content under ‘Convert values’ step
Conclusion:
For large sets of mapping values to be maintained and confirmed, this could be a time-consuming task.
To save time and avoid human errors, the migration tool does provide a very nice feature to move mappings from Q to P system using Import/Export functions.
Very helpful and detailed - thank you for sharing, Sandeep!
Thanks Riwa.
Very interesting.
How do you find the performance when using mappings within the Migration Cockpit? We were warned off using this (by SAP) as it could have a detrimental impact on performance (this was on 1802). Would you recommend its use on a real project - or is it still better to do the data transformation on a separate tool prior to importing in the cockpit?
Would be interested to know what approach other customers have taken.
Good question - performance impact could be at 2 places
a. Import/Export itself could take a long time if number of mapping entries are huge
b. Transformation or mappings should be done in the source file in my opinion so that this can be directly re-used for data validation/reconciliation as well
However, you still need to confirm some of the mappings like ISO codes, country codes etc in the tool irrespective of they are same in the file or not. This task can be eliminated using import/export function in P system.
And yes i have used this in a customer project, data volumes were in range of 1000 records for few migraiton objects.
thanks for sharing...quite helpful.
Thanks!
Useful information. Thanks for sharing.
Thanks
Thanks for sharing!!