Skip to Content
Product Information

Importing Bill of Materials (BoM) via DTW in SAP Business One 9.2

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,

 

Hope this one was helpful,

KENAN JADDENY

12 Comments
You must be Logged on to comment or reply to a post.
  • Hi KENAN JADDENY,

    As per SAP Note 1280506:

    Always generate templates as described below. If unable to generate them, use the ones available by default as part of the DTW.

    Choose Templates from the DTW Menu and choose Customize templates. From here you can select the object for which you wish to create a new MS Excel template. Expand the tree view to find the required structure, then right-click and choose Create template for this Structure.

    Please note that Microsoft Excel must be installed on the computer running DTW in order to create customized templates.

    Kind regards,

    ANKIT CHAUHAN

    SAP Business One Support

  • Hi Kenan.

    Can you please explain me BOM template for 9.3.

    I am trying to import (OITT, ITT1,ITT2), but it gives me error when I’m trying to import routing stages (ITT2).

    Error: “Stage ID is not set but stages are defined [ITT1.StageId][line: 1]”

    Regards,

    Sapna

  • Hi Kenan,

    In the Quantity column of OITT1 i need to put 0 but DTW wants a figure greater than but in doing that it will increase my additional quantity column …. what can i try any ideas ?

     

    Many Thanks

     

    Julie

    • Hi Julie Plumber

      First of all when we’re importing the Bill of Materials via DTW, we’re just opening production templates inside SAP Business One, according to that, creating these templates doesn’t mean that you produce these products or these goods being entered to the production process.

      the Quantity column of OITT1 means that; the specific quantity of a product that you want it to be manufactured, according to it if you leave it as 1 for the quantity column, it won’t mean that you’re at this moment manufacturing this quantity,

      it’s just a template that you provide SAP B1 through it instructions, when produce 1 of this item, you take out from the warehouse these and these amounts of these materials.

      I hope make it clear for you Julie,

      thanks,

      KENAN JADDENE

       

  • Hi Kenan,

     

    Thank-you so much for your speedy response as this was my first time on here 🙂

     

    The quantity i am trying to add in fact should be left blank… as it is against the  resource not the material so is not a stock item.

     

     

    Julie

     

    • Thank you too Julie Plumber

      actually the logic of the DTW templates is that you’re not adding the materials that you’ll not use during the production process, due to this reason, we can’t left it blank or with zero amount! it must be specified with at least 1,

      please let me ask you that, if there’s some materials you want them to be represented as 0 why you adding them to the template?

      Thanks.

  • /