Skip to Content
Nov 03, 2017 at 08:59 AM

ABAP CDS View in RSRT: Filter on Master Data empty


Hello colleagues,

we have a ABAP CDS View Query which should later be consumed in analytical Fiori Apps (Query Browser). We are on S/4 Hana 1610 (NW 751 SP01).

In this query we populate data from SAP Tables like: PRPS (Projects), PA0002 (HR), an catsdb.

The problem is that the query does not recognize the master data from these tables.
This results in empty search helps - See Screenshot from RSRT:

In this case the Projects from table PRPS should be displayed in the search help.


The query view selects from a Cube, which selects from basic views and database tables. I tried a lot of things but did not find a solution. I think that the solution is connected with the @ObjectModel.foreignkey and @ObjectModel.text.element annotations.

Question: How needs the basic view to be coded to get Master Data in Query?

Example from the Basic View:

What needs to be done to populate master data in CDS Queries?

Thank you very much!

kind regards,


rsrt-cds.png (14.5 kB)
basicview.png (30.0 kB)