FICO

Calculating Actual Price with SAP S/4HANA

In SAP S/4HANA, cost center under/overabsorption can be allocated to products, with the additional period-end process of revaluation at actual prices.

 

This process calculates the incremental planned activity price needed to allocate all cost center balances. Orders are then revalued with the incremental debits, and the cost center receives corresponding credits. Following revaluation, the cost center actual balance is zero in the actual costs column and the under/overabsorption row of the target/actual cost center report shown in this figure.

 

Actual/Target Cost Center Report Revaluation

 

The actual costs credited to the cost center, which were -28,000 before revaluation, are reduced to -23,000. The original product cost collectors and manufacturing orders receive a credit calculated with the formula: Consumed quantity (Original price – Actual price).

 

Product cost collectors need to be resettled following revaluation due to the incremental debit received during revaluation. There are two requirements for carrying out revaluation: a version configuration setting and an activity type setting. Let’s discuss each in turn.

 

Version Configuration

You maintain version configuration with Transaction OKEQ or via IMG menu path Controlling > General Controlling > Organization > Maintain Versions.

 

You’re presented with a screen like the one displayed in the next figure. Use the following steps to navigate to the version configuration setting displayed:

  1. Select Version 0.
  2. Double-click on Settings for Each Fiscal Year.
  3. Double-click on the current Fiscal Year.
  4. Click on the Price calculation

The screen shown is displayed.

 

Revaluation Setting in Version Configuration

 

Now that we’ve navigated to the correct tab, you make the configuration setting with the following steps:

  1. Click in the Revaluation
  2. Choose Own business transaction.
  3. Save the configuration.4

Activity Type Setting

The second requirement for carrying out revaluation is setting the actual price indicator for activity types to be revalued. You set the actual price indicator with Transaction KL02 or via menu path Accounting > Controlling > Cost Center Accounting > Master Data > Activity Type > Individual Processing > Change. Complete the Activity Type field, and press (Enter) to display the screen shown here.

 

Actual Price Indicator in Activity Type

 

You make the Activity Type setting with the following steps:

  1. Click in the price indicator field shown at the bottom of the above figure, and choose Possible Entries.
  2. Choose Actual price, automatically based on activity.
  3. Save the configuration.

Actual Price Calculation

Now that we’ve ensured that the configuration and activity type settings are correct, we’re ready to carry out actual price calculation. Revaluation occurs automatically during actual price calculation.

 

You carry out actual price calculation with Transaction KSII or via menu path Accounting > Controlling > Cost Center Accounting > Period-End Closing > Single Functions > Price Calculation. The screen shown below is displayed.

 

Actual Price Calculation Selection Screen

 

Enter your Period and Fiscal Year, select the Detail Lists checkbox, and click on the Execute button (not shown) to run the transaction.

 

You analyze the results of the actual price calculation in the information system with Transaction KSBT or via menu path Accounting Controlling > Cost Center Accounting > Information System > Reports for Cost Center Accounting > Prices > Cost Centers: Activity Prices. You can compare plan and actual activity prices with the report.

 

As long as you’ve set the Revaluation indicator in the Version, as shown earlier, and set the Act. price indicator in the activity type, also shown earlier, revaluation automatically occurs during actual price calculation. You can confirm the cost center balance is zero following revaluation with the standard actual/target cost center report.

 

Actual price calculation and revaluation allow you to post cost center variances to product cost collectors and manufacturing orders. If you need to allocate all purchasing and manufacturing differences to finished products as well, you should consider actual costing with the Material Ledger in SAP S/4HANA.

 

Editor’s note: This post has been adapted from a section of the book Production Variance Analysis in SAP S/4HANA by John Jordan and Janet Salmon.

Recommendation

Production Variance Analysis in SAP S/4HANA
Production Variance Analysis in SAP S/4HANA

To effectively plan production costs, you know that guesswork and projections aren’t enough. Optimize your production processes—and increase profitability—with this guide to production variance analysis in SAP S/4HANA. Start with the planning basics, and then perform costing runs and create cost estimates. See how to post actual costs with the Universal Journal, analyze variance during period-end processing, and assess scrap. Get details on SAP Fiori apps for reporting and the road ahead for variance analysis in this comprehensive resource!

Learn More
SAP PRESS
by SAP PRESS

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!

Comments