P_VALID_COMPONENTS

Get Valid BOM items | view: P_COMPONENTS | TRAN | Extraction: Not supported | Component: Bills of Material
Tables used: DOST, MAST, STAS, STAS, STPO, T414, T460A, TCS03
Column Name Description
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
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
IsConfigurableBOM Selection indicator for configurable BOMs Show values
IsSoftwareComponent Indicator: Software component Show values
IsDeleted Deletion Indicator Show values
IsALE ALE indicator Show values
AlternativeItemStrategy Alternative item: strategy Show values
IsPMAssemblyRelevant PM assembly indicator Show values
IsPhantomItem Checkbox Show values
Column Name Description Domain name
BillOfMaterialItemUUID Global identification of an item's change status SYSUUID
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_COMPONENTS.MANDT == T418.MANDT
  • P_VALID_COMPONENTS.BILLOFMATERIALITEMCATEGORY == T418.POSTP
Component Unit of Measure
  • Component Unit of Measure
  • Client
  • P_VALID_COMPONENTS.BILLOFMATERIALITEMUNIT == T006.MSEHI
  • P_VALID_COMPONENTS.MANDT == T006.MANDT
for every costing relevancy none, one or several entries
  • Indicator for relevancy to costing
  • Client
  • P_VALID_COMPONENTS.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ
  • P_VALID_COMPONENTS.MANDT == TCK08.MANDT
Indicator: item relevant to sales
  • Client
  • Indicator: item relevant to sales
  • P_VALID_COMPONENTS.MANDT == TVRL.MANDT
  • P_VALID_COMPONENTS.BOMITEMISSALESRELEVANT == TVRL.RVREL
Indicator: Spare Part
  • Indicator: Spare Part
  • Client
  • P_VALID_COMPONENTS.BOMITEMISSPAREPART == T413.ERSKZ
  • P_VALID_COMPONENTS.MANDT == T413.MANDT
Change Number
  • Change Number
  • Change Number
  • Client
  • P_VALID_COMPONENTS.CHANGENUMBERFROM == AENR.AENNR
  • P_VALID_COMPONENTS.CHANGENUMBERTO == AENR.AENNR
  • P_VALID_COMPONENTS.MANDT == AENR.MANDT
Change Number
  • Change Number
  • Change Number
  • Client
  • P_VALID_COMPONENTS.CHANGENUMBERFROM == AENR.AENNR
  • P_VALID_COMPONENTS.CHANGENUMBERTO == AENR.AENNR
  • P_VALID_COMPONENTS.MANDT == AENR.MANDT
Class Type
  • Client
  • Class Type
  • P_VALID_COMPONENTS.MANDT == TCLA.MANDT
  • P_VALID_COMPONENTS.CLASSTYPE == TCLA.KLART
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_VALID_COMPONENTS.CREDITOR == LFA1.LIFNR
  • P_VALID_COMPONENTS.MANDT == LFA1.MANDT
Currency Key
  • Currency Key
  • Client
  • P_VALID_COMPONENTS.CURRENCY == TCURC.WAERS
  • P_VALID_COMPONENTS.MANDT == TCURC.MANDT
Distribution key for component consumption
  • ?
  • Client
  • Distribution key for component consumption
  • P_VALID_COMPONENTS.[column in domain "WERKS_D"] == T437V.WERKS
  • P_VALID_COMPONENTS.MANDT == T437V.MANDT
  • P_VALID_COMPONENTS.DISTRKEYCOMPCONSUMPTION == T437V.VERTL
Document Type
  • Document Type
  • Client
  • P_VALID_COMPONENTS.DOCUMENTTYPE == TDWA.DOKAR
  • P_VALID_COMPONENTS.MANDT == TDWA.MANDT
Explosion type
  • Client
  • Explosion type
  • P_VALID_COMPONENTS.MANDT == T414.MANDT
  • P_VALID_COMPONENTS.EXPLOSIONTYPE == T414.DISPO
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • P_VALID_COMPONENTS.FORMULAKEY == T418F.RFORM
  • P_VALID_COMPONENTS.MANDT == T418F.MANDT
Material Provision Indicator
  • Material Provision Indicator
  • Client
  • P_VALID_COMPONENTS.ISMATERIALPROVISION == T417.BEIKZ
  • P_VALID_COMPONENTS.MANDT == T417.MANDT
Long Text Language, for Creation of a Change Document P_VALID_COMPONENTS.LONGTEXTLANGUAGE == T002.SPRAS
Material Group
  • Client
  • Material Group
  • P_VALID_COMPONENTS.MANDT == T023.MANDT
  • P_VALID_COMPONENTS.MATERIALGROUP == T023.MATKL
Unit for lead-time offset for operation
  • Client
  • Unit for lead-time offset for operation
  • P_VALID_COMPONENTS.MANDT == T006.MANDT
  • P_VALID_COMPONENTS.OPSLEADTIMEOFFSETUNIT == T006.MSEHI
Issue Location for Production Order
  • Issue Location for Production Order
  • ?
  • Client
  • P_VALID_COMPONENTS.PRODORDERISSUELOCATION == T001L.LGORT
  • P_VALID_COMPONENTS.[column in domain "WERKS_D"] == T001L.WERKS
  • P_VALID_COMPONENTS.MANDT == T001L.MANDT
Production Supply Area
  • Production Supply Area
  • ?
  • Client
  • P_VALID_COMPONENTS.PRODUCTIONSUPPLYAREA == PVBE.PRVBE
  • P_VALID_COMPONENTS.[column in domain "WERKS_D"] == PVBE.WERKS
  • P_VALID_COMPONENTS.MANDT == PVBE.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_VALID_COMPONENTS.MANDT == T024.MANDT
  • P_VALID_COMPONENTS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_VALID_COMPONENTS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_VALID_COMPONENTS.MANDT == T024E.MANDT
Reference point for BOM transfer
  • Reference point for BOM transfer
  • Client
  • P_VALID_COMPONENTS.REFERENCEPOINT == TCNRFP.RFPNT
  • P_VALID_COMPONENTS.MANDT == TCNRFP.MANDT
Resulting item category
  • Client
  • Resulting item category
  • P_VALID_COMPONENTS.MANDT == T418.MANDT
  • P_VALID_COMPONENTS.RESULTINGITEMCATEGORY == T418.POSTP
Unit of measure for piece
  • Unit of measure for piece
  • Client
  • P_VALID_COMPONENTS.UNITOFMEASUREFORPIECE == T006.MSEHI
  • P_VALID_COMPONENTS.MANDT == T006.MANDT
Unit of measure for sizes 1 to 3
  • Client
  • Unit of measure for sizes 1 to 3
  • P_VALID_COMPONENTS.MANDT == T006.MANDT
  • P_VALID_COMPONENTS.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI
Unit of measure for variable-size items
  • Unit of measure for variable-size items
  • Client
  • P_VALID_COMPONENTS.UNITOFMEASUREFORVARSIZEITEM == T006.MSEHI
  • P_VALID_COMPONENTS.MANDT == T006.MANDT