Skip to Content
Product Information
Author's profile photo Sudharsan Renganathan

Multiple Valuation Approaches -SAP S/4HANA

A transfer prices arises for accounting purposes, when one entity purchases goods from another entity within same group of companies. When two unrelated companies trade with each other, the price at which they undertake their transaction is simply known as “Price”. But when supply of goods and services is made to another related company, the price is called “transfer Price”

What you will understand from this blog Post?

A Multinational company operating in three countries have a requirement to determine the actual cost of goods manufactured for the group and does not include any intercompany profit and at the same time for legal reporting purpose require to include intercompany profit. This blog explained about how we can valuate inventory for different reporting purposes. In SAP S/4HANA Multiple valuation approaches /transfer prices functionality can manage up to three valuation approaches. This blog post covers two valuation approaches or views a) Legal View b) Group View

  1. Introduction to Multiple Valuation approach
  2. Business Case
  3. Configuration Settings required for Multiple Valuation approach
  4. Scenario explained for business transaction
  5. Summary and Limitation in Multiple Valuation approach

What is Multiple Valuation approach

Multiple valuation approach is the ability to value inventory in more than one valuation method.

This Approach required for:

Legal view

The legal view is the view of the individual enterprise that represents the transfers of goods and services between independent companies according to the legal reporting requirements

Group view

In the group view, the exchanged goods and services within affiliated companies determines the cost of good manufactured without including any intercompany profits.

Profit center view

In the profit center view, the exchanges of goods and services between profit centers are valuated using internal prices. In order to determine the profitability of those profit center and helpful for management to take pricing decision accordingly.

 Business case:

In our example “Best Run” is a holding company with three legal entities the system represents the company codes LT02 located in Germany ,Company LT01 located in India and the company code LT03 located in US

The entity LT02 uses EUR as its local currency,LT01 uses INR as its local currency and LT03 uses USD as its local currency and all the three company code assign to the Controlling area “Best Run” LTP1 which uses the group currency EUR .The controlling area is assigned to an Operating concern called “Best Run” LTP1 with Accounting Based COPA ,its Currency EUR.

This session provides an configuration setting required for multiple valuation with in S/4 HANA environment

1.Creating a Currency and Valuation Profile:

The currency and valuation profile determine which valuations the system stores in which currency. Using standard, we can store up to three different valuation views in up to two different currency

To create valuation profile, follow the below steps:

Transaction 8KEM or follow the IMG menu Path Controlling –> General Controlling –>Multiple Valuation Approaches/Transfer Prices –>Basic settings –>Maintain Currency and Valuation Profile

 

2. Assigning Currency and Valuation profile to Controlling area:

Assignment of the currency and valuation Profiles enable you to create actual version in CO for different valuation views. To assign the valuation profile to the controlling area, follow these steps:

Transaction 8KEQ or follow the IMG menu Path Controlling–>General Controlling –>Multiple Valuation Approaches/Transfer Prices –> Basic settings –> Assign currency and valuation profile to controlling area

 

3.  Creating Versions for valuations

 

The multiple valuation approaches are stored in CO version in Controlling. If you use multiple valuation, the system used actual Version 0 for legal valuation and data of the parallel valuation stored in the delta version.

To create a delate version in CO, follow these steps

IMG menu path: Controlling –>General Controlling –>Organization –>Maintain version

 

4. Currency and Ledger settings in the Universal Journal

In the universal journal, multiple valuation approaches are managed in same way as parallel FI currencies. In SAP S/4HANA two options available to store multiple valuation.

    1. Multi-Valuation ledger (Mixed ledger)
    2. Separate Valuation ledger (Single- Valuation ledger)

Multiple Valuation-Single Ledger

Multiple Valuation-Multiple Ledger 

Customizing settings in Finance: IMG menu path Financial accounting–>Financial accounting Global settings –>Ledgers–>Define settings for ledger and Currency types (transaction FINSC_ledger)

In case of multiple valuation ledger approach Valuation view is blank. In our Example we are using Multiple valuation- Single Ledger

For activating group valuation, both currency types 11 and 31 need to be maintained in the new currency customizing. In ACDOCA, the currency types in the company code currency and global currency must exit for group valuation. Although only one currency type is maintained for a valuation approach in the currency and valuation profile both currency types of a valuation are necessary for updating data in Controlling (Refer SAP note-2882025)

