Problem uploading tariff code from data provider

[former_member598105]

Dear all,

I am trying to upload tariff codes in GTS from XML files obtained from Bundesanzeiger.

I've created a number scheme which corresponds to the requirements specified in the files but when I run the upload, I get the following error message:

Errors occurred during the conversion of the XML file

I've tried to check in the ABAP code to figure out where the process stops and found out that it stops after the following operation:

PERFORM validate_tcots USING  es_tcots  lv_subrc.

The code returned is 4

The XML file is correctly formated so my guess is that something is missing in the config but I don't know what.

Please advise

Many thanks

[mouaz_benredjeb · Accepted solution]

Hello Nicolas,

Seems you are trying to load a country-specific numbering scheme (German EZT).

Could you please check in table /SAPSLL/TCOTS for numbering scheme DEEZT that you have the flag "country-specific" set in field CTSNB ?

Regards.

Mouaz BEN REDJEB

[former_member598105 · Accepted solution]

Hello Mouaz,

Indeed the problem is gone since I've checked the country specific flag.

I was able to check it by running SM30 on the following view: /SAPSLL/V_TCOTS

I don't remember having the option to do it when I created the number scheme though nor when I go back to the custom point in SPRO (GTS > General Settings > Define Numbering Scheme for Tariff Code Numbers). How could it be properly defined if not directly in the table?

I've used the scheme BEZT1 for the upload as it is the one mentioned in the header of the XML file from Bundesanzeiger:

<schema_id>BEZT1</schema_id>

I didn't think the file was country specific as I've read in another post that country specific file would be prefixed with the country code e.g. DExx_I_00158001007.xml, the one I was trying to load is WN_I_00158001007.xml

Thank you for your help!

[mouaz_benredjeb · Accepted solution]

Hi Nicolas,

I think that the country-specific flag should be coming from the uploaded file, there is a tag in the XML file that makes me think this:

<country_dependent>false</country_dependent>

I don't know if this flag can be managed in SPRO. It seems that the only way to change it is as you did through SM30.

Regards.

Mouaz BEN REDJEB

[Former Member]

Hi Nicolas,

I believe you have defined the structure for the Numbering scheme. Seems there is mismatch in the structure of the Numbering Scheme you defined and the Tariff code coming in the xml file.

Please re-check the structure defined under the numbering schemes.

Regards

Dhilipan

[former_member598105]

Hi Dhilipan,

Here is the scheme definition in the XML file:

<level>

<level_id>10</level_id>

<length>02</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>Kapitel</text>

</level_description>

<level_description>

<language>FR</language>

<text>chapter</text>

</level_description>

<level_description>

<language>EN</language>

<text>chapter</text>

</level_description>

</level>

<level>

<level_id>20</level_id>

<length>02</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>Position</text>

</level_description>

<level_description>

<language>FR</language>

<text>position</text>

</level_description>

<level_description>

<language>EN</language>

<text>position</text>

</level_description>

</level>

<level>

<level_id>30</level_id>

<length>02</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>Unterposition</text>

</level_description>

<level_description>

<language>FR</language>

<text>subposition</text>

</level_description>

<level_description>

<language>EN</language>

<text>subposition</text>

</level_description>

</level>

<level>

<level_id>40</level_id>

<length>02</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>KN</text>

</level_description>

<level_description>

<language>FR</language>

<text>KN</text>

</level_description>

<level_description>

<language>EN</language>

<text>KN</text>

</level_description>

</level>

<level>

<level_id>50</level_id>

<length>02</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>TARIC</text>

</level_description>

<level_description>

<language>FR</language>

<text>TARIC</text>

</level_description>

<level_description>

<language>EN</language>

<text>TARIC</text>

</level_description>

</level>

<level>

<level_id>60</level_id>

<length>01</length>

<separator></separator>

<usage></usage>

<level_description>

<language>DE</language>

<text>National</text>

</level_description>

<level_description>

<language>FR</language>

<text>national</text>

</level_description>

<level_description>

<language>EN</language>

<text>national</text>

</level_description>

</level>

and here is the number scheme I've set up:

I've tried different schemes setup such as:

10     2     0 Exact length

20     2     0 Exact length

30     2     0 Exact length

40     2     0 Exact length

50     2     0 Exact length

60     1     0 Exact length

but none of them works.

[Former Member]

Hi Nicolas,

The sample xml scheme and the numbering schemes you have setup seems fine for me..I meant the screenshot you provided. As we have setup "From To range", it should be fine.

I believe problem is with the xml file encoding format you are trying to upload. Please check the Encoding format in the xml file. That would be the top line. I believe it would be "UTF-8".

Try to open the xml file with notepad. Identify the encoding format. Save the notepad as .xml file . Please make sure the encoding format is setup accordingly in the save dialog.

Try the same and let us know how it works.

Regards

Dhilipan