I_CMPLRQRSLTTP

CDS View
13 Fields 5 CDS Views

CRR - Compliance Requirement Result

I_CMPLRQRSLTTP is a CDS View in S/4HANA. CRR - Compliance Requirement Result. It contains 13 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CmplRqRsltChmCmInSiCmTP view from CONSUMPTION Marketability Assessment - Product
C_CmplRqRsltChmCmInSupInTP view from CONSUMPTION CmplRqRslt - Chemical Compliance Info - Supplier Info
C_CmplRqRsltSupMaSiCmTP view from CONSUMPTION CmplRqRslt Supplier Material
C_CmplRqRsltTP view from CONSUMPTION CmplRqRslt Transactional Processing
C_PackagedDangerousGoodClfn view from CONSUMPTION Packaged Dangerous Good Classification

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CmplRqRsltUUID CmplRqRsltUUID 1
ActiveCmplRqRsltUUID ActiveCmplRqRsltUUID 5
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 3
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 2
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 4
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus 1
CmplRqVersUUID CmplRqVersUUID 4
ComplianceRequirement ComplianceRequirement 1
LastChangeDateTime LastChangeDateTime 2
PCESScenarioUUID PCESScenarioUUID 1
SubstanceUUID SubstanceUUID 4
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDateTime ValidityStartDateTime 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.

-- CRR - Compliance Requirement Result
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQRSLTTP (
    CMPLRQRSLTUUID,
    ACTIVECMPLRQRSLTUUID,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCINFOUUID,
    CHMLSUPLRMATLUUID,
    CMPLRQRSLTPROCESSINGSTATUS,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    LASTCHANGEDATETIME,
    PCESSCENARIOUUID,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CMPLRQRSLTUUID)
);

Learn More