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 must be installed on your 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, and so on are also valid here.

Features

You can import existing market data files.

Note Note

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.

End of the note.

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 Start of the navigation path Basic Functions Next navigation step Market Data Management Next navigation step Spreadsheet End of the navigation path.

  2. Press the Spreadsheet button that controls the interface parameters of the report.

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

  • 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.

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

Note Note

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.

End of the note.

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

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.

Switch to the Spreadsheet tab page.

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

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