topic user function marco in Application Development and Automation Discussions

user function marco

Former Member — Wed, 17 Sep 2008 14:37:41 GMT

Hi!

I'm facing a problem with a user function in a marco.

I have my macro, I've defined my function module but I don't how how to save data in my planning book from the function.

I would like to fill in a specific key figure in my plannig book (so that users see a specific, calculated value).

But I don't know how I should pass this from within my function module to my planning book.

I can go into debug, and I see my selections an stuff but don't know how to continue.

Thanks a lot

Caroline,

Re: user function marco

ThomasZloch — Wed, 17 Sep 2008 14:45:43 GMT

Only from past experience I think I know that this relates to PP module? Sales & operation planning?

If you don't find an answer here, check in as well (if I'm not completely mistaken).

Thomas

Re: user function marco

Former Member — Thu, 18 Sep 2008 05:36:20 GMT

Ok, I will have a look.

Thanks,

Re: user function marco

Former Member — Tue, 21 Jul 2009 15:58:48 GMT

I am sure you have figured this out by now, but I was just trying to figure out user functions in macros myself, and have the answer for any others...

When you define a function as User Function in the Macro Workbench, the large parameter screen which appears has certain parameters forced on you - value_tab, f_argument and f_calc_error. Value_tab will contain all the parameters which you pass to the function, and f_argument (you have to select whether it is a value or a string) will contain the value you want to pass back to the macro (i.e. a value in this case).

a) your function interface needs to have these 3 changing/table parameters with the same names and types

b) at the end of the function, set f_argument to the result of the calculation

Thats it.

Edited by: Jason Calcutt on Jul 21, 2009 5:59 PM