I_BILLOFMATERIALITEMBASIC

CDS View
72 Fields 3 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. 3 CDS views read from this table.

CDS Views using this table (3)

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.
P_ProductionModelComponent view_entity from COMPOSITE Prodn Model Sales Order Component

Fields (72)

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

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 (
    BILLOFMATERIALITEMUUID,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMUNIT,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMINTERNALCHANGECOUNT,
    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 (BILLOFMATERIALITEMUUID)
);

Learn More