Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
kenan_jaddeny
Contributor
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,

  • IssueMethod: im_Backflush,im_Manual


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;


iNotATree, iAssemblyTree, iSalesTree, iProductionTree, iTemplateTree, iIngredient

  • Quantity: the required manufactured quantity

  • DistributionRule: optional choice, you have the choice to not fill it out,


After preparing the two files (OITT, ITT1), we have to take them together in consideration while importing via DTW, not take each one individually, it won’t work,

For more visit us https://glyceria.com

Hope this one was helpful,

KENAN JADDENE
13 Comments