P_BSESNAPSHOT

Balance Sheet Exposure Snapshot | view: PFXMSNAPSHOT | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: FXM_SNAPFXM_SNAP_ITEMT001
Column Name Description
snap_id Snapshot ID
snap_item_id ID of Snapshot Item (B/S FX Risk)
Column Name Description
💲 Reporting Currency (group_currency):
amount_in_group_currency Amount in Reporting Currency
💲 Currency (currency):
amount Amount
Column Name Description
Column Name Description
keydate Key Date
period_start Period Start
period_end Period End
Column Name Description
status Status of Snapshot (B/S FX Risk) Show values
certainty_level Certainty Level Show values
manual_or_automatic Generation Method of Snapshot Item (B/S FX Risk) Show values
Column Name Description Domain name
fi_chart_of_account Chart of Accounts KTOPL
fi_account Account Number SAKNR
planning_level Planning Level FDLEV
liquidity_item Liquidity Item FLQPOS
trm_product_type Product Type VVSART
trm_transaction_type Financial Transaction Type T_SFHAART
create_user Entered By SYCHAR12
last_change_user Employee ID SYCHAR12
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_BSESNAPSHOT.MANDT == T001.MANDT
  • P_BSESNAPSHOT.COMPANY_CODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_BSESNAPSHOT.MANDT == T005.MANDT
  • P_BSESNAPSHOT.COMPANY_CODE_COUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • P_BSESNAPSHOT.MANDT == TCURC.MANDT
  • P_BSESNAPSHOT.COMPANY_CODE_CURRENCY == TCURC.WAERS