I_SalesOrderBOMItem

Sales Order BOM Item | view: IKBOMITEM | TRAN | Extraction: Not supported | Component: Bills of Material
Tables used: DRAT, T418, T418T, KLAH, SWOR, MAST, MAKT, KDST, LFA1, STAS, STPO, STKO, STZU, TCS03, TCS03
Column Name Description
BillOfMaterial Bill of Material
BillOfMaterialCategory BOM category Show values
BillOfMaterialVariant Alternative BOM
BillOfMaterialItemNodeNumber BOM item node number
HeaderChangeDocument FK Change Number
Material FK Material Number
Plant FK Plant
Column Name Description
💲 Currency Key (Currency):
MaterialComponentPrice Price
Column Name Description
📏 Component Unit of Measure (BillOfMaterialItemUnit):
BillOfMaterialItemQuantity Component Quantity
NumberOfVariableSizeItem Required Number of Variable-Size Items
QuantityVariableSizeItem Variable-Size Item Quantity per Piece (PC)
Size1 Size 1
Size2 Size 2
Size3 Size 3
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
BOMItemRecordCreationDate Date Record Created On
BOMItemLastChangeDate Last Changed On
Column Name Description
BillOfMaterialCategory BOM category Show values
IsSubItem Indicator: sub-items exist Show values
FixedQuantity Fixed Quantity Show values
BOMItemHasFixedQuantity Fixed Quantity Show values
IsNetScrap Net Scrap Indicator Show values
IsClassificationRelevant Indicator: classification as selection condition Show values
IsBulkMaterial Indicator: bulk material Show values
IsProductionRelevant Indicator: item relevant to production Show values
BOMItemIsPlantMaintRelevant Indicator: item relevant to plant maintenance Show values
IsEngineeringRelevant Indicator: item relevant to engineering Show values
IsBOMRecursiveAllowed Indicator: recursiveness allowed Show values
BOMIsRecursive Indicator: BOM is recursive Show values
DocumentIsCreatedByCAD CAD Indicator Show values
RequiredComponent Required Component Show values
MultipleSelectionAllowed Multiple Selection Allowed Show values
MaterialIsCoProduct Indicator: co-product Show values
AlternativeItemStrategy Alternative item: strategy Show values
IsConfigurableBOM Selection indicator for configurable BOMs Show values
IsDeleted Deletion Indicator Show values
IsALE ALE indicator Show values
Column Name Description Domain name
BillOfMaterialItemUUID Global identification of an item's change status SYSUUID
BOMItemInternalChangeCount Internal counter CIM_COUNT
ChgToEngineeringChgDocument Change Number To AENNR
InheritedNodeNumberForBOMItem Inherited node number of BOM item KNTNR
BOMItemCreatedByUser User who created record USNAM
BOMItemLastChangedByUser Name of Person Who Changed Object USNAM
BillOfMaterialComponent BOM component MATNR
BillOfMaterialItemNumber BOM Item Number SPOSN
IsAssembly Indicator: assembly CHAR1
BOMItemSorter Sort String CHAR10
IdentifierBOMItem External identification of an item CHAR8
MaterialPriceUnitQty Price unit PACK3
ComponentScrapInPercent Component Scrap in Percent DEC3_2
OperationScrapInPercent Operation Scrap DEC3_2
ComponentDescription BOM Item Text (Line 1) TEXT40
BOMItemDescription BOM Item Text (Line 1) TEXT40
BOMItemText2 BOM Item Text (Line 2) TEXT40
DocNumber Document number DOKNR
DocumentVersion Document Version DOKVR
DocumentPart Document Part DOKTL
ClassNumber Class number KLASSE
DependencyObjectNumber Number of Object with Assigned Dependencies KNOBJ
ObjectType Object type (BOM item) OBJTY
SpecialProcurementType Special Procurement Type for BOM Item SOBSL
OperationLeadTimeOffset Lead-time offset for operation NLFZT
DeliveryDurationInDays Delivery time in days DEC3
Creditor Account Number of Supplier LIFNR
CostElement Cost element SAKNR
GoodsReceiptDuration Goods receipt processing time in days DEC3
AlternativeItemGroup Alternative item: group CHAR2
AlternativeItemPriority Alternative item: ranking order NUM2
UsageProbabilityPercent Usage Probability in % (Alternative Item) DEC3
FollowUpGroup Follow-up group CHAR2
DiscontinuationGroup Discontinuation group CHAR2
LeadTimeOffset Lead-time offset NLFZT
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Item category (bill of material)
  • Client
  • Item category (bill of material)
  • I_SALESORDERBOMITEM.MANDT == T418.MANDT
  • I_SALESORDERBOMITEM.BILLOFMATERIALITEMCATEGORY == T418.POSTP
BOM Usage
  • BOM Usage
  • Client
  • I_SALESORDERBOMITEM.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • I_SALESORDERBOMITEM.MANDT == T416.MANDT
for every costing relevancy none, one or several entries
  • Client
  • Indicator for relevancy to costing
  • I_SALESORDERBOMITEM.MANDT == TCK08.MANDT
  • I_SALESORDERBOMITEM.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ
