Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 

In this document, we will see about QUERY_VIEW_DATA webservice and the methods and input and output parameters required for this Web service. Also the testing procedure will be explained.

Web Service for Accessing Query Data:

Please note the tables and information here are taken from

QUERY_VIEW_DATA webervice is mainly used to extract the data from the result set for a query or query view in XML format. The Web service has to be released with the SAP Web Service Infrastructure.

In the following table, the methods and input and output parameters required for the Web service are shown:




This method serves to request the query or query view data.

Input Parameter





Parameter (optional)

To specify the query use the parameters InfoProvider and Query. To specify the query view, use the parameter ViewId.

The Parameter parameter allows you to set Data Provider Commands  from the Web API reference (for example, filters or setting a navigation status) as a name/value pair.

Output Parameter






You will find a detailed description of the output parameters under

Datasets - SAP Business Information Warehouse - SAP Library

Definition of  Output Parameter


The component AXIS_DATA describes the contents of the axis. AXIS_DATA is a table with the following structure:

0 : Columns
1 : Rows
255 : Filters
SETAxis contents


This component describes the properties of the structures, characteristics, and attributes, and how they are distributed between the axes. The AXIS_INFO is a table of axes (rows, columns, and filters) with the appropriate axes components.

0 : Columns
1 : Rows
255 : Filters
NCHARSValue cells
The cells are arranged by row first, and then by column.
NCOORDSNumber of objects on the axis (number of rows / columns / filter values)
CHARSCharacteristics with their attributes and structures on the axis.


The CELL_DATA component describes the value cells.

The number cells of the query view are given as the assigned table of rows for BAPI type BAPI6111CD. If you display the query view data as a table, the assignment of cells corresponds to that of the data block, in which the assignment is run first using the rows and then using the columns.

The index of a specific value is therefore calculated as follows:

Index = Column position + (row position – 1)* number of columns


The component TXT_SYMBOLS describes the text elements of the query. The text elements are available as a table made up of RRX_TXT_SYMBOLS rows.

Scenario :

We will see how to execute the webservice in internally in BW system and will see how the data is being fetched from the query or query view.

1. Go to the tcode SOAMANAGER and select the tab Business Administration.

2. Click on Web Service Administration and search for QUERY_VIEW_DATA webservice.

3. Select the werbservice QUERY_VIEW_DATA and click on Apply Selection button. Now it will show the properties of the webservice. Select the option "Open WSDL document for selected binding"

4. Login to the system and click on queryviewdata webservice navigator.

5. Here we need to enter the appropriate inputs to request the data from the qweu view data webservice. Below the sample input request.



  <Infoprovider>ZZ_SAMPLE_INFOCUBE</Infoprovider> ** Enter the info provider name which is the source of the query



      <Name>FILTER_IOBJNM_1</Name> ** Enter the info object name which would be the filter for the query to restrict the values.




      <Name>FILTER_VALUE_LOW_1</Name> ** From and To range for the mentioned info object








  <Query>ZZ_SAMPLE_QUERY</Query> ** Technical name of the query


6. After clicking on SEND button the input values will be passed to the query and data will be extracted. You can be able to see the response the right side.

7. Data will be stored in the pre defined output parameters as discussed above. We can view and check the data quality be checking inside the parameters Axis Data, Axis Info, Cell Data and Text Symbols. In the output parameters, column values will be stored under the axis 0, and row values will be stored under 1. What ever filter used to restrict the query results would be visible under the axis 255.

Hope this document will be useful.



1 Comment
Labels in this area