EHFNDW_CCI_CSM2

Transparent Table Application Table
12 Fields 1 CDS Views

Draft table for entity R_CHMLCMPLNCSUPLRMATLASSGMTTP

EHFNDW_CCI_CSM2 is an SAP database table in S/4HANA. Draft table for entity R_CHMLCMPLNCSUPLRMATLASSGMTTP. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChmlCmplncSuplrMatlDraft view_entity from BASIC CCI Supplier Material Assignment Draft

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncsuplrmatlassgmtuuid ehfnd_cci_csm_uuid UUID
actvchmlcmplncsuplrassgmtuuid ehfnd_cci_csm_uuid UUID
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
chmlsuplrmatluuid ehfnd_csm_uuid Supplier Raw Material
creationutcdatetime ehfnd_bo_crea_date_time Created On
createdbyuser ehfnd_bo_crea_uname Created By
lastchangeutcdatetime ehfnd_bo_lchg_date_time Last Changed On
lastchangedbyuser ehfnd_bo_lchg_uname Last Changed By
chmlsuplrmatlsuplrsts ehfnd_csm_supplier_status Supplier Status for Raw Material
chmlsuplrmatlisoutdated ehfnd_csm_is_outdated Outdated
businesspartnersupplier ehfnd_bupa_supplier Supplier

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.

-- Draft table for entity R_CHMLCMPLNCSUPLRMATLASSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI_CSM2 (
    MANDT,                          -- Client [mandt]
    CHMLCMPLNCSUPLRMATLASSGMTUUID,  -- UUID [ehfnd_cci_csm_uuid]
    ACTVCHMLCMPLNCSUPLRASSGMTUUID,  -- UUID [ehfnd_cci_csm_uuid]
    CHMLCMPLNCINFOUUID,             -- Chemical Compliance Information [ehfnd_cci_uuid]
    CHMLSUPLRMATLUUID,              -- Supplier Raw Material [ehfnd_csm_uuid]
    CREATIONUTCDATETIME,            -- Created On [ehfnd_bo_crea_date_time]
    CREATEDBYUSER,                  -- Created By [ehfnd_bo_crea_uname]
    LASTCHANGEUTCDATETIME,          -- Last Changed On [ehfnd_bo_lchg_date_time]
    LASTCHANGEDBYUSER,              -- Last Changed By [ehfnd_bo_lchg_uname]
    CHMLSUPLRMATLSUPLRSTS,          -- Supplier Status for Raw Material [ehfnd_csm_supplier_status]
    CHMLSUPLRMATLISOUTDATED,        -- Outdated [ehfnd_csm_is_outdated]
    BUSINESSPARTNERSUPPLIER,        -- Supplier [ehfnd_bupa_supplier]
    PRIMARY KEY (MANDT, CHMLCMPLNCSUPLRMATLASSGMTUUID)
);

Learn More