P_Valid_Bomitems

Get Valid BOM items | view: P_VALIDBOMITEMS | TRAN | Extraction: Not supported | Component: Bills of Material

Tables used: DOST, MAST, STAS, STAS, STPO, T414, T460A, TCS03

🔑 Keys (5)
💰 Amounts (1)
∑ Quantities (6)
📅 Dates (5)
☰ Categorical (20)
Other (36)
🔗 Relations (25)

Column Name	Description
BillOfMaterialItemUUID	Global identification of an item's change status
BillOfMaterialCategory	BOM category	Show values
BillOfMaterial	Bill of Material
BillOfMaterialVariant	Alternative BOM
BillOfMaterialItemNodeNumber	null

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
BOMItemChangeDate	Last Changed On

Column Name	Description
BillOfMaterialCategory	BOM category	Show values
IsSubItem	Indicator: sub-items exist	Show values
FixedQuantity	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
IsConfigurableBOM	Selection indicator for configurable BOMs	Show values
IsDeleted	Deletion Indicator	Show values
IsALE	ALE indicator	Show values
AlternativeItemStrategy	Alternative item: strategy	Show values
IsPhantomItem	Checkbox	Show values

Column Name	Description	Domain name
BOMItemInternalChangeCount	Internal counter	CIM_COUNT
InheritedNodeNumberForBOMItem	Inherited node number of BOM item	KNTNR
InheritedNodeNumberVersionBOM	Inherited node number of BOM item	KNTNR
BillOfMaterialVersion	BOM Version	BOM_VERSION
BOMItemCreatedByUser	User who created record	USNAM
BOMItemLastChangedByUser	Name of Person Who Changed Object	USNAM
BillOfMaterialComponent	BOM component	MATNR
BillOfMaterialItemNumber	BOM Item Number	SPOSN
SortString	Sort String	CHAR10
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
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
CostElement	Cost element	SAKNR
GoodsReceiptDuration	Goods receipt processing time in days	DEC3
FollowUpGroup	Follow-up group	CHAR2
DiscontinuationGroup	Discontinuation group	CHAR2
ReinsurContrOrgUnit	Organizational Area	CHAR10
LeadTimeOffset	Lead-time offset	NLFZT
AlternativeItemGroup	Alternative item: group	CHAR2
AlternativeItemPriority	Alternative item: ranking order	NUM2
UsageProbabilityPercent	Usage Probability in % (Alternative Item)	DEC3
IsAssembly	null
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)	`P_VALID_BOMITEMS.MANDT == T418.MANDT` `P_VALID_BOMITEMS.BILLOFMATERIALITEMCATEGORY == T418.POSTP`
Component Unit of Measure Client Component Unit of Measure	`P_VALID_BOMITEMS.MANDT == T006.MANDT` `P_VALID_BOMITEMS.BILLOFMATERIALITEMUNIT == T006.MSEHI`
for every costing relevancy none, one or several entries Client Indicator for relevancy to costing	`P_VALID_BOMITEMS.MANDT == TCK08.MANDT` `P_VALID_BOMITEMS.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ`
Indicator: item relevant to sales Client Indicator: item relevant to sales	`P_VALID_BOMITEMS.MANDT == TVRL.MANDT` `P_VALID_BOMITEMS.BOMITEMISSALESRELEVANT == TVRL.RVREL`
Indicator: Spare Part Client Indicator: Spare Part	`P_VALID_BOMITEMS.MANDT == T413.MANDT` `P_VALID_BOMITEMS.BOMITEMISSPAREPART == T413.ERSKZ`
Change Number Client Change Number Change Number	`P_VALID_BOMITEMS.MANDT == AENR.MANDT` `P_VALID_BOMITEMS.CHANGENUMBERTO == AENR.AENNR` `P_VALID_BOMITEMS.CHANGENUMBERFROM == AENR.AENNR`
Change Number Client Change Number Change Number	`P_VALID_BOMITEMS.MANDT == AENR.MANDT` `P_VALID_BOMITEMS.CHANGENUMBERTO == AENR.AENNR` `P_VALID_BOMITEMS.CHANGENUMBERFROM == AENR.AENNR`
Class Type Client Class Type	`P_VALID_BOMITEMS.MANDT == TCLA.MANDT` `P_VALID_BOMITEMS.CLASSTYPE == TCLA.KLART`
Account Number of Supplier Account Number of Supplier Client	`P_VALID_BOMITEMS.CREDITOR == LFA1.LIFNR` `P_VALID_BOMITEMS.MANDT == LFA1.MANDT`
Currency Key Client Currency Key	`P_VALID_BOMITEMS.MANDT == TCURC.MANDT` `P_VALID_BOMITEMS.CURRENCY == TCURC.WAERS`
Distribution key for component consumption Client ? Distribution key for component consumption	`P_VALID_BOMITEMS.MANDT == T437V.MANDT` `P_VALID_BOMITEMS.[column in domain "WERKS_D"] == T437V.WERKS` `P_VALID_BOMITEMS.DISTRKEYCOMPCONSUMPTION == T437V.VERTL`
Document Type Client Document Type	`P_VALID_BOMITEMS.MANDT == TDWA.MANDT` `P_VALID_BOMITEMS.DOCUMENTTYPE == TDWA.DOKAR`
Explosion type Client Explosion type	`P_VALID_BOMITEMS.MANDT == T414.MANDT` `P_VALID_BOMITEMS.EXPLOSIONTYPE == T414.DISPO`
Formula Key for Variable-Size Items Client Formula Key for Variable-Size Items	`P_VALID_BOMITEMS.MANDT == T418F.MANDT` `P_VALID_BOMITEMS.FORMULAKEY == T418F.RFORM`
Material Provision Indicator Client Material Provision Indicator	`P_VALID_BOMITEMS.MANDT == T417.MANDT` `P_VALID_BOMITEMS.ISMATERIALPROVISION == T417.BEIKZ`
Material Group Client Material Group	`P_VALID_BOMITEMS.MANDT == T023.MANDT` `P_VALID_BOMITEMS.MATERIALGROUP == T023.MATKL`
Unit for lead-time offset for operation Client Unit for lead-time offset for operation	`P_VALID_BOMITEMS.MANDT == T006.MANDT` `P_VALID_BOMITEMS.OPSLEADTIMEOFFSETUNIT == T006.MSEHI`
Issue Location for Production Order Client ? Issue Location for Production Order	`P_VALID_BOMITEMS.MANDT == T001L.MANDT` `P_VALID_BOMITEMS.[column in domain "WERKS_D"] == T001L.WERKS` `P_VALID_BOMITEMS.PRODORDERISSUELOCATION == T001L.LGORT`
Production Supply Area Client ? Production Supply Area	`P_VALID_BOMITEMS.MANDT == PVBE.MANDT` `P_VALID_BOMITEMS.[column in domain "WERKS_D"] == PVBE.WERKS` `P_VALID_BOMITEMS.PRODUCTIONSUPPLYAREA == PVBE.PRVBE`
Purchasing Group Client Purchasing Group	`P_VALID_BOMITEMS.MANDT == T024.MANDT` `P_VALID_BOMITEMS.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Purchasing organization Client	`P_VALID_BOMITEMS.PURCHASINGORGANIZATION == T024E.EKORG` `P_VALID_BOMITEMS.MANDT == T024E.MANDT`
Reference point for BOM transfer Client Reference point for BOM transfer	`P_VALID_BOMITEMS.MANDT == TCNRFP.MANDT` `P_VALID_BOMITEMS.REFERENCEPOINT == TCNRFP.RFPNT`
Resulting item category Client Resulting item category	`P_VALID_BOMITEMS.MANDT == T418.MANDT` `P_VALID_BOMITEMS.RESULTINGITEMCATEGORY == T418.POSTP`
Unit of measure for sizes 1 to 3 Client Unit of measure for sizes 1 to 3	`P_VALID_BOMITEMS.MANDT == T006.MANDT` `P_VALID_BOMITEMS.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI`
Unit of measure for piece Client Unit of measure for piece	`P_VALID_BOMITEMS.MANDT == T006.MANDT` `P_VALID_BOMITEMS.UNITOFMEASUREFORVARSIZEITEM == T006.MSEHI`