EHFNDW_CCI_DG

Transparent Table Application Table
24 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 24 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 (24)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CHMLCMPLNCMNLDNGRSGDSUUID)
);

Learn More