Skip to Content
Author's profile photo Former Member

No Applicable Data in Queries

Hi All,

Recently i reported no applicable data issue in BeX Reports we were facing on discussions here .

The issue was irrespective of below possible scenarios that could actually transpire

1) Insufficient data foe query selections

2)Insufficient Authorization

3)Data unavailability for reporting due to roll up or  BWA issues

4)Query filters etc…

When we deep dived we established that the issue was actually happening due to inconsistent multiprovider buffer .

So we decided to switch off the buffer and tested it widley across some queries.

With buffer switched off/no buffer the queries worked fine and we were able to get data in report output.

For switching off buffer go to table RRKMULTIPROVHINT and flag the column “Do Not Buffer”  with “X” meaning no buffer to be used for multiproviders.

For permanently fixing inconsistent multiprovider buffer issue see/apply SAP Note 1970017



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Phani KV
      Phani KV

      Nice experience thanks for sharing.



      Author's profile photo Former Member
      Former Member

      Hi Nayab,

      Nice one... Thanks for Sharing 🙂