Indicator: item relevant to sales
  • Client
  • Indicator: item relevant to sales
  • I_SALESORDERBOMITEM.MANDT == TVRL.MANDT
  • I_SALESORDERBOMITEM.BOMITEMISSALESRELEVANT == TVRL.RVREL
Indicator: Spare Part
  • Indicator: Spare Part
  • Client
  • I_SALESORDERBOMITEM.BOMITEMISSPAREPART == T413.ERSKZ
  • I_SALESORDERBOMITEM.MANDT == T413.MANDT
Class Type
  • Class Type
  • Client
  • I_SALESORDERBOMITEM.CLASSTYPE == TCLA.KLART
  • I_SALESORDERBOMITEM.MANDT == TCLA.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SALESORDERBOMITEM.MANDT == TCURC.MANDT
  • I_SALESORDERBOMITEM.CURRENCY == TCURC.WAERS
Distribution key for component consumption
  • ?
  • Distribution key for component consumption
  • Client
  • I_SALESORDERBOMITEM.[column in domain "WERKS_D"] == T437V.WERKS
  • I_SALESORDERBOMITEM.DISTRKEYCOMPCONSUMPTION == T437V.VERTL
  • I_SALESORDERBOMITEM.MANDT == T437V.MANDT
Document Type
  • Document Type
  • Client
  • I_SALESORDERBOMITEM.DOCUMENTTYPE == TDWA.DOKAR
  • I_SALESORDERBOMITEM.MANDT == TDWA.MANDT
Change Number
  • Change Number
  • Change Number
  • Change Number
  • Client
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.HEADERCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR
  • I_SALESORDERBOMITEM.MANDT == AENR.MANDT
Change Number
  • Change Number
  • Change Number
  • Change Number
  • Client
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.HEADERCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR
  • I_SALESORDERBOMITEM.MANDT == AENR.MANDT
Explosion type
  • Explosion type
  • Client
  • I_SALESORDERBOMITEM.EXPLOSIONTYPE == T414.DISPO
  • I_SALESORDERBOMITEM.MANDT == T414.MANDT
Formula Key for Variable-Size Items
  • Client
  • Formula Key for Variable-Size Items
  • I_SALESORDERBOMITEM.MANDT == T418F.MANDT
  • I_SALESORDERBOMITEM.FORMULAKEY == T418F.RFORM
Change Number
  • Change Number
  • Change Number
  • Change Number
  • Client
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.HEADERCHANGEDOCUMENT == AENR.AENNR
  • I_SALESORDERBOMITEM.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR
  • I_SALESORDERBOMITEM.MANDT == AENR.MANDT
Material Provision Indicator
  • Client
  • Material Provision Indicator
  • I_SALESORDERBOMITEM.MANDT == T417.MANDT
  • I_SALESORDERBOMITEM.ISMATERIALPROVISION == T417.BEIKZ
Material Number
  • Material Number
  • Client
  • I_SALESORDERBOMITEM.MATERIAL == MARA.MATNR
  • I_SALESORDERBOMITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_SALESORDERBOMITEM.MANDT == T023.MANDT
  • I_SALESORDERBOMITEM.MATERIALGROUP == T023.MATKL
Unit for lead-time offset for operation
  • Unit for lead-time offset for operation
  • Client
  • I_SALESORDERBOMITEM.OPSLEADTIMEOFFSETUNIT == T006.MSEHI
  • I_SALESORDERBOMITEM.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • I_SALESORDERBOMITEM.MANDT == T001W.MANDT
  • I_SALESORDERBOMITEM.PLANT == T001W.WERKS
Issue Location for Production Order
  • ?
  • Client
  • Issue Location for Production Order
  • I_SALESORDERBOMITEM.[column in domain "WERKS_D"] == T001L.WERKS
  • I_SALESORDERBOMITEM.MANDT == T001L.MANDT
  • I_SALESORDERBOMITEM.PRODORDERISSUELOCATION == T001L.LGORT
Production Supply Area
  • ?
  • Production Supply Area
  • Client
  • I_SALESORDERBOMITEM.[column in domain "WERKS_D"] == PVBE.WERKS
  • I_SALESORDERBOMITEM.PRODUCTIONSUPPLYAREA == PVBE.PRVBE
  • I_SALESORDERBOMITEM.MANDT == PVBE.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SALESORDERBOMITEM.PURCHASINGGROUP == T024.EKGRP
  • I_SALESORDERBOMITEM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SALESORDERBOMITEM.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SALESORDERBOMITEM.MANDT == T024E.MANDT
Reference point for BOM transfer
  • Reference point for BOM transfer
  • Client
  • I_SALESORDERBOMITEM.REFERENCEPOINT == TCNRFP.RFPNT
  • I_SALESORDERBOMITEM.MANDT == TCNRFP.MANDT
Resulting item category
  • Resulting item category
  • Client
  • I_SALESORDERBOMITEM.RESULTINGITEMCATEGORY == T418.POSTP
  • I_SALESORDERBOMITEM.MANDT == T418.MANDT
Unit of measure for sizes 1 to 3
  • Unit of measure for sizes 1 to 3
  • Client
  • I_SALESORDERBOMITEM.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI
  • I_SALESORDERBOMITEM.MANDT == T006.MANDT