Skip to Content
Product Information

Query Browser

Dear SAP Friends,

Welcome to another interesting topic, in Analytical area.

In this blog will see how to design our own report Via Query Browser by using SAP delivered Analytical Queries

In 1809 standard Analytical Queries are 588 in 1909 number has increased to 753.

Introduction

The Query Browser is a Fiori application using which we can quickly and easily search, browse, and tag the analytical queries. This application displays all the analytical queries to which the user has access. We need to assign the Query Browser role to a user. (Fiori Role:- SAP_BR_EMPLOYEE)

  1. Open Query Browser App

  1. Select any Analytical Queries as per requirement which you wanted to develop a Report below are some of the Analytical Queries related to Manufacturing
  • C_MFGORDCOMPEXCSCONSMPTQRY
  • C_MFGORDEROPEXECDURNQRY
  • C_MFGORDOPERATIONSCRAPQRY

  1. Once you selected Analytical Queries in bottom click on open for Analysis, it will open in Design Studio
  2. Based on the Query we selected the selection Parameters will vary select as per your requirement
  3. Once opened in the left-hand side we can see 2 lines
  • Dimensions
  • Column + Rows

  1. Which fields we want in the report we can simply drag and drop in either column or row.
  2. I have added fields as shown below

8. As per the selection of fields will get the report

9. This report we can download to excel and change the graphical presentation

10. Above are the option to make report useful for presentation

Different type of chats

By using Action Icon in Query Bowser, Save as Tile we can directly send Mail or save as tile to save time

Directly if we select tile report will open no need to search for analytical query, drag and drop and all not required.

Also, we can choose in launchpad to which group this tile need to be added

 

Please share, Like and Comment anything else you want to share or add points.

Thanks & Regards

Ruthvik Chowdary

SME – S/4 HANA Manufacturing & Procurement

SAP Ariba P2P

 

 

7 Comments
You must be Logged on to comment or reply to a post.
  • Hi Ruthvik Chowdary,

    Really good explanation, keep sharing wonderful blogs like this in SAP Comunity.

    I have a small question, as you have selected a single Analytical query and developed a report by drag and drop. can we use more than one analytical query to do same?

     

    • Hi Lavanya,

      Small correction I designed report as per requirement not developed 😉

      in query browser we can use only one analytical query and design report if you want to combine more then one analytical query and design report means we need to take help from ABAP / UI5 Consultants to develop it

      Guess now you understood difference Design Vs Development

  • Hello Ruthvik,

    Good blog. With SAC now embedded with S/4 HANA, will Query browser become redundant. Is there an advantage of using Query browser vs SAC?

  • Hi Ruthvik

    Nice blog, thank you. We have been working on a query in the same way. However, our customer would like the ability to automate the running of this query and have it emailed out regularly. I assume that has to be a wrap around ABAP program to do that. Do you know how easy it is to call the query from within a program?

    thanks

    Jon