SAP Business ByDesign: Sample Commodity Catalog File to Upload

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>