
Upload and Download of Summarized Data
Download and upload functions make it possible to summarize data across system and client boundaries. First you export the investment program data and entities from the local system into respective files, and then import these files into the central system.
Download
When you download data, you specify the investment program, the approval year and the program position. The system then outputs the specified data to the file. You can also limit the selection by entering a value type and a timeframe. For the summarization data of appropriation requests, you can specify a partner function. The system then writes the holders of this partner function to the summarization database.
In addition, you have to enter the file to which the program should write the data. You can choose whether the data should be output on the application server or on a presentation server.
You specify in Customizing those characteristics and scales that you do not want to be summarized. These Customizing settings are valid for the client as a whole. However, when you export the summarization database, you can specify which Customizing settings the system should use. You can choose the Customizing settings from the local client, or from an exported file on an application server, or from another R/3 System (using RFC). To export Customizing settings to a file, use the special Customizing function for this purpose (Investment Programs ® Information System ® Information System Using Summarization).
Import
To import data, you only have to enter the file from which the import should be made.
File Structure
When you export data, the system creates the file using the file name you enter in the report selection screen. This file is an ASCII file. The system creates one files for the investment program data and one file for the entities. The structure of the files is as follows:
The following list contains the names of the Dictionary structures:
You can display these structures using transaction SE11. In that transaction, you can also see the field names of the structures.
Within a data record, the individual entries are separated by a tab (tabulator).

Make sure that the ASCII files you create are structured so that they can be processed using various PC applications (such as Excel).