Skip to Content

Authorization relevant Object as a mandatory prompt Issue in sap bi -webi reporting

Hello All,

We have few Auth relevant objects in BW for example company code, plant etc.

so company code is mandatory in couple of reports and other few report it is optional .

is it SAP Best Practise to keep Company code as a Mandatory Prompt wherever it is been used a prompt (as optional prompt ) if not does it make sense to have company code mandatory in few reports and optional in other report?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 24, 2018 at 06:02 AM

    well the authorization info-object will always be active when used in query and assigned roles, whether the prompt is mandatory or optional. I guess it can be set as optional, in case a manager who is allowed to see all data just want to see data from 1 company code.

    Great document is:

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23, 2018 at 04:20 PM


    I would say restrict Company Code at BEx query level rather giving an option to select.

    Until and unless, you have same business requirement for everyone within Organization.



    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24, 2018 at 09:54 AM


    in general it does not make sense to have mandatory variables on authorization-relevant infoobjects. If users, which are authorized for all data, want to select all data in the report, the easiest way to do this is to leave the variable empty -> no selection means "select all". This would not be possible with a "mandatory" variable.

    In case you want the variable to be filled automatically with authorizations, you can use authorization-variables described in the WIKI-page:

    Please read the topics "Usage of variables filled by authorizations" and "Usage of authorization variables results in "no authorization" when multi-dimensional authorizations are assigned" in the WIKI-page, in case you decide to use authorization-variables.

    best regards,


    Add comment
    10|10000 characters needed characters exceeded

    • @Jerome -

      thanks for the reply! we have custom solution implemented, and as per the user requirement we made it as mandatory for few reports. but as per the custom solution - when user click on refresh /f4 it gets the values back from custom dso (loads from ecc based on user auth) and gets filtered the data based on the user , so the user can only see the profit centre or sales org that he has authorised to.

      Thanks again!