I_CMPLRQRSLTTP

CDS View
12 Fields 4 CDS Views

CRR - Compliance Requirement Result

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

CDS Views using this table (4)

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

Fields (12)

KeyField CDS FieldsUsed in Views
ActiveCmplRqRsltUUID ActiveCmplRqRsltUUID 4
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 3
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 1
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 4
CmplRqRsltReferencedObjectUUID CmplRqRsltReferencedObjectUUID 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 (
    ACTIVECMPLRQRSLTUUID,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCINFOUUID,
    CHMLSUPLRMATLUUID,
    CMPLRQRSLTREFERENCEDOBJECTUUID,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    LASTCHANGEDATETIME,
    PCESSCENARIOUUID,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME
);

Learn More