Entering content frameProcedure documentation Planning Offline and Uploading into the SAP System Locate the document in its SAP Library structure


You can create your planning data in multiple files on your PC and upload those files later into the SAP System.


To be able to upload the files, you must specify the characteristic values in the lead column of the corresponding planning layout. It is not enough to simply specify the characteristic text.



The data you enter in Excel is uploaded into the SAP System using a suitable file description. You are therefore required to use an Excel template defined in Customizing for your offline planning. You need to proceed as follows:

  1. Follow the procedure outlined in the section Setting Up Integrated Excel and structure you Excel sheet template according to your needs.
  2. Enter a generic file name under Generic file. This name must consist of a string of characters (upper case), an asterisk (*), and the file suffix ".TXT" (example: PLANNING*.TXT).
  3. When you later upload Excel files into the SAP System, this generic file name links the file on your local PC to the file description.

    The name ranges of the various generic file names cannot overlap, because this would mean that the assignment of file name to file description would not be unique. For example, if you assigned the generic file name PLAN*.TXT to one file description and PLANS*.TXT to another, file PLANS03.TXT would not be uniquely assigned.

    For an overview of all file descriptions together with the generic file names, you can call up the program RKCDPREO with the ABAP Editor for the ABAP Workbench. From the list drawn up by the program, you can delete any file descriptions and generic file names that are no longer used.

  4. In Excel, save a copy of the file on your PC and assign it a name that matches the generic file name. For example, if the generic file name is SALES*.TXT, you can name the downloaded file SALES1, SALES2, or SALES_NW.


You have to save your copy of the Excel template as an Excel file (suffix ".XLS") for the template to be opened correctly. The text format (suffix ".TXT") becomes necessary when the file is uploaded back into the SAP System. For this reason, you must save the file with file type "TXT" before uploading it into the SAP System.

Once you have downloaded the Excel template, you can make copies of it or give it to other users for the purpose of offline planning. The name of each new file you create must still adhere to the generic file name so that they can be uploaded later.

Local Planning

  1. Enter your planning data offline using the downloaded Excel file (or copies of this file). Whenever you want to save your planning data but are not yet ready to upload it, save in .XLS-format.

Note the following for local planning:

  1. When you are ready to upload your data, save the file in text format (suffix ".TXT").
  2. Make sure that the file name adheres to the generic file name, so that it can be assigned to the file description correctly.

Uploading Files

  1. To import planning data into the SAP System, call up the uploading function:
  1. Specify the file or directory that you want to import.
  2. In the file description field, you can specify the file description with which the file(s) are to be imported. If you leave this field blank, the system will automatically create a file description using the generic file name.
  3. Upload your files.





Leaving content frame