EHFNDV_CP_CR

10 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmplncPrpsRqmtAssgmt view from BASIC Compliance Purpose CR Assignment

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient MANDT Client
KEY cmplncprps EHFND_CMPLNC_PRPS_ID Purpose ID
KEY cmplncprpsrqmtassgmtuuid EHFND_CP_CR_ASSGMT_UUID UUID Assignment
KEY cmplncprpsuuid EHFND_CMPLNC_PRPS_UUID Compliance Purpose
KEY cmplrquuid EHFND_REQ_UUID Compl Req.
creationdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangedatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
cmplncprpsrqmtassgmtisobslt EHFND_CP_CR_ASSGMT_OBSOLETE Obsolete Assignment

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_CP_CR (
    SAPCLIENT,                    -- Client [MANDT]
    CMPLNCPRPS,                   -- Purpose ID [EHFND_CMPLNC_PRPS_ID]
    CMPLNCPRPSRQMTASSGMTUUID,     -- UUID Assignment [EHFND_CP_CR_ASSGMT_UUID]
    CMPLNCPRPSUUID,               -- Compliance Purpose [EHFND_CMPLNC_PRPS_UUID]
    CMPLRQUUID,                   -- Compl Req. [EHFND_REQ_UUID]
    CREATIONDATETIME,             -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                -- User Name [UNAME]
    LASTCHANGEDATETIME,           -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,            -- User Name [UNAME]
    CMPLNCPRPSRQMTASSGMTISOBSLT,  -- Obsolete Assignment [EHFND_CP_CR_ASSGMT_OBSOLETE]
    PRIMARY KEY (SAPCLIENT, CMPLNCPRPS, CMPLNCPRPSRQMTASSGMTUUID, CMPLNCPRPSUUID, CMPLRQUUID)
);

Learn More