Skip to Content
avatar image
Former Member

Macro to restrict the users to adjust keyfigure in planning book


My Planning book is using by all the managers, where i need to restrict a keyfigure to enter manually for few users.

Only for 3 users the keyfigure has to open, when they are in planning book, and all other users should not have any access to enter manually any voulmes in the planning book.

i tried framing a macro, but not successfull.

Is it really Macro required to make this? or any other way that we can make this?

if it is a macro can u brief,me how to proceed for the macro.

Thanks in Advance

Arun R Y

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 04, 2008 at 12:50 PM

    Hi Arun,

    The best way is to create different roles for your users. The C_APO_IOBJ authorization object defines the permitted activities.



    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 02:01 PM

    Best is to create a copy of the planning book / data view combination.

    Make the keyfigures for one set of planning book / data view non-editable and for the other make the keyfigures editable.

    Assign the two types of end users to the according planning book.

    This can be maintained through security (role has specific planning books is accessible).

    Hope this helps.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I know this is not the forum for this question.

      There are APO alerts that use APO transaction /SAPAPO/AMON1 - Alert Monitor.

      Can this alert monitor be configured to show up in the universal worklist (UWL) in the portal?

      if so would these alerts show up in the alert inbox of the uwl just as other sap ECC alerts do?

      (the other alerts i speak of are those referenced here (

      Or are these alerts two totally different types of SAP functionality with the same name (ALERT) ?


      Ted Smith

  • avatar image
    Former Member
    Sep 05, 2008 at 07:29 AM

    Hi Arun.

    An alternative approach could be to use the USER macro function to control the availability of the key figure.


    USER( <NAME1> ) = 1


    USER( <NAME2> ) = 1

    <key figure>

    ROW_INPUT( 0 )


    <key figure>

    ROW_INPUT( 1 )


    of course the hassle with this approach would be that changes to the restricted users require updates to the macro, whereas the other approach of separate data views would be managed by user profiles.

    Hope this helps.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 10:40 AM

    {Macro Name} User Specific Macro

    {Control Statement} IF

    User = Shireen

    {Operator/function} USER( 'shireen' ) = 1

    User Restriction - Shireen :(36 Iterations : M 09/2006; M 08/2009)

    Row: History ( Attributes ) = {Operator/function} ROW_INPUT( 0 ) Row: Statistical Forecast ( Attributes ) =

    {Operator/function} ROW_INPUT( 1 )

    The details within {} are the Macro functions used to define every row of macro, which would be easy for you to create it again.

    Here I am restricting the user SHIREEN to only edit Row: Statastical Forecast & Row: History is read only for him for a duration on 36 iterations(Months).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI All,

      Thanks for your detail answerers.

      But i have a doubt here,

      If i use name of the user how the system will come to know who is the user using the planning book?

      And is it required to give the user name or log in id of SAP server? if it is name we will be having first name and last name also so, which we can use here?

      i found a function called ACT_USER to retrieve the user? does this anyway helps me?

      Thanks for all your answers again, waiting for your reply

      ARUN R Y

  • avatar image
    Former Member
    Nov 06, 2008 at 05:57 PM

    Even the logic is same as everyone is contributed. but

    We need to open the keyfigure and write the macro to close the keyfigure.

    The reverse way is not possible.

    Thanks for your contribution

    Add comment
    10|10000 characters needed characters exceeded