FXM_BSR

Transparent Table Application Table
41 Fields 1 CDS Views

Balance Sheet Exposure Hedge Request

FXM_BSR is an SAP database table in S/4HANA. Balance Sheet Exposure Hedge Request. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BalShtExpsrHdgReq view from BASIC Basic View of BSE Hedge Request

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY bsr_id FXM_BSR_ID Hedge Request ID
company_code BUKRS Company Code
company_code_currency WAERS Currency
bsr_amount FXM_BSR_AMOUNT Amount (B/S HR)
open_amount FXM_OPEN_AMOUNT Open Amount
declined_amount FXM_DECLINED_AMOUNT Declined Amount
bsr_currency FXM_CURRENCY Currency
buy_sell_indicator FXM_FX_BUY_SELL Buy/Sell
put_call_indicator TI_SPUTCAL Put/Call
value_date FXM_VALUE_DATE Value Date
instrument_category FXM_BSR_INSTCAT Instrument Cat.
snap_id FXM_SNAP_ID Snapshot ID
description FXM_BSR_DESCRIPTION Hedge Request Descr.
release_status FXM_BSR_STATUS Hedge Request Status
fulfillment_status FXM_FULFILLMENT_STATUS Fulfillment Status
period_start FXM_PERIOD_START Period Start
period_end FXM_PERIOD_END Period End
edit_indicator FXM_BSR_EDITED Change Indicator
portfolio RPORTB Portfolio
external_ref TRBA_NORDEXT External Ref.
assignment TB_ZUOND Assignment
internal_ref TB_REFER Internal Ref.
chars TB_MERKM Characteristics
profit_center PRCTR Profit Center
cost_center KOSTL Cost Center
wbs_element PS_PSP_PNR WBS Element
on_behalf_of_company TRBA_BEHALF_OF_COMPANY On Behalf of CoCode
country LAND1 Country/Reg.
segment FB_SEGMENT Segment
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
msgid SYMSGID Message Class
msgty BAPI_MTYPE Message type
msgno SYMSGNO Message Number
msgv1 SYMSGV Message Variable
msgv2 SYMSGV Message Variable
msgv3 SYMSGV Message Variable
msgv4 SYMSGV Message Variable

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.

-- Balance Sheet Exposure Hedge Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FXM_BSR (
    CLIENT,                 -- Client [MANDT]
    BSR_ID,                 -- Hedge Request ID [FXM_BSR_ID]
    COMPANY_CODE,           -- Company Code [BUKRS]
    COMPANY_CODE_CURRENCY,  -- Currency [WAERS]
    BSR_AMOUNT,             -- Amount (B/S HR) [FXM_BSR_AMOUNT]
    OPEN_AMOUNT,            -- Open Amount [FXM_OPEN_AMOUNT]
    DECLINED_AMOUNT,        -- Declined Amount [FXM_DECLINED_AMOUNT]
    BSR_CURRENCY,           -- Currency [FXM_CURRENCY]
    BUY_SELL_INDICATOR,     -- Buy/Sell [FXM_FX_BUY_SELL]
    PUT_CALL_INDICATOR,     -- Put/Call [TI_SPUTCAL]
    VALUE_DATE,             -- Value Date [FXM_VALUE_DATE]
    INSTRUMENT_CATEGORY,    -- Instrument Cat. [FXM_BSR_INSTCAT]
    SNAP_ID,                -- Snapshot ID [FXM_SNAP_ID]
    DESCRIPTION,            -- Hedge Request Descr. [FXM_BSR_DESCRIPTION]
    RELEASE_STATUS,         -- Hedge Request Status [FXM_BSR_STATUS]
    FULFILLMENT_STATUS,     -- Fulfillment Status [FXM_FULFILLMENT_STATUS]
    PERIOD_START,           -- Period Start [FXM_PERIOD_START]
    PERIOD_END,             -- Period End [FXM_PERIOD_END]
    EDIT_INDICATOR,         -- Change Indicator [FXM_BSR_EDITED]
    PORTFOLIO,              -- Portfolio [RPORTB]
    EXTERNAL_REF,           -- External Ref. [TRBA_NORDEXT]
    ASSIGNMENT,             -- Assignment [TB_ZUOND]
    INTERNAL_REF,           -- Internal Ref. [TB_REFER]
    CHARS,                  -- Characteristics [TB_MERKM]
    PROFIT_CENTER,          -- Profit Center [PRCTR]
    COST_CENTER,            -- Cost Center [KOSTL]
    WBS_ELEMENT,            -- WBS Element [PS_PSP_PNR]
    ON_BEHALF_OF_COMPANY,   -- On Behalf of CoCode [TRBA_BEHALF_OF_COMPANY]
    COUNTRY,                -- Country/Reg. [LAND1]
    SEGMENT,                -- Segment [FB_SEGMENT]
    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]
    MSGID,                  -- Message Class [SYMSGID]
    MSGTY,                  -- Message type [BAPI_MTYPE]
    MSGNO,                  -- Message Number [SYMSGNO]
    MSGV1,                  -- Message Variable [SYMSGV]
    MSGV2,                  -- Message Variable [SYMSGV]
    MSGV3,                  -- Message Variable [SYMSGV]
    MSGV4,                  -- Message Variable [SYMSGV]
    PRIMARY KEY (CLIENT, BSR_ID)
);

Learn More