Special Topics in Product Costing Config- Planning Profile & Layouts
Product Costing, part of the Controlling module, is used to value the internal cost of materials and production for profitability and management accounting. Product Costing is a niche skill. Due to costing’s high integration with other modules, many people avoid it due to the complexity. In my last blog series, I simplified Product Costing into 5 parts. I think an important follow up to that blog series is diving in to some of the configuration that support product costing.
In my blog on Cost Center Accounting, I discussed that you need to enter plan total dollars and quantities in each Cost Center in a Plant.
- Cost Center dollars are planned by Activity Type and Cost Element in Transaction KP06. Variable and fixed dollar amounts can be entered.
- Cost Center activity quantities are planned in by Activity Type in Transaction KP26. You can also manually enter an activity rate based on last year’s actual values.
- Statistical Key Figures are planned by Cost Center in Transaction KP46. SKF’s can be used in cost allocations.
When planning Cost Center dollars, activity quantities or rates, or SKF’s it’s important to ensure that your planning profile and layout are suitable for your requirements. For example, the default layout uses the Controlling Area currency. If your Company Code currency is not the same as the Controlling Area currency it will be confusing for users to convert currencies for planning purposes. You may also choose change your layout to make mass cost center planning possible rather than one sheet per cost center.
Below is the step by step process to create Planning Profiles and Layouts including best practices and tips.
1. KP34 Define User-Defined Planner Profiles
If you need to make changes to planning layouts, you will need to edit the Planner Profile. It is a best practice to create a new Planner Profile if changes need to be made instead of editing a SAP Planner Profile. You can use one Planner Profile with multiple Planning Layouts, or separate layouts into different Planner Profiles. To create: Click New Entries, enter the Profile, Description, and save.
2. Select the Planning Profile and click General Controlling. Drop down on Planning Areas and select the relevant planning that should be included in this Planning Profile. You can enter multiple Planning Areas in the same Planner Profile. Once entered, save. We will come back later to add more details.
3. KP65 Create Planning Layouts for Cost Element Planning
Enter the Planning Layout and description. You can also copy from an existing layout. It is best practice to copy from and create a new Layout if necessary. Click Create. The Report Painter screen shows the Planning Layouts for Cost Element Planning and the Planning Layout just created. Double click on any header field to change the column field or column description. Make any necessary changes to the fields in the layout and save.
Double click on any header field to change the column field or column description. Make any necessary changes to the fields in the layout and save.
4. KP34 Define User-Defined Planner Profiles
Select your previously created Planner Profile and click General Controlling. Select the Planning Area previously created and click Layouts for Controlling. Select the layout you created. Click the Overview and Integrated Planning check boxes. The overview option allows users to write over the default parameters on the selection screen. This usually makes sense to select. The Integrated Planning option allows the user to plan in an Excel sheet in SAP, or save an Excel file into SAP. We can deselect this later, but we need it to get our file description. Enter and save.
5. Select the layout and click Default Settings. You will be taken to the selection screen where Cost Element Planning is done. You can enter default parameters for any of the fields. For now, you must enter a Version, From Period, To Period, Fiscal Year, Cost Center and Cost Element. You can change defaults later.
6. Click the Overview button (F5). A popup will say ‘File description 0X_XPX_XXXX_XXXX has been generated’. Click enter. An excel upload template will appear. Copy and paste text to an excel file to save for users to upload. Click Save file description. If you click Save file layout, the layout on screen will appear for users when they enter planning. Some users may prefer this view. I find that users prefer the more structured standard layout versus the excel layout.
7. Green arrow back to the Default Parameters screen. Correct any default parameters and save. Green arrow back to the Layouts for Controlling screen. Deselect the Integrated Planning check box if desired. Notice that the File Description is now populated. Save.
8. Repeat steps 2 – 7 for any other Planning Layouts:
KP75 Create Planning Layouts for Activity Type Planning
KP85 Create Planning Layouts for Statistical Key Figure Planning
9. Now that this configuration is in place, users can upload an excel file or file directory instead of manually typing planning in SAP.
Go to KP06, KP26, or KP46. Extras-> Excel Planning-> Upload. Select Import single file or file directory. Enter the file path on your desktop. Enter the file description from configuration. Select the proper decimal notation and separator. Execute. The excel upload function is very finicky, but when it works, it can save a lot of time for users.