Learn SAP from the Experts | The SAP PRESS Blog

The Material Ledger and Actual Costing with SAP S/4HANA

Written by SAP PRESS | Oct 19, 2020 1:15:00 PM

Material ledger accounting refers to the ability to generate financial transactions at a material level, providing granular detail of inventory movement.

 

Although it's called the Material Ledger, the material-ledger detail is actually stored as part of the Universal Journal in SAP S/4HANA Finance.

 

Actual costing is an optional feature that can be activated as part of the Material Ledger to revalue materials at their actual cost as part of period-end close. It is important to understand that actual costing is an element of the Material Ledger, but requires additional transaction processing to calculate and revalue inventory based on actual costs.

 

 

This blog post will start with a process overview of the Material Ledger and actual costing, and then explore the key functionalities and reporting options.

 

Process Overview

One of the major changes in SAP S/4HANA in regard to management accounting (inventory valuation, to be specific) is that the Material Ledger is now obligatory in SAP S/4HANA.

 

In other words, the Material Ledger and finance in SAP S/4HANA provide inventory valuation, rather than Material Ledger and materials management, as was the case with prior SAP versions. Material valuation is now stored in Material Ledger tables rather than materials management tables.

 

This change enables dynamic Material Ledger reporting, which is a powerful capability, given the technical advancements of SAP HANA data. Additionally, the Material Ledger supports ad-hoc reporting capabilities with SAP Fiori, as well as with other analytics tools. Now, inventory valuation is brought into the Universal Journal, serving as a single source of truth.

 

While the Material Ledger is required in SAP S/4HANA, activating actual costing is still optional. SAP has made it mandatory for Material Ledger to be active, but the specific use of Material Ledger can still be customized to suit your business’s needs. This requirement also does not prevent you from using either standard or moving average prices to value your inventory. In short, price control remains unchanged.

 

The actual costing process identifies the differences between the standard price and the real procurement price of the goods movement, which are recorded in the Material Ledger when the material movement takes place. At period end, all these recordings are used to calculate the periodic unit price (PUP) of the materials using actual costing. Furthermore, the calculated PUP can be used to revaluate the ending inventories and consumptions.

 

The fact that Material Ledger is now obligatory in SAP S/4HANA does not mean an additional effort on your part in terms of implementation, period-end close, or reporting. Rather, this activation of Material Ledger in SAP S/4HANA enables inventory valuation reporting as part of the Universal Journal. Advanced reporting capabilities are just one of the benefits.

 

The new solution enables inventory values to be stored in multiple currencies and, if you choose to activate multiple valuation views, according to several parallel accounting standards. Technical benefits include the elimination of redundant data, since local currency inventory value is stored in both material master and Material Ledger tables.

 

Additionally, this offers improved scalability through optimization of the locking mechanism when material documents are created.

 

There are two new Material Ledger document tables in SAP S/4HANA: MLDOC and MLDOCCCS. These tables replace the following periodic tables: MLHD, MLIT, MLPP, MLPPF, MLCR, MLCRF, MLKEPH, CKMLPP, CKMLCR, MLCD, CKMLMV003, CKMLMV004, CKMLPPWIP, and CKMLKEPH.

 

Transfer Pricing and Multiple Valuation Approaches

Transfer prices allow organizations to value goods and services exchanged between different organizational units within the corporation. By valuing the exchange of goods and services using transfer prices, you can significantly influence the actual success of your corporate divisions or profit centers.

 

For example, when company code A sells raw materials to company code B, company B pays company A a transfer price. This transfer price may be based on company code A’s cost plus a markup or based on a market price. The transfer price provides company code A with a profit that aligns with legal reporting requirements and is represented in financial reporting.

 

At a corporate level, the intercompany profit on company code A and intercompany cost on company code B are eliminated to represent a consolidated corporate financial report. The transfer pricing and multiple valuation approach functionality in SAP S/4HANA enables reporting on both of these views.

 

As in financial accounting, parallel valuation can be implemented in controlling to attribute valuation approaches to a particular ledger in the general ledger. You can manage up to three valuation approaches, or valuation views, in parallel to support transfer pricing: legal valuation view, group valuation view, and profit center valuation view.

 

The following valuation views are available:

  • The legal valuation view provides a view of company codes as separate legal entities with transfer pricing between companies within the corporation. The view is aligned with the accounting principles of the leading ledger within the general ledger.
  • The group valuation view provides a view of the organization as a group reporting entity rather than many legal entities (company codes). This view can be used to provide a reporting view without intercompany transfer pricing for decision making at a corporate (group) level.
  • The profit center valuation view enables reporting on profit centers when profit centers represent divisions within an organization and drive transfer pricing with different profits and profit margins.

