I_OrderBOMItemAPITP_1

Sales Order BOM Item TP | view: IKBOMITEMAPITP_1 | 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 (7)
💰 Amounts (1)
∑ Quantities (6)
📅 Dates (4)
☰ Categorical (19)
Other (38)
🔗 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

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