Market Data Transfer from Spreadsheet 

Use

This function allows you to call up market data directly in the SAP R/3 System from a spreadsheet and transfer the data.

Integration

The integration of the external spreadsheet (Microsoft Excel 97 or Lotus 1-2-3, Version 9.0 Millenium Edition) with the SAP R/3 System takes place via OLE.

The program is preconfigured to work with Microsoft Excel 97.

 If you do not use this program, adjustments may be necessary.

Prerequisites

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 transfer a maximum of 1000 rates and prices to the SAP R/3 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.

Activities

  1. Choose Basic functions ® Market data management ® Spreadsheet.
  2. Press the "Spreadsheet" button which controls the interface parameters of the report.
    1. Application that is to be started: Via F4-Help, choose the spreadsheet that you wish to use. (The spreadsheet must support the Table category.)
    2. 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.
    3. 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 SAP R/3 System (TableBackToR3). The second macro fetches the data from the SAP R/3 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 SAP R/3 System.
  7. When you import an existing file, the spreadsheet is opened. Use the Import market data function to load data into the SAP R/3 System.