EHFNDW_CCMPS

Transparent Table Application Table
29 Fields 1 CDS Views

I_CHMLCOMPOSITIONTP I_CHMLCOMPOSITIONTP

EHFNDW_CCMPS is an SAP database table in S/4HANA. I_CHMLCOMPOSITIONTP I_CHMLCOMPOSITIONTP. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCompositionDraft view from BASIC Chemical Composition Draft Data

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
activechmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
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
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
substanceuuid EHFND_SUB_HOST_UUID Host Substance
chmlcompositiontype EHFND_CCI_CCMPS_TYPE Legal Area
prodcmplnclegalarea EHFND_LEGAL_AREA Legal Area
chmlcompositionstatus EHFND_CCI_CCMPS_STATUS Processing Status
releasedatetime EHFND_RELEASE_TS Composition Released On
releasedbyuser EHFND_RELEASE_USER Released By
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
prodcmplnclegalarearef EHFND_LEGAL_AREA_REF Legal Area Reference
chmlcmplncprodcatztnphrsuuid EHFND_CHM_PROD_CATZTNPHRS_UUID Product Categorization
pctrdscrtcalculationsetting EHFND_TS_CALCULATION_SETTING Handling of Concentrations
polymercompositionintid EHFND_SUB_PCMPS_INT_ID Internal Number
polymercompositionname EHFND_SUB_PCMPS_CCMPS_NAME Name
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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_CHMLCOMPOSITIONTP I_CHMLCOMPOSITIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCMPS (
    MANDT,                          -- Client [MANDT]
    CHMLCOMPOSITIONUUID,            -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    ACTIVECHMLCOMPOSITIONUUID,      -- Chemical Composition [EHFND_CCI_CCMPS_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]
    CHMLCMPLNCINFOUUID,             -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHMLSUPLRMATLUUID,              -- Supplier Raw Material [EHFND_CSM_UUID]
    SUBSTANCEUUID,                  -- Host Substance [EHFND_SUB_HOST_UUID]
    CHMLCOMPOSITIONTYPE,            -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    PRODCMPLNCLEGALAREA,            -- Legal Area [EHFND_LEGAL_AREA]
    CHMLCOMPOSITIONSTATUS,          -- Processing Status [EHFND_CCI_CCMPS_STATUS]
    RELEASEDATETIME,                -- Composition Released On [EHFND_RELEASE_TS]
    RELEASEDBYUSER,                 -- Released By [EHFND_RELEASE_USER]
    VALIDITYSTARTDATETIME,          -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,            -- Valid To [EHFND_VALID_TO_TSTMP]
    PRODCMPLNCLEGALAREAREF,         -- Legal Area Reference [EHFND_LEGAL_AREA_REF]
    CHMLCMPLNCPRODCATZTNPHRSUUID,   -- Product Categorization [EHFND_CHM_PROD_CATZTNPHRS_UUID]
    PCTRDSCRTCALCULATIONSETTING,    -- Handling of Concentrations [EHFND_TS_CALCULATION_SETTING]
    POLYMERCOMPOSITIONINTID,        -- Internal Number [EHFND_SUB_PCMPS_INT_ID]
    POLYMERCOMPOSITIONNAME,         -- Name [EHFND_SUB_PCMPS_CCMPS_NAME]
    ACTIVEUUID,                     -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, CHMLCOMPOSITIONUUID)
);

Learn More