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

January 03, 2008   Authorization

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
   
   
   


2. 
   
   Select user master data with authorization
   
   
   


3. 
   
   Enter username and execute. Results will be displayed is the excel sheet.
   
   
   


4. 
   
   Right click on a cell > Add Drilldown According to > Field Name
   
   


5. 
   
   Now filter again. Right click > Add Drilldown according to > Authoriz. value low
   
   
   


6. 
   
   
   Keep filtered value
   
   


7. 
   
   Congratulation! You have listed only plant company code for the user