EHENV_AMNS_EXT

CDS View
11 Fields 8 CDS Views

Amounts Extended View with Mount text

EHENV_AMNS_EXT is a CDS View in S/4HANA. Amounts Extended View with Mount text. It contains 11 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Ehenv_Adef_Amns view from Aggregation Amounts
Ehenv_Adef_Amns_At_Location view from Aggregation Amounts At Location
Ehenv_Cdef_Amns view from Calculation Amounts
Ehenv_Cdef_Amns_At_Location view from Calculation Amounts At Location
Ehenv_Mdef_Amns view from Measurement Amounts
Ehenv_Mdef_Amns_At_Location view from Measurement Amounts At Location
Ehenv_Sdef_Amns view from Sampling Amounts
Ehenv_Sdef_Amns_At_Location view from Sampling Amounts at Location

Fields (11)

KeyField CDS FieldsUsed in Views
amount_key amount_key 8
deviation_id deviation_id 8
external_src external_src 8
preliminary_ind preliminary_ind 8
sourcetype sourcetype 8
status amount_status 8
unit_text unit_text 8
value value 8
value_date value_date 4
value_month_txt value_month_txt 8
valuetimestamp valuetimestamp 8

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 Extended View with Mount text
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENV_AMNS_EXT (
    AMOUNT_KEY,
    DEVIATION_ID,
    EXTERNAL_SRC,
    PRELIMINARY_IND,
    SOURCETYPE,
    STATUS,
    UNIT_TEXT,
    VALUE,
    VALUE_DATE,
    VALUE_MONTH_TXT,
    VALUETIMESTAMP
);

Learn More