Macro which uses table data via functional module

[Former Member]

Hello,

I am not very experienced with macros but now I have following required functionality:

I should implement a macro which uses the data of a table. I am not sure how to realize this, ABAP coding will be required.

Am I right that I have to create a separate function module in se37 where I realize the coding?

Can you give me a short coding (fragment) example how to get values of a table via ABAP coding in a function module used in a macro, please? This will be a huge assistance for me to get the first steps of this implementation requirement....

For information, my requirement is as follows:

A table is maintained for every month with a correction factor, for example:

 

year     month      factor

 

2012      may          1.6

2012      june           0.8

2012      july            1.2

Now, the macro will go through the buckets of a planning book and the bucket values will be multiplied with the specified factors in the tabel. So, with the function module I should figure out the factor for the corresponding buckets in the planning book.

Hope, you can give some suggestions - as always.

Thanks and kind regards

Heinz

[former_member187488]

Hello,

Since the 'factor' is based on time, why don't you put it into a time series key figure in the planning book? Then your purpose will be easily acheived by a very simple macro.

If you don't want users to see the 'factor' key figure, you can just hide it in planning book design.

If you really want to use user-exit macro, please refer to the below document:

http://help.sap.com/saphelp_scm70/helpdata/EN/0c/326539e02fdc7ee10000000a114027/content.htm

Best Regards,

Ada