I_CMPLRQVERSENHANCED

CDS View
22 Fields 19 CDS Views

Compliance Requirement Version View

I_CMPLRQVERSENHANCED is a CDS View in S/4HANA. Compliance Requirement Version View. It contains 22 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
C_ChmlCmplncMnlDngrsGdsRglnVH view from CONSUMPTION Regulation for Dangerous Goods
C_ChmlSuplrMatlCmplRqRsltVH view from CONSUMPTION CRR Value Help with Filter
C_CmplncDisclCmplRqVersVH view_entity from CONSUMPTION Compliance Requirement Version
C_EHSCmplncRqmtRelatedTask view from CONSUMPTION Compliance Requirement tasks
C_EnvrmtCmplRqCurVersReldVH view_entity from CONSUMPTION Current Envoriment Compliance Req
C_EnvrmtCmplRqVersReldVH view from CONSUMPTION Released Env Compl. Req Value Help
C_MngEnvrmtCmplRqVers view from CONSUMPTION Manage Env. Mgmt Compliance Requirements
C_PCESCmplRqVersVH view from CONSUMPTION Exposure Scenario Compliance Requirement Version
I_ActiveComplianceRqmtVersion view_entity from COMPOSITE Active Compliance Requirement Version
I_CmplncRqmtAuthznFields view inner COMPOSITE Cmplnc Requirement Authorization Fields
I_CmplRqVersionOverview view from COMPOSITE Cmpl Rq Version Overview
I_CmplRqVersSftyDataShtVH view_entity from COMPOSITE Compliance Requirement Version for SDS
I_DangerousGoodsRegulationVH view_entity from TRANSACTIONAL Compliance Requirement Name
I_EHSCmplncRqmtIdHex view left_outer COMPOSITE Compliance Requirement Version Hex UUID
I_EHSCmplRqImprtExtUpdate view left_outer BASIC Basic View for Compl Integration Update
I_EHSCmplRqParagraphCube view_entity from COMPOSITE Compliance Requirement Paragraph - Cube
I_SftyDataShtCmplRqRsltCube view inner COMPOSITE SafetyDataSheet CRR Cube
P_CmplRqVersActvtnDynValues view from CONSUMPTION
P_CmplRqVersVH view from COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CmplRqUUID CmplRqUUID 2
KEY CmplRqVersUUID CmplRqVersUUID 10
_CmplncRqmtStatus _CmplncRqmtStatus 1
_CmplRqVersAppltyArea _CmplRqVersAppltyArea 1
CmplRqApplicationComponent CmplRqApplicationComponent 3
CmplRqDomain CmplRqDomain 1
CmplRqPattern CmplRqPattern 5
CmplRqType CmplRqType 1
CmplRqVers CmplRqVers 2
CmplRqVersEHSLocationUUID CmplRqVersEHSLocationUUID 1
CmplRqVersEnglishName CmplRqVersEnglishName 2
CmplRqVersMaintStatus CmplRqVersMaintStatus 4
CmplRqVersName CmplRqVersName 7
CmplRqVersNameInCurLang CmplRqVersNameInCurLang 1
CmplRqVersPermitNumber CmplRqVersPermitNumber 1
CmplRqVersTopic CmplRqVersTopic 1
CmplRqVersValidToDate CmplRqVersValidToDate 1
ComplianceRequirement ComplianceRequirement 4
ContentProvider ContentProvider 2
EffectiveDate EffectiveDate 3
IssuingOrganization IssuingOrganization 1
TransitionPeriodEndDate TransitionPeriodEndDate 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_CMPLRQVERSENHANCED (
    CMPLRQUUID,
    CMPLRQVERSUUID,
    _CMPLNCRQMTSTATUS,
    _CMPLRQVERSAPPLTYAREA,
    CMPLRQAPPLICATIONCOMPONENT,
    CMPLRQDOMAIN,
    CMPLRQPATTERN,
    CMPLRQTYPE,
    CMPLRQVERS,
    CMPLRQVERSEHSLOCATIONUUID,
    CMPLRQVERSENGLISHNAME,
    CMPLRQVERSMAINTSTATUS,
    CMPLRQVERSNAME,
    CMPLRQVERSNAMEINCURLANG,
    CMPLRQVERSPERMITNUMBER,
    CMPLRQVERSTOPIC,
    CMPLRQVERSVALIDTODATE,
    COMPLIANCEREQUIREMENT,
    CONTENTPROVIDER,
    EFFECTIVEDATE,
    ISSUINGORGANIZATION,
    TRANSITIONPERIODENDDATE,
    PRIMARY KEY (CMPLRQUUID, CMPLRQVERSUUID)
);

Learn More