I_CMPLRQRSLTCUSTCMPLNCCHKTP

CDS View
17 Fields 3 CDS Views

CRR Customer Compliance Check - TP

I_CMPLRQRSLTCUSTCMPLNCCHKTP is a CDS View in S/4HANA. CRR Customer Compliance Check - TP. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ChmCstMtCmplRqRsltTP view_entity from CONSUMPTION Chemical Customer Material CRRs
C_CmplRqRsltChmCmInCstCmChkTP view from CONSUMPTION CRR CCI Customer Compliance Check
C_CmplRqRsltChmCstMtCstCmChkTP view from CONSUMPTION CRR CCM Customer Compliance Check

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CmplRqRsltUUID CmplRqRsltUUID 3
_ChmlCmplncInfo _ChmlCmplncInfo 1
ActiveCmplRqRsltUUID ActiveCmplRqRsltUUID 2
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 3
ChmlCmplncInfoUUID ChmlCmplncInfoNavgnLink,ChmlCmplncInfoUUID 3
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus 1
CmplRqVersUUID CmplRqVersUUID 3
ComplianceRequirement ComplianceRequirement 3
MaterialIsProduced MaterialIsProduced 1
MaterialIsSold MaterialIsSold 1
MaterialIsSourced MaterialIsSourced 1
MaterialIsTransported MaterialIsTransported 1
Processor CmplRqRsltProcessor,Processor 3
ProdCmplncRiskLevelUUID ProdCmplncRiskLevelUUID 1
ReleasedByUser ReleasedByUser 3
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDateTime ValidityStartDateTime 2

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 Customer Compliance Check - TP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQRSLTCUSTCMPLNCCHKTP (
    CMPLRQRSLTUUID,
    _CHMLCMPLNCINFO,
    ACTIVECMPLRQRSLTUUID,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCINFOUUID,
    CMPLRQRSLTPROCESSINGSTATUS,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    MATERIALISPRODUCED,
    MATERIALISSOLD,
    MATERIALISSOURCED,
    MATERIALISTRANSPORTED,
    PROCESSOR,
    PRODCMPLNCRISKLEVELUUID,
    RELEASEDBYUSER,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CMPLRQRSLTUUID)
);

Learn More