
Planning Locally with Excel Upload
Use
You can carry out planning de-centrally, that is, you can process planning data locally with a number of Excel files on one or more computers. The planning data entered with Excel can be imported to the SAP system via an upload.
Prerequisites
Planning with Excel is based on the settings in the
planning layout. In order to prepare and carry out an Excel upload, the following prerequisites must be met for the planning layout:
If you change a planning layout after creating an Excel template for it you can no longer use this Excel template. In this case, you have to create a new Excel template.
Preparing the Excel Upload
In order to enter planning data in Excel and to then import it to the SAP system, you must first prepare the Excel upload. To do so, you have to set up a connection between the planning layout and the Excel file. To do this, proceed as follows:
Enter the values for the variables defined in the planning layout. This entry is necessary so that the Excel spreadsheet can be opened in the next step.
The system automatically assigns a

You can also define a file name. To do this, you have to go to the column File Name in the planning profile when editing your plan task and enter your own file name.
The screen defined in the planning layout is displayed in the upper left hand corner of the Excel sheet. You can set up the spreadsheet individually. Various functions are available for this purpose. For more information see Functions for Editing Excel Sheets.
The generic file name creates the connection between the file on the local PC and the file name during the upload.

The generic file name must consist of a group of characters (in capital letters), the generic sign *, and the file ending .TXT, for example PLANNING*.TXT.

The name ranges of the various generic file names cannot overlap as this would not allow a unique assignment of the local file to the file name. If, for example, the generic file name PLAN*.TXT was assigned at one position and PLANN*.TXT at another, the system cannot uniquely assign the upload of file PLANN5*.TXT.
You can display an overview of all data files with generic data names. To do this, call up the program RKCDPREO using the ABAP Editor . You can delete data file names and generic data names from this list if they are no longer used.

You first have to use the Excel format with the ending .XLS as a file format. The file can now be opened in Excel independent of the SAP system. You have to save the file as a text file .TXT if you want to upload this file to the SAP system.

Ensure that the individual file names correspond to the generic file name so that you can upload this file to the SAP system correctly.
Creating Planning Data Locally with Excel

Do not use the following Excel functions:
If you use these functions, data cannot be imported to the SAP system correctly.
The following functions are available for entering your planning data in the Excel sheet:

Complete the following before the Excel upload:
Completing the Excel Upload

The path and the file names on your PC in which the planning data is saved must not have any spaces such as the directory "My Documents".