I_CMPLRQVERS

CDS View
7 Fields 43 CDS Views

Compliance Requirement Version View

I_CMPLRQVERS is a CDS View in S/4HANA. Compliance Requirement Version View. It contains 7 fields. 43 CDS views read from this table.

CDS Views using this table (43)

ViewTypeJoinVDMDescription
C_AllMarnPlltntIMDG view cross CONSUMPTION All Marine Pollutants for IMDG
C_CA_AllMarnPlltntTDG view cross CONSUMPTION All Marine Pollutants for TDG
C_DngrsGdsApplyRglnFltrRgln view inner CONSUMPTION Filtered Possible Regulations
C_DngrsGdsApplyRglnLangOfRgln view inner CONSUMPTION Possible Languages of a Regulation
C_PaDaGdsClfnEnclosureVarVH view union CONSUMPTION Value Help for Enclosure Variant in CRR
C_PaDaGdsClfnSpclPrvsnVH view from CONSUMPTION Value Help for Special Provision in CRR
C_PaDaGdsClfnSpclPrvsnVH view union CONSUMPTION Value Help for Special Provision in CRR
C_UpaDaGdsClfnWordPrefix view union CONSUMPTION Unpackaged DG Classification Qualifying Word Prefix
C_UpaDaGdsClfnWordSuffix view union CONSUMPTION Unpackaged DG Classification Qualifying Word Suffix
C_US_AllMarnPlltntCFR view cross CONSUMPTION All Marine Pollutants for 49 CFR
I_CmplRqForSVT view from COMPOSITE SVT relevant Compliance Requirements - Text
I_CmplRqMigrationVH view from BASIC EHS Compliance Requirement
I_CmplRqVersDocumentationLink view from BASIC Compliance Requirement Docu Link
I_CmplRqVersEnhanced view from BASIC Compliance Requirement Version View
I_CmplRqVersLastActive view inner COMPOSITE Cmpliance Requirement Activated version
I_CmplRqVersLastDteActvtd view from COMPOSITE Sooner released crv
I_CmplRqVersLastEffctvDte view from COMPOSITE Compliance Requirement Last Effective Date
I_CmplRqVersLastEffctvDteReld view inner COMPOSITE Released Compliance Requirement Last Effective Date
I_DngrsGdsCmplRqLatestVers view from COMPOSITE Compliance Requirement Latest Version
I_DngrsGdsCmplRqText view from COMPOSITE DG Compliance Requirement - Text
I_WasteCmplRqVersGrouped view from COMPOSITE Waste Compliance Requirement grouped
P_BasicDescForReldRglnMaxCRR view inner COMPOSITE
P_BasicDescForReldRglnScore view inner COMPOSITE
P_BasicDescForReldRglnScore view from COMPOSITE
P_CmplncRqmtCurFutRevision view from COMPOSITE
P_CmplncRqmtLastPastRev view from COMPOSITE
P_CmplncRqmtNewestActvRev view from COMPOSITE
P_CmplncRqmtNewestRev view from COMPOSITE
P_CmplRqLatestSubstanceList view inner COMPOSITE
P_CmplRqRsltNone view cross CONSUMPTION None Phrase for Reason for No Data for each CRV
P_CmplRqSubstanceListMaxDate view inner COMPOSITE
P_CmplRqVersActvSuccssrExists view from CONSUMPTION
P_CmplRqVersActvtnCmplRqUsage view from CONSUMPTION
P_CmplRqVersActvtnCtrl view_entity from CONSUMPTION
P_CmplRqVersPredecessorCount view from CONSUMPTION
P_CmplRqVersPredecessorCount view inner CONSUMPTION
P_DngrsGdsCmplRqVersMaxDate view from CONSUMPTION
P_NameOnListAndSubstFbAllLang view cross COMPOSITE
P_NewestActvtdCmplRq view_entity from COMPOSITE Newest activated CR
P_NewestActvtdCmplRqSubstLst view_entity inner COMPOSITE Newest activated CR substance list
P_NewestCmplRqActvVers view from COMPOSITE
P_NewestCmplRqVers view from COMPOSITE
R_CmplRqVersDngrsGdsTP view_entity from TRANSACTIONAL Compliance Requirement Version - TP

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CmplRqUUID CmplRqUUID 3
KEY CmplRqVersUUID CmplRqVersUUID 12
KEY ComplianceRequirement ComplianceRequirement 10
CmplRqPattern CmplRqPattern 1
EffectiveDate EffectiveDate 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 Requirement Version View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERS (
    CMPLRQUUID,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    CMPLRQPATTERN,
    EFFECTIVEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (CMPLRQUUID, CMPLRQVERSUUID, COMPLIANCEREQUIREMENT)
);

Learn More