1. Import Market Data
Use
This function allows you to call up market data directly in the system from a spreadsheet and transfer the data. It is required to import the market data reference interest rates and swap rates.
Prerequisites
A spreadsheet program is installed on the PC.
Procedure
- Access the transaction using the following navigation options: #### SAP ECC menu > Financial Supply Chain Management ➞ Treasury and Risk Management ➞ Transaction Manager ➞ Money Market ➞ Environment ➞ Market Data ➞ Spreadsheet
Transaction code TBEX
- The excel sheets attached below are the sample market data of reference interest rates and swap rates. Please save one of the excel sheets in a local folder in your PC (for SAP ERP 6.0 with Enhancement Package 6, please Use Sample_Market_Data_606.xls; for SAP ERP 6.0 with Enhancement Package 7, please ### Use Sample_Market_Data_607.xls), for example, you save it as C:\temp\Sample_Market_Data.xls.
- Please open the excel sheet from the local folder, delete the lines that are not relevant for your business environment (that means you may not need some reference interest rates), and modify the Date (column E), Time (column F) and Value (interest rate, Column G) of each line based on real market data.
Please ### Use ‘.’ instead of ‘,’ as the decimal point for column G.
- On the Market Data Transfer from Spreadsheet screen, choose the Settings tab page and make the following entries:
User action and values
Field name User action and values Comment Name The path of where the excel sheet is stored and the name of it. For example, C:\temp\Sample_Market_Data.xls
- Choose Change (F8).
- Choose Enable Macros if the Microsoft Excel Security Notice dialog box is displayed.
- On the Market data transfer from spreadsheet screen, choose Import Market Data to write the data into the database.
- Scroll to the right (columns Status and Error message) to verify the upload status. If the status is OK, you can choose Back (F3). On the dialog box that “Should the spreadsheet created be saved first?” is asked, choose No.
The imported data can be accessed via
Transaction code S_ALR_87008537 or JBIRM or
Accounting Financial Supply Chain Management ➞ Treasury and Risk Management ➞ Basic Functions ➞ Market Data Management ➞ Manual Market Data Entry ➞ Interest ➞ Enter Reference Interest Rates) for reference interest rates, and
Transaction code S_ALR_87008539 or
Accounting Financial Supply Chain Management ➞ Treasury and Risk Management ➞ Basic Functions ➞ Market Data Management ➞ Manual Market Data Entry ➞ Currency ➞ Enter Forex Swap Rates) for swap rates. Here, you can change the market data manually.
Result
The market data has been imported into system
