Market Data Transfer from Spreadsheet 

Use

This function allows you to call up market data directly in the system from a spreadsheet and transfer the data.

Prerequisites

·        A spreadsheet program is installed on the PC.

·        This function is exclusively designed for the Enjoy screen size of 27 lines and 120 columns.

Read the report documentation 'Importing Market Data via the File Interface' (RFTBFF00) and 'Output of the Requirements List' (RFTBFF01). The requirements regarding field length, field meaning, etc. are also valid here.

Features

·        You can import existing market data files.

You can transfer a maximum of 1000 rates and prices to the system at the same time via the spreadsheet. If you wish to transfer more rates and prices, you should use the file interface or datafeed.

·        You can create new files. The master data that has been defined in the system is transferred as the table framework so that only the values still have to be entered.

Activities

...

       1.      Choose Basic functions ® Market data management ® Spreadsheet or the corresponding path in SEM Banking.

       2.      Press the "Spreadsheet" button which controls the interface parameters of the report.

...

                            a.      Application that is to be started: Via F4-Help, choose the spreadsheet that you wish to use. (The spreadsheet must support the Table category.)

                            b.      Document template (WEB repository): You enter a template here that is copied from the WEB repository to the current document when you create a new spreadsheet.

                            c.      First and second macro to be run: You enter the macros here that are called up in the work file of your spreadsheet for transferring table information. The first macro transfers data back into the system (TableBackToR3). The second macro fetches the data from the system. (FillTableFromR3).

SAP delivers an Excel template with the relevant macros. Only change the standard macro names if you wish to create your own template with its own macros and wish to use your own macro names.

       3.      If you wish to import an existing file, then enter its name and path where you can find it. 

       4.      If you wish to create a new file, you can specify the market data you wish to enter under Market data selection for new creation. The table is then preconfigured so that you can enter the values for all defined characteristics of this market data.

       5.      Switch to the Spreadsheet tab page.

       6.      Choose Create to enter new files and then enter the data. Use the Import market data function to load data into the system.

       7.      When you import an existing file, the spreadsheet is opened. Use the Import market data function to load data into the system.