Skip to Content

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

when we need to open this BoM via DTW, we should do the following steps;

  • Open Item Master Data for the Parent Items in SAP with all required details according to the company needs,
  • For importing purposes, we should have the following data;
    • Parent Item Code and the manufactured quantity
    • The components and the manufactured quantity,

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,

When importing both files,

Hope this one was helpful,

to download the complete documentation from here,

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

if you do have any inquiries or suggestion, please feel free to reach me out,


You must be Logged on to comment or reply to a post.

    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,


    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]”