EHFNDW_CCA_ADLPR

Transparent Table Application Table
18 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 18 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 (18)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, CHMLCMPLNCADDLPRPTYUUID)
);

Learn More