Planning with Excel Integration 

Use

You can use Microsoft Excel as your interface to enter plan data in the SAP System. Microsoft Excel can be connected to your SAP System as an interface.

Prerequisites

The entry of plan data is based on the planning layout. In order to complete planning using Excel as the creation screen, the following perquisites have to be met:

If you change a planning layout after creating an Excel template, you can no longer use this Excel template. In this case, you have to create a new Excel template.

Procedure

Preparations for planning with Excel integration

  1. In Financial Accounting Customizing, choose Special Purpose Ledger ® Planning ® Define Planner Profile.
  2. Navigate to the desired plan task and set the indicator Excel int. This activates Excel integration for this plan task.
  3. Open the default settings for your plan task.

    4. Enter the values for the variables defined in the planning layout. This entry is necessary so that the Excel sheet can be opened in the next step.

  4. Choose . This opens Microsoft Excel as the entry screen.

The system automatically assigns a file name. A connection between the plan task and the Excel spreadsheet is created by the file name, that is, a connection between the cells of the spreadsheet and the cells of the planning layout.

You can also enter a file name. To do so, you have to go to the column file name in the plan task when editing your plan task and enter your own file name.
  1. This takes you to the screen Maintain File Name with Excel as the entry screen.

The planning layout is displayed as an Excel spreadsheet. You can individually set up the spreadsheets. Various functions are available for this purpose. For more information see Functions for Editing Excel Templates.
  1. To save your Excel template, choose the Save icon. This saves your file name and the Excel layout.
  2. To return to the default parameters, choose .
  3. You can delete the values that you entered for the default parameters, if you do not want to display them for planning. Choose .

The default parameters are only temporarily saved at this point. To assign the file name to the planning layout and to save the values for the variables, you have to save the planner profile.

Entering plan data with Excel as the entry screen

Once you have set up and activated the Excel integration for a planning layout, you can enter your plan data in the Excel entry screen.

  1. Make certain the planner profile and totals table, to which the desired planning layout is assigned, are assigned to your user master data. To assign a planner profile and totals table to your user master data, from the SAP Easy Access menu choose Accounting ® Financial Accounting ® Special Purpose Ledger ® Planning ® Set planner profile.
  2. From the Special Purpose Ledger planning menu, choose Plan values ® Enter. Excel opens as the entry screen within the SAP System. Your planning layout is displayed as an Excel spreadsheet.
  1. Enter your plan data.

You should not use the following functions:

If you use these functions, the data cannot be properly imported into the SAP System.
  1. Save your plan data.

You can find additional information on creating plan data under Creating Plan Data.