EHFNDW_CCMPS_CMP

Transparent Table Application Table
32 Fields 1 CDS Views

I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SubstBsdCmpstnComponentDraft view from BASIC Draft Substances in compositions

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcompuuid EHFND_CCI_CCOMP_UUID Chemical Component
activechmlcompuuid EHFND_CCI_CCOMP_UUID Chemical Component
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
hostsubstanceuuid EHFND_SUB_HOST_UUID Host Substance
chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
substanceuuid EHFND_SUB_UUID Substance
chmlcomptype EHFND_CCI_CCOMP_TYPE_NCE Role in Composition
chmlcompqty EHFND_CCI_CCOMP_QTY Concentration Value
chmlcompqtyastext EHFND_CCI_CCOMP_QTY_CH Concentration
chmlcompqtyunit EHFND_UNIT_CODE_MEINS Unit of Measurement
chmlcompoperatorlowerlimit EHFND_CCI_CCOMP_LOWER_OPERATOR Operator Lower Limit
chmlcompqtylowerlimit EHFND_CCI_CCOMP_LOWER_LIMIT Lower Limit Value
chmlcompqtylowerlimitastext EHFND_CCI_CCOMP_LOWER_LIMIT_CH Lower Limit
chmlcompoperatorupperlimit EHFND_CCI_CCOMP_UPPER_OPERATOR Operator Upper Limit
chmlcompqtyupperlimit EHFND_CCI_CCOMP_UPPER_LIMIT Upper Limit Value
chmlcompqtyupperlimitastext EHFND_CCI_CCOMP_UPPER_LIMIT_CH Upper Limit
chmlcompisremoved EHFND_CCI_CCOMP_IS_REMOVED Removed Component
polymercompositionintidref EHFND_SUB_PCMPS_INT_ID_REF Internal Number Reference
pctrdscrtidentityismasked EHFND_TS_IDENTITY_IS_MASKED Use Generic Name
pctrdscrtrangeismasked EHFND_TS_RANGE_IS_MASKED Mark Range as Confidential
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_CHMLCOMPONENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCMPS_CMP (
    MANDT,                          -- Client [MANDT]
    CHMLCOMPUUID,                   -- Chemical Component [EHFND_CCI_CCOMP_UUID]
    ACTIVECHMLCOMPUUID,             -- Chemical Component [EHFND_CCI_CCOMP_UUID]
    CHMLCMPLNCINFOUUID,             -- Chemical Compliance Information [EHFND_CCI_UUID]
    HOSTSUBSTANCEUUID,              -- Host Substance [EHFND_SUB_HOST_UUID]
    CHMLCOMPOSITIONUUID,            -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    CREATIONUTCDATETIME,            -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                  -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,              -- User Name [UNAME]
    SUBSTANCEUUID,                  -- Substance [EHFND_SUB_UUID]
    CHMLCOMPTYPE,                   -- Role in Composition [EHFND_CCI_CCOMP_TYPE_NCE]
    CHMLCOMPQTY,                    -- Concentration Value [EHFND_CCI_CCOMP_QTY]
    CHMLCOMPQTYASTEXT,              -- Concentration [EHFND_CCI_CCOMP_QTY_CH]
    CHMLCOMPQTYUNIT,                -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    CHMLCOMPOPERATORLOWERLIMIT,     -- Operator Lower Limit [EHFND_CCI_CCOMP_LOWER_OPERATOR]
    CHMLCOMPQTYLOWERLIMIT,          -- Lower Limit Value [EHFND_CCI_CCOMP_LOWER_LIMIT]
    CHMLCOMPQTYLOWERLIMITASTEXT,    -- Lower Limit [EHFND_CCI_CCOMP_LOWER_LIMIT_CH]
    CHMLCOMPOPERATORUPPERLIMIT,     -- Operator Upper Limit [EHFND_CCI_CCOMP_UPPER_OPERATOR]
    CHMLCOMPQTYUPPERLIMIT,          -- Upper Limit Value [EHFND_CCI_CCOMP_UPPER_LIMIT]
    CHMLCOMPQTYUPPERLIMITASTEXT,    -- Upper Limit [EHFND_CCI_CCOMP_UPPER_LIMIT_CH]
    CHMLCOMPISREMOVED,              -- Removed Component [EHFND_CCI_CCOMP_IS_REMOVED]
    POLYMERCOMPOSITIONINTIDREF,     -- Internal Number Reference [EHFND_SUB_PCMPS_INT_ID_REF]
    PCTRDSCRTIDENTITYISMASKED,      -- Use Generic Name [EHFND_TS_IDENTITY_IS_MASKED]
    PCTRDSCRTRANGEISMASKED,         -- Mark Range as Confidential [EHFND_TS_RANGE_IS_MASKED]
    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, CHMLCOMPUUID)
);

Learn More