EHFNDV_CCMPS

7 Fields 2 CDS Views

EHFNDV_CCMPS is an SAP database table in S/4HANA. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChmlComposition view from BASIC Chemical Composition
I_SubstVolRetrckgChmlCmpstn view from BASIC Subst Vol Retracking Composition Details

Fields (7)

KeyField CDS FieldsUsed in Views
KEY chmlcompositionuuid ChmlCompositionUUID 1
chmlcmplncinfouuid ChmlCmplncInfoUUID 1
chmlcompositiontype ChmlCompositionType 1
createdbyuser CreatedByUser 1
lastchangeutcdatetime LastChangeUTCDateTime 1
validityenddatetime ValidityEndDateTime 1
validitystartdatetime ValidityStartDateTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_CCMPS (
    CHMLCOMPOSITIONUUID,
    CHMLCMPLNCINFOUUID,
    CHMLCOMPOSITIONTYPE,
    CREATEDBYUSER,
    LASTCHANGEUTCDATETIME,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CHMLCOMPOSITIONUUID)
);

Learn More