Skip to Content

Upload File Format for Commodity Catalogs - Intrastat Declaration

Hello Team,

Can some one provide the upload file format for commodity catalogs for Intrastat declaration purpose?

We know the below prerequisites;

1. It is only possible to upload catalogs from SAP partners.

2. The system only supports the upload of .xml and .zip files. If a catalog to be uploaded exceeds 10 MB, then it must be uploaded as a .zip file. The system will then unzip the file automatically.

How to create commodity catalog through XML file? If not, is there any excel format to upload the commodity catalogs?

Best Regards,

Arun

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 08 at 09:39 AM

    Hello Arun

    I had the very same question this week during an implementation. I don't have an official specification, but I can paste the contents of a sample HTML file which worked for us. It successfully loaded into an 1805 ByD tenant:

    <ForeignTradeCommodityCatalogue>
    	<CatalogueID schemeID="" schemeVersionID="" schemeAgencyID="">SOVA-2018</CatalogueID>
    	<TypeCode>1</TypeCode>
    	<ValidityStartDate>2018-01-01</ValidityStartDate>
    	<Description>
    		<Description languageCode="DE">SOVA Liste 2018</Description>
    	</Description>
    	<MeasureUnit>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<MeasureUnitCode>EA</MeasureUnitCode>
    		<MeasureUnitDescription>
    			<Description languageCode="DE">Stück</Description>
    		</MeasureUnitDescription>
    	</MeasureUnit>
    	<Item>
    		<CustomsCommodityClassificationCode>01012990</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000001</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Pferde, lebend (ausg. reinrassige Zuchttiere und Schlachtpferde)</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Other</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01013000</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000002</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Esel, lebend</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Asses</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01019000</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000003</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Maultiere und Maulesel, lebend</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Other</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022110</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000004</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">F?rsen (weibliche Rinder, die noch nicht gekalbt haben) als reinrassige Zuchttiere</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Heifers (female bovines that have never calved)</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022130</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000005</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">K?he als reinrassige Zuchttiere</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Cows</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022190</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000006</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Hausrinder als reinrassige Zuchttiere (ausg. F?rsen und K?he)</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Other</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022905</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000007</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Hausrinder, lebend, der Untergattung Bibos oder Poephagus</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Of the sub-genus Bibos or of the sub-genus Poephagus</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022910</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000008</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Hausrinder, lebend, mit einem Gewicht von 80kg oder weniger (ausg. reinrassige Zuchttiere)</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">Of a weight not exceeding 80 kg</ContentText>
    		</BasicText>
    	</Item>
    	<Item>
    		<CustomsCommodityClassificationCode>01022921</CustomsCommodityClassificationCode>
    		<CatalogueItemID>0000000009</CatalogueItemID>
    		<TypeCode>1</TypeCode>
    		<MeasureUnitID>EA</MeasureUnitID>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="DE">Hausrinder, mit einem Gewicht von mehr als 80kg bis 160kg, zum Schlachten</ContentText>
    		</BasicText>
    		<BasicText>
    			<TypeCode>10052</TypeCode>
    			<ContentText languageCode="EN">For slaughter</ContentText>
    		</BasicText>
    	</Item>
    </ForeignTradeCommodityCatalogue>
    

    Under the tag <Item> --> <Basic Text> you can create Official Descriptions using <TypeCode> 10052. And you can create Official Notes with <TypeCode> 10053.


    I have not tested this, but if you want to 'indent' your Item Codes (much like you can create sub-levels in the Product Category Hierarchy), you can apparently take cues from the following code snippet, the key tag here being <ParentCatalogueItemID>

    :
    :
    <Item>
    	<CustomsCommodityClassificationCode>0105</CustomsCommodityClassificationCode>
    	<CatalogueItemID>0000000105</CatalogueItemID>
    	<ParentCatalogueItemID>0000000001</ParentCatalogueItemID>
    	<TypeCode>1</TypeCode>
    	<BasicText>
    		<TypeCode>10052</TypeCode>
    		<ContentText languageCode="EN">Live poultry, that is to say, fowls of the species Gallus domesticus, ducks, geese, turkeys and guinea fowls</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10054</TypeCode>
    		<ContentText languageCode="EN">LIVE ANIMALS; Live poultry, that is to say, fowls of the species Gallus domesticus, ducks, geese, turkeys and guinea fowls</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10052</TypeCode>
    		<ContentText languageCode="FR">Coqs, poules, canards, oies, dindons, dindes et pintades, vivants, des espèces domestiques</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10054</TypeCode>
    		<ContentText languageCode="FR">ANIMAUX VIVANTS; Coqs, poules, canards, oies, dindons, dindes et pintades, vivants, des espèces domestiques</ContentText>
    	</BasicText>
    </Item>
    
    
    <Item>
    	<CustomsCommodityClassificationCode>010511</CustomsCommodityClassificationCode>
    	<CatalogueItemID>0000010511</CatalogueItemID>
    	<ParentCatalogueItemID>0000000105</ParentCatalogueItemID>
    	<TypeCode>1</TypeCode>
    	<BasicText>
    		<TypeCode>10052</TypeCode>
    		<ContentText languageCode="EN">Weighing not more than 185 g; Fowls of the species Gallus domesticus</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10054</TypeCode>
    		<ContentText languageCode="EN">LIVE ANIMALS; Live poultry, that is to say, fowls of the species Gallus domesticus, ducks, geese, turkeys and guinea fowls; Weighing not more than 185 g; Fowls of the species Gallus domesticus</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10052</TypeCode>
    		<ContentText languageCode="FR">d'un poids n'excédant pas 185 g; Coqs et poules</ContentText>
    	</BasicText>
    	<BasicText>
    		<TypeCode>10054</TypeCode>
    		<ContentText languageCode="FR">ANIMAUX VIVANTS; Coqs, poules, canards, oies, dindons, dindes et pintades, vivants, des espèces domestiques; d'un poids n'excédant pas 185 g; Coqs et poules</ContentText>
    	</BasicText>
    </Item>
    :
    :
    
    Add comment
    10|10000 characters needed characters exceeded