on 09-06-2011 8:20 AM
Hi Experts,
I created my own Planning Book and Dataview in SNP with 3 Key Figures: KF1, KF2, KF3. Now I want to create one my own button with Macro so that when I press that button, the Macro will run to calculate: KF3 = KF1 + KF2.
I know that I can drag this Macro to one of default events like: Default, Level Change, Start. But actually, I want to create my own button so that I can handle the event as I want.
My question are:
1. How to create a custom button on the toolbar of SNP Planning book and writing macro for the button?
2. Please give me any document, material teaching about writing macro and relating to my above scenario.
Thanks very much!
Duyennx
Edited by: xuanduyen on Sep 6, 2011 9:20 AM
Hi,
You can assign any Push button for the created macro. This can be done by right click your macro name from the Macro builder. Select 'Properties'. In the popup, next to Assigned push button field, click 'Choose' button. This will display the available push buttons. Select the required one. Save the macro. Now go to your planning book. You can see the Push button with the Macro name as the 'tool tip'.
For more information on writing macros, and various macro functions, please refer the below link,
http://help.sap.com/saphelp_scm70/helpdata/en/0c/326539e02fdc7ee10000000a114027/frameset.htm
Regards,
Manimaran M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Access the transaction "/n/sapapo/advm". In the list select your planning book/ data view and click 'Start Macro Builder' button.
In the Macro builder screen, drag and drop your macro from Macro depot to the work area.
Right click on your macro name and select 'properties'. In the pop up, next to the Assigned Push button field, there is a button 'Choose'. Click that. It will display all the available icons. In standard system, it displays more than 1000 icon. Choose any one icon which is suitable for your macro function. Close the pop up and save the macro. This will assign a push button to your macro.
In the Planning book tool bar, you can see the selected icon in the header tool bar. Just by clicking that icon, you can execute the macro interactively.
And I don't know whether we can include/design our own icon. But there are already 1000+ standard icons to choose.
Regards,
Manimaran M.
Dear Mr. Manimaran,
I had tested and received result after your first answer.
In the last post, I only asked whether or not we can add our own button and where to design.
Thanks very much for your answers. They are very helpful for me.
Is there any Expert having the solution for adding our own button? Please help me.
Thanks and Best Regards,
Duyennx
Edited by: xuanduyen on Sep 9, 2011 4:56 AM
Hello,
the proper answer has already been given. You have to use the APO DP macro Builder in order to define your own macro. The calculation of the sum of three key figures is quite simple.
The link to the related SAP help topic has been given too.
Regards
Martin
Edited by: Martin Renardy on Sep 9, 2011 3:45 PM
User | Count |
---|---|
7 | |
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.