I_CHMLCMPLNCPRODASSGMT

CDS View
3 Fields 18 CDS Views

Chemical Compliance Product Assignment

I_CHMLCMPLNCPRODASSGMT is a CDS View in S/4HANA. Chemical Compliance Product Assignment. It contains 3 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_ChmlCmplncMktProdAssgmt view from CONSUMPTION Packaged Product Assignment
C_ChmlCmplncMktSpcfcCvrg view from CONSUMPTION Specific Coverage of Packaged Product
C_ChmlCmplncPckgdProdAssgmt view_entity from CONSUMPTION Packaged Product Assignment
C_ChmlCmplncPckgdProdsAssgmtVH view from CONSUMPTION Packaged Product for Dangerous Goods
C_ChmlCmplncProdAssgmt view_entity from CONSUMPTION Chemical Compliance Packaged Product Assignment
C_CmbndChmlCmplncProdAssgmt view from CONSUMPTION Manage Material - Product Assignment
C_UpaDaGdsClfnAssgdPckgdClfn view_entity inner CONSUMPTION Related Packaged Products
I_ChmlCmplncMktCvrgProdAssgmt view from COMPOSITE Marketability Coverages for PP and UP
I_ChmlCmplncMktCvrgProdAssgmt view union COMPOSITE Marketability Coverages for PP and UP
I_ChmlCmplncPckgdProduct view from BASIC Pckgd Products assigned to Unpckgd Prod
I_ChmlCmplncProdAssgmtDimn view from COMPOSITE Dimension Prodcut Assignment
I_ChmlCmplncProdAssgmtTP view from TRANSACTIONAL Chemical Compliance Product Assignment
I_EnvrmtProductWasteCode view inner COMPOSITE Product Waste Codes
I_EnvrmtProductWasteData view inner COMPOSITE Product Waste Data
P_CmbndChmlCmplncPkgdDGClfnDes view inner CONSUMPTION Private View for DG Basic Description
P_PaDaGdsBscClassfctn view inner CONSUMPTION
R_ChmlCmplncInfoPckgdProdTP view_entity from TRANSACTIONAL CCI Packaged Product Assgmt - TP
R_ChmlCmplncInfoUnpckgdProdTP view_entity from TRANSACTIONAL CCI Unpackaged Product Assgmt - TP

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID,PckgdChmlCmplncInfoUUID 3
KEY ChmlCmplncProdAssgmtUUID ChmlCmplncProdAssgmtUUID 1
ChmlCmplncProdUUID ChmlCmplncProdUUID 3

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.

-- Chemical Compliance Product Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHMLCMPLNCPRODASSGMT (
    CHMLCMPLNCINFOUUID,
    CHMLCMPLNCPRODASSGMTUUID,
    CHMLCMPLNCPRODUUID,
    PRIMARY KEY (CHMLCMPLNCINFOUUID, CHMLCMPLNCPRODASSGMTUUID)
);

Learn More