MDEF_AMNS

24 Fields

MDEF_AMNS is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
amount_key amount_key 2
amount_status amount_status 2
buss_area buss_area 2
company_code company_code 2
cost_center cost_center 2
country country 2
data_period data_period 2
data_title data_title 2
deviation_id deviation_id 2
external_src external_src 2
issue_type issue_type 2
issue_type_icon issue_type_icon 2
loc_auth_group loc_auth_group 2
loc_status loc_status 2
location_text location_text 2
plant_id plant_id 2
preliminary_ind preliminary_ind 2
region region 2
sourcetype sourcetype 2
type type 2
unit_text unit_text 2
value value 2
value_date value_date 1
value_month_txt value_month_txt 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDEF_AMNS (
    AMOUNT_KEY,
    AMOUNT_STATUS,
    BUSS_AREA,
    COMPANY_CODE,
    COST_CENTER,
    COUNTRY,
    DATA_PERIOD,
    DATA_TITLE,
    DEVIATION_ID,
    EXTERNAL_SRC,
    ISSUE_TYPE,
    ISSUE_TYPE_ICON,
    LOC_AUTH_GROUP,
    LOC_STATUS,
    LOCATION_TEXT,
    PLANT_ID,
    PRELIMINARY_IND,
    REGION,
    SOURCETYPE,
    TYPE,
    UNIT_TEXT,
    VALUE,
    VALUE_DATE,
    VALUE_MONTH_TXT
);

Learn More