DTW of Intrastat Commodity code data (ODCI table)

[vicky_williams]

Hi Experts

Does anyone know if DTW can be used to import some commodity code data into the table ODCI?

We have data in excel - 2 columns which we would like to populate:

Column A = ODCI.Code

Column B = ODCI.Descr

I think the Intrastat information was only added into SAP recently (previously it was an add on) so perhaps it is not possible

Thanks in Advance

Vicky

SAP B1 v 9.0 PL:11

[Former Member · Accepted solution]

Hi Vicky,

there is a button at the Intrastat Configuration Screen that allows you to import.

the path is Administration>Setup>Financials>Intrastat>Intrastat Configuration

On the Commodity Codes Tab there is an import button.

Prepare your file as per the screen layout and save it as a unicode text. then select it.

hope this helps.

Robinson

[vicky_williams · Accepted solution]

Thank you Robinson

I had not noticed this import button before

I will try this in the future

[former_member212181]

Hi Vicky,

Which Localization you are using?

Pleas try below.

Login to Data transfer work bench > your database.

Click on Templates > Customize template> and then search for your template in modules.

Thanks

Unnikrishnan

[vicky_williams]

Thank you for your suggestion

I checked the customize template, but it doesn't appear to have this option so I guess it may not be possible

Localization is UK

Thanks

Vicky