Skip to Content
avatar image
Former Member

is there any way to find out this

Hi All,

I want to write a macro like it has to check if saleshistory values=0 from last 2 years and final forecast=o for future 2 years.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 09, 2011 at 12:17 PM

    Hello Nagareddy,

    Checkout below link:

    Macro Builder: Guides, Tutorials and Function References

    Regards,

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Naga,

      Download the two Key figures data from infocube in the T-code RSA1.

      Export the downloaded file into the spreadsheet and put the filter with the date range.

      Select the CVC combinations of which there is no data in the two key figures.

      Go to T-code SAPAPO/MC62 and delete the CVCs with reference to the file you have prepared.

      Please revert if you need more clarification as well.

      Thanks & Regards,

      Veera.

  • Nov 18, 2011 at 11:13 AM

    Naga, you would have 2 options -

    option 1) In the planning area, create a macro which would check the sum of the data in teh future and the past as per your requirement. If sum = 0, then you could create an alert based on this macro. This macro could then be used either in some background job or could be used dynamically and the demand planner could delete the CVCs which appear in alerts, after his cross-checks as required.

    option 2) A custom program could be created which would check the sum of forecast and history data, and display the results to the user. The user could then select the CVCs which he wants to delete. You could assign this kind of custom program to a custom T-code.

    option 1 is an option that is very commonly used, as this kind of activity comes under the normal scope of the demand planner. However, if your users are more interested in option 2 kind of solution, that also would not be very complex and any technical person who knows a little bit about APO can help you in creating such a program/t-code.

    Add comment
    10|10000 characters needed characters exceeded