After attribute transformation values calculation

[OliverA41]

Hello,

I have follow situation.

I have a product, that will be order within a certain time period. With on Order the is a big quantity. (e.g 100.000 pc per order)

Now the task is, that we have a follow calculation

order qty - demand planning qty -> new stock value.

The "new stock value" should be transfer in the next time period (week). This transfer will be working. But in this new time period the kf "new stock" should be also calculated with the demand planning quantity. and this result should also transfer.

The point is, that I don't find a way, to calculate a transfered value and transfered the result in the next period and so on.

Have you an idea, how I can do this?

Regards

Oliver

[Irmi_Kuntze · Accepted solution]

Hi Oliver

your description sounds a bit confusing. In such cases, a simple excel example would help a lot

But it sounds like a projected stock calculation, which is available either as a result of time series planning operator for heuristic or optimizer, or from response planning operators, or as on-the-fly calculation in the control tower template planning area SAP5 as LCode calculation.

In principle, if you need a rolling cross-period calculation where the result of period t is input to period t+1, this is currently only possible with LCode.

For that, there is a consulting note 2298382 "Requesting L-Code from SAP" available that describes the way how to request LCode from SAP, with the most important step to provide a good description (best with excel example from which you can see the formula) and to open an OSS message.

Yours

Irmi

[OliverA41]

Hi Imri,

yor're right. I attached a pdf file for better understanding.

in the first row you see the "demand planning qty".
In the next row, you see the "order qty". this is based on a lot size. in this case 100.000 pc. The calculation will now show how this amount is used up.
Below in the first column, is empty. In the further periods, you will see there the result of the calculation, which was calculate in the period before
In the last row, you see the result off the calculation. In the first colum the calculation is "order qty - demand planning qty". in the second periode the calculation is "stock in the month before - demand planning quantity"

And this is my problem. To move the result from one periode to another periode is working. But to use the shifted value in the calculation is my problem.

Regards

Oliver