I_MATERIALBOMLINK

CDS View
8 Fields 11 CDS Views

Material Link for Bill of Material

I_MATERIALBOMLINK is a CDS View in S/4HANA. Material Link for Bill of Material. It contains 8 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_OpActyInstceReferenceCompVH view_entity inner CONSUMPTION Reference component of an OA instance
CIC_BOM_FILTER view_entity left_outer Bill of Material Filter
I_BomHeaderChanges view inner BASIC BOM Header Changes
I_MaterialBOMHeaderSearch view from BASIC BOM header view for CDS based search model.
I_ProjNtwkActyMatBOMAssembly view from COMPOSITE BOM Assembly for Ntwk Activity Comp
I_TskPlngElmntBOMLink view_entity from BASIC Task Planning Element BOM Link
P_BOMHeaderType view from BASIC
P_BOMItemChanges view inner BASIC
P_ChgRecdRefBITAfterDataMigrtn view inner COMPOSITE
P_EngSnpshtMfgBOM view_entity from COMPOSITE All Material and Sales Order BOM
P_JITOutBOMData view from TRANSACTIONAL Bill of material data

Fields (8)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 2
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 7
KEY Material Material 6
KEY Plant BOMOrBOMAltvCrtedInPlnt,Plant 7
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 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.

-- Material Link for Bill of Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALBOMLINK (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    MATERIAL,
    PLANT,
    CREATEDBYUSER,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, MATERIAL, PLANT)
);

Learn More