Being active on a global SAP BW roll-out, I’d to find out which queries had already been created on a dataprovider (DSO, Cube, MultiProvider,….) before creating new ones.
As all roads lead to Rome, I’m herewith sharing the road I’d taken today.

  • Execute transaction RSRT
  • Within the ‘Menu bar’, select ‘Environment’ and then select ‘Query Mass Maintenance’


 

 

 

 

  • Enter the name of the dataprovider within the ‘InfoCube’ selection field
  • After the name of the dataprovider has been entered, press the ‘Check’ button
  • The result will be a list of all queries, as shown below, which have been created on the dataprovider


 

 

 

 

 

 

 

 

 

That’s it