Use of CDS table function without parameters

[raveeshsaurabh73]

Hi Gurus,

We are planning to use the ABAP CDS table function to do the data modeling for one of our requirements, but we can not add any parameters to it(except client field) as all of our selection criteria fields are optional.

Will it cause any performance issue, as we may need to fetch all the data(may be restricted to document type and sales orgs etc. in the code), process and display?

I am asking this because we have observed that during debugging when the control is in the table function code, we don't have the filters available. It fetches all the data irrespective of applied filter in the select query, and when the data is passed back to ABAP layer, then the required filters are applied and respective data is returned back. 

If this may cause performance issues, then what should be correct approach if using CDS views(due to complexity) and AMDP Procedure(service has to be used in FE App) is not possible?

Thanks in Advance

Warm Regards

Raveesh