Skip to Content
Nov 04, 2019 at 02:03 PM

Analytical Table and custom OData Service

209 Views Last edit Nov 04, 2019 at 02:11 PM 2 rev

Hi all,

I'm trying to implement a Smart Analytical Table with the use of OData Services. I understand what needs to be done on the frontend side (it's a custom Fiori App) and what annotations should be in place.

The only thing that confuses me is the backend implementation. I know that the service can be prepared using SADL framework, but I need to include a complex custom logic behind that. I have a lot of table relations and non-trival filter logic.

Is it possible to write non-SADL OData Service with the custom ABAP implementation for analytical purposes? SADL is handling a lot of things like aggregations, generated ids, etc. I'm not sure what's the best approach in such a case.

I need to provide a complex analytical table with nested groups, sums and also complex filtering. What are your experiences? What is your recommendation upon this Analytical Table?