Activating Valuation Views

Often legal and group valuation are required for reporting, but profit center valuation is not. In this case, it is recommended to only activate the valuation views that are required or will be required in the future. Activating profit center valuation requires maintenance of additional configuration to map transfer prices at a profit center level. If not required, this additional configuration creates unnecessary additional system processing time and ongoing maintenance.

 

For your valuation views, you can either use separate ledgers, or map multiple valuation views within a ledger as follows:

  • Parallel single-valuation refers to the assignment of valuation approaches each to a single ledger (i.e., legal valuation assigned to leading ledger). Parallel single-valuation includes: Valuation assigned to ledger; option for new implementations; simpler authorization concept; separate close processing required by valuation view; and multiple currencies in journal entries, allocations (assessments and distributions), and asset capitalization and depreciation.
  • Multi-valuation ledger refers to the assignment of one ledger to all currency types and valuation views. The multi-valuation ledger includes: currency types of all valuation views can be used in that ledger, no separate close required by valuation view, optimized memory, and valuation view specified in reporting.

You can select per each ledger whether you want to enable a parallel single-valuation or multi-valuation approach. The leading ledger can be used either with the legal valuation view or without restriction to one valuation view. However, it cannot be configured exclusively with only group or profit center valuation views.

Multiple Valuation Views

If you want to use multiple valuation views within a ledger, do not assign a valuation view to that ledger. This enables all currency types to be available for reporting within that ledger. The following depicts how you can design your ledgers to coincide with valuation views.

 

 

Actual Costing Runs

The actual costing cockpit provides a way to perform the various steps included in actual costing runs. These steps include production and process order closure, overhead cost calculation, allocations, actual cost split, actual activity rate calculation, and actual costing.

 

Changes within the actual costing run functionality in SAP S/4HANA include the following:

  • A change of standard price for materials and activities within the period is supported
  • If a material is reprocessed by settlement, the system automatically recognizes the dependent materials on higher costing levels need to be reprocessed
  • Consumption price differences are now considered
  • A new two-dimensional distribution logic avoids rounding errors
  • Price limiter logic is accurate on the cost component split level

The sequence of steps in the Material Ledger actual costing cockpit are as follows:

Selection

The figure below shows the selection screen of the actual costing program execution. All material transactions and activities related to the materials for which the price determination is 3, and all activity types (if an activity type update of 2 is activated), will be selected for actual costing execution and will be in scope for calculation of the PUP. Parallel processing is available to run the actual costing based on the plant and other given parameters combinations.

 

Preparation

In the preparation step, the settlement records are created. These settlement records will get updated with the values while the settlement process is executed. The different types of settlement records are used to differentiate types of value flows like revaluation of ending inventory, revaluation of single-level consumption, multi-level revaluation from input (material or activity), WIP input (material or activity) to output material, and WIP increase/reduction.

Settlement

The processing steps that were previously performed in Transaction CKMLCP (single-level price determination, multilevel price determination, revaluation of consumption, and WIP revaluation) and replaced in SAP S/4HANA by a single settlement step. The settlement step performs cost allocations and actual price calculations.

Post Closing

The post-closing step specifies whether the system should re-evaluate the ending inventory and consumption for the period to be closed with the prices calculated in the settlement process step, and to whether the post the closing adjustment documents.

Mark Prices

If a business decides to use the PUP as a valuation price in the following period, then you can mark and release the price as standard price (S). Then, the system changes the price control indicator from S to moving average price (V) and updates the new PUP as the standard price.

 

There are several other changes to the Material Ledger’s actual costing cockpit (Transactions CKMLCP and CKMLCPAVR):

  • A new parameter Application makes it possible to process alternative valuation runs via Transaction CKMLCP, and actual costing runs via Transaction CKMLCPAVR.
  • In the toolbar of Transactions CKMLCP and CKMLCPAVR, there is a new button next to Display <-> Change to switch the application from Costing Run to Run Reference and vice versa.
  • It is no longer possible to use delta posting runs in the actual costing cockpit.

Conclusion

This blog post on the SAP Material Ledger/actual costing provided an overview of the key changes in SAP S/4HANA Finance to the Material Ledger and actual costing.

 

Editor’s note: This post has been adapted from a section of the book SAP S/4HANA Finance: An Introduction by Maunil Mehta, Usman Aijaz, Sam Parikh, and Sanjib Chattopadhyay.