how to change fixed (grey) key figure with a macros?

[former_member447980]

Dear DP experts,

We are using two key figures that are being changed by different users. The first key figure is destinated and unfixed for the first user, the second one is unfixed for the second user.

The sum of these two figures should be seen by both users as fixed (not changeable) key figure.

A macros cannot fill into this key figure since it is fixed. Is there any possibility to calculate this key figure in automatic way by the system? This key figure should be filled after each user has pressed "Enter".

I would appreciate your assistenace.

[Former Member · Accepted solution]

Hi,

You can achieve this using macros.

Create a macro with the function USER() to check the user and use function ROW_INPUT() to set the key figure to set to chnageable or display.

The same time have a default macro (this works when user presses enter) that sums these two values and displays it the total key figure.

Check this link:http://help.sap.com/saphelp_scm50/helpdata/en/1d/310eb3d0ee11d4b2e40050da385632/frameset.htm

Be careful about having default macros they effect performance as they run for every action.

Alternatively can you consider giving users different views where you set the KF to be display in one and changeable in other and have the total displayed in both views.