EHFNDW_CCA_ADLPR

Transparent Table Application Table
13 Fields 1 CDS Views

I_CHMLCMPLNCADDLPRPTYTP I_CHMLCMPLNCADDLPRPTYTP

EHFNDW_CCA_ADLPR is an SAP database table in S/4HANA. I_CHMLCMPLNCADDLPRPTYTP I_CHMLCMPLNCADDLPRPTYTP. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncAddlPrptyDraft view from BASIC Chml Cmplnc Addl Prprty - Draft

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncaddlprptyuuid ehfnd_cca_adlpr_uuid Chml Cmplnc Adl Prpt
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
chmlcmplncaddlprptyversionid ehfnd_version_number Version Number
chmlcmplncaddlprptystatus ehfnd_cca_adlpr_status Processing Status
creationutcdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangeutcdatetime timestampl Time Stamp
lastchangedbyuser uname User Name
validitystartdatetime ehfnd_valid_from_tstmp Valid From
validityenddatetime ehfnd_valid_to_tstmp Valid To
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_CHMLCMPLNCADDLPRPTYTP I_CHMLCMPLNCADDLPRPTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCA_ADLPR (
    MANDT,                         -- Client [mandt]
    CHMLCMPLNCADDLPRPTYUUID,       -- Chml Cmplnc Adl Prpt [ehfnd_cca_adlpr_uuid]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [ehfnd_cci_uuid]
    CHMLCMPLNCADDLPRPTYVERSIONID,  -- Version Number [ehfnd_version_number]
    CHMLCMPLNCADDLPRPTYSTATUS,     -- Processing Status [ehfnd_cca_adlpr_status]
    CREATIONUTCDATETIME,           -- Time Stamp [timestampl]
    CREATEDBYUSER,                 -- User Name [uname]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [timestampl]
    LASTCHANGEDBYUSER,             -- User Name [uname]
    VALIDITYSTARTDATETIME,         -- Valid From [ehfnd_valid_from_tstmp]
    VALIDITYENDDATETIME,           -- Valid To [ehfnd_valid_to_tstmp]
    ACTIVEUUID,                    -- Key [/bobf/uuid]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCMPLNCADDLPRPTYUUID)
);

Learn More