2956924 - Not Distributed price difference in App Material Price Analysis

作者：郑德鼎约 4 分钟阅读更新日期：2024-02-22 2 年前更新标签：MM, 物料管理

There is good explanation in below KBA
I would like to explain this logic again with below small example
So, the Not Distributed difference should be
The solution is also explained in the KBA
Rated Helpful
Quality Rating
There are 2 main causes for the Not Distributed value

Price Limiter and Not Distributed value calculation logic

331,843

With Material Ledger Actual Costing Run finished, sometimes we could see “Not Distributed” value happens on some materials.

One big reason for the “Not Distributed” value is the Price Limiter logic.

So, in this Blog, I would like to introduce the calculation logic for the “Not Distributed” value value which is caused by Price Limiter.

First, we need to understand what Price Limiter is.

There is good explanation in below KBA

2956924 – Not Distributed price difference in App Material Price Analysis

What is Price Limiter?

Price Limiter is a statistical quantity information in case of price difference postings without actual quantity movement. The price limiter quantity, for example, is updated in case of invoice receipts or order settlement.

The system will consider the Price Limiter quantity and by default, in case the Price Limiter value is bigger than cumulative inventory, system will only distribute the portion of cumulative inventory part of difference.

There is also one example in the attachment of the KBA (described only with text).

I would like to explain this logic again with below small example

We could see we only have 2 lines of price difference.

One is from the order settlement, and the other is from the Debit/Credit posting.

I made this Debit/Credit posting just to simulate the invoice postings or settlement postings which from previous period and with big price limiter quantity.

Although this posting doesn’t change the actual quantity for the material, I intended to make the base quantity as 100. So this 100 quantity will be considered as Price Limiter.

The basic calculation formula for the difference which should be distributed is:

Distributed Difference(D) = Total Price Difference(A) x Cumulative Inventory Quantity(B) / Total Price Limiter Quantity(C)

So, the Not Distributed difference should be

Not Distributed Difference(E) = A – D

In this case,

A = -439 + 500 = 61

B = 50

C = 40(Price Limiter for Order Settlement) + 100 (Price Limiter I created with Debit/Credit posting) = 140

D = 61 x 50 / 140 = 21.79

E = 61 – 21.79 = 39.21

Hope this will help you to understand the calculation logic.

Here you may ask why we introduce this Price Limiter calculation logic.

In the real business, the invoice comes later than the GR and sometimes it will be posted to the next period.

The invoice posting will not bring real quantity change, but it will bring the big price difference and also the Price Limiter quantity.

For some customers, they don’t want to have this kind of lagged behind price difference to affect the material price for current period. Here, the Price Limiter logic works.

Of course, if you don’t mind this impact and you don’t want to have the “Not Distributed” value, you can consider turning off this logic.

The solution is also explained in the KBA

2956924 – Not Distributed price difference in App Material Price Analysis

In the parameter setting for Settlement step of Actual Costing Run, you could tick the flag “No Stock Coverage Check” to disable the Price Limiter Logic.

FollowLikeRSS Feed

Alert Moderator

Assigned Tags

SAP S/4HANA Cloud for Finance

Rated Helpful

(4 people)

Quality Rating



DescriptionProductAttachmentsLanguagesRate This Document

Activate item to go to section in page

Symptom

After executing Actual Costing Run, you find in App Material Price Analysis, there are Not Distributed price difference.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

Open App Material Price Analysis.

Check price difference value.

Cause

There are 2 main causes for the Not Distributed value

1. Price Limiter logic

What is Price Limiter?

There is an example in attachment. Please check if you are interested.

2. Fallback strategy

If the cumulated difference is too low (negative), it may cause the actual value (prerequisite + difference) become negative. Since this is not reasonable to have negative actual value, system will use fallback stratery to determine the actual value.

The PUP is calculated with these priorities and you normally get relevant messages:

1. 'Cumulative Inventory' line (no fallback)

2. Receipts ('ZU') line (Info message C+ 135 in the log)

3. Beginning inventory ('AB') line (Info message C+ 138 in the log)

4. PUP-price of previous period (Info message C+ 136 in the log)

5. S-price (Info message C+ 137 in the log).

Resolution

1. If you don't want to apply this Price Limiter logic, you could choose to deactivate it in the actual costing run setting:

In the Parameter setting for Settlement step in App Edit Actual Costing Run, tick on the flag "No Stock Coverage Check". Then run the Settlement step again.

2. For the Fallback Strategy issue, you need to find out which posting caused the big negative difference. You need to make correction on that posting.

Keywords

CKMLCP, CKM3, exchange rate difference

关于作者：郑德鼎

企业信息化与 SAP 技术顾问，长期专注 SAP ABAP、FI/CO、MM、SD 等模块的技术分享与实战经验总结。查看更多介绍

来源说明：本文内容由「2956924 - Not Distributed price difference in App Material Price Analysis.docx」整理生成，仅用于内部技术分享与学习交流。