Entering content frameProcedure documentation Planning with Excel Integration Locate the document in its SAP Library structure

Use

You can use Microsoft Excel as an interface to enter planning data in the SAP system. The Excel entry screen is included in your SAP system.

Prerequisites

The entry of planning data is based on the settings in the planning layout. In order to carry out planning using Excel as an entry screen, the following prerequisites must be met:

Caution

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.

Preparations for Planning with Excel Integration

  1. Choose Budget Control System (BCS) ® Planning ® Define Planning Profile in Customizing of Funds Management.
  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 parameters 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 graphic is explained in the accompanying text (Overview Screen F5). This opens Microsoft Excel as the entry screen.

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

Note

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.
  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 set up the spreadsheet individually. Various functions are available for this purpose. For more information see Functions for Editing Excel Sheets.

  1. To save your Excel template, choose This graphic is explained in the accompanying text Save File Name. This saves your file name and the Excel layout.
  2. To return to the default parameters, choose This graphic is explained in the accompanying text (Back F3).
  3. You can delete the values that you entered for the variables in the default parameters if you do not want to display them for planning. Then choose This graphic is explained in the accompanying text (Save Ctrl+S).

Caution

The default parameters are only saved temporarily 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 Planning Data with Excel as the Entry Screen

Once you have set up and activated Excel integration for a planning layout, you can enter your planning data by using Excel as an entry screen.

  1. Ensure that the planner profile and the totals tables to which the planning layout is assigned are assigned to your user master data. To assign a planner profile and totals table to your user master data, choose Budgeting ® Budget Control System (BCS) ® Tools® Planning ® Set Planner Profile in the Funds Management menu.
  2. In the Funds Management menu choose, Budgeting ® Budget Control System ® Planning ® Change Planning Data. Excel opens as an entry screen within your SAP system The planning layout is displayed as an Excel spreadsheet.
  1. Enter your planning data.

Caution

You should not use the following functions:

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

You can find more information on entering planning data under Editing Planning Data.

 

 

Leaving content frame