I_CMPLRQRSLTSUBSTLISTCHKTP

CDS View
10 Fields 2 CDS Views

CmplRqRslt Substance List Check

I_CMPLRQRSLTSUBSTLISTCHKTP is a CDS View in S/4HANA. CmplRqRslt Substance List Check. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CmplRqRsltChmCmInSubChkTP view from CONSUMPTION Marketability Assessment - Product
C_CmplRqRsltSubstSubLiChkTP view from CONSUMPTION Marketability Assessment - Substance

Fields (10)

KeyField CDS FieldsUsed in Views
KEY CmplRqRsltUUID CmplRqRsltUUID 1
ActiveCmplRqRsltUUID ActiveCmplRqRsltUUID 2
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 1
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 1
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 1
CmplRqVersUUID CmplRqVersUUID 1
ComplianceRequirement ComplianceRequirement 2
SubstanceUUID SubstanceUUID 2
ValidityEndDateTime ValidityEndDateTime 1
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.

-- CmplRqRslt Substance List Check
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQRSLTSUBSTLISTCHKTP (
    CMPLRQRSLTUUID,
    ACTIVECMPLRQRSLTUUID,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCINFOUUID,
    CHMLSUPLRMATLUUID,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CMPLRQRSLTUUID)
);

Learn More