I_CHMLCMPLNCPRODASSGMT

CDS View
3 Fields 17 CDS Views

Chemical Compliance Product Assignment

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

CDS Views using this table (17)

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
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 Basic Classification of a Packaged Dangerous Good
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 ChmlCmplncProdAssgmtUUID ChmlCmplncProdAssgmtUUID 1
ChmlCmplncInfoUUID ChmlCmplncInfoUUID,PckgdChmlCmplncInfoUUID 2
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 (
    CHMLCMPLNCPRODASSGMTUUID,
    CHMLCMPLNCINFOUUID,
    CHMLCMPLNCPRODUUID,
    PRIMARY KEY (CHMLCMPLNCPRODASSGMTUUID)
);

Learn More