{"id":1054,"date":"2014-09-26T07:43:29","date_gmt":"2014-09-26T06:43:29","guid":{"rendered":"http:\/\/oprsteny.cz\/?p=1054"},"modified":"2014-09-26T08:09:52","modified_gmt":"2014-09-26T07:09:52","slug":"abap-apo-planning-book-macros-on-aggregated-levels","status":"publish","type":"post","link":"https:\/\/oprsteny.cz\/?p=1054","title":{"rendered":"ABAP – APO Planning book macros on aggregated levels"},"content":{"rendered":"

\"SAP\"Here I’d like to present my solution of a problem in APO planning books where it was necessary to load multiple products and locations at the same time into the planning view and execute some Default<\/em> macros on all of them. The requirement was to execute the macro always only per ONE product\/location. This was not possible because the planning data was aggregated on material and\/or location level.<\/p>\n

Therefore I have to modify the macros in macro editor (\/SAPAPO\/ADVM) so at first they DRILL_DOWN <\/em>on material level, then on location level and then the computation macro itself is executed.<\/p>\n

Macro “Drill down to Material level”<\/h2>\n

The basic idea is: IF ( AGG_LEVEL( ‘9AMATNR’ ) = 1 ) DRILL_DOWN( ‘9AMATNR’ ; ‘internal’ )<\/p>\n

\"Material<\/a><\/p>\n

Macro “Drill down to Location level”<\/h2>\n

The basic idea is the same as for material : IF ( AGG_LEVEL( ‘9ALOCNO’ ) = 1 ) DRILL_DOWN( ‘9ALOCNO’ ; ‘internal’ )<\/p>\n

\"Location<\/a><\/p>\n

Collective macro “Multiple: Calculation”<\/h2>\n

The collective macro executes the “sub-macros” in the list sequentially:<\/p>\n

    \n
  1. Drill down to Material level<\/li>\n
  2. Drill down to Location level<\/li>\n
  3. Computation macro<\/li>\n<\/ol>\n

    \"Collective<\/a><\/p>\n

    Planning book output<\/h2>\n

    In the planning book (\/SAPAPO\/SDP94) it’s now visible that each key figure row is split into several rows:<\/p>\n