I_CHMLSUPLRMATL

CDS View
8 Fields 10 CDS Views

Chemical Supplier Material

I_CHMLSUPLRMATL is a CDS View in S/4HANA. Chemical Supplier Material. It contains 8 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ChmlSuplrMatlMntr view from CONSUMPTION Supplier Material
C_CmplRqRsltSuplrMatlAssmtSts view inner CONSUMPTION Supplier Material Assessment Details
I_ChmlSuplrMatlActiveDraft view from COMPOSITE Chemical Supplier Material with Active and Draft Data
I_ChmlSuplrMatlDataStsCritlty view from COMPOSITE Criticality of Data Status
I_ChmlSuplrMatlNames view from COMPOSITE Names of Supplier Material
I_ChmlSuplrMatlStdVH view from COMPOSITE Chemical Supplier Material
I_ChmlSuplrMatlTP view from TRANSACTIONAL Chemical Supplier Material
P_ChmlSuplrMatlData view from CONSUMPTION Additional Data for Supplier Material
P_ChmlSuplrMatlDataMntr view from CONSUMPTION Material Data of Supplier and Raw Material for Monitor
P_ChmlSuplrMatlRqmtRsltAllSts view from CONSUMPTION Counter for all CRR Status for Chemical Supplier Material

Fields (8)

KeyField CDS FieldsUsed in Views
_BusinessPartner _BusinessPartner 3
_BusinessPartnerSupplier _BusinessPartnerSupplier 2
_ResponsibleUnit _ResponsibleUnit 1
BusinessPartnerSupplier BusinessPartnerSupplier 2
ChmlSuplrMatlName ChmlSuplrMatlName 1
ChmlSuplrMatlUUID ChmlSuplrMatlNavgnLink 1
ResponsibleUnit ResponsibleUnit 3
SupplierMaterialNumber SupplierMaterialNumber 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.

-- Chemical Supplier Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHMLSUPLRMATL (
    _BUSINESSPARTNER,
    _BUSINESSPARTNERSUPPLIER,
    _RESPONSIBLEUNIT,
    BUSINESSPARTNERSUPPLIER,
    CHMLSUPLRMATLNAME,
    CHMLSUPLRMATLUUID,
    RESPONSIBLEUNIT,
    SUPPLIERMATERIALNUMBER
);

Learn More