I_BILLOFMATERIAL

CDS View
44 Fields 25 CDS Views

Bill of Material

I_BILLOFMATERIAL is a CDS View in S/4HANA. Bill of Material. It contains 44 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_BOMItemForCustomerReturn view from CONSUMPTION BOM Items for Customer Return
C_ChangeRecordETOVersBOMVH view from CONSUMPTION ETO Version BOM
C_EngSnpshtObjPgMfgBOM view inner CONSUMPTION Engineering Snapshot Ref Obj Page MBOM
CIC_BOM_FILTER view_entity from Bill of Material Filter
CIC_BOM_HEADER view_entity from Bill of Material Header
I_BillOfMaterialSubItemsHeader view inner COMPOSITE Composite for sub items
I_BOMItemHdrChangeState view inner COMPOSITE BOM Item with Header Changes
I_ChangeRecordBillOfMaterial view from COMPOSITE Change Record Bill Of Material
I_ChangeRecordOrderBOM view from COMPOSITE Change Record Order Bill of Material
I_ChangeRecordStdBOM view from COMPOSITE Change Record Order Bill of Material
I_ChangeRecordWBSElmntBOM view from COMPOSITE Change Record WBS Bill of Material
I_ChgImpactBOMLtstChgState view from COMPOSITE BOM Header Latest Change States
I_ChgRecdEquipBOM view from COMPOSITE Change Record EQUIP BOM
I_ChgRecdFuncLocBOM view from COMPOSITE Chg Recd Funloc BOM
I_DocInfoRecdStructure view from COMPOSITE Document Structure Header Details
I_MaintBOMItemHdrChangeState view inner COMPOSITE Maintenance BOM Item with Header Changes
I_MaintenanceBillOfMaterial view from COMPOSITE Maintenance Bill of Material Header
I_MaterialBOM view from BASIC Interface view to expose material and plant with header data
I_MfgBOMItemWithPhantomHier view_entity inner COMPOSITE MBOM items with phantom hierarchy
I_SalesBOMItemHdrChangeState view inner COMPOSITE Sales Order BOM Item change state
P_BillOfMaterialHeader view from COMPOSITE
P_BillOfMaterialHeader view union_all COMPOSITE
P_Billofmaterialwd view union_all COMPOSITE
P_Bomchangehistory view inner COMPOSITE
P_SalesOrderBOMHeader view from BASIC Private view for Sales order BoM header

Fields (44)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 7
KEY BillOfMaterialCategory BillOfMaterialCategory,Category 9
KEY BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 15
KEY BillOfMaterialVariant AlternativeBillOfMaterial,BillOfMaterialVariant,Variant 11
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage,BOMUsage 11
KEY BillOfMaterialVersion BillOfMaterialVersion,Version 7
KEY BOMHeaderInternalChangeCount BillOfMaterialItemNodeNumber,BOMHeaderInternalChangeCount 9
KEY EngineeringChangeDocument EngineeringChangeDocument,HeaderChangeDocument 10
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 6
BillOfMaterialStatus BillOfMaterialStatus,Status 7
BillOfMaterialUUID BillOfMaterialUUID 3
BOMAlternativeText BOMAlternativeText 6
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 3
BOMExplosionApplication BOMExplosionApplication 4
BOMGroup BOMGroup 6
BOMHeaderBaseUnit BaseUnit,BOMHeaderBaseUnit 7
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit,QuantityInBaseUnit 7
BOMHeaderText BOMHeaderText 6
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 3
BOMIsToBeDeleted BOMIsToBeDeleted 6
BOMPredecessorVersion BOMPredecessorVersion 3
BOMPrioritizedVersion BOMPrioritizedVersion 4
BOMTechnicalType BOMTechnicalType 4
BOMUsagePriority BOMUsagePriority 5
BOMVersionStatus BOMVersionStatus 6
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 6
CreatedByUser CreatedByUser 6
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 6
HeaderValidityEndDate HeaderValidityEndDate,ValidityEndDate 7
HeaderValidityStartDate HeaderValidityStartDate,ValidityStartDate 7
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 2
IndicatorIsBOMWithDateHistory IndicatorIsBOMWithDateHistory 2
IsALE IsALE 3
IsConfiguredMaterial IsConfiguredMaterial 5
IsLatestBOMVersion IsLatestBOMVersion 6
IsMarkedForDeletion DocInfoRecdIsMarkedForDeletion,IsMarkedForDeletion 6
IsMultipleBOMAlt IsMultipleBOMAlt 5
IsVersionBillOfMaterial IsVersionBillOfMaterial 8
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 6
LastChangeDate LastChangeDate 6
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 6
LongTextLanguage LongTextLanguage 2
RecordCreationDate RecordCreationDate 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIAL (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMHEADERINTERNALCHANGECOUNT,
    ENGINEERINGCHANGEDOCUMENT,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISTOBEDELETED,
    BOMPREDECESSORVERSION,
    BOMPRIORITIZEDVERSION,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    INDICATORISBOMCHANGEDWITHHIST,
    INDICATORISBOMWITHDATEHISTORY,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LONGTEXTLANGUAGE,
    RECORDCREATIONDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALHEADERUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, BOMHEADERINTERNALCHANGECOUNT, ENGINEERINGCHANGEDOCUMENT)
);

Learn More