EHFNDW_CCI_MCVRG

Transparent Table Application Table
18 Fields 1 CDS Views

I_CHMLCMPLNCINFOTP I_CHMLCMPLNCMKTCVRGTP

EHFNDW_CCI_MCVRG is an SAP database table in S/4HANA. I_CHMLCMPLNCINFOTP I_CHMLCMPLNCMKTCVRGTP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncMktCvrgDraft view from BASIC Chemical Compliance Market Coverage

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncmktcvrguuid ehfnd_cci_mcov_uuid Marketability Coverage
activechmlcmplncmktcvrguuid ehfnd_cci_mcov_uuid Marketability Coverage
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
activechmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
chmlcmplncmktrequuid ehfnd_cci_mreq_uuid Marketability Request
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
country ehfnd_country_id Country / Region
chmlcmplncprodnallwd ehfnd_cci_prod_allowed Produce In
chmlcmplncexprtallwd ehfnd_cci_export_allowed Export From
chmlcmplncimprtallwd ehfnd_cci_import_allowed Import To
chmlcmplncsalesallwd ehfnd_cci_sales_allowed Sell In
chmlcmplncmktcvrgremark ehfnd_cci_mcov_remark Official Remark
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_CHMLCMPLNCINFOTP I_CHMLCMPLNCMKTCVRGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI_MCVRG (
    MANDT,                        -- Client [mandt]
    CHMLCMPLNCMKTCVRGUUID,        -- Marketability Coverage [ehfnd_cci_mcov_uuid]
    ACTIVECHMLCMPLNCMKTCVRGUUID,  -- Marketability Coverage [ehfnd_cci_mcov_uuid]
    CHMLCMPLNCINFOUUID,           -- Chemical Compliance Information [ehfnd_cci_uuid]
    ACTIVECHMLCMPLNCINFOUUID,     -- Chemical Compliance Information [ehfnd_cci_uuid]
    CHMLCMPLNCMKTREQUUID,         -- Marketability Request [ehfnd_cci_mreq_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]
    COUNTRY,                      -- Country / Region [ehfnd_country_id]
    CHMLCMPLNCPRODNALLWD,         -- Produce In [ehfnd_cci_prod_allowed]
    CHMLCMPLNCEXPRTALLWD,         -- Export From [ehfnd_cci_export_allowed]
    CHMLCMPLNCIMPRTALLWD,         -- Import To [ehfnd_cci_import_allowed]
    CHMLCMPLNCSALESALLWD,         -- Sell In [ehfnd_cci_sales_allowed]
    CHMLCMPLNCMKTCVRGREMARK,      -- Official Remark [ehfnd_cci_mcov_remark]
    ACTIVEUUID,                   -- Key [/bobf/uuid]
    HASACTIVEENTITY,              -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCMPLNCMKTCVRGUUID)
);

Learn More