I_ENGSNPSHTEBOM

CDS View
23 Fields 3 CDS Views

Engineering snapshot EBOMs

I_ENGSNPSHTEBOM is a CDS View in S/4HANA. Engineering snapshot EBOMs. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_EngSnpshtInitChgPrep view from CONSUMPTION Engineering snapshot initial change preparation
C_EngSnpshtInitChgPrepEBOM view from CONSUMPTION Engineering Snapshot EBOM
C_EngSnpshtObjPgEngBOM view inner CONSUMPTION Engineering Snapshot Ref Obj Page EBOM

Fields (23)

KeyField CDS FieldsUsed in Views
KEY EngSnapshotRefUUID EngSnapshotRefUUID 3
KEY EngSnapshotUUID EngSnapshotUUID 3
BillOfMaterial BillOfMaterial 3
BillOfMaterialStatus BillOfMaterialStatus 3
BillOfMaterialVariant BillOfMaterialVariant 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
BillOfMaterialVersion BillOfMaterialVersion 3
BOMVersionStatus BOMVersionStatus 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 3
EngSnapshotID EngSnapshotID 3
EngSnpshtAuxiliaryPrepSts EngSnpshtAuxiliaryPrepSts 1
EngSnpshtHdrEBOMMaterial EngSnpshtHdrEBOMMaterial 1
EngSnpshtHdrEBOMPlant EngSnpshtHdrEBOMPlant 1
EngSnpshtHdrEBOMVariant EngSnpshtHdrEBOMVariant 1
EngSnpshtHdrEBOMVariantUsage EngSnpshtHdrEBOMVariantUsage 1
EngSnpshtProposedEffectiveDate EngSnpshtProposedEffectiveDate 1
EngSnpshtRevisionNumber EngSnpshtRevisionNumber 3
IsBOMHeader IsBOMHeader 3
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 1
Material Material 3
Plant Plant 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 EBOMs
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENGSNPSHTEBOM (
    ENGSNAPSHOTREFUUID,
    ENGSNAPSHOTUUID,
    BILLOFMATERIAL,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMVERSIONSTATUS,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ENGSNAPSHOTID,
    ENGSNPSHTAUXILIARYPREPSTS,
    ENGSNPSHTHDREBOMMATERIAL,
    ENGSNPSHTHDREBOMPLANT,
    ENGSNPSHTHDREBOMVARIANT,
    ENGSNPSHTHDREBOMVARIANTUSAGE,
    ENGSNPSHTPROPOSEDEFFECTIVEDATE,
    ENGSNPSHTREVISIONNUMBER,
    ISBOMHEADER,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PLANT,
    PRIMARY KEY (ENGSNAPSHOTREFUUID, ENGSNAPSHOTUUID)
);

Learn More