Uploading budgets at cost center level for different periods and accounting for the same is a basic requirement for any organization. Budgeting works as a goal or target to achieve, for a particular cost center. SAP provides us beautiful standard configuration to achieve this functionality. There are two options to upload budgets at cost center level or GL- either one can decide to develop a custom program or to attain this functionality by simple configurations as stated below. I have used some configurations as shown below with report painter.
Report painter is a beautiful tool which can be leveraged to achieve this functionality. ABAP knowledge is not necessary to use report painter.
This blog on budget upload covers two functionalities; cost center budget uploads and GL budget uploads.
Pre-requisites/assumptions:
Budget uploads
Cost center and GL budget uploads are covered in this document. These budgets are planned values for a cost center and GL- profit center wise. Like cost centers SAP has flexibility to budget GL as well. There are different planning versions delivered by SAP which can be used to upload budgets, or you can define your own version as required.
Definition: Cost center is a cost object/collector for e.g. project; cost element is the nature of cost for e.g. rent, salary etc. Cost centers are used to analyze all sorts of costs that are posted to it, departments are treated as cost centers.
In this document, let’s understand how to upload budgets for a particular cost center, cost element wise.
Note: Since PCA has been moved into FI with introduction of new GL, profit centers are created wrt to controlling area only. You can assign profit center to more than one company code.
SAP provides a standard functionality of flexible upload which can be used to meet this requirement.
Configuration design
It is recommended to use standard functionality of flexible upload to upload budgets for cost centers/cost elements and GL/profit center budget uploads. SAP has very simple configuration for uploading budgets.
Configuration for cost center/cost element budget uploads:
Configuration for GL/profit center budget upload
Detailed configuration:
Planning layout is created using report painter. Design a layout from scratch or copy a standard layout delivered by SAP depending on the requirement.
Take care of below pointers if the layout is created from scratch.
Choose if you want to create or change an existing layout:
Copy from existing layout or create your own from scratch
Usually your layout will have 2 lead columns and 12 columns for period.
Give general data selection. Again, this selection will vary based on business requirements:
Define what will appear at header level in general data selection and what values will be fixed. These values cannot be changed later by end user. Here there is an option of keeping input value as variable – which means the values can be changed later in the excel template while uploading. Unchecking the variable box will keep the value fixed. This is usually used to upload budgets for different versions using same template or using same template for different fiscal years.
Note:
For lead columns there is an option of keeping hierarchy node on/off and variable on/off. Hierarchy node is kept on only when there is a group of cost centers defined and you want to upload budgets only for that group. Variable ‘on’ and ‘off’ will give option to input variable value or fixed value as discussed above.
There is an option to define the lead column to be only characteristics or name. Below are the options to choose from. Click on lead as shown in below screenshot and choose the type of column required.
My second lead column has name and value.
Define other columns as periods. Periods is a required entry for this type of layout. Either use periods in general data selection, or it must be included in rows/columns.
Make sure to enable field for input.
2. Create planner profile: It is recommended to copy a standard planner profile.
Path to copy planner profile: SPRO-Controlling-Cost Center Accounting-Planning-Manual Planning-Define user defined planner profiles.
Copy SAPALL to ZSAPALL and ignore all the warnings that come up while saving ZSAPALL.
3. Assign planning layout to planner profile
Navigate to sub folders to reach layouts for controlling folder as shown below:
Select cost elements/activity inputs and double click on layouts for controlling. Here, assign the layout created previously and save it.
In next step we need to generate file description. This file description will be used at the time of upload and it is generated automatically by system at config level. Select the layout created earlier and double click on default parameters.
Fill in the parameters and click on overview.
Click on overview, an excel sheet will open. Click on enable macros and this will take you back to SAP screen.
Copy all and paste this in exact same format in a new excel sheet. Make sure not to change anything manually in the format. If anything changes the upload will fail.
Save generic file name description. The system will recognize this file name at the time of next uploads.
Click on save all to save file description and excel template. Do not forget to save preset parameters in previous screen. Incase if preset parameters are not saved there will be an error “preset parameters not found”.
Save the format in a new excel on the local PC. Update the template and use transaction code KE13 to upload the file. System will recognize only .txt file and not excel file. Make sure to save the file after updating in .txt format before you upload the same. Execute transaction code KE13 and select the file to be uploaded and file description which was generated earlier.
Configuration for GL/profit center budget upload
This functionality is used to prepare future forecast. Below is a simple configuration to achieve this functionality. You can generate a reusable excel template and upload the budgets every time you need to and prepare for forecast.
a) Install summary table
b) Define plan versions
c) Assign plan version to fiscal year and activate
d) Activate line items for planning
e) Define distribution keys
f) Define planning layout
g) Define planner profile
h) Assign planning layout to planner profile
i) Define document types for planning
j) Assign number ranges for plan documents
a) Install summary table:
In this activity, you install your summary tables for planning. This enters the summary tables in the Customizing tables of planning and makes them available for use with planning.
Path: SPRO-Financial Accounting (New)- General Ledger Accounting (New)-Planning-Technical help-Install summary table
You can either do a consistency check and execute or simply execute to install the summary table. Installing this table will activate the planning for summary tables and you can then do GL planning
Please note: if you do not install this table GL planning is not possible. This is a mandatory step
b) Define planning version:
In this activity, you will define or maintain standard planning version delivered by SAP to be available for each ledger.
c) Assign planning version to fiscal year and activate.
you can specify fiscal-year-dependent parameters for the plan versions of your ledgers. In so doing, you assign the desired fiscal year and posting period to your plan versions and activate them. You can also lock a plan version.
Please note: if your plan version is blocked, you cannot change planned values for this version
d) Activate line items for planning
Determine in the planning if summaries as well as plan line items are to be written. Also determine the following:
e) Define planning layout
You can choose to copy standard SAP layout and change it as per requirement or create a new layout using report painter from scratch. The summary table installed earlier is the basis of planning layout. In planning layout you will decide which characteristics and key figures you want to use. Layout of screen.
Choose create planning layout
Choose the summary table we installed earlier.
Click on create.
Here you get a new layout with 1 lead column and 1 column. You can create additional period columns and assign characters.
Define general data selection. This selection will be the base of your excel template which will be generated at the time of creating file name description exactly how we did for cost center budgets.
Define characters for 1st lead column.
Create period columns.
Give your posting period, system automatically picks up the month name for that period.
f) Define planner profile
Planner profile controls planning process. In a planner profile, you define for each table, which plan tasks can be used with which pre-setting. You can set up as many plan tasks as you need for each table. With the profile item, which determines the order of the plan tasks for a table, you are able to assign the same plan task more than once to a planner profile using different settings each time.
Copy SAPFAGL to ZSAPFAGL
Make sure you have totals table available to plan as shown in below screenshot.
g) Assign planning layout to planner profile
Assign the planning layout created in report painter to planner profile.
Choose default parameters for planning layout. To create excel template for planning.
Update fields and click on overview: save the file description and copy the excel template generated in a new excel sheet to re use in future for uploading the budgets.
h) Define document types for planning
Define document type PO for planning.
i) Assign number ranges for plan documents
Without number ranges no planning can be executed.
I have used report painter to create reusable excel format to upload budgets. This option saves cost and time for business. One can upload budgets using these same layout and same excel format for multiple items.
Feedback/suggestions are most welcome.
Okumaya devam et...
Report painter is a beautiful tool which can be leveraged to achieve this functionality. ABAP knowledge is not necessary to use report painter.
This blog on budget upload covers two functionalities; cost center budget uploads and GL budget uploads.
Pre-requisites/assumptions:
- New GL is activated
- Posting period is open
Budget uploads
Cost center and GL budget uploads are covered in this document. These budgets are planned values for a cost center and GL- profit center wise. Like cost centers SAP has flexibility to budget GL as well. There are different planning versions delivered by SAP which can be used to upload budgets, or you can define your own version as required.
Definition: Cost center is a cost object/collector for e.g. project; cost element is the nature of cost for e.g. rent, salary etc. Cost centers are used to analyze all sorts of costs that are posted to it, departments are treated as cost centers.
In this document, let’s understand how to upload budgets for a particular cost center, cost element wise.
Note: Since PCA has been moved into FI with introduction of new GL, profit centers are created wrt to controlling area only. You can assign profit center to more than one company code.
SAP provides a standard functionality of flexible upload which can be used to meet this requirement.
Configuration design
It is recommended to use standard functionality of flexible upload to upload budgets for cost centers/cost elements and GL/profit center budget uploads. SAP has very simple configuration for uploading budgets.
Configuration for cost center/cost element budget uploads:
- Create planning layout
- Create planner profile
- Assign planning layout to planner profile
- Define distribution keys
Configuration for GL/profit center budget upload
- a) Install summary table
- b) Define plan versions
- c) Assign plan version to fiscal year and activate
- d) Activate line items for planning
- e) Define distribution keys
- f) Define planning layout
- g) Define planner profile
- h) Assign planning layout to planner profile
- i) Define document types for planning
- j) Assign number ranges for plan documents
Detailed configuration:
- Create planning layout:
Planning layout is created using report painter. Design a layout from scratch or copy a standard layout delivered by SAP depending on the requirement.
Take care of below pointers if the layout is created from scratch.
- Keep minimum lead columns
- Make sure not to have any formula’s in the layout
- Make sure you enable field for input. if this field is not enabled, there will be an error “field not ready for input”
Choose if you want to create or change an existing layout:
Copy from existing layout or create your own from scratch
Usually your layout will have 2 lead columns and 12 columns for period.
Give general data selection. Again, this selection will vary based on business requirements:
Define what will appear at header level in general data selection and what values will be fixed. These values cannot be changed later by end user. Here there is an option of keeping input value as variable – which means the values can be changed later in the excel template while uploading. Unchecking the variable box will keep the value fixed. This is usually used to upload budgets for different versions using same template or using same template for different fiscal years.
Note:
For lead columns there is an option of keeping hierarchy node on/off and variable on/off. Hierarchy node is kept on only when there is a group of cost centers defined and you want to upload budgets only for that group. Variable ‘on’ and ‘off’ will give option to input variable value or fixed value as discussed above.
There is an option to define the lead column to be only characteristics or name. Below are the options to choose from. Click on lead as shown in below screenshot and choose the type of column required.
My second lead column has name and value.
Define other columns as periods. Periods is a required entry for this type of layout. Either use periods in general data selection, or it must be included in rows/columns.
Make sure to enable field for input.
2. Create planner profile: It is recommended to copy a standard planner profile.
Path to copy planner profile: SPRO-Controlling-Cost Center Accounting-Planning-Manual Planning-Define user defined planner profiles.
Copy SAPALL to ZSAPALL and ignore all the warnings that come up while saving ZSAPALL.
3. Assign planning layout to planner profile
Navigate to sub folders to reach layouts for controlling folder as shown below:
Select cost elements/activity inputs and double click on layouts for controlling. Here, assign the layout created previously and save it.
In next step we need to generate file description. This file description will be used at the time of upload and it is generated automatically by system at config level. Select the layout created earlier and double click on default parameters.
Fill in the parameters and click on overview.
Click on overview, an excel sheet will open. Click on enable macros and this will take you back to SAP screen.
Copy all and paste this in exact same format in a new excel sheet. Make sure not to change anything manually in the format. If anything changes the upload will fail.
Save generic file name description. The system will recognize this file name at the time of next uploads.
Click on save all to save file description and excel template. Do not forget to save preset parameters in previous screen. Incase if preset parameters are not saved there will be an error “preset parameters not found”.
Save the format in a new excel on the local PC. Update the template and use transaction code KE13 to upload the file. System will recognize only .txt file and not excel file. Make sure to save the file after updating in .txt format before you upload the same. Execute transaction code KE13 and select the file to be uploaded and file description which was generated earlier.
Configuration for GL/profit center budget upload
This functionality is used to prepare future forecast. Below is a simple configuration to achieve this functionality. You can generate a reusable excel template and upload the budgets every time you need to and prepare for forecast.
a) Install summary table
b) Define plan versions
c) Assign plan version to fiscal year and activate
d) Activate line items for planning
e) Define distribution keys
f) Define planning layout
g) Define planner profile
h) Assign planning layout to planner profile
i) Define document types for planning
j) Assign number ranges for plan documents
a) Install summary table:
In this activity, you install your summary tables for planning. This enters the summary tables in the Customizing tables of planning and makes them available for use with planning.
Path: SPRO-Financial Accounting (New)- General Ledger Accounting (New)-Planning-Technical help-Install summary table
You can either do a consistency check and execute or simply execute to install the summary table. Installing this table will activate the planning for summary tables and you can then do GL planning
Please note: if you do not install this table GL planning is not possible. This is a mandatory step
b) Define planning version:
In this activity, you will define or maintain standard planning version delivered by SAP to be available for each ledger.
c) Assign planning version to fiscal year and activate.
you can specify fiscal-year-dependent parameters for the plan versions of your ledgers. In so doing, you assign the desired fiscal year and posting period to your plan versions and activate them. You can also lock a plan version.
Please note: if your plan version is blocked, you cannot change planned values for this version
d) Activate line items for planning
Determine in the planning if summaries as well as plan line items are to be written. Also determine the following:
- which ledger, version, company code, and fiscal year plan line items are to be written.
- if the beginning balance of the plan summary records is to be calculated in the form of line items.
- Enter the desired document type.Choose your options as per business requirements in screen above
e) Define planning layout
You can choose to copy standard SAP layout and change it as per requirement or create a new layout using report painter from scratch. The summary table installed earlier is the basis of planning layout. In planning layout you will decide which characteristics and key figures you want to use. Layout of screen.
Choose create planning layout
Choose the summary table we installed earlier.
Click on create.
Here you get a new layout with 1 lead column and 1 column. You can create additional period columns and assign characters.
Define general data selection. This selection will be the base of your excel template which will be generated at the time of creating file name description exactly how we did for cost center budgets.
Define characters for 1st lead column.
Create period columns.
Give your posting period, system automatically picks up the month name for that period.
f) Define planner profile
Planner profile controls planning process. In a planner profile, you define for each table, which plan tasks can be used with which pre-setting. You can set up as many plan tasks as you need for each table. With the profile item, which determines the order of the plan tasks for a table, you are able to assign the same plan task more than once to a planner profile using different settings each time.
Copy SAPFAGL to ZSAPFAGL
Make sure you have totals table available to plan as shown in below screenshot.
Assign the planning layout created in report painter to planner profile.
Choose default parameters for planning layout. To create excel template for planning.
Update fields and click on overview: save the file description and copy the excel template generated in a new excel sheet to re use in future for uploading the budgets.
h) Define document types for planning
Define document type PO for planning.
i) Assign number ranges for plan documents
Without number ranges no planning can be executed.
I have used report painter to create reusable excel format to upload budgets. This option saves cost and time for business. One can upload budgets using these same layout and same excel format for multiple items.
Feedback/suggestions are most welcome.
Okumaya devam et...