Steps by step to query user with certain plants using Business Explorer.
In organizational level, plant value is actually an object field called "WERKS"
- Launch Business Explorer
- Select user master data with authorization
- Enter username and execute. Results will be displayed is the excel sheet.
- Right click on a cell > Add Drilldown According to > Field Name
- Now filter again. Right click > Add Drilldown according to > Authoriz. value low
Keep filtered value
- Congratulation! You have listed only plant company code for the user