FXM_SNAP_ITEM

Transparent Table Application Table
25 Fields 2 CDS Views

Snapshot Item (Balance Sheet FX Risk)

FXM_SNAP_ITEM is an SAP database table in S/4HANA. Snapshot Item (Balance Sheet FX Risk). It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BalShtExpsrSnpshtItm view from BASIC BSE Snapshot item basic view
P_BSESNAPSHOT view from BASIC

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY snap_id FXM_SNAP_ID Snapshot ID
KEY snap_item_id FXM_SNAP_ITEM_ID Snapshot Item ID
company_code BUKRS Company Code
keyfigure_id FXM_KF Key Figure
group_currency FXM_GRP_CURRENCY Reporting Currency
amount_in_group_currency FXM_GRP_AMOUNT Amount in Rep. Crcy
amount FXM_AMOUNT Amount
currency FXM_CURRENCY Currency
period_start FXM_PERIOD_START Period Start
period_end FXM_PERIOD_END Period End
manual_or_automatic FXM_MANUAL_AUTOMATIC_INDICATOR Generation Method
description FXM_SNAPITEM_DESC Snapshot Item Desc
fi_account RACCT Account Number
fi_chart_of_account KTOPL Chart of Accts
planning_level FDLEV Planning Level
certainty_level FXM_CERTAINTY_LEVEL Certainty Level
liquidity_item FLQPOS Liquidity Item
trm_product_type VVSART Product Type
trm_transaction_type TB_SFHAART Transactn Type
trm_portfolio RPORTB Portfolio
create_user RERF Entered By
create_timestamp FXM_CRTIMESTAMP Created At
last_change_user RBEAR Last Changed By
last_change_timestamp FXM_CHTIMESTAMP Changed At

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.

-- Snapshot Item (Balance Sheet FX Risk)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FXM_SNAP_ITEM (
    MANDT,                     -- Client [MANDT]
    SNAP_ID,                   -- Snapshot ID [FXM_SNAP_ID]
    SNAP_ITEM_ID,              -- Snapshot Item ID [FXM_SNAP_ITEM_ID]
    COMPANY_CODE,              -- Company Code [BUKRS]
    KEYFIGURE_ID,              -- Key Figure [FXM_KF]
    GROUP_CURRENCY,            -- Reporting Currency [FXM_GRP_CURRENCY]
    AMOUNT_IN_GROUP_CURRENCY,  -- Amount in Rep. Crcy [FXM_GRP_AMOUNT]
    AMOUNT,                    -- Amount [FXM_AMOUNT]
    CURRENCY,                  -- Currency [FXM_CURRENCY]
    PERIOD_START,              -- Period Start [FXM_PERIOD_START]
    PERIOD_END,                -- Period End [FXM_PERIOD_END]
    MANUAL_OR_AUTOMATIC,       -- Generation Method [FXM_MANUAL_AUTOMATIC_INDICATOR]
    DESCRIPTION,               -- Snapshot Item Desc [FXM_SNAPITEM_DESC]
    FI_ACCOUNT,                -- Account Number [RACCT]
    FI_CHART_OF_ACCOUNT,       -- Chart of Accts [KTOPL]
    PLANNING_LEVEL,            -- Planning Level [FDLEV]
    CERTAINTY_LEVEL,           -- Certainty Level [FXM_CERTAINTY_LEVEL]
    LIQUIDITY_ITEM,            -- Liquidity Item [FLQPOS]
    TRM_PRODUCT_TYPE,          -- Product Type [VVSART]
    TRM_TRANSACTION_TYPE,      -- Transactn Type [TB_SFHAART]
    TRM_PORTFOLIO,             -- Portfolio [RPORTB]
    CREATE_USER,               -- Entered By [RERF]
    CREATE_TIMESTAMP,          -- Created At [FXM_CRTIMESTAMP]
    LAST_CHANGE_USER,          -- Last Changed By [RBEAR]
    LAST_CHANGE_TIMESTAMP,     -- Changed At [FXM_CHTIMESTAMP]
    PRIMARY KEY (MANDT, SNAP_ID, SNAP_ITEM_ID)
);

Learn More