on 05-14-2007 2:04 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 wont 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
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.