P_Valid_VersionBomitems

Get Valid Version BOM items | view: PVALIDVERSNBOM | TRAN | Extraction: Not supported | Component: Bills of Material
Tables used: MAST, STAS, STPO, T414, T460A, TCS03
Column Name Description
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
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
IsAssembly Checkbox Show values
IsPhantomItem Checkbox Show values
Column Name Description Domain name
BillOfMaterial Bill of Material STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialItemNodeNumber BOM item node number KNTNR
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
ChangeNumberTo Change Number To AENNR
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
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
AlternativeItemGroup Alternative item: group CHAR2
FollowUpGroup Follow-up group CHAR2
DiscontinuationGroup Discontinuation group CHAR2
ReinsurContrOrgUnit Organizational Area CHAR10
LeadTimeOffset Lead-time offset NLFZT
Master Data Relations Join Conditions
Item category (bill of material)
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T418.MANDT
  • P_VALID_VERSIONBOMITEMS.BILLOFMATERIALITEMCATEGORY == T418.POSTP
Component Unit of Measure
  • Component Unit of Measure
  • Client
  • P_VALID_VERSIONBOMITEMS.BILLOFMATERIALITEMUNIT == T006.MSEHI
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T006.MANDT
for every costing relevancy none, one or several entries
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == TCK08.MANDT
  • P_VALID_VERSIONBOMITEMS.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ
Indicator: item relevant to sales
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == TVRL.MANDT
  • P_VALID_VERSIONBOMITEMS.BOMITEMISSALESRELEVANT == TVRL.RVREL
Indicator: Spare Part
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T413.MANDT
  • P_VALID_VERSIONBOMITEMS.BOMITEMISSPAREPART == T413.ERSKZ
Change Number
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == AENR.MANDT
  • P_VALID_VERSIONBOMITEMS.CHANGENUMBERFROM == AENR.AENNR
Class Type
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == TCLA.MANDT
  • P_VALID_VERSIONBOMITEMS.CLASSTYPE == TCLA.KLART
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_VALID_VERSIONBOMITEMS.CREDITOR == LFA1.LIFNR
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == LFA1.MANDT
Currency Key
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == TCURC.MANDT
  • P_VALID_VERSIONBOMITEMS.CURRENCY == TCURC.WAERS
Distribution key for component consumption
  • Distribution key for component consumption
  • ?
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T437V.MANDT
  • P_VALID_VERSIONBOMITEMS.DISTRKEYCOMPCONSUMPTION == T437V.VERTL
  • P_VALID_VERSIONBOMITEMS.[column in domain "WERKS_D"] == T437V.WERKS
Explosion type
  • Explosion type
  • Client
  • P_VALID_VERSIONBOMITEMS.EXPLOSIONTYPE == T414.DISPO
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T414.MANDT
Formula Key for Variable-Size Items
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T418F.MANDT
  • P_VALID_VERSIONBOMITEMS.FORMULAKEY == T418F.RFORM
Material Provision Indicator
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T417.MANDT
  • P_VALID_VERSIONBOMITEMS.ISMATERIALPROVISION == T417.BEIKZ
Material Group
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T023.MANDT
  • P_VALID_VERSIONBOMITEMS.MATERIALGROUP == T023.MATKL
Unit for lead-time offset for operation
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T006.MANDT
  • P_VALID_VERSIONBOMITEMS.OPSLEADTIMEOFFSETUNIT == T006.MSEHI
Issue Location for Production Order
  • Issue Location for Production Order
  • ?
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T001L.MANDT
  • P_VALID_VERSIONBOMITEMS.PRODORDERISSUELOCATION == T001L.LGORT
  • P_VALID_VERSIONBOMITEMS.[column in domain "WERKS_D"] == T001L.WERKS
Production Supply Area
  • Production Supply Area
  • ?
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == PVBE.MANDT
  • P_VALID_VERSIONBOMITEMS.PRODUCTIONSUPPLYAREA == PVBE.PRVBE
  • P_VALID_VERSIONBOMITEMS.[column in domain "WERKS_D"] == PVBE.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • P_VALID_VERSIONBOMITEMS.PURCHASINGGROUP == T024.EKGRP
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T024.MANDT
Purchasing organization
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T024E.MANDT
  • P_VALID_VERSIONBOMITEMS.PURCHASINGORGANIZATION == T024E.EKORG
Reference point for BOM transfer
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == TCNRFP.MANDT
  • P_VALID_VERSIONBOMITEMS.REFERENCEPOINT == TCNRFP.RFPNT
Resulting item category
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T418.MANDT
  • P_VALID_VERSIONBOMITEMS.RESULTINGITEMCATEGORY == T418.POSTP
Client P_VALID_VERSIONBOMITEMS.SAPCLIENT == T000.MANDT
Unit of measure for sizes 1 to 3
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T006.MANDT
  • P_VALID_VERSIONBOMITEMS.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI
Unit of measure for piece
  • Unit of measure for piece
  • Client
  • P_VALID_VERSIONBOMITEMS.UNITOFMEASUREFORVARSIZEITEM == T006.MSEHI
  • P_VALID_VERSIONBOMITEMS.SAPCLIENT == T006.MANDT