I_BILLOFMATERIALITEM

CDS View
90 Fields 14 CDS Views

Bill of Material Items

I_BILLOFMATERIALITEM is a CDS View in S/4HANA. Bill of Material Items. It contains 90 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_ChangeRecordBOMItem view from COMPOSITE Change Record Bill Of Material item
I_ChgAlertBOOOpBOMItmChgState view inner COMPOSITE BOO Op BOM Item Chg State (Change Alert)
I_ChgImpactBOMItem view from COMPOSITE Bill of Material Items
I_DocInfoRecdStructureItem view from COMPOSITE Document Stucture Item Details
I_JITOutbCallsBOMTP view inner TRANSACTIONAL Transactional View for BOM Explosion
I_JITOutbCtrlCycBOMSchedgAgrmt view inner COMPOSITE Control Cycle BOM Scheduling agreement
I_ProductionModelComponent view_entity from COMPOSITE Production Model Component
I_SourceBOMHierarchyNodeRltn view_entity from COMPOSITE Source BOM Hierarchy Node Relation
I_SourceBOMHierarchyNodeRltn view_entity inner COMPOSITE Source BOM Hierarchy Node Relation
P_Billofmaterialitemwd view union_all COMPOSITE Bill Of Material Item with Draft Data
P_Bomchangehistory view inner COMPOSITE Change History of BOM
P_BOMItmValdty view from COMPOSITE Validity of BOM items-Last Change State
P_ChgRecdRefBITAfterDataMigrtn view inner COMPOSITE Change Record Reference BOM Item After Data Migration
P_SlowOrNonMvgMatlBOMUsage view_entity from COMPOSITE SlowNonMovingMaterials: BOM Usage

Fields (90)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 6
KEY BillOfMaterialCategory BillOfMaterialCategory 6
KEY BillOfMaterialComponent BillOfMaterialComponent,Material 9
KEY BillOfMaterialItemNumber BillOfMaterialItemNumber 6
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID,ProductionModelComponentUUID,SourceBOMPhantomNodeUUID 7
KEY BillOfMaterialVariant AlternativeBillOfMaterial,BillOfMaterialVariant 8
KEY BillOfMaterialVersion BillOfMaterialVersion 5
KEY ProdOrderIssueLocation ProdOrderIssueLocation 4
_UnitOfMeasure _UnitOfMeasure 1
AlternativeItemGroup AlternativeItemGroup 2
BillOfMaterialItemCategory BillOfMaterialItemCategory 5
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 4
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 7
BillOfMaterialItemUnit BillOfMaterialItemUnit 7
BOMIsRecursive BOMIsRecursive 3
BOMItemCreatedByUser BOMItemCreatedByUser,CreatedByUser 2
BOMItemDescription BOMItemDescription 3
BOMItemHasFixedQuantity BOMItemHasFixedQuantity 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 3
BOMItemIsCostingRelevant BOMItemIsCostingRelevant 2
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 3
BOMItemIsSalesRelevant BOMItemIsSalesRelevant 2
BOMItemIsSparePart BOMItemIsSparePart 2
BOMItemLastChangeDate BOMItemLastChangeDate 2
BOMItemLastChangedByUser BOMItemLastChangedByUser,LastChangedByUser 2
BOMItemRecordCreationDate BOMItemRecordCreationDate,CreationDate,LastChangeDate 3
BOMItemSorter BOMItemSorter 3
BOMItemText2 BOMItemText2 3
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 4
ClassNumber ClassNumber 1
ClassType ClassType 1
ComponentScrapInPercent ComponentScrapInPercent 2
CostElement CostElement 2
Creditor Creditor 2
Currency Currency 2
DeliveryDurationInDays DeliveryDurationInDays 2
DependencyObjectNumber DependencyObjectNumber 2
DiscontinuationGroup DiscontinuationGroup 2
DistrKeyCompConsumption DistrKeyCompConsumption 2
DocNumber DocNumber,DocumentInfoRecord 3
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 3
DocumentPart DocumentPart 3
DocumentType DocumentType 3
DocumentVersion DocumentVersion 3
EngineeringChangeDocument EngineeringChangeDocument 5
ExplosionType ExplosionType 2
FixedQuantity FixedQuantity 2
FollowUpGroup FollowUpGroup 2
FormulaKey FormulaKey 2
GoodsReceiptDuration GoodsReceiptDuration 2
IdentifierBOMItem IdentifierBOMItem 1
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 2
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 2
IsALE IsALE 3
IsAssembly IsAssembly 3
IsBOMRecursiveAllowed IsBOMRecursiveAllowed 3
IsBulkMaterial IsBulkMaterial 2
IsClassificationRelevant IsClassificationRelevant 1
IsConfigurableBOM IsConfigurableBOM 1
IsDeleted IsDeleted 3
IsEngineeringRelevant IsEngineeringRelevant 3
IsMaterialProvision IsMaterialProvision 2
IsNetScrap IsNetScrap 2
IsProductionRelevant IsProductionRelevant 2
IsSubItem IsSubItem 3
LeadTimeOffset LeadTimeOffset 2
MaterialComponentPrice MaterialComponentPrice 2
MaterialGroup MaterialGroup 3
MaterialIsCoProduct MaterialIsCoProduct 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
MultipleSelectionAllowed MultipleSelectionAllowed 1
NumberOfVariableSizeItem NumberOfVariableSizeItem 1
ObjectType ObjectType 1
OperationLeadTimeOffset OperationLeadTimeOffset 2
OperationScrapInPercent OperationScrapInPercent 2
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 2
ProductionSupplyArea ProductionSupplyArea 4
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
QuantityVariableSizeItem QuantityVariableSizeItem 2
ReferencePoint ReferencePoint 3
RequiredComponent RequiredComponent 1
ResultingItemCategory ResultingItemCategory 1
Size1 Size1 2
Size2 Size2 2
Size3 Size3 2
SpecialProcurementType SpecialProcurementType 2
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3 2
ValidityEndDate ValidityEndDate 4
ValidityStartDate ValidityStartDate 5

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.

