Steps by step to query user with certain plants using Business Explorer.

Steps by step to query user with certain plants using Business Explorer.
In organizational level, plant value is actually an object field called "WERKS"


Guide:




  1. Launch Business Explorer
    0010-bussexplorer-001



  2. Select user master data with authorization
    0010-bussexplorer-002



  3. Enter username and execute. Results will be displayed is the excel sheet.
    0010-bussexplorer-003



  4. Right click on a cell > Add Drilldown According to > Field Name
    0010-bussexplorer-004


  5. Now filter again. Right click > Add Drilldown according to > Authoriz. value low
    0010-bussexplorer-005




  6. Keep filtered value
    0010-bussexplorer-006


  7. Congratulation! You have listed only plant company code for the user
    0010-bussexplorer-007

Popular posts from this blog

HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC

Step by step to create new job using SM36

HOW TO SAP - SAP Web dispatcher Installation