EHFNDW_CCI

Transparent Table Application Table
28 Fields 1 CDS Views

I_CHMLCMPLNCINFOTP I_CHMLCMPLNCINFOTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncInfoDraft view from BASIC Chemical Compliance Information Draft Data

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
activechmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
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
prodstewardshiprespunit ehfnd_cci_responsible_unit_pss Responsible Unit
dngrsgdsrespunit ehfnd_cci_responsible_unit_dg Responsible Unit for Dangerous Goods
chmlcmplncinfotype ehfnd_cci_type Type of Chemical Compliance Information
chmlcmplncinternalname ehfnd_cci_internal_name Internal Name
chmlcmplncprodcatztnphrsuuid ehfnd_chm_prod_catztnphrs_uuid Product Categorization
materialisbaseproduct ehfnd_cci_is_base_product Is Base Product
materialissold ehfnd_cci_is_sold Is Sold
materialistransported ehfnd_cci_is_transported Is Transported
materialissourced ehfnd_cci_is_sourced Is Purchased
materialisproduced ehfnd_cci_is_produced Is Produced
materialisdisposed ehfnd_cci_is_disposed Is Disposed
materialisemissionrelevant ehfnd_cci_is_emission_rlvt Emission Relevant
matlismulticomponentproduct ehfnd_cci_is_mcp
specification ehfnd_internal_nr Internal Number
chmlcmplncprodisresearched ehfnd_cci_is_researched R&D Sample
specificationinternalid ehfnd_ehs_eserecn Record number
matlisnotdngrsgdsrlvt ehfnd_cci_is_not_dg_rlvt Is Not Dangerous Goods Relevant
matlisnotprodmarketabilityrlvt ehfnd_cci_is_not_pma_rlvt Is Not Product Marketability Relevant
matlisnotprodsafetyrlvt ehfnd_cci_is_not_ps_rlvt Is Not Product Safety Relevant
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_CHMLCMPLNCINFOTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI (
    MANDT,                           -- Client [mandt]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [ehfnd_cci_uuid]
    ACTIVECHMLCMPLNCINFOUUID,        -- Chemical Compliance Information [ehfnd_cci_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]
    PRODSTEWARDSHIPRESPUNIT,         -- Responsible Unit [ehfnd_cci_responsible_unit_pss]
    DNGRSGDSRESPUNIT,                -- Responsible Unit for Dangerous Goods [ehfnd_cci_responsible_unit_dg]
    CHMLCMPLNCINFOTYPE,              -- Type of Chemical Compliance Information [ehfnd_cci_type]
    CHMLCMPLNCINTERNALNAME,          -- Internal Name [ehfnd_cci_internal_name]
    CHMLCMPLNCPRODCATZTNPHRSUUID,    -- Product Categorization [ehfnd_chm_prod_catztnphrs_uuid]
    MATERIALISBASEPRODUCT,           -- Is Base Product [ehfnd_cci_is_base_product]
    MATERIALISSOLD,                  -- Is Sold [ehfnd_cci_is_sold]
    MATERIALISTRANSPORTED,           -- Is Transported [ehfnd_cci_is_transported]
    MATERIALISSOURCED,               -- Is Purchased [ehfnd_cci_is_sourced]
    MATERIALISPRODUCED,              -- Is Produced [ehfnd_cci_is_produced]
    MATERIALISDISPOSED,              -- Is Disposed [ehfnd_cci_is_disposed]
    MATERIALISEMISSIONRELEVANT,      -- Emission Relevant [ehfnd_cci_is_emission_rlvt]
    MATLISMULTICOMPONENTPRODUCT,     -- ehfnd_cci_is_mcp
    SPECIFICATION,                   -- Internal Number [ehfnd_internal_nr]
    CHMLCMPLNCPRODISRESEARCHED,      -- R&D Sample [ehfnd_cci_is_researched]
    SPECIFICATIONINTERNALID,         -- Record number [ehfnd_ehs_eserecn]
    MATLISNOTDNGRSGDSRLVT,           -- Is Not Dangerous Goods Relevant [ehfnd_cci_is_not_dg_rlvt]
    MATLISNOTPRODMARKETABILITYRLVT,  -- Is Not Product Marketability Relevant [ehfnd_cci_is_not_pma_rlvt]
    MATLISNOTPRODSAFETYRLVT,         -- Is Not Product Safety Relevant [ehfnd_cci_is_not_ps_rlvt]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCMPLNCINFOUUID)
);

Learn More