-- Bill of Material Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIALITEM (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    PRODORDERISSUELOCATION,
    _UNITOFMEASURE,
    ALTERNATIVEITEMGROUP,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMDESCRIPTION,
    BOMITEMHASFIXEDQUANTITY,
    BOMITEMINTERNALCHANGECOUNT,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT2,
    CHGTOENGINEERINGCHGDOCUMENT,
    CLASSNUMBER,
    CLASSTYPE,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CREDITOR,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISCONTINUATIONGROUP,
    DISTRKEYCOMPCONSUMPTION,
    DOCNUMBER,
    DOCUMENTISCREATEDBYCAD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    EXPLOSIONTYPE,
    FIXEDQUANTITY,
    FOLLOWUPGROUP,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    IDENTIFIERBOMITEM,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    ISALE,
    ISASSEMBLY,
    ISBOMRECURSIVEALLOWED,
    ISBULKMATERIAL,
    ISCLASSIFICATIONRELEVANT,
    ISCONFIGURABLEBOM,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPRODUCTIONRELEVANT,
    ISSUBITEM,
    LEADTIMEOFFSET,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALISCOPRODUCT,
    MATERIALPRICEUNITQTY,
    MULTIPLESELECTIONALLOWED,
    NUMBEROFVARIABLESIZEITEM,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    PRODUCTIONSUPPLYAREA,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUANTITYVARIABLESIZEITEM,
    REFERENCEPOINT,
    REQUIREDCOMPONENT,
    RESULTINGITEMCATEGORY,
    SIZE1,
    SIZE2,
    SIZE3,
    SPECIALPROCUREMENTTYPE,
    UNITOFMEASUREFORSIZE1TO3,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALCOMPONENT, BILLOFMATERIALITEMNUMBER, BILLOFMATERIALITEMUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, PRODORDERISSUELOCATION)
);

Learn More