EHFNDW_CCI_DG

Transparent Table Application Table
18 Fields 1 CDS Views

Draft table for entity R_CHMLCMPLNCMNLDNGRSGDSTP

EHFNDW_CCI_DG is an SAP database table in S/4HANA. Draft table for entity R_CHMLCMPLNCMNLDNGRSGDSTP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncMnlDngrsGdsDraft view from BASIC Manual Maintenance of DG Data - Draft

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncmnldngrsgdsuuid ehfnd_generic_uuid Generic Key
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
chmlcmplncproduuid ehfnd_cci_prod_uuid Product Assignment
chmlcmplncinfopckgdprod ehfnd_cci_product Product
classifiedasdangerousgood ehdgm_classified_as_dg Classified As
dngrsgoodsmodeoftransport ehfnd_req_mot Mode of Transport
transportpermission ehdgm_transport_permission Transport Permission
dngrsgoodspackagingtype ehfnd_dg_packaging_type Dangerous Goods Packaging Type
dngrsgoodspackagingsize ehfnd_dg_packaging_size Dangerous Goods Packaging Size
dngrsgoodspackagingsizeunit ehfnd_dg_packaging_size_unit DngrsGds Packaging Size Unit
cmplrqversuuid ehfnd_crv_uuid Compl Req UUID
productispackaged ehfnd_dg_packed_product Dangerous Goods: Is Packed Product
dngrsgoodsdescription ehfnd_dg_description Dangerous Goods Description
creationdatetime abp_creation_tstmpl Created On
createdbyuser abp_creation_user Created By
lastchangedatetime abp_lastchange_tstmpl Changed On
lastchangedbyuser abp_lastchange_user Changed By

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_CHMLCMPLNCMNLDNGRSGDSTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI_DG (
    MANDT,                        -- Client [mandt]
    CHMLCMPLNCMNLDNGRSGDSUUID,    -- Generic Key [ehfnd_generic_uuid]
    CHMLCMPLNCINFOUUID,           -- Chemical Compliance Information [ehfnd_cci_uuid]
    CHMLCMPLNCPRODUUID,           -- Product Assignment [ehfnd_cci_prod_uuid]
    CHMLCMPLNCINFOPCKGDPROD,      -- Product [ehfnd_cci_product]
    CLASSIFIEDASDANGEROUSGOOD,    -- Classified As [ehdgm_classified_as_dg]
    DNGRSGOODSMODEOFTRANSPORT,    -- Mode of Transport [ehfnd_req_mot]
    TRANSPORTPERMISSION,          -- Transport Permission [ehdgm_transport_permission]
    DNGRSGOODSPACKAGINGTYPE,      -- Dangerous Goods Packaging Type [ehfnd_dg_packaging_type]
    DNGRSGOODSPACKAGINGSIZE,      -- Dangerous Goods Packaging Size [ehfnd_dg_packaging_size]
    DNGRSGOODSPACKAGINGSIZEUNIT,  -- DngrsGds Packaging Size Unit [ehfnd_dg_packaging_size_unit]
    CMPLRQVERSUUID,               -- Compl Req UUID [ehfnd_crv_uuid]
    PRODUCTISPACKAGED,            -- Dangerous Goods: Is Packed Product [ehfnd_dg_packed_product]
    DNGRSGOODSDESCRIPTION,        -- Dangerous Goods Description [ehfnd_dg_description]
    CREATIONDATETIME,             -- Created On [abp_creation_tstmpl]
    CREATEDBYUSER,                -- Created By [abp_creation_user]
    LASTCHANGEDATETIME,           -- Changed On [abp_lastchange_tstmpl]
    LASTCHANGEDBYUSER,            -- Changed By [abp_lastchange_user]
    PRIMARY KEY (MANDT, CHMLCMPLNCMNLDNGRSGDSUUID)
);

Learn More