Product Tax Classifications overrunning spreadsheet for DMC template

[hassett_lee]

Hi

I am creating materials /products using the Migration Cockpit. But with 27 countries associated to SORG i need to enter 27 rows per 1 material in the spreadsheet.
After building s/s with over 8000 materials, i dont have enough rows on the tax class page to populate all the tax classifications due to the 100k excel limit.

Splitting to three files is an option, but is a real pain …. I really need to load in excess of 15000 materials

Any ideas for options, i feel this must be a common issue?

many thanks

Lee

[denisminervino]

Hello Lee,

The XML file isn´t the only option, when you have this ammount of data, you can use third party tools to populate the staging tables. In this article you can read more about it:

https://blogs.sap.com/2019/12/02/sap-s-4-hana-migration-cockpit-migrating-data-using-staging-tables-...

[GitteGreibe]

Hi Lee

Maybe this blog can help you?
SAP S/4HANA migration cockpit – how to overcome file size limitation when uploading XML files | SAP ...

BR Gitte.

[denisminervino]

Excellent, it´s a good option too.