I_OrderBillOfMaterialItemAPITP

Sales Order BOM Item TP | view: IKBOMITEMAPITP | TRAN | Extraction: Not supported | Component: Bills of Material

Tables used: DRAT, VBKD, VEDA, VBAK, T418, T418T, KLAH, SWOR, MAST, MAKT, KDST, LFA1, STAS, STPO, STKO, STZU, TCS03, TCS03

🔑 Keys (8)
💰 Amounts (1)
∑ Quantities (6)
📅 Dates (4)
☰ Categorical (20)
Other (37)
🔗 Relations (26)

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
BillOfMaterialItemUUID	Global identification of an item's change status

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
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
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales order item	POSNR
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_ORDERBILLOFMATERIALITEMAPITP.MANDT == T418.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.BILLOFMATERIALITEMCATEGORY == T418.POSTP`
BOM Usage BOM Usage Client	`I_ORDERBILLOFMATERIALITEMAPITP.BILLOFMATERIALVARIANTUSAGE == T416.STLAN` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T416.MANDT`
for every costing relevancy none, one or several entries Indicator for relevancy to costing Client	`I_ORDERBILLOFMATERIALITEMAPITP.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TCK08.MANDT`
Indicator: item relevant to sales Indicator: item relevant to sales Client	`I_ORDERBILLOFMATERIALITEMAPITP.BOMITEMISSALESRELEVANT == TVRL.RVREL` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TVRL.MANDT`
Indicator: Spare Part Client Indicator: Spare Part	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T413.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.BOMITEMISSPAREPART == T413.ERSKZ`
Class Type Class Type Client	`I_ORDERBILLOFMATERIALITEMAPITP.CLASSTYPE == TCLA.KLART` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TCLA.MANDT`
Currency Key Client Currency Key	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TCURC.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.CURRENCY == TCURC.WAERS`
Distribution key for component consumption ? Distribution key for component consumption Client	`I_ORDERBILLOFMATERIALITEMAPITP.[column in domain "WERKS_D"] == T437V.WERKS` `I_ORDERBILLOFMATERIALITEMAPITP.DISTRKEYCOMPCONSUMPTION == T437V.VERTL` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T437V.MANDT`
Document Type Document Type Client	`I_ORDERBILLOFMATERIALITEMAPITP.DOCUMENTTYPE == TDWA.DOKAR` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TDWA.MANDT`
Change Number Client Change Number Change Number Change Number	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == AENR.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.HEADERCHANGEDOCUMENT == AENR.AENNR`
Change Number Client Change Number Change Number Change Number	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == AENR.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.HEADERCHANGEDOCUMENT == AENR.AENNR`
Explosion type Client Explosion type	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T414.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.EXPLOSIONTYPE == T414.DISPO`
Formula Key for Variable-Size Items Formula Key for Variable-Size Items Client	`I_ORDERBILLOFMATERIALITEMAPITP.FORMULAKEY == T418F.RFORM` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T418F.MANDT`
Change Number Client Change Number Change Number Change Number	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == AENR.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.ENGINEERINGCHANGEDOCFOREDIT == AENR.AENNR` `I_ORDERBILLOFMATERIALITEMAPITP.HEADERCHANGEDOCUMENT == AENR.AENNR`
Material Provision Indicator Material Provision Indicator Client	`I_ORDERBILLOFMATERIALITEMAPITP.ISMATERIALPROVISION == T417.BEIKZ` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T417.MANDT`
Material Number Client Material Number	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == MARA.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T023.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.MATERIALGROUP == T023.MATKL`
Unit for lead-time offset for operation Client Unit for lead-time offset for operation	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T006.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.OPSLEADTIMEOFFSETUNIT == T006.MSEHI`
Plant Plant Client	`I_ORDERBILLOFMATERIALITEMAPITP.PLANT == T001W.WERKS` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T001W.MANDT`
Issue Location for Production Order ? Issue Location for Production Order Client	`I_ORDERBILLOFMATERIALITEMAPITP.[column in domain "WERKS_D"] == T001L.WERKS` `I_ORDERBILLOFMATERIALITEMAPITP.PRODORDERISSUELOCATION == T001L.LGORT` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T001L.MANDT`
Production Supply Area ? Production Supply Area Client	`I_ORDERBILLOFMATERIALITEMAPITP.[column in domain "WERKS_D"] == PVBE.WERKS` `I_ORDERBILLOFMATERIALITEMAPITP.PRODUCTIONSUPPLYAREA == PVBE.PRVBE` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == PVBE.MANDT`
Purchasing Group Client Purchasing Group	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T024.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T024E.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.PURCHASINGORGANIZATION == T024E.EKORG`
Reference point for BOM transfer Client Reference point for BOM transfer	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == TCNRFP.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.REFERENCEPOINT == TCNRFP.RFPNT`
Resulting item category Resulting item category Client	`I_ORDERBILLOFMATERIALITEMAPITP.RESULTINGITEMCATEGORY == T418.POSTP` `I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T418.MANDT`
Unit of measure for sizes 1 to 3 Client Unit of measure for sizes 1 to 3	`I_ORDERBILLOFMATERIALITEMAPITP.MANDT == T006.MANDT` `I_ORDERBILLOFMATERIALITEMAPITP.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI`