Cumulativ Material Ledger initialization (MR22)

[RomainC]

Hi experts,

Here is my problematic:
Our customer plans to use the material ledger in Year-to-Date Run Type at system startup:

The question we're asking ourselves today is this: How to initialize the Material Ledger value?

I mean, our customer has been calculating the actual production costs of his products for years and would like the Material Ledger to consider the last known value at start-up, before calculating the actual stock value (CKMLCP) at the 1st monthly closing in SAP. (the go-live takes place during the current fiscal year)

However, they does not wish to define this actual price as the standard price for their products.

If we had been using a S/4HANA On Premise system, we would have followed the following procedure:

Initialization scenario: (Go live on 01/03/2025)

• Load material master data
• Load stocks: Quantity and standard or MAP values at month-end (28/02/2025)
• Validate inventory value, reconcile with balance sheet on inventory accounts (Business)
• Run CK40N as of 01/03/2025 (new period) => Automatic generation of accounting entry for standard revaluation difference
• 01/03: loading of actual price difference with transaction code MR22 on date 28/02/2025 to integrate current value
• Run Material Ledger (CKMLCP) for period M-1 (February)

We are currently experiencing a problem with the step highlighted in red, which to our knowledge cannot be carried out in S/4HANA Public Cloud, as an application equivalent to the MR22 transaction code does not appear to exist.

The fioriappslibrary provides the Manage Material Valuations application for transaction code MR22. But this application doesn't seem to allow us to modify the stock value as the MR22 transaction did. (I mean debit/credit a material)
According to the online documentation for S/4HANA Public Cloud, this functionality should be available : https://help.sap.com/docs/SAP_S4HANA_CLOUD/7f47a6d9441c46ac86c96fd27f6015f0/0152bfb67de346768835bd7c...

Are we missing something in app F2680?

We did some tests with API_MATERIAL_VALUATION_SRV (https://api.sap.com/api/API_MATERIAL_VALUATION_SRV/path/post_InventoryPriceChange) but it just changed the material price like a MR21.

Thanks for your support.

Romain C.

[Jessica_Dewald]

Hello, your question has been forwarded to the experts. We hope to provide an answer soon. Kind regards, Jessica

[Jessica_Dewald]

Hello Romain, 

you can find the debit/credit feature in the Manage Material Valuations app as follows: 

1. Search for your material.
2. Open the Details page from the results list (click on the arrow on the right side).
3. Choose Debit/Credit Material.

I hope this answers your question. 

Kind regards,

Jessica

[RomainC]

Hi Jessica,

Thank you for your help !
I was tricked by the 3 dots at the top right of my screen, which made the functionality button impossible to see...

I should have looked harder, sorry about that...

With the topic now open, my next question is obviously: How is it possible to make this mass stock value change in the system?
We'll have to carry out this operation on several thousand materials during the go-live weekend and the API API_MATERIAL_VALUATION_SRV I've tested doesn't seem to allow this debit/credit material functionality (I'm going to check again). And I don't see any file upload functionality apart from for the MR21 part.
Implementing a bot seems to me inconceivable as it would take at least 1 week to make the changes.

It would be a great help if you could get some inputs on the subject.

Thanks in advance !

Romain.