Skip to Content
author's profile photo
Former Member

Macros help?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Posted on Sep 27, 2007 at 05:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2007 at 05:43 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded