{"id":51453,"date":"2022-03-24T09:11:15","date_gmt":"2022-03-24T08:11:15","guid":{"rendered":"https:\/\/www.pikon.com\/blog\/s4hana-international-trade-massenupload-statistischer-warennummern\/"},"modified":"2025-05-28T16:44:15","modified_gmt":"2025-05-28T14:44:15","slug":"s4hana-international-trade-mass-upload-statistical-commodity-codes","status":"publish","type":"post","link":"https:\/\/www.pikon.com\/en\/blog\/s4hana-international-trade-mass-upload-statistical-commodity-codes\/","title":{"rendered":"Migration to SAP S\/4HANA: mass upload of commodity codes"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Data migration is always a hot topic when switching from SAP ECC to SAP S\/4HANA. Migrating customs-related data into the component SAP S\/4HANA International Trade is especially complicated: For most master data, SAP has provided a solution via the migration cockpit (SAP S\/4HANA 2021) or, in earlier S\/4HANA releases, via transaction LTMC. If you have maintained customs-related data such as commodity codes for Intrastat declarations and customs tariff numbers in your ECC system up until now, you will be affected by the replacement of the ECC Foreign Trade component with S\/4HANA International Trade. And up until now, there was no out-of-the-box migration tool available for migrating this data.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Mass upload of commodity codes for EU countries is obsolete<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

In an SAP ECC system, you were able to load commodity codes and the related descriptions to the system en masse in the SD foreign trade and customs sub-component with transaction VE94. According to SAP note 2267310 \u2013 Worklist for transition to SAP S\/4HANA \u2013 foreign trade (https:\/\/launchpad.support.sap.com\/#\/notes\/2267310<\/a>), we aren\u2019t just losing transaction VE94; we are losing all transactions for maintaining commodity codes.<\/p>

In a S\/4HANA system from release 1610, apps are available for maintaining commodity codes, however, these do not allow any mass upload. From SAP note 2432527 \u2013 KBA: S\/4HANA \u2013 Define Commodity Codes and (re-)classify products (https:\/\/launchpad.support.sap.com\/#\/notes\/2432527<\/a>) also shows that the data at table level is no longer saved in the previous ECC tables but in new tables. So, if you have built your own program for uploading commodity codes, you will need a new solution after a switch to S\/4HANA.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Initial mass upload of commodity codes under S\/4HANA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

What are your options for loading commodity codes to the system for data migration after a switch to SAP S\/4HANA?<\/p>

Option 1 is to create all commodity codes manually with the SAP FIORI app \u201cManage Commodity Codes\u201d. This may still be reasonable, up to a certain number of codes. However, this begs the question of whether it would be better to invest the time and the budget into a custom program that can also be used for future data migrations, as option 2.<\/p>

My colleagues and I were also faced with this problem for several S\/4HANA implementations. And our project teams chose option 2.<\/p>

You can find an approach for developing a custom program for migrating commodity codes in SAP Note 2458080 \u2013 KBA: S\/4HANA 1610 \u2013 Commodity Codes and (Re-)Classification without Fiori Apps (https:\/\/launchpad.support.sap.com\/#\/notes\/2458080<\/a>). Here, SAP recommends using the function modules \/SAPSLL\/API_COMCO_CLS_DISTR and \/SAPSLL\/API_COMCO_MD_DISTR, to maintain and allocate the commodity codes. There are restrictions to consider here, such as the fact that an automated creation of commodity codes only succeeds if you have defined the related numbering scheme with the type \u201cSAP GTS\u201d in customizing. This kind of custom program should only be used for the initial creation. We would be delighted to develop a migration program for you.\u00a0<\/p>

With release 2023 SP03, SAP provides the Launchpad app \u201cMass Upload Utility,\u201d<\/strong> a feature that enables the mass upload of statistical commodity codes in both on-premise and cloud systems. The upload is done via a generated CSV file and is language-dependent. Accordingly, a separate CSV file must be maintained and uploaded for each system language in use. We are happy to assist you with using this tool.
We would be happy to help you use this tool, contact us via the button below.<\/p>

As in other areas of the SAP S\/4HANA system, it\u2019s also worth keeping your eyes open for new apps and functions in new releases for International Trade as well. In any case, we will keep working on the topic of data migration so we can advise and support our customers in the best way possible.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Do you have further questions about S\/4HANA International Trade?\u200b<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Contact me or set up a web meeting. You are also welcome to write your question in the comment box at the end of the article.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\"Martina<\/a><\/figure>
Martina Ksinsik<\/div>
Customer Success Manager<\/div>
<\/i> +49 (0) 681 379 62 - 113<\/a><\/div>
<\/i> martina.ksinsik@pikon.com<\/a><\/div>

[borlabs-cookie id=\"active-campaign-email-marketing-form\" type=\"content-blocker\"]
<\/div>