EHFNDW_CCI_PURP2

Transparent Table Application Table
15 Fields 1 CDS Views

Draft table for entity R_CHMLCMPLNCPRPSASSGMTTP

EHFNDW_CCI_PURP2 is an SAP database table in S/4HANA. Draft table for entity R_CHMLCMPLNCPRPSASSGMTTP. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChmlCmplncPrpsAssgmtDraft view_entity from BASIC Chemical Compliance Info Purpose Assignment Draft

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcmplncprpsassgmtuuid EHFND_CCI_PURP_UUID Purpose Assignment
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
creationutcdatetime EHFND_BO_CREA_DATE_TIME Created On
createdbyuser EHFND_BO_CREA_UNAME Created By
lastchangeutcdatetime EHFND_BO_LCHG_DATE_TIME Last Changed On
lastchangedbyuser EHFND_BO_LCHG_UNAME Last Changed By
cmplncprpsuuid EHFND_CMPLNC_PRPS_UUID Compliance Purpose
cmplncprps EHFND_CMPLNC_PRPS_ID Purpose ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_CHMLCMPLNCPRPSASSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI_PURP2 (
    MANDT,                          -- Client [MANDT]
    CHMLCMPLNCPRPSASSGMTUUID,       -- Purpose Assignment [EHFND_CCI_PURP_UUID]
    CHMLCMPLNCINFOUUID,             -- Chemical Compliance Information [EHFND_CCI_UUID]
    CREATIONUTCDATETIME,            -- Created On [EHFND_BO_CREA_DATE_TIME]
    CREATEDBYUSER,                  -- Created By [EHFND_BO_CREA_UNAME]
    LASTCHANGEUTCDATETIME,          -- Last Changed On [EHFND_BO_LCHG_DATE_TIME]
    LASTCHANGEDBYUSER,              -- Last Changed By [EHFND_BO_LCHG_UNAME]
    CMPLNCPRPSUUID,                 -- Compliance Purpose [EHFND_CMPLNC_PRPS_UUID]
    CMPLNCPRPS,                     -- Purpose ID [EHFND_CMPLNC_PRPS_ID]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CHMLCMPLNCPRPSASSGMTUUID)
);

Learn More