P_BOMITEMS

CDS View
103 Fields 6 CDS Views

Get Valid BOM items for BOM header

P_BOMITEMS is a CDS View in S/4HANA. Get Valid BOM items for BOM header. It contains 103 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BillOfMaterialComponent view from COMPOSITE Bill of Material Components
I_BillOfMaterialItem view from COMPOSITE Bill of Material Items
I_ChgImpactETOVersBOMItem view from COMPOSITE ETO Version BOM Items
P_BOMCOMPONENTS view from BASIC Get Valid BOM items for BOM header
P_BOMComponentsWithKeyDate view from COMPOSITE
P_OpActyInstceRefCompInstce view_entity inner COMPOSITE Reference Component instance of an OA

Fields (103)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 3
KEY BillOfMaterialCategory BillOfMaterialCategory 4
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 3
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID 2
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY BillOfMaterialVersion BillOfMaterialVersion 4
KEY BOMItemInternalChangeCount BOMItemInternalChangeCount 1
AlternativeItemGroup AlternativeItemGroup 3
AlternativeItemPriority AlternativeItemPriority 2
AlternativeItemStrategy AlternativeItemStrategy 2
BillOfMaterialComponent BillOfMaterialComponent 4
BillOfMaterialItemCategory BillOfMaterialItemCategory 3
BillOfMaterialItemNumber BillOfMaterialItemNumber 3
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 1
BillOfMaterialItemUnit BillOfMaterialItemUnit 1
BOMIsRecursive BOMIsRecursive 3
BOMItemCreatedByUser BOMItemCreatedByUser 3
BOMItemDescription BOMItemDescription 3
BOMItemHasFixedQuantity BOMItemHasFixedQuantity 3
BOMItemIsCostingRelevant BOMItemIsCostingRelevant 3
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 3
BOMItemIsSalesRelevant BOMItemIsSalesRelevant 3
BOMItemIsSparePart BOMItemIsSparePart 3
BOMItemLastChangeDate BOMItemLastChangeDate 3
BOMItemLastChangedByUser BOMItemLastChangedByUser 3
BOMItemRecordCreationDate BOMItemRecordCreationDate 1
BOMItemSorter BOMItemSorter 3
BOMItemText2 BOMItemText2 3
ChangeNumberFrom EngineeringChangeDocument 4
ChangeNumberTo ChgToEngineeringChgDocument 1
ClassNumber ClassNumber 3
ClassType ClassType 3
ComponentScrapInPercent ComponentScrapInPercent 3
CostElement CostElement 3
Creditor Creditor 3
Currency Currency 3
DeliveryDurationInDays DeliveryDurationInDays 3
DependencyObjectNumber DependencyObjectNumber 3
DiscontinuationGroup DiscontinuationGroup 3
DistrKeyCompConsumption DistrKeyCompConsumption 3
DocNumber DocNumber 3
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 4
DocumentPart DocumentPart 3
DocumentType DocumentType 3
DocumentVersion DocumentVersion 3
ExplosionType ExplosionType 3
FixedQuantity FixedQuantity 3
FollowUpGroup FollowUpGroup 3
FormulaKey FormulaKey 3
GoodsReceiptDuration GoodsReceiptDuration 3
IdentifierBOMItem IdentifierBOMItem 3
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 3
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 3
IsALE IsALE 4
IsAssembly IsAssembly 1
IsBOMRecursiveAllowed IsBOMRecursiveAllowed 3
IsBulkMaterial IsBulkMaterial 3
IsClassificationRelevant IsClassificationRelevant 3
IsConfigurableBOM IsConfigurableBOM 3
IsDeleted IsDeleted 3
IsEngineeringRelevant IsEngineeringRelevant 3
IsMaterialProvision IsMaterialProvision 3
IsNetScrap IsNetScrap 3
IsPhantomItem IsPhantomItem 1
IsPMAssemblyRelevant IsPMAssemblyRelevant 1
IsProductionRelevant IsProductionRelevant 3
IsSoftwareComponent IsSoftwareComponent 3
IsSubItem IsSubItem 3
LastChangeDateTime LastChangeDateTime 2
LeadTimeOffset LeadTimeOffset 3
LongTextLanguage LongTextLanguage 1
MaterialComponentPrice MaterialComponentPrice 3
MaterialGroup MaterialGroup 4
MaterialIsCoProduct MaterialIsCoProduct 3
MaterialPriceUnitQty MaterialPriceUnitQty 3
MultipleSelectionAllowed MultipleSelectionAllowed 3
NumberOfVariableSizeItem NumberOfVariableSizeItem 3
ObjectType ObjectType 3
OperationLeadTimeOffset OperationLeadTimeOffset 3
OperationScrapInPercent OperationScrapInPercent 3
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 3
OrigSalesOrderBOM OrigSalesOrderBOM 1
OrigSalesOrderBOMItmCategory OrigSalesOrderBOMItmCategory 2
OrigSalesOrderBOMItmNodeNumber OrigSalesOrderBOMItmNodeNumber 2
OrigSalesOrderBOMItmNumber OrigSalesOrderBOMItmNumber 2
PreliminaryMaterial PreliminaryMaterial 1
ProdOrderIssueLocation ProdOrderIssueLocation 3
ProductionSupplyArea ProductionSupplyArea 3
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
QuantityVariableSizeItem QuantityVariableSizeItem 2
ReferencePoint ReferencePoint 3
RequiredComponent RequiredComponent 3
ResultingItemCategory ResultingItemCategory 3
Size1 Size1 3
Size2 Size2 3
Size3 Size3 3
SpecialProcurementType SpecialProcurementType 3
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3 3
UnitOfMeasureForVarSizeItem UnitOfMeasureForVarSizeItem 2
UsageProbabilityPercent UsageProbabilityPercent 2
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Get Valid BOM items for BOM header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BOMITEMS (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEMINTERNALCHANGECOUNT,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMDESCRIPTION,
    BOMITEMHASFIXEDQUANTITY,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT2,
    CHANGENUMBERFROM,
    CHANGENUMBERTO,
    CLASSNUMBER,
    CLASSTYPE,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CREDITOR,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISCONTINUATIONGROUP,
    DISTRKEYCOMPCONSUMPTION,
    DOCNUMBER,
    DOCUMENTISCREATEDBYCAD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    EXPLOSIONTYPE,
    FIXEDQUANTITY,
    FOLLOWUPGROUP,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    IDENTIFIERBOMITEM,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    ISALE,
    ISASSEMBLY,
    ISBOMRECURSIVEALLOWED,
    ISBULKMATERIAL,
    ISCLASSIFICATIONRELEVANT,
    ISCONFIGURABLEBOM,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPHANTOMITEM,
    ISPMASSEMBLYRELEVANT,
    ISPRODUCTIONRELEVANT,
    ISSOFTWARECOMPONENT,
    ISSUBITEM,
    LASTCHANGEDATETIME,
    LEADTIMEOFFSET,
    LONGTEXTLANGUAGE,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALISCOPRODUCT,
    MATERIALPRICEUNITQTY,
    MULTIPLESELECTIONALLOWED,
    NUMBEROFVARIABLESIZEITEM,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    ORIGSALESORDERBOM,
    ORIGSALESORDERBOMITMCATEGORY,
    ORIGSALESORDERBOMITMNODENUMBER,
    ORIGSALESORDERBOMITMNUMBER,
    PRELIMINARYMATERIAL,
    PRODORDERISSUELOCATION,
    PRODUCTIONSUPPLYAREA,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUANTITYVARIABLESIZEITEM,
    REFERENCEPOINT,
    REQUIREDCOMPONENT,
    RESULTINGITEMCATEGORY,
    SIZE1,
    SIZE2,
    SIZE3,
    SPECIALPROCUREMENTTYPE,
    UNITOFMEASUREFORSIZE1TO3,
    UNITOFMEASUREFORVARSIZEITEM,
    USAGEPROBABILITYPERCENT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALITEMUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, BOMITEMINTERNALCHANGECOUNT)
);

Learn More