EHFNDD_AMNS_ROOT

Transparent Table Application Table
36 Fields 11 CDS Views

Amounts - Root

EHFNDD_AMNS_ROOT is an SAP database table in S/4HANA. Amounts - Root. It contains 36 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
E_EHSDataAmount view from EXTENSION EHS Amount - Extension
Ehenv_Amns_All_Loc_Filter view inner Amounts for all locations filter
Ehenv_Amns_At_Loc_Filter view inner Amounts for location and sublocations filter
Ehenv_Amns_Ex view from Amounts with Value date/time extended data
Ehenv_Cdef_Amns_All view from All CDEFs for Amounts
Ehenv_Cdef_Amns_All view union All CDEFs for Amounts
Ehenv_Cdef_Amns_All_P view from All CDEFs for Amounts with parameter
Ehenv_Cdef_Amns_All_P view union All CDEFs for Amounts with parameter
Ehhss_Sampling_Agent_Name view from Name of a agent of a sampling
Ehhss_Sampling_Amounts view from Amounts of a Sampling
I_EHSAmount view_entity from BASIC EHS Amount Root

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
datetime_cr /BOBF/DATETIME_CR Created On/At
user_id_cr /BOBF/USER_ID_CR Created By
datetime_ch /BOBF/DATETIME_CH Changed On/At
user_id_ch /BOBF/USER_ID_CH Changed By
sourcetype EHFND_AMNS_SRC_TYPE Data Type
source_root_key_ref EHFND_AMNS_SRC_ROOT_KEY_REF Source
subjecttype EHFND_AMNS_SUBJ_TYPE Subject Type
subject_root_key_ref EHFND_AMNS_SBJ_ROOT_KEY_REF Subject Ref Key
business_proc_root_key_ref EHFND_BP_ROOT_KEY_REF Drive Proc BO Key
subj_comp_key_ref EHFND_AMNS_SRC_ROOT_KEY_REF Source
subj_comp_type EHFND_AMNS_SUBJ_TYPE Subject Type
valuetimestamp TIMESTAMP Time Stamp
outofpreciseness_operator EHFND_AMNS_OUTOFPRECISENESS_OP Operator
value EHFND_AMNS_VALUE Value
valueunit EHFND_UNIT_CODE Unit of Measurement
valuedimension EHFND_UNIT_DIMENSION Dimension
remark EHFND_AMNS_COMMENT Remark
amountcategory EHFND_AMN_CATEGORY Category
valuetype EHFND_VALUE_TYPE_CODE Value Type
missing_ind EHFND_AMNS_MISSING_IND Missing Value
fault_ind EHFND_AMNS_FAULTY_IND Faulty Value
calibration_ind EHFND_AMNS_CALIBR_IND Calibrated Value
notavailable_ind EHFND_AMNS_NA_IND Not Available
substitute_ind EHFND_AMNS_SUBSTITUTE_IND Substituted
deviation_id EHFND_BO_ID ID
deviation_ind EHFND_AMNS_DEVIATION_IND Deviation Exists
warning_ind EHFND_AMNS_WARNING_IND Warning
preliminary_ind EHFND_AMNS_PRELIMINARY_IND Preliminary Result
status EHFND_AMNS_STATUS_CODE Status
archivingstatus /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
external_src EHFND_AMNS_EXTERNAL_SOURCE External Source
migration_src EHFND_AMNS_MIGRATION_SOURCE Migr. Source
controlling_object EHFND_AMNS_CTRLG_OBJ Controlling Object
eew_amns_root_d DUMMY Dummy function in length 1

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.

-- Amounts - Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_AMNS_ROOT (
    MANDT,                       -- Client [MANDT]
    DB_KEY,                      -- NodeID [/BOBF/CONF_KEY]
    DATETIME_CR,                 -- Created On/At [/BOBF/DATETIME_CR]
    USER_ID_CR,                  -- Created By [/BOBF/USER_ID_CR]
    DATETIME_CH,                 -- Changed On/At [/BOBF/DATETIME_CH]
    USER_ID_CH,                  -- Changed By [/BOBF/USER_ID_CH]
    SOURCETYPE,                  -- Data Type [EHFND_AMNS_SRC_TYPE]
    SOURCE_ROOT_KEY_REF,         -- Source [EHFND_AMNS_SRC_ROOT_KEY_REF]
    SUBJECTTYPE,                 -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    SUBJECT_ROOT_KEY_REF,        -- Subject Ref Key [EHFND_AMNS_SBJ_ROOT_KEY_REF]
    BUSINESS_PROC_ROOT_KEY_REF,  -- Drive Proc BO Key [EHFND_BP_ROOT_KEY_REF]
    SUBJ_COMP_KEY_REF,           -- Source [EHFND_AMNS_SRC_ROOT_KEY_REF]
    SUBJ_COMP_TYPE,              -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    VALUETIMESTAMP,              -- Time Stamp [TIMESTAMP]
    OUTOFPRECISENESS_OPERATOR,   -- Operator [EHFND_AMNS_OUTOFPRECISENESS_OP]
    VALUE,                       -- Value [EHFND_AMNS_VALUE]
    VALUEUNIT,                   -- Unit of Measurement [EHFND_UNIT_CODE]
    VALUEDIMENSION,              -- Dimension [EHFND_UNIT_DIMENSION]
    REMARK,                      -- Remark [EHFND_AMNS_COMMENT]
    AMOUNTCATEGORY,              -- Category [EHFND_AMN_CATEGORY]
    VALUETYPE,                   -- Value Type [EHFND_VALUE_TYPE_CODE]
    MISSING_IND,                 -- Missing Value [EHFND_AMNS_MISSING_IND]
    FAULT_IND,                   -- Faulty Value [EHFND_AMNS_FAULTY_IND]
    CALIBRATION_IND,             -- Calibrated Value [EHFND_AMNS_CALIBR_IND]
    NOTAVAILABLE_IND,            -- Not Available [EHFND_AMNS_NA_IND]
    SUBSTITUTE_IND,              -- Substituted [EHFND_AMNS_SUBSTITUTE_IND]
    DEVIATION_ID,                -- ID [EHFND_BO_ID]
    DEVIATION_IND,               -- Deviation Exists [EHFND_AMNS_DEVIATION_IND]
    WARNING_IND,                 -- Warning [EHFND_AMNS_WARNING_IND]
    PRELIMINARY_IND,             -- Preliminary Result [EHFND_AMNS_PRELIMINARY_IND]
    STATUS,                      -- Status [EHFND_AMNS_STATUS_CODE]
    ARCHIVINGSTATUS,             -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    EXTERNAL_SRC,                -- External Source [EHFND_AMNS_EXTERNAL_SOURCE]
    MIGRATION_SRC,               -- Migr. Source [EHFND_AMNS_MIGRATION_SOURCE]
    CONTROLLING_OBJECT,          -- Controlling Object [EHFND_AMNS_CTRLG_OBJ]
    EEW_AMNS_ROOT_D,             -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More