cancel
Showing results for 
Search instead for 
Did you mean: 

Upload File Format for Commodity Catalogs - Intrastat Declaration

arunml
Employee
Employee
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

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>
:
:

Answers (0)