EHFNDV_CCMPS

21 Fields 2 CDS Views

Generated Table for View

EHFNDV_CCMPS is an SAP database table in S/4HANA. Generated Table for View. It contains 21 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 (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
substanceuuid EHFND_SUB_HOST_UUID Host Substance
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
chmlcompositiontype EHFND_CCI_CCMPS_TYPE Legal Area
prodcmplnclegalarea EHFND_LEGAL_AREA Legal Area
chmlcompositionstatus EHFND_CCI_CCMPS_STATUS Processing Status
releasedatetime EHFND_RELEASE_TS Composition Released On
releasedbyuser EHFND_RELEASE_USER Released By
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
chmlcmplncprodcatztnphrsuuid EHFND_CHM_PROD_CATZTNPHRS_UUID Product Categorization
pctrdscrtcalculationsetting EHFND_TS_CALCULATION_SETTING Handling of Concentrations
prodcmplnclegalarearef EHFND_LEGAL_AREA_REF Legal Area Reference
polymercompositionintid EHFND_SUB_PCMPS_INT_ID Internal Number
polymercompositionname EHFND_SUB_PCMPS_CCMPS_NAME Name

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_CCMPS (
    MANDT,                         -- Client [MANDT]
    CHMLCOMPOSITIONUUID,           -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHMLSUPLRMATLUUID,             -- Supplier Raw Material [EHFND_CSM_UUID]
    SUBSTANCEUUID,                 -- Host Substance [EHFND_SUB_HOST_UUID]
    CREATIONUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    CHMLCOMPOSITIONTYPE,           -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    PRODCMPLNCLEGALAREA,           -- Legal Area [EHFND_LEGAL_AREA]
    CHMLCOMPOSITIONSTATUS,         -- Processing Status [EHFND_CCI_CCMPS_STATUS]
    RELEASEDATETIME,               -- Composition Released On [EHFND_RELEASE_TS]
    RELEASEDBYUSER,                -- Released By [EHFND_RELEASE_USER]
    VALIDITYSTARTDATETIME,         -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,           -- Valid To [EHFND_VALID_TO_TSTMP]
    CHMLCMPLNCPRODCATZTNPHRSUUID,  -- Product Categorization [EHFND_CHM_PROD_CATZTNPHRS_UUID]
    PCTRDSCRTCALCULATIONSETTING,   -- Handling of Concentrations [EHFND_TS_CALCULATION_SETTING]
    PRODCMPLNCLEGALAREAREF,        -- Legal Area Reference [EHFND_LEGAL_AREA_REF]
    POLYMERCOMPOSITIONINTID,       -- Internal Number [EHFND_SUB_PCMPS_INT_ID]
    POLYMERCOMPOSITIONNAME,        -- Name [EHFND_SUB_PCMPS_CCMPS_NAME]
    PRIMARY KEY (MANDT, CHMLCOMPOSITIONUUID)
);

Learn More