EHFNDV_CCA_ADLPR

11 Fields 1 CDS Views

Generated Table for View

EHFNDV_CCA_ADLPR is an SAP database table in S/4HANA. Generated Table for View. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncAddlPrpty view from BASIC Chemical Compliance Addiitonal Property

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chmlcmplncaddlprptyuuid EHFND_CCA_ADLPR_UUID Chml Cmplnc Adl Prpt
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
chmlcmplncaddlprptyversionid EHFND_VERSION_NUMBER Version Number
chmlcmplncaddlprptystatus EHFND_CCA_ADLPR_STATUS Processing Status
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To

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_CCA_ADLPR (
    CLIENT,                        -- Client [MANDT]
    CHMLCMPLNCADDLPRPTYUUID,       -- Chml Cmplnc Adl Prpt [EHFND_CCA_ADLPR_UUID]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [EHFND_CCI_UUID]
    CREATIONUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    CHMLCMPLNCADDLPRPTYVERSIONID,  -- Version Number [EHFND_VERSION_NUMBER]
    CHMLCMPLNCADDLPRPTYSTATUS,     -- Processing Status [EHFND_CCA_ADLPR_STATUS]
    VALIDITYSTARTDATETIME,         -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,           -- Valid To [EHFND_VALID_TO_TSTMP]
    PRIMARY KEY (CLIENT, CHMLCMPLNCADDLPRPTYUUID)
);

Learn More