For profitability and management accounting, the Product Costing module of the Controlling module is utilised to value the internal cost of materials and production. A specialised skill is product costing. Due to its complexity and high level of connection with other modules, pricing is frequently avoided. I broke down Product Costing into 5 sections in my previous blog series to make it simpler. I believe that delving into some of the configuration that support product costing is a crucial follow-up to that blog series.

You must input plan total dollars and quantities in each cost centre in a plant, as I explained in my blog post on cost centre accounting.

  • In Transaction KP06, Cost Center funds are budgeted according to Activity Type and Cost Element. You can input both variable and fixed dollar amounts.
  • In Transaction KP26, Cost Center activity quantities are planned in based on Activity Type. A manual activity rate based on the actual figures from the previous year can also be entered.
  • In Transaction KP46, Statistical Key Figures are planned by Cost Center. You can allocate costs using SKFs.

It’s crucial to confirm that your planning profile and structure are appropriate for your needs when planning Cost Center dollars, activity amounts or rates, or SKFs. For instance, the Controlling Area currency is used in the basic arrangement. It will be challenging for users to translate currencies for planning purposes if your Company Code currency differs from the Controlling Area currency. Instead of using a page for each cost centre, you may alter your layout to enable mass cost centre planning.

The method for creating planning profiles and layouts is outlined below, along with best practises and advice.

1. Create user-defined planner profiles with KP34

You must adjust the Planner Profile if you need to make modifications to the planning layouts. If modifications must be made, it is best practise to build a new Planner Profile rather than altering an existing SAP Planner Profile. You can combine several planning layouts into a single planner profile or divide them up into different planner profiles. To produce: After entering the Profile and Description, click New Entries.

2. Click General Controlling after selecting the Planning Profile. Select the pertinent planning that belongs in this planning profile from the drop-down list of planning areas. The single Planner Profile can contain several Planning Areas. Save after entering. Later, we’ll revisit and provide more information.

3. KP65 Produce Cost Element Planning Planning Layouts

The Planning Layout and Description are now entered. You can also duplicate a layout that already exists. The best course of action is to copy from and, if necessary, develop a new Layout. Press Create. The Planning Layouts for Cost Element Planning and the newly produced Planning Layout are displayed on the Report Painter screen. To edit the column field or column description, double click on any header field. Make any necessary adjustments to the layout’s fields, then save.

To edit the column field or column description, double click on any header field. Make any necessary adjustments to the layout’s fields, then save.

4. KP34 Create User-Defined Profiles for Planners

Click General Controlling after selecting the Planner Profile you already generated. Select the previously generated Planning Area, then select Layouts for Controlling. Choose the design you produced. The Overview and Integrated Planning check boxes should be selected. The selection screen’s default parameters can be modified by users using the overview option. Selecting this typically makes sense. The Integrated Planning option enables users to import Excel files into SAP or plan on an Excel sheet within SAP. Although we require this to obtain our file description, we can uncheck it afterwards. Type in and save.

5. After deciding on a layout, click Default Settings. The selection screen, when Cost Element Planning is completed, will be presented to you. Any field can have default values entered into it. The Version, From Period, To Period, Fiscal Year, Cost Center, and Cost Element fields are currently required. Later, you can modify defaults.

6. Select Overview from the menu (F5). File description 0X XPX XXXX XXXX has been produced, according to a popup. the Enter key. You’ll see an excel upload template. To save text for users to upload, copy and paste it into an excel document. Save file description by clicking. Users will see the layout on screen when they enter planning if you click Save file layout. Some users could favour this viewpoint. I discover that consumers choose the conventional style over the excel layout since it is more structured.

7. A green arrow points to the screen with the default parameters. Change any default settings, then save. Back to Layouts for Controlling screen with a green arrow. If desired, uncheck the Integrated Planning box. The File Description has now been filled in, as you can see. Save.

8. Repetition of steps 2 through 7 for any additional planning layouts:

KP75 Produce Activity Type Planning Planning Layouts

KP85 Develop Statistical Key Figure Planning Planning Layouts

9. Users can upload an excel file or file directory instead of manually entering plans into SAP now that this configuration is in place.

To KP06, KP26, or KP46, proceed. Upload via Extras > Excel Planning. Choose Import single file or directory. Enter the desktop’s file path here. Type in the configuration file’s description of the file. Decimal separator and notation should be chosen properly. Execute. Although the excel upload option is somewhat erratic, when it does work, users can save a tonne of time.