cancel
Showing results for 
Search instead for 
Did you mean: 

Table name for Macro

Former Member
0 Kudos

Hello,

Please let me know in which table can I find the author for the macro.

I have macro description, planning book and data view.

Thanks,

Siva.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The table- /sapapo/advm should contain the list of macros with the author name

This table has the GUID for planning book and data view

So use the table- /sapapo/pbmadvm which lists the GUID to name of the planning book and data views.

Write a quick query to join these 2 and you should be all set.

Hope this helps..

Regards

Kumar

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Vikas,

Thanks for your reply.

But my query is to find out the Author for the macro. So Please let me know where can I get the information abt the developer name.

Regards,

Siva.

Former Member
0 Kudos

To get header info as in transaction code /SAPAPO/ADVM, youll get that via the table named the same way /SAPAPO/ADVM. Youd find there Macro description /SAPAPO/ADVM-MTEXT, planning book as /SAPAPO/ADVM-SDP_BOOK and data view as /SAPAPO/ADVM-SDP_VIEW.  Created by, on and time as well as Changed by, on and time are there.

If you need macro details as in the steps etc, make a join for /SAPAPO/AMAKR_TX with either /sapapo/advm or /sapapo/PBMADVM

Former Member
0 Kudos

Hello Kumar,

Under a Planning Book and Data View I have around 20 macros under it. But the query returns me a single record. Please let me know how to get the details of all the 20 macros under the planning book.

Thanks,

Siva.

Former Member
0 Kudos

Hi Siva,

Getting macro list from SAP APO

Go to transaction SE16.

1) Enter the table /SAPAPO/AMAKR_TX .Copy Contents to excel

2) Come back to SE16, enter table /SAPAPO/PBMADVM, copy the contents of both tables to excel.

The first table won’t give Planning book in readable form, it gives GUID.

Now the 2nd table will give both GUID and reference.

By doing a lookup, you can get the list of Macros.

In the first table, select columns which are blank for Step

Regards,

Vikas