Macros help?

[Former Member]

Hi experts,

My requirement is to design a macros for a planning book where apart from other fields i need to compute open demand and shipment plan.My shipment plan formula invloves open demand of previous day and open demand formula needs the shipment plan for the previous day.So i cannot calculate any one of this key figure before the other. But if i calculate all the key figures for one column first and then the next column and so on , then i suppose it will work fine .But i am not able to compute it one column after the other.I am able to do it only one keyfigure at a time across all columns .Can any of you kindly help to compute the key figures column wise

Kindly help

regards

Ashwin

[somnath_manna · Accepted solution]

It maybe worthwhile to go for a User Exit / BADI macro. The logic will be same as STOCK_CALC function. For more details see SAP Note 418801.

Thanks,

Somnath

[srinivas_krishnamoorthy]

If you want to avoid the BADIs path, I would recommend to execute the Macro multiple times. ( as many times as number of time buckets) This sounds very performance intensive, however if your calculations are simple, it should be ok.

The way to do it multiple times will be to use layers of collective macro.