EHFNDW_CSM

Transparent Table Application Table
21 Fields 1 CDS Views

I_CHMLSUPLRMATLTP I_CHMLSUPLRMATLTP

EHFNDW_CSM is an SAP database table in S/4HANA. I_CHMLSUPLRMATLTP I_CHMLSUPLRMATLTP. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlSuplrMatlDraft view from BASIC Chemical Supplier Material Draft Data

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
activechmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
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
businesspartnersupplier EHFND_BUPA_SUPPLIER Supplier
suppliermaterialnumber EHFND_CSM_EMATNR External Product Number
chmlsuplrmatlname EHFND_CSM_NAME External Product Name
chmlsuplrmatldatastatus EHFND_CSM_DATA_STATUS Compliance Data
chmlsuplrmatlisoutdated EHFND_CSM_IS_OUTDATED Outdated
responsibleunit EHFND_CCI_RESPONSIBLE_UNIT_PSS Responsible Unit
chmlsuplrmatldatastschgdtetme TIMESTAMPL Time Stamp
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_CHMLSUPLRMATLTP I_CHMLSUPLRMATLTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CSM (
    MANDT,                          -- Client [MANDT]
    CHMLSUPLRMATLUUID,              -- Supplier Raw Material [EHFND_CSM_UUID]
    ACTIVECHMLSUPLRMATLUUID,        -- Supplier Raw Material [EHFND_CSM_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]
    BUSINESSPARTNERSUPPLIER,        -- Supplier [EHFND_BUPA_SUPPLIER]
    SUPPLIERMATERIALNUMBER,         -- External Product Number [EHFND_CSM_EMATNR]
    CHMLSUPLRMATLNAME,              -- External Product Name [EHFND_CSM_NAME]
    CHMLSUPLRMATLDATASTATUS,        -- Compliance Data [EHFND_CSM_DATA_STATUS]
    CHMLSUPLRMATLISOUTDATED,        -- Outdated [EHFND_CSM_IS_OUTDATED]
    RESPONSIBLEUNIT,                -- Responsible Unit [EHFND_CCI_RESPONSIBLE_UNIT_PSS]
    CHMLSUPLRMATLDATASTSCHGDTETME,  -- Time Stamp [TIMESTAMPL]
    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, CHMLSUPLRMATLUUID)
);

Learn More