Company code settings for the ledger LT02 and LT03

 

5. Assigning Currency type to Material ledger

Material ledger is used for a multi-currency and or multi- valuation of inventory. In SAP S/4HANA ML must be active. The valuated inventory accountings are stored in Universal journal (ACDOCA). The currency types assigned to Material ledger types only in the currency maintained in the Currency and Valuation profile. If you use group valuation only one currency per valuation is allowed.

IMG Menu path Controlling–> Product Cost Controlling–>Actual costing/Material ledger–>Assign Currency types and Define Material ledger type.

 

6. Determining the valuation approach for Clearing Account

When you use multiple valuation approaches/transfer prices, payables and receivables are only posted using legal valuation because that represents the amount in which the payment is made. If, however, you want to record other valuation approaches in the valuation clearing account, you need to post the difference to accounts for intercompany profits so that this amount appears in the group report.

Use Transaction 8KEN, or follow the IMG menu path Controlling –>General Controlling –>Multiple Valuation Approaches/Transfer Prices –> Level of Detail –> Define Valuation Clearing Account

 

7. Standard cost Estimate settings for valuation approach (Optional Activity)

Product cost planning provide the possibility of determining standard cost according to different valuation approach (Legal and Group).To update the standard cost of the material for each valuation, additional costing variant required in product cost planning for Legal Valuation and Group Valuation .

First create the costing types to create the costing variant. The costing type determines what valuation approach is assigned to the costing variant.

Transaction OKKI Or IMG menu path Controlling –>Product Cost controlling –> Product Cost Planning –>Material Cost Estimate with Quantity Structure –>Costing Variant: Components –>Define Costing Types.

The product cost variant contains all the control parameters of costing.

Transaction OKKN or follow the IMG menu path Controlling –> Product Cost controlling –>Product Cost Planning –>Material Cost Estimate with Quantity Structure –> Define Costing Variants.

Costing Type GR used for Group Valuation

Costing Type L1 used for Legal Valuation

Product Costing Variant for Legal valuation LT01

Product Costing Variant for Group valuation LT02

 

8. Cost Component structure settings for Group valuation (Optional Activity)

Additionally, a configuration in the cost component structure allows you to display the intercompany profit across all levels of the entire value chain. This enables you to compare actual costs with actual revenue by eliminating the internal profits between company codes from the same group.

To identify the markup in the intercompany process, you have to create a new cost component in your cost component structure. You configure the cost component structure

Transaction OKTZ or by following the IMG menu path Controlling –>Product Cost Controlling –>Product Cost Planning –> Basic Settings for Material Costing –> Define Cost Component Structure

 

9. Splitting of Cost of Goods Sold in Parallel Valuation View (Optional Activity)

By activating this function, the cost of goods sold amount are split into different accounts in accordance with the cost components.

By implementing the account-based split in Cost Splitting profile, it will split the cost when the source account is posted.

As of Release1809, the cost posted during the revaluation of material consumption (CKMLCP) can be split based on the actual costing. For this you must set the “Split Revaluated Consumption with Actual Cost Component Split”

As of Release 1909, The COGS split document, the fixed portion is updated in the controlling area currency for the legal valuation, group valuation in table ACDOCA.

Refer SAP note –2399030

Customizing option for COGS Split performed in IMG menu Financial accounting (New)–>General ledger Accounting (New)–>Periodic Processing–>Integration->Material management –>Define Accounts for splitting the cost of Goods Sold

 

10. Activating Multiple Valuation

Activating the currency and valuation profile is the final mandatory step in customizing. The currency and valuation profile must only be activated after all above necessary steps are completed. The activation can be by following the Transaction 8KEP or IMG menu path Controlling–>General Controlling –>Multiple Valuation approaches /Transfer Prices –>Activation –> Multiple Valuation Approaches: Check/Execute Activation

Select the option Check activation before activation, the system checks whether the valuation approaches defined in the currency and valuation profile are consistent with the settings in the individual applications.

Scenario:

