I_CMPLNCPRPS

CDS View

Compliance Purpose

I_CMPLNCPRPS is a CDS View in S/4HANA. Compliance Purpose. It contains 8 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_ChmlCmplncPurpose2VH view_entity from CONSUMPTION Purposes without Filter
C_CmplncPrpsNameWithFallback view from CONSUMPTION Compliance Purpose Name with Fallback
I_CmplncPrpsStdVH view from COMPOSITE Compliance Purpose
I_CmplncPrpsTP view from TRANSACTIONAL Compliance Purpose Transactional View
P_ChmlCmplncPrpsDGRqmtCt view from CONSUMPTION
P_ChmlCmplncPrpsMktRqmtCt view from CONSUMPTION
P_ChmlCmplncPrpsSdsRqmtCt view from CONSUMPTION
P_CmbndChmlCmplncPrpsDGRqmtCt view from CONSUMPTION Private View for Count of Cmplnc Reqt used in Cmplnc Purpose

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CmplncPrpsUUID CmplncPrpsUUID 8
CmplncPrps CmplncPrps 1
CmplncPrpsBuildDate CmplncPrpsBuildDate 1
ContentProvider ContentProvider 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1

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.

-- Compliance Purpose
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLNCPRPS (
    CMPLNCPRPSUUID,
    CMPLNCPRPS,
    CMPLNCPRPSBUILDDATE,
    CONTENTPROVIDER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (CMPLNCPRPSUUID)
);