EHFNDW_CCI2

Transparent Table Application Table
33 Fields 1 CDS Views

Draft table for entity R_CHEMICALCOMPLIANCEINFOTP

EHFNDW_CCI2 is an SAP database table in S/4HANA. Draft table for entity R_CHEMICALCOMPLIANCEINFOTP. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChemicalComplianceInfoDraft view_entity from BASIC Chemical Compliance Info Draft

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcmplncinfouuid 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
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
chemicalcomplianceinfo EHFND_INTERNAL_NR_NC Internal Number
specificationinternalid EHFND_EHS_ESERECN Record number
chmlcmplncprodisresearched EHFND_CCI_IS_RESEARCHED R&D Sample
matlisnotdngrsgdsrlvt EHFND_CCI_IS_NOT_DG_RLVT Is Not Dangerous Goods Relevant
matlisnotprodmarketabilityrlvt EHFND_CCI_IS_NOT_PMA_RLVT Is Not Product Marketability Relevant
sftydatashtisnotrequired EHFND_CCI_IS_NOT_PS_RLVT Is Not Product Safety Relevant
matlisnotsupplierrlvt EHFND_CCI_IS_NOT_PCS_RLVT Is Not Supplier Relevant
chmlcmplncprodcatztnphrsuuid EHFND_CHM_PROD_CATZTNPHRS_UUID Product Categorization
prodcmplncphrs EHFND_PHRS_ID Phrase ID
matlismulticomponentproduct EHFND_CCI_IS_MCP Multi-Component Product
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft 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_CHEMICALCOMPLIANCEINFOTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI2 (
    MANDT,                           -- Client [MANDT]
    CHMLCMPLNCINFOUUID,              -- 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]
    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]
    CHEMICALCOMPLIANCEINFO,          -- Internal Number [EHFND_INTERNAL_NR_NC]
    SPECIFICATIONINTERNALID,         -- Record number [EHFND_EHS_ESERECN]
    CHMLCMPLNCPRODISRESEARCHED,      -- R&D Sample [EHFND_CCI_IS_RESEARCHED]
    MATLISNOTDNGRSGDSRLVT,           -- Is Not Dangerous Goods Relevant [EHFND_CCI_IS_NOT_DG_RLVT]
    MATLISNOTPRODMARKETABILITYRLVT,  -- Is Not Product Marketability Relevant [EHFND_CCI_IS_NOT_PMA_RLVT]
    SFTYDATASHTISNOTREQUIRED,        -- Is Not Product Safety Relevant [EHFND_CCI_IS_NOT_PS_RLVT]
    MATLISNOTSUPPLIERRLVT,           -- Is Not Supplier Relevant [EHFND_CCI_IS_NOT_PCS_RLVT]
    CHMLCMPLNCPRODCATZTNPHRSUUID,    -- Product Categorization [EHFND_CHM_PROD_CATZTNPHRS_UUID]
    PRODCMPLNCPHRS,                  -- Phrase ID [EHFND_PHRS_ID]
    MATLISMULTICOMPONENTPRODUCT,     -- Multi-Component Product [EHFND_CCI_IS_MCP]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CHMLCMPLNCINFOUUID)
);

Learn More