I_MATERIALBOM

CDS View
49 Fields 28 CDS Views

Interface view to expose material and plant with header data

I_MATERIALBOM is a CDS View in S/4HANA. Interface view to expose material and plant with header data. It contains 49 fields. 28 CDS views read from this table.

CDS Views using this table (28)

ViewTypeJoinVDMDescription
C_EngineeringRedlineBOM view_entity from CONSUMPTION Bill of Material Redlining
C_LinkedProdnVersBOM view_entity from CONSUMPTION BOM to Material Assgmt in Rec prv
C_MaterialBOM view from CONSUMPTION Consumption view to consume & expose BOM
C_ProdnRtgVersAssignableBOM view_entity from CONSUMPTION Routing Version Assignable BOM
C_ProdnVersMatlBOMVersVH view from CONSUMPTION Material BOM Version
I_BillOfMaterialAPITP view from TRANSACTIONAL Bill of Material Header(Transactional Processing)
I_BillOfMaterialAPITP_1 view_entity from TRANSACTIONAL Bill of Material Header(Transactional Processing)
I_ChangeRecordMaterialBOM view from COMPOSITE Change Record Material BOM
I_ChgImpactBOMItem view inner COMPOSITE Bill of Material Items
I_EngBOM view from BASIC Engineering Bill of Materials
I_EngSnpshtObjRefBOM view_entity inner COMPOSITE Engineering Snapshot Reference Obj BOMs
I_EngSnpshtRefBOMForHndovr view_entity inner COMPOSITE Snapshot BOMs for Handover
I_EngSnpshtRefEngBOM view inner COMPOSITE Engineering Snapshot Reference Obj EBOM
I_EngSnpshtRefPlngBOM view_entity inner COMPOSITE Snapshot Reference Obj PBOM
I_MasterRecipeComponentAlloc view inner COMPOSITE Master Recipe Component Allocation Details
I_MfgBOM view from BASIC Manufacturing Bill Of Material
I_RecmddProdnVersMatlBOM view_entity from COMPOSITE Material BOM for Recmd Production Vers
I_RoutingComponentAlloc view_entity inner COMPOSITE Routing Component Allocation details
I_UnitizedMaterialVersBOM view from COMPOSITE Unitized Versioned Material BOM
P_EngBOMAssgdToChgRecd view inner COMPOSITE
P_MaterialBOMHdrLtstInstance view from COMPOSITE
P_MatlBOMHdrLtstInstanceDets view inner COMPOSITE
P_NonVersEBOMHdrLtstInstance view from COMPOSITE
P_NonVrsEngBillofMaterial view inner COMPOSITE
P_PlanningScopeHeader view union_all COMPOSITE
P_VersEngBillOfMaterial view from COMPOSITE
P_VersMFGBillofMaterial view from COMPOSITE
R_BillOfMaterialTP view_entity from TRANSACTIONAL Bill of Material Header

Fields (49)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 13
KEY BillOfMaterialCategory BillOfMaterialCategory,SourceBOMType 15
KEY BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 11
KEY BillOfMaterialVariant BillOfMaterialVariant,SourceBOMAlternative 20
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage,SourceBOMUsage 22
KEY BillOfMaterialVersion BillOfMaterialVersion 18
KEY EngineeringChangeDocument EngineeringChangeDocForEdit,EngineeringChangeDocument 10
KEY Material Material,SourceMaterial 21
KEY Plant Plant,SourcePlant 20
_BillOfMaterialItem _BillOfMaterialItem 5
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage 6
_BOMChangeNumbers _BOMChangeNumbers 1
_UnitOfMeasure _UnitOfMeasure 5
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 8
BillOfMaterialStatus BillOfMaterialStatus,BOMIsActive 13
BillOfMaterialUUID BillOfMaterialUUID 6
BOMAlternativeText BOMAlternativeText 10
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 1
BOMExplosionApplication BOMExplosionApplication 2
BOMGroup BOMGroup 8
BOMHeaderBaseUnit BOMHeaderBaseUnit 10
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 8
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 8
BOMHeaderText BOMHeaderText 9
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 2
BOMIsConfigurable BOMIsConfigurable 1
BOMIsToBeDeleted BOMIsToBeDeleted 8
BOMPrioritizedVersion BOMPrioritizedVersion 4
BOMTechnicalType BOMTechnicalType 5
BOMUsagePriority BOMUsagePriority 7
BOMVersionStatus BOMVersionStatus 12
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 8
CreatedByUser CreatedByUser 9
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 8
HeaderValidityEndDate HeaderValidityEndDate,ValidityEndDate 9
HeaderValidityStartDate HeaderValidityStartDate,ValidityStartDate 9
IsALE IsALE 8
IsConfiguredMaterial IsConfiguredMaterial 7
IsLatestBOMVersion IsLatestBOMVersion 9
IsMarkedForDeletion IsMarkedForDeletion 8
IsMultipleBOMAlt IsMultipleBOMAlt 7
IsVersionBillOfMaterial IsVersionBillOfMaterial 9
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 8
LastChangeDate LastChangeDate 10
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 9
MaterialToLotSizeQuantity MaterialToLotSizeQuantity 5
MatFromLotSizeQuantity MatFromLotSizeQuantity 5
RecordCreationDate RecordCreationDate 11

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.

-- Interface view to expose material and plant with header data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALBOM (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    _BILLOFMATERIALITEM,
    _BILLOFMATERIALVARIANTUSAGE,
    _BOMCHANGENUMBERS,
    _UNITOFMEASURE,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISCONFIGURABLE,
    BOMISTOBEDELETED,
    BOMPRIORITIZEDVERSION,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALTOLOTSIZEQUANTITY,
    MATFROMLOTSIZEQUANTITY,
    RECORDCREATIONDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALHEADERUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More