Where-Used List Scenario for Bill of Material (BOM) Locate this document in the navigation structure

 

This virtual data model provides the prerequisites for the where-used list scenario for a BOM item, which provides the details of the BOM header for an item as a component in a material, order and work breakdown structure (WBS) BOM.

Structure

To support the reports listed above, the structure of this view hierarchy contains the following reuse and query views:

  • Reuse Views

    • Valid item list for order BOM(BOMValidItemListOrder)

    • Valid item list for material BOM(BOMValidItemListMaterial)

    • Valid item list for WBS BOM(BOMValidItemListWBSElement)

  • Query View

    • Where-Used list for BOM Item(WhereUsedListBOMItemQuery)

  • Measures and Attributes

    Some important measures and attributes are:

    • Valid item list for order BOM(BOMValidItemListOrder)

    • Valid item list for material BOM(BOMValidItemListMaterial)

    • Valid item list for WBS BOM(BOMValidItemListWBSElement)

      • The views provide data relevant to an item such as client, bill of material, bill of material category, bill of material item node number, bill of material item category , bill of material node number, alternative bill of material, validity start and end date, engineering change document, indicator for bulk material and special procurement type for BOM item, bill of material item quantity and bill of material item unit for order, material and WBS BOM.

    • Where-Used list for BOM Item(WhereUsedListBOMItemQuery)

      • This view provides the data relevant to BOM header and item for order, material, WBS BOM such as client, bill of material, bill of material category and its description, bill of material item node number, bill of material item category, bill of material node number, alternative BOM, validity start and end date, engineering change document, indicator for bulk material, special procurement type for BOM item and its description, BOM header, BOM usage and its description, plant, sales order and sales order item incase of order BOM, internal ID incase of WBS BOM and lot size range in case of material BOM, bill of material authorization group for providing analytic privilege, record create date, record change date, user who created record, user who changed the record, base unit of measure for BOM header and row number as a measure.

    Filters

    The views use the following filters:

    • Item list for order BOM(BOMItemListOrder)

      • BillOfMaterialCategory(STLTY=K)

    • Item list for material BOM(BOMItemListMaterial)

      • BillOfMaterialCategory(STLTY=M)

    • Item list for WBS BOM(BOMItemListWBSElement)

      • BillOfMaterialCategory(STLTY=P)

    • Where-used scenario for BOM item(WhereUsedListBOMItemQuery)

      • BOMCategoryName (DOMNAME = STLTY)

    Used Tables and Views

    The views select data from the following tables and views, for example:

    • KDST (Sales Order to BOM Link)

    • PRST (Project - BOM Link)

    • MAST (Material to BOM Link)

    • STZU (Permanent BOM Data)

    • STPO (BOM item)

    • STAS (BOMs - Item Selection)

    • DD07T (DD: Texts for Domain Fixed Values (Language-Dependent))

    • DD07L (R/3 DD: values for the domains)

    • T460T (Texts for Special Procurement Keys)

    • T460A (Special Procurement Key)

    • T416T (BOM Usage Texts)

    • T416 (BOM Usage - Item Statuses)

    • T418T (Item Category Texts)

    • T418 (Item Categories)

    • Valid item list for material BOM (BOMValidItemListMaterial)

    • Valid item list for WBS BOM (BOMValidItemListWBSElement)

    • Valid item list for order BOM (BOMValidItemListOrder)

    • Item list for material BOM (BOMItemListMaterial)

    • Item list for WBS BOM (BOMItemListWBSElement)

    • Item list for order BOM (BOMItemListOrder)

    • WhereUsedListBOMItemQuery (Query view for where—used scenario for BOM Item)

    • BOMVariantUsageName (View that provides description for BOM Usage)

    • BOMCategoryName (View to give description of BOM Category)

    • BOMItemSpclProcmtTypeName (View for special procurement type for BOM Item Description)

      BOMItemCategoryName (View to get the description of BOM Item Category)

    • MaterialPlantData (Plant Master Data for Materials)

    • Material (Material Data)

More Information

For more information about auto documentation, see Auto Documentation.