I_CMPLRQVERSACTVTN

CDS View
15 Fields 8 CDS Views

CR Version Activation

I_CMPLRQVERSACTVTN is a CDS View in S/4HANA. CR Version Activation. It contains 15 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_CmplRqPrpsDrftVH view inner CONSUMPTION CmplRq VH Draft Consumption View
C_CmplRqVH view inner CONSUMPTION CmplRq VH Consumption View
C_PCESCmplRqVersVH view inner CONSUMPTION Exposure Scenario Compliance Requirement Version
I_CmplRqVersActvtnTP view from TRANSACTIONAL CR Version Activation
I_CmplRqVersLastDteActvtd view inner COMPOSITE Sooner released crv
P_CmplRqVersActvtnCompType view from CONSUMPTION Composition Type for Compliance Requirement
P_NewestActvtdCmplRq view_entity inner COMPOSITE Newest activated CR
P_NewestActvtdCmplRqSubstLst view_entity inner COMPOSITE Newest activated CR substance list

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersUUID CmplRqVersUUID 1
ChmlCompositionType ChmlCompositionType 1
CmplRqDomain CmplRqDomain 1
CmplRqSourceURLStatus CmplRqSourceURLStatus 1
CmplRqVersActivatedByUser CmplRqVersActivatedByUser 1
CmplRqVersActivationDate CmplRqVersActivationDate 1
CmplRqVersActivationStatus CmplRqVersActivationStatus 2
CmplRqVersBuildDate CmplRqVersBuildDate 1
CmplRqVersDeactivatedByUser CmplRqVersDeactivatedByUser 1
CmplRqVersDeactivationDate CmplRqVersDeactivationDate 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ValidityEndDate ValidityEndDate 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.

-- CR Version Activation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSACTVTN (
    CMPLRQVERSUUID,
    CHMLCOMPOSITIONTYPE,
    CMPLRQDOMAIN,
    CMPLRQSOURCEURLSTATUS,
    CMPLRQVERSACTIVATEDBYUSER,
    CMPLRQVERSACTIVATIONDATE,
    CMPLRQVERSACTIVATIONSTATUS,
    CMPLRQVERSBUILDDATE,
    CMPLRQVERSDEACTIVATEDBYUSER,
    CMPLRQVERSDEACTIVATIONDATE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    VALIDITYENDDATE,
    PRIMARY KEY (CMPLRQVERSUUID)
);

Learn More