Based on the above-mentioned customizing settings let understand the accounting postings in Universal Journal. The entity LT02 has plant LT02 located in Germany and Company code LT03 has plant LT03 located in US. LT02 plant  transfer Finished goods to selling plant, LT03. Whereas LT02 receive finished goods from  LT01 is a manufacturing Plant. To avoid operating at a breakeven /loss ,entity LT02 add intercompany margin in the intercompany sales.

In these case all the plants are activated actual costing and actual cost component split in SAP S/4HANA.

.

This session provides an intercompany transaction postings and integrated accounting documents (From LT02 to LT03). Based on the above-mentioned customizing settings

I . Standard Cost Estimate:

The released standard cost estimate can be viewed in material master for finished goods. The price determination of the material ML-FG-P300 in plant LT03 and LT02is 3. The special procurement type F& L2 (Stock transfer from LT02) maintained for this material

 

II  .Cost Component Split in Standard Price

Let us analysis the I/C profit for transfer price in cost component view in both valuation legal and Group valuation

In Legal Valuation:

Intercompany profit will be zero

In Group Valuation:

In Group view system calculates the delta profit between company code which we called as Intercompany margin.

IC margin = Procurement Costs -COGM_in_group_valuation (Refer Sap Note-2160974 for calculation)

 

III. Purchase Order

Let’s create an intercompany purchase order in company code LT03 and LT02 as supplier -Company code located in Germany.

In the above purchase order material- ML-FG-P300 procured from company code LT02, for a PO quantity 1 EA

Pricing Element Condition in Purchase order Contains:

Finished material procured from company code LT02 for a price of 125.40 EUR and Intercompany mark value is 21.60 EUR per quantity

 

IV. Accounting Document:

In this step, lets analyses the intercompany accounting document posting in both company code LT02 and Lt03 against purchased order created in above step.

Once you posted goods receipt, you can see the three documents posted for intercompany posting ,2 document posted in sending company code LT02 and one document posted in receiving company code LT03

Before analyzing the accounting document in entity LT02, let understand the Standard price of the material ML-FG-P300 in plant LT02. For legal valuation at 125.40 EUR and in Group Valuation at 104.49 EUR

Legal Valuation:

Group Valuation:

a ) Below document posted in company code LT02 for cost of goods sold at standard price

b) Another document posted in company code LT02 for COGS Split in Group Valuation.

c) Third Accounting Document posted in Company code LT03, lets understand how intercompany profit calculated in legal valuation and eliminated in Group View

In the above document I/C profit value is added only in Legal view both in local and Group Currency

V. Intercompany Invoice Posting:

We are using parallel valuation approaches, receivables and payables are posted only in the legal valuation view because the payment is made with this amount. However, if different valuations are posted for the offsetting account, the difference must be posted in valuation approach clearing accounts to be used in consolidated financial statement reporting.

Entity LT02 post a sales invoice to company code LT03

Once Goods receipts posted against Intercompany Purchase order, next step to post Vendor invoice posting in company code LT03.

The difference in value between two valuation approach has been posted in Gl account – “Valuation Transfer” with value of EUR 42.51 only in group view in Gl clearing account 52040000. Gl account is determined based on the above settings mentioned in 8KEN.

In addition to above accounting entry Valuation transfer GL get posted even at the time of  price difference settlement posting during actual costing run.

VI. Actual Costing Run:

Calculate and post the actual costing run across the company code by using actual costing run CKMLCP. The actual costing run allocates the price difference from raw material to semi-Finished to Finished goods. In case of stock transfer from one pant to another both plants should be included in same costing run to settle the price difference from sending plant to receiving plant. The actual costing run determines all the material having price determination 3.Activating Actual Costing is not mandatory in SAPS/4HANA it depends on business requirement .

Let’s examine in Material Price Analysis -CKM3 what happens in the Legal and Group valuation view. When the goods receipt is performed in the receiving company code, an inter-company is calculated in the legal view and show in Inter company profit component created in OKTZ.

Legal Valuation View Receiving Plant LT03:

Group Valuation View in Receiving Plant LT03:

Legal Valuation View in Sending Plant LT02:

Group Valuation View in Sending Plant LT02:

Before concluding let’s simulate the all the accounting entry posted to understand the P&L balance in Legal and Group View. This accounting document get stored in Universal Journal table and can be analysed in COPA line item report KE24 in each valuation view.

Summary

By reading this blog post, you would have understood the concepts and configuration steps of multiple valuation approaches/transfer prices by using  Legal and Group valuation .The management requirement also met with the valuating inventory at multiple level by including with and without  intercompany  profit.

When you divide up your company as a Profit center by manufacturing ,sales depot for same classification of material and we do more number of inter profit center transaction ,then there is a requirement to use the option of transfer price for inter profit transfer in this case activating profit center views will provide the inventory valuation at profit center level. The additional configuration steps for profit center views are – Automatic Account determination, Determining Accounts for Internal Goods Movement, Transfer price Pricing procedure (8KEA).

Limitation on the Multiple valuation approaches :

  • You can only perform group costing within a single controlling area
  • Multiple valuation approaches cannot be used for the purposes of make-to-order production for unvaluated customer sales order stock.
  • A deactivation of multiple valuation approaches/transfer prices in SAP S/4HANA is currently impossible. !
  • Multiple valuations approach /transfer prices are not supported in RAR (FI-RA). The corresponding currencies must be deactivated in customizing for RAR.
  • A maximum of three currency fields are available for the operational inventory valuation of the materials
  • The subsequent implementation of multiple valuation approaches in a productive SAP S/4HANA system is not yet supported. Therefore, if multiple valuation approaches are required in your group, the current recommendation is to introduce the multiple valuations in the ERP system and then migrate to SAP S/4HANA.

Thanks

Sudharsan R

Assigned Tags

      35 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo diamantino gorrad
      diamantino gorrad

      Thanks a lot for this  !

       

      Author's profile photo PALURU GIRIDHAR
      PALURU GIRIDHAR

      Thanks a lot

      Author's profile photo Mallareddy Udumula
      Mallareddy Udumula

      Super blog and explained very well with detailed manner.

      Author's profile photo CK Challa
      CK Challa

      Sudharsan Renganathan

      Very informative! Well written Blog.

      Thank you, Sudharsan.

      Author's profile photo Sandip Kurewar
      Sandip Kurewar

      Thank you ! @Sudharsan Renganathan.

      This is very informative!

      Author's profile photo vitulsyan vitulsyan
      vitulsyan vitulsyan

      Great doc...What if we are already live in S/4 HANA and want to use the Parallel Valuation? I know the note says not supported but what's the option as we are already live?

      Author's profile photo Sudharsan Renganathan
      Sudharsan Renganathan
      Blog Post Author

      Unfortunately we need to wait for new release with subsequent activation of Transfer price.

      Alternatively PAPM has capability to handle Transfer price module.

      You can check on that module to help your requirement .

       

      Author's profile photo Vidya A.L
      Vidya A.L

      PAPM Modules, for Disclosure Management, will not support For Transfer price.

       

      Yes we need to wait for New release.

      Author's profile photo dhiraj deo
      dhiraj deo

      Nice blog and well explained. WHat is the heuristic solution to this as an alternative? WIthout activating TP and Parallel valuations?

      Becuase I understand that this activation is done at CO area level, and only 30% of divisions use INTRA company TP ( other use only wen there is INTER company transaction).

      So they do want TP only for specific set of divisions or lower levels ( such as PCs).

      They do not want to maintain PC views of Material master , costing run etc etc for entire organisation.

      Is there SO-PO like traditional option also for inter PC ( or Intra Company) material and services transfer? Becuase if we do, it means every PC has to be a customer and vendor relationship. It would be massive.

      Can you pls share your views as to how without activating TP solution in S/4, one can still manage the cost transperacy within legal viewbut get the transfer price visibility between 2 PCs ( even if it is within same Company Code)

      Author's profile photo Emiliano MANFREDI
      Emiliano MANFREDI

      Hello ,

      I'm sorry , but when we  activate group valuation Standard cost Estimate settings for valuation approach (Optional Activity)  it's not an optional option any more , we have to complete all the customising for the group valuation costing

      please correct me if I'm wrong ,

       

      thank you

      BBH

      Author's profile photo Joachim Nerreter
      Joachim Nerreter

      Thank you for this great BLOG, Sudharsan.

      Your example is based on price control S and cross-company costing.
      If the price control is V the standard price won't be used but the GR will use the current moving average price. That is why we are planning to use a condition similar to KW00 in SD which is populated with the IC sender's group cost on the MM. The GR will post this amount as group cost on the GR/IR then.
      Thank you
      Author's profile photo Shashank Sourabh
      Shashank Sourabh

      Hey Joachim,

      Did we get a solution for doing group valuation using moving average price?you mentioned the plan to use a condition type similar to KW00 in your response to post the movement with group cost.Where would this group cost be stored ?

      thanks a lot in advance.

      shashank

      Author's profile photo Joachim Nerreter
      Joachim Nerreter

      Hello Shashank,

      Actually, we skipped the idea of using the current group valuation price of the the sending IC company and use the SAP standard, which means that goods receipts will use the current group valuation price on the material master for valuation.

      Note 458543 (section EXIT_SAPLPC32_003 (enhancement PCA0004)) describes this approach and how a user exit can be implemented to use the legal valuation instead. But from my point of view this is not correct, either since the legal price contains the IC mark-up.

      Regards,

      Joachim

      Author's profile photo Venkata giri
      Venkata giri

      How can we activate the profit center valuation with internal prices in the existing company code that already having transaction data?

      Author's profile photo Madhusekhar Gupta Gadamsetty
      Madhusekhar Gupta Gadamsetty

      Good to see contents of our demo script here.

      Author's profile photo Wieke HARTONO
      Wieke HARTONO

      Hello,

      During IC AP posting, I could not get the valuation clearing account (TCV) to post. Instead, it posted to PRD.  I have tried IC AP through MIRO route, and VF31 route (with intercompany billing ticked) using RD04 output type.

      Is there anything special to be set on MM STO Purchase order condition types?

       

      Thanks,

      WH

      Author's profile photo S Ragothaman
      S Ragothaman

      Hello WH

      Please check the Inter Company Pricing Procedure in billing which should have Print Parameter = X against KW00 in Group Valuation and Trading Partner should present in the Bill to Party, then TCV will be triggered for receiving company code else it will be posted to PRD.  Thanks!

      Author's profile photo Former Member
      Former Member

      Hi SS

      I configured KW00 in SD price procedure and Trading Partner in the master data. I got the right AR document which triggered TCV, but failed in AP document which not triggered TCV but post into PRD.

      Is there anything special to be set on MM STO Purchase order condition types? Thanks.

      AP document:

      Coc. DC Trs Posting Key Description Amount Currency Amt.in loc.cur. Local Currency LC2 amount Local currency 2 Group valuation by group currency group currency
      LT02 H KBS 31 Payable-Intra Co oth -7,800.00 CNY -1,000.00000 EUR -7,800.00 CNY -7,800.00 CNY
      LT02 S WRX 86 GR/IR 7,800.00 CNY 1,000.00000 EUR 7,800.00 CNY 6,094.23 CNY
      LT02 S PRD 86 SFG/FG cost variance 0.00 CNY 0.00000 EUR 0.00 CNY 1,705.77 CNY

       

       

      AR document with TCV:

      Coc. Dc Trs Posting Key Description Amount Cur Amt.in loc.cur. Local Currency LC2 amount Local currency 2 Group valuation by group currency group currency
      LT01 S   01 Intra Co AR-Others 7,800.00 CNY 7,800.00 CNY 7,800.00 CNY 7,800.00 CNY
      LT01 H   50 Intra Sales-Export -7,800.00 CNY -7,800.00 CNY -7,800.00 CNY 0.00 CNY
      LT01 H TCV 50 valuation transfer 0.00 CNY 0.00 CNY 0.00 CNY -1,705.77 CNY
      LT01 H   50 Intra Sales-Export 0.00 CNY 0.00 CNY 0.00 CNY -6,094.23 CNY

       

      Author's profile photo Fisher Jiang
      Fisher Jiang

      Hi WH,

      Did you resolve the posting entries in AP side? I have the same issue with you, the variance was posted to PRD instead of TCV.

      Appreciate your input in advace!

      Regards

      Fisher

      Author's profile photo peng zhao
      peng zhao

      For sales invoice  LT02, the group currency/group value is 104.49 of rev 41001500, in my system it's 147 as the value of local and group currency, and I don't know why we have 4 items . The document is like this

      local currency amt        group currency        group currency/group value

      01      LCU_LT03                     147                          147                              147

      50      41001500                      147-                         147-                             147-

      40      52040000                      0.00                         0.00                              104.49

      50      41001500                      0.00                         0.00                              104.49-

      . Could you help to analysis it or can you tell me your SD pricing procedures?

      Author's profile photo Madhusekhar Gupta Gadamsetty
      Madhusekhar Gupta Gadamsetty

      May I know which system?

      Regards

      Madhu

       

      Author's profile photo peng zhao
      peng zhao

      It's S4  2020  core  105.

      The vendor invoice  which is from IDOC when sales invoice create has right group currency/group value as condition type KW00. Only sales invoice is wrong.

      Author's profile photo Former Member
      Former Member

      Hi, Peng Zhao

      The vendor invoice is generated by IDOC, not through MIRO? Thanks.

       

      Author's profile photo Fisher Jiang
      Fisher Jiang

      Hi Peng zhao,

      Can you please share me the idoc setup? I am getting the error message when trigger idoc from billing.

      EDI: Outbound partner profile process code does not exist

      Message No. E0335

      Diagnosis

      An outbound partner profile could not be found with the following key:

      /0000004300/KU/RE/V3/RD04//

      Why "RE" was determined not "BP" maintained in WE20?

      Appreciate your input!

      Regards

      Fisher

      Author's profile photo Amit Narayan Sathe
      Amit Narayan Sathe

      Excellent article, very comprehensive, thanks a lot!

      Author's profile photo Chhandak Bhattacharyya
      Chhandak Bhattacharyya

      It  is indeed flawlessly described. My question is if I go to Single Leger or Multi ledger option, Can I see different standard cost (standard cost with cost component split in legal and group view ) and ML varaince entries (Group and legal) separately in accounts based COPA. Here you are using costing based copa not margin analysis therfore zou can show two view but in account based copa is that two possible?

      Author's profile photo Sanjai Babu Kopuri
      Sanjai Babu Kopuri

      Hi Sudharshan,

       

      Indeed its a great document , very informative . Appreciate for taking time and sharing the document.

       

      Thanks

      Sanjai

      Author's profile photo Shoujian Shi
      Shoujian Shi

      Hi Sudharshan,

      We purchase material by standard PO type,and the actual legal and group value are same (material cost + Markup).

      The PO type can only use STO?

      Thanks

      David

       

      Author's profile photo Sudhir Pawar
      Sudhir Pawar

      Hi Sudharshan,

       

      Thanks for the detailed explanation.

      When we add the intercompany markup condition % in STO and same is copied to intercompany billing document, the valuation clearing account (TCV) is not getting posted. W/O markup condition this working fine for us.

      Kind regards,

      Sudhir

       

      Author's profile photo SATYANARAYANA MULAGAPATI
      SATYANARAYANA MULAGAPATI

      Very important and useful blog. Great Job Sudharsan!

      Author's profile photo Raghavendra Baichwal
      Raghavendra Baichwal

      Thank you and great document, Sudharsan!

      One thing missing here is how was the std cost in LT03 calculated including the IC mark up in legal value....164.53 should be including the IC markup needed for IC sales.

      It would be great if you include some reference to it.

       

       

      Author's profile photo Indrajit Das
      Indrajit Das

      Excellent article connecting all the dots - great effort!

      Author's profile photo Gary Ding
      Gary Ding

      Hi Sudharsan R,

      Thank you so much for the detail sharing, is it available in S/4 Hana Cloud as well? Thanks

      B,R

      Gary

      Author's profile photo Former Member
      Former Member

      Hi, Sudharsan Renganathan

      Thanks for your detail sharing.

      I just create a delta co version but encounter an error like below:

      Journal entry is active; ABC delta versions cannot be used anymore

      Message no. FINS_ACDOC_CUST104

      There's nothing in table ACDOCA .

      How can I solve this? Thanks.

      B.R.

       

      Author's profile photo Linxu Gao
      Linxu Gao

      Sudharsan R,

      Good document. Thanks.

      I have a question. Under group valuation, to evaluation the group cost, you use the STO document. Is it the only way?

      Considering lots of cross-company transaction every day, we are planning to use material transfer or material issue between plants across company. Under these cases, the group cost can be read or not? If we create stock transfer order for internal vendor, it would be a huge volume of workload.

      Thanks.

      Linux Gao