In SAP Business ByDesign, when activating the Intrastat Work Center, there is a possibility to upload the commodity catalog in addition to maintain it manually.
There are partners that provide complete commodity catalogs in the most actual version.
However, if you only have a certain number of dedicated commodity codes, you might want to upload it on your own.
As described in the Online Help the xml-format is the supported file format for uploading.
So, I listed a sample code below. You can use it for reference and maintain it with any xml editor of your choice.
The code example contains:
- Setting the measurements
- Providing the Hierarchy Levels and the underlying 8-digit codes with the parent reference
- Providing 8-digit codes without hierarchy level (last two examples)
- Providing examples with more than one language
<ForeignTradeCommodityCatalogue>
<CatalogueID>SOVA-2018</CatalogueID>
<TypeCode>1</TypeCode>
<ValidityStartDate>2018-01-01</ValidityStartDate>
<Description>
<Description languageCode="EN">English SOVA Liste 2018</Description>
</Description>
<MeasureUnit>
<MeasureUnitID>EA</MeasureUnitID>
<MeasureUnitCode>EA</MeasureUnitCode>
<MeasureUnitDescription>
<Description languageCode="EN">Each</Description>
</MeasureUnitDescription>
</MeasureUnit>
<Item>
<CustomsCommodityClassificationCode>27</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000002</CatalogueItemID>
<TypeCode>1</TypeCode>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">CHAPTER 27 - MINERAL FUELS, MINERAL OILS AND PRODUCTS OF THEIR DISTILLATION; BITUMINOUS SUBSTANCES; MINERAL WAXES</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>2710</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000003</CatalogueItemID>
<TypeCode>1</TypeCode>
<ParentCatalogueItemID>0000000002</ParentCatalogueItemID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="DE">Erdöl und Öl aus bituminösen Mineralien, ausgenommen rohe Öle; Zubereitungen mit einem Gehalt an Erdöl oder Öl aus bituminösen Mineralien von 70 GHT oder mehr, in denen diese Öle der Grundbestandteil sind, anderweit weder genannt noch inbegriffen; Ölabfälle</ContentText>
</BasicText>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Petroleum oils and oils obtained from bituminous minerals, other than crude; preparations not elsewhere specified or included, containing by weight 70 % or more of petroleum oils or of oils obtained from bituminous minerals, these oils being the basic constituents of the preparations; waste oils</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>271019</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000004</CatalogueItemID>
<TypeCode>1</TypeCode>
<ParentCatalogueItemID>0000000003</ParentCatalogueItemID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="DE">Andere .....</ContentText>
</BasicText>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Other</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>27101981</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000005</CatalogueItemID>
<TypeCode>1</TypeCode>
<MeasureUnitID>EA</MeasureUnitID>
<ParentCatalogueItemID>0000000004</ParentCatalogueItemID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Motor oils, compressor lube oils, turbine lube oils</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>27101999</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000006</CatalogueItemID>
<TypeCode>1</TypeCode>
<MeasureUnitID>EA</MeasureUnitID>
<ParentCatalogueItemID>0000000004</ParentCatalogueItemID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Lubricating oils and other heavy oils and preparations n.e.s., containing by weight greater than equals to 70% of petroleum oils or of oils obtained from bituminous minerals, these oils being the basic constituents of the preparations (excl. for undergoing chemical transformation)</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>32082090</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000007</CatalogueItemID>
<TypeCode>1</TypeCode>
<MeasureUnitID>EA</MeasureUnitID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Paints and varnishes, incl. enamels and lacquers, based on acrylic or vinyl polymers, dispersed or dissolved in a non-aqueous medium</ContentText>
</BasicText>
</Item>
<Item>
<CustomsCommodityClassificationCode>32149000</CustomsCommodityClassificationCode>
<CatalogueItemID>0000000008</CatalogueItemID>
<TypeCode>1</TypeCode>
<MeasureUnitID>EA</MeasureUnitID>
<BasicText>
<TypeCode>10052</TypeCode>
<ContentText languageCode="EN">Non-refractory surfacing preparations for facades, inside walls, floors, ceilings and the like</ContentText>
</BasicText>
</Item>
</ForeignTradeCommodityCatalogue>
