Product Information
Migration Cockpit: How to correctly fill data into XML template
Hello S/4HANA Cloud Community,
I have observed that many customers have issues regarding XML filling. So, I decided to write this blog to share some important tips that can avoid many errors during the migration process. The below information is valid for all Migration Objects and should avoid losing time during the migration process.
When copying data to a sheet from Microsoft Excel, always right-click the relevant cell and choose the paste option ‘Values (V)‘. You should also refer to the KBA ##2692715 – Migration Cockpit: How to correctly fill data into XML template.
Please pay attention to the different data types, like date (for example 12/31/1998 to United States or 31.12.1998 to Germany) and number (enter numbers with decimals in the relevant country-specific format, for example 12.34 to United States or 12,34 to Germany. This information is described in the sheet “Introduction” in all templates, you should take a look on this sheet.
Do not make any changes to the structure of the migration template, as this will corrupt the structure of the XML migration template. Take care specifically:
• Do not delete, rename or change the order of any sheet in the migration template;
• Do not change the formatting of any cells;
• Do not use formulas;
• Do not hide, remove, or change the order of any of the columns in the migration template.
I hope this blog can be helpful!
Cheers,
Kelly
Thanks Kelly for sharing this useful information.
Hi Kelly, can we add the tips below?
Pay attention to the format of date, only the proper format following the xml file rule can be used otherwise this date cannot be migrated correctly.
Hi Eric, great point.
As described in the sheet "Introduction" for all Migration templates: "Enter the date in your country-specific format, for example 12/31/1998 (United States) or 31.12.1998 (Germany). Note that Microsoft Excel automatically recognizes different date formats and transforms them automatically to the correct XML format."
We have also other important tips in Introduction sheet!
Thanks a lot for improving this topic!
Thanks for your feendback Kelly Hannel , when I am dealing with migration issue from procure I noted some customers may miss this important tips in Introduction, so I think we can highlight it independently.
We ran into a similar issue 3 weeks back and you helped to nailed it down( if you remember) Thank you Kelly for putting this together! This blog can reference to many of our questions in the past and future:-)
Hello Amith Nair, sure I remember 🙂 Together we did a good job!