EHFNDV_AMNS_HIST

14 Fields 1 CDS Views

Generated Table for View

EHFNDV_AMNS_HIST is an SAP database table in S/4HANA. Generated Table for View. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSAmountHistory view from BASIC EHS Amount History

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient MANDT Client
KEY ehsamounthistoryuuid /BOBF/CONF_KEY NodeID
ehsamountuuid /BOBF/CONF_KEY NodeID
creationdatetime /BOBF/DATETIME_CR Created On/At
lastchangedatetime /BOBF/DATETIME_CH Changed On/At
createdbyuser /BOBF/USER_ID_CR Created By
lastchangedbyuser /BOBF/USER_ID_CH Changed By
ehsamountoldvalue EHFND_AMNS_VALUE Value
ehsamountoldvalueisempty EHFND_BOOLEAN Select
note EHFND_AMNS_COMMENT Remark
ehsamountoldstatus EHFND_AMNS_STATUS_CODE Status
ehsamtoldoutofprecisenessoptr EHFND_AMNS_OUTOFPRECISENESS_OP Operator
unitofmeasure EHFND_UNIT_CODE Unit of Measurement
ehsunitconversionfactorvalue UMREF Conv. factor

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_AMNS_HIST (
    SAPCLIENT,                      -- Client [MANDT]
    EHSAMOUNTHISTORYUUID,           -- NodeID [/BOBF/CONF_KEY]
    EHSAMOUNTUUID,                  -- NodeID [/BOBF/CONF_KEY]
    CREATIONDATETIME,               -- Created On/At [/BOBF/DATETIME_CR]
    LASTCHANGEDATETIME,             -- Changed On/At [/BOBF/DATETIME_CH]
    CREATEDBYUSER,                  -- Created By [/BOBF/USER_ID_CR]
    LASTCHANGEDBYUSER,              -- Changed By [/BOBF/USER_ID_CH]
    EHSAMOUNTOLDVALUE,              -- Value [EHFND_AMNS_VALUE]
    EHSAMOUNTOLDVALUEISEMPTY,       -- Select [EHFND_BOOLEAN]
    NOTE,                           -- Remark [EHFND_AMNS_COMMENT]
    EHSAMOUNTOLDSTATUS,             -- Status [EHFND_AMNS_STATUS_CODE]
    EHSAMTOLDOUTOFPRECISENESSOPTR,  -- Operator [EHFND_AMNS_OUTOFPRECISENESS_OP]
    UNITOFMEASURE,                  -- Unit of Measurement [EHFND_UNIT_CODE]
    EHSUNITCONVERSIONFACTORVALUE,   -- Conv. factor [UMREF]
    PRIMARY KEY (SAPCLIENT, EHSAMOUNTHISTORYUUID)
);

Learn More