Skip to Content
Product Information
Author's profile photo KENAN JADDENE

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,

For more visit us https://glyceria.com

Hope this one was helpful,

KENAN JADDENE

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ANKIT CHAUHAN
      ANKIT CHAUHAN

      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

      Author's profile photo Sapna Chaudhari
      Sapna Chaudhari

      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

      Author's profile photo NICOLETTA PAGLIARA
      NICOLETTA PAGLIARA

      Hi Sapna,

      have you found the solution? i have the same problem

      Thank

      Nicoletta

      Author's profile photo Julie Plummer
      Julie Plummer

      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

      Author's profile photo KENAN JADDENE
      KENAN JADDENE
      Blog Post Author

      Hi Julie Plummer

      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

       

      Author's profile photo Julie Plummer
      Julie Plummer

      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

       

      Author's profile photo KENAN JADDENE
      KENAN JADDENE
      Blog Post Author

      Thank you too Julie Plummer

      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.

      Kenan

      Author's profile photo Julie Plummer
      Julie Plummer

      Thank-you very much for your time Kenan.

       

      julie

      Author's profile photo KENAN JADDENE
      KENAN JADDENE
      Blog Post Author

      You're welcome Julie, hope that was helpful.

      Regards.

      Kenan

      Author's profile photo Former Member
      Former Member

      got error while click on your link

      Author's profile photo KENAN JADDENE
      KENAN JADDENE
      Blog Post Author

      could you plz try again?

      Kenan

      Author's profile photo Former Member
      Former Member

      thank you brother got it now

       

      Author's profile photo KENAN JADDENE
      KENAN JADDENE
      Blog Post Author

      You're welcome!

      Kenan