DTW Item Master

[Former Member]

2007 B

DTW

Item Master:

how to define the following field in the item master template

- 'additional identifier'

- excisable item

- Mfg catalog Number

- Required (Purchasing UoM) in the inventory data.

[Former Member · Accepted solution]

You can find these columns in 'oItems' template from the folder:

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

Excel Column   Excel Column Name         Used as
Column FW      SupplierCatalogNo            Mfg catalog Number 
Column EJ        PurchaseUnit                   Purchasing UoM
Column ER       SWW                              additional identifier

Excise information are not exposed to DTW. They have to be entered manually

[Former Member]

DTW: Item master Template

What are the corresponding sbo fields for these template fileds

BaseUnitName

CommissionGroup

CommissionPercent

CommissionSum

DataExportCode

DesiredInventory

ForceSelectionOfSerialNumber

ItemCountryOrg

Picture ( how to upload pictures? )

SRIAndBatchManageMethod

SerialNum

[former_member583013]

For the picture ...copy the pictures to the picture folder as defined in the Path Tab of General Settings

In your DTW....picture column enter the mapped folder name as it appears in the picture folder area

example
Bitmaps\abc.jpg

[former_member186095]

Hi,

based on your requirements :

• 'additional identifier'

• excisable item

• Mfg catalog Number

• Required (Purchasing UoM) in the inventory data.

the 1st and 2nd seems unexposed to DI. I mean it is temporarily unavailable. The 3rd and 4th should be available. The 3rd is SupplierCatalogNo and the 4th are purchaseunit column.

Rgds,