SAP Knowledge Base Article - Public

2980955 - Web Service Query Returns Incorrect Number of Records


You are using a webservice to query business objects from the system via SOAP. Although the query is executed successfully, the amount or records brought by the query is not the same as the number of objects in the system.


SAP Business ByDesign

Reproducing the Issue

  1. Go to Application and User Management work center.
  2. Enter the Communication Arrangement view.
  3. Click on the communication scenario name hyperlink.
  4. Select the relevant query from the Included Operations section.
  5. Click on the Download WSDL button to save the file.
  6. Open your SOAP client (such as SOAP UI).
  7. Create a new SOAP project and import the downloaded WSDL.
  8. Open the project and search for the required query (for example, FindByIdentification).
  9. Fulfill the XML payload with the request needed.
  10. Enter the user credentials in the SOAP project.
  11. Execute the request.


By default, the standard webservice queries in Business ByDesign restricts the results to 100.


You can set the property QueryHitsUnlimitedIndicator to true in the XML payload. You can also set property QueryHitsMaximumNumberValue to a high number in order to accommodate all the existing records.

Both fields can be found in the ProcessingConditions section of the query web service XML request. This way the webservice should return the desired number of records.


Queryemployeein, Web Service, Processing Conditions, , KBA , SRD-MD-BP , Business Partner , How To


SAP Business ByDesign all versions