In app "Custom CDS Views" is it possible to preview more than 101 entries?

[MarioFranco]

Hello

In app "Custom CDS Views", in the preview option you can see a maximun of 101 entries. ¿is it possible to view all the CDS entries?

If not, there is some way for viewing the entries of a CDS?

Regards

Custom CDS Views

[Amith_Nair · Accepted solution]

Hi Mario,

To Jerome's point, you're building a custom Analytical Query on top of existing custom CDS view that you already created. While doing so, you did not find the data source for the CDS view you created, is this what you encountered?

Make sure, you mark 'Analytical' option while building your Custom CDS view, only then you will find your custom CDS view in the available data source while creating a query.

In addition, please make a note of these links while creating custom Analytical Queries. Very handy information.

https://launchpad.support.sap.com/#/notes/2657021

https://launchpad.support.sap.com/#/notes/2628104

Good Luck!

Amith Nair

[MartyMcCormick]

Hi Mario

Unfortunately not. I would second Jeroen comments or you could expose as API or if it is an API you can use Postman to view dataset after exposing via Comm Arrangement.

Often, what I'll do is use the filter capability on the CDS view to restrict my dataset down to what I want to see (i.e. by a date, customer, project, etc). Then you have 100 rows of data that you potentially want to see versus random 100.

Thanks,

Marty

[JZijderveld]

Hi,

You can create a custom analytical query based on the CDS and put in all the fields. That allows a max of 10.000 records.

regards,

Jeroen

[MarioFranco]

Hi,

At creating a custom analytical query I can't set as data source the CDS I want. Not all CDS are available as data source for a Customer analytical query.

Regards