Skip to Content

Doubt with BEx Query

Nov 09, 2017 at 03:30 PM


avatar image

Hi guys,

I have a doubt. I have a summary query that shows 593 records:

Then if I add new sample fields to that query, the 593 records are kept. Particularly the ratio is added ZKOFPRJPC=ProjectPercentComple.

Finally, if I remove the ratio rowcount from the previous query, it does not return data:

Is it because the ratio ZKOFPRJPC=ProjectPercentComple has no values? Is it wrong SAP behavior?

Thank you for your help :)

Kind Regards


bex1.png (63.2 kB)
bex2.png (100.9 kB)
bex3.png (92.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Nov 16, 2017 at 08:31 AM

if the remaining KF has no values <empty>, the query will not return data. this is standard SAP behavior because the query shows Transactional data with Master Data as a left outer join, if the KF retrieve zero's, it will show those zero's, but empty is empty

10 |10000 characters needed characters left characters exceeded