Planning Offline and Uploading into the SAP System
Use
You can create your planning data in multiple files on your PC and upload those files later into the SAP System.
Prerequisites
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.
Procedure
Setup
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:
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.
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
Note the following for local planning:
Uploading Files