I_ENGSNPSHTREFENGBOM

CDS View

Engineering Snapshot Reference Obj EBOM

I_ENGSNPSHTREFENGBOM is a CDS View in S/4HANA. Engineering Snapshot Reference Obj EBOM. It contains 16 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_EngSnpshtEBOM view from COMPOSITE Engineering snapshot EBOMs
I_EngSnpshtEBOMLtstRevision view from COMPOSITE Engineering Snapshot Latest Revision with EBOM
I_EngSnpshtEBOMWithoutHdrEBOM view from COMPOSITE EBOMs linked to Engineering snapshot without header EBOM
I_EngSnpshtHdrEBOM view from COMPOSITE Engineering snapshot header EBOM

Fields (16)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 4
KEY EngSnapshotID EngSnapshotID 2
KEY EngSnapshotRefUUID EngSnapshotRefUUID 3
KEY Material Material 4
KEY Plant Plant 4
BillOfMaterial BillOfMaterial 3
BillOfMaterialStatus BillOfMaterialStatus 3
BillOfMaterialVersion BillOfMaterialVersion 3
BOMVersionStatus BOMVersionStatus 3
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
EngSnapshotUUID EngSnapshotUUID 3
EngSnpshtRevisionNumber EngSnpshtRevisionNumber 1
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3

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.

-- Engineering Snapshot Reference Obj EBOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENGSNPSHTREFENGBOM (
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    ENGSNAPSHOTID,
    ENGSNAPSHOTREFUUID,
    MATERIAL,
    PLANT,
    BILLOFMATERIAL,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALVERSION,
    BOMVERSIONSTATUS,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ENGSNAPSHOTUUID,
    ENGSNPSHTREVISIONNUMBER,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, ENGSNAPSHOTID, ENGSNAPSHOTREFUUID, MATERIAL, PLANT)
);