Import Item Master Data

[Former Member]

Hi all,

we want to import the Item master data from excel sheet to sap b1 item master.

which templates are required to import all item master data using DTW.

Thanks,

Neetu

[former_member186095]

Hi,

The template for importing item master data is available in the live server SAP B1 or server standalone e.g. notebook or server IBM in the folder:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems

you must install the DTW using setup.exe that available in the package folder of the SAP B1 product CD.

Rgds,

[Former Member]

Use the templates from the following folder

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems

Check the Filled Templated from the folder for reference:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Data preparation examples\10. Testcase1_Test Data for Import function\oItems

[Former Member]

Please use oItems for the item definition.

Also check this thread:

Thanks,

Gordon