in some cases, when we’re working with more than one company database and we need to open the same Bill of Materials in all of them, and we have bulk to be imported, in that case open them manually it’s not the perfect way, because it’ll case us time and margin of wrongness, according to that we should use DTW, here’s how we can apply it and get benefit of it,
first of all, all BoM in SAP Business One 9.2 associated with two Tables in the database (OITT, ITT1), according to that we should use both of these tables at the same time while importing them via DTW,
we can find them in the available SAP backage with the associated link:
C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Samples\1. Add New Data\Production\Bill of Materials
According to that we should now prepare two files,
ITT1 - ProductTrees_Lines
ParentKey: The Parent Item Code,
LineNum: It should be an integer which begin with 0 ,it is just for update, keep it empty when import.
Quantity: the required manufactured quantity
Warehouse: the warehouse code that must the row materials be issued from,
backflush (MM-IM): The non-manual posting of an issue of components some time after their physical withdrawal for an order. The goods issue posting for backflushed components is performed automatically at the time of order completion confirmation.
ParentItem: The Parent Item Code,
PriceList: you have the choice to connect it with a price list,
OITT – ProductTrees
TreeCode: The Parent Item Code
TreeType: choose one of the following options according to your needs;