I_BILLOFMATERIALITEMBASIC

CDS View
72 Fields 5 CDS Views

Bill of Material Item Details

I_BILLOFMATERIALITEMBASIC is a CDS View in S/4HANA. Bill of Material Item Details. It contains 72 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BillOfMaterialSubItemsBasic view inner BASIC Bill of Material Sub items Details
I_ChgRecdRefBOMComponent view from BASIC Bill of Material Components for Change Record Ref.
I_TskPlngElmntBOMItemBasic view_entity from BASIC Task Planning Element BOM Item Basic
P_ProductionModelBOMItem view_entity inner COMPOSITE
P_ProductionModelComponent view_entity from COMPOSITE Prodn Model Sales Order Component

Fields (72)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 3
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID,ProductionModelComponentUUID 3
KEY BOMItemInternalChangeCount BOMItemInternalChangeCount 3
AlternativeItemGroup AlternativeItemGroup 2
AlternativeItemPriority AlternativeItemPriority 2
AlternativeItemStrategy AlternativeItemStrategy 2
BillOfMaterialComponent BillOfMaterialComponent 3
BillOfMaterialItemCategory BillOfMaterialItemCategory 2
BillOfMaterialItemNumber BillOfMaterialItemNumber 2
BillOfMaterialItemUnit BillOfMaterialItemUnit 2
BOMIsRecursive BOMIsRecursive 2
BOMItemCreatedByUser BOMItemCreatedByUser,RecordCreatedByUser 3
BOMItemIsCostingRelevant BOMItemIsCostingRelevant 2
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 2
BOMItemIsSalesRelevant BOMItemIsSalesRelevant 2
BOMItemIsSparePart BOMItemIsSparePart,MatlComponentSparePartType 3
BOMItemLastChangeDate BOMItemLastChangeDate,LastChangedDate 3
BOMItemLastChangedByUser BOMItemLastChangedByUser,LastChangedByUser 3
BOMItemRecordCreationDate BOMItemRecordCreationDate,RecordCreatedDate 3
BOMItemSorter BOMItemSorter 2
BOMItemText1 BOMItemDescription 2
BOMItemText2 BOMItemText2 2
ComponentScrapInPercent ComponentScrapInPercent 2
CostElement CostElement 2
Currency Currency 2
DeliveryDurationInDays DeliveryDurationInDays 2
DependencyObjectNumber DependencyObjectNumber 2
DiscontinuationGroup DiscontinuationGroup 2
DistrKeyCompConsumption DistrKeyCompConsumption 2
DocNumber DocNumber 2
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 2
DocumentPart DocumentPart 2
DocumentType DocumentType 2
DocumentVersion DocumentVersion 2
EngineeringChangeDocument EngineeringChangeDocument 2
ExplosionType ExplosionType 2
FixedQuantity BOMItemHasFixedQuantity 3
FollowUpGroup FollowUpGroup 2
FormulaKey FormulaKey 2
GoodsReceiptDuration GoodsReceiptDuration 2
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 2
IsALE IsALE 2
IsBOMRecursiveAllowed IsBOMRecursiveAllowed 2
IsBulkMaterial IsBulkMaterial 2
IsDeleted IsDeleted 2
IsEngineeringRelevant IsEngineeringRelevant 2
IsMaterialProvision IsMaterialProvision 2
IsNetScrap IsNetScrap 2
IsProductionRelevant IsProductionRelevant 2
IsSubItem IsSubItem 2
LeadTimeOffset LeadTimeOffset 2
MaterialComponentPrice MaterialComponentPrice 2
MaterialGroup MaterialGroup 2
MaterialIsCoProduct MaterialIsCoProduct 2
NumberOfVariableSizeItem NumberOfVariableSizeItem 2
ObjectType BillOfMaterialItemObjectType 2
OperationLeadTimeOffset OperationLeadTimeOffset 2
OperationScrapInPercent OperationScrapInPercent 2
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 2
ProdOrderIssueLocation ProdOrderIssueLocation 2
ProductionSupplyArea ProductionSupplyArea 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
QuantityVariableSizeItem QuantityVariableSizeItem 2
ReferencePoint ReferencePoint 2
Size1 Size1 2
Size2 Size2 2
Size3 Size3 2
SpecialProcurementType SpecialProcurementType 2
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3 2
UsageProbabilityPercent UsageProbabilityPercent 2
ValidityStartDate ValidityStartDate 2

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 Item Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIALITEMBASIC (
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMUUID,
    BOMITEMINTERNALCHANGECOUNT,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMUNIT,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT1,
    BOMITEMTEXT2,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISCONTINUATIONGROUP,
    DISTRKEYCOMPCONSUMPTION,
    DOCNUMBER,
    DOCUMENTISCREATEDBYCAD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    EXPLOSIONTYPE,
    FIXEDQUANTITY,
    FOLLOWUPGROUP,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    INHERITEDNODENUMBERVERSIONBOM,
    ISALE,
    ISBOMRECURSIVEALLOWED,
    ISBULKMATERIAL,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPRODUCTIONRELEVANT,
    ISSUBITEM,
    LEADTIMEOFFSET,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALISCOPRODUCT,
    NUMBEROFVARIABLESIZEITEM,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    PRODORDERISSUELOCATION,
    PRODUCTIONSUPPLYAREA,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUANTITYVARIABLESIZEITEM,
    REFERENCEPOINT,
    SIZE1,
    SIZE2,
    SIZE3,
    SPECIALPROCUREMENTTYPE,
    UNITOFMEASUREFORSIZE1TO3,
    USAGEPROBABILITYPERCENT,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALITEMUUID, BOMITEMINTERNALCHANGECOUNT)
);

Learn More