Skip to Content
0
Oct 25, 2020 at 07:30 AM

How to achieve Windowing Functionality in S4 HANA Cloud CDS Views

99 Views

Hi,
In the CDS views I want to achieve the windowing functionality where I can rank the records in a subgroup and filter the latest record in that subgroup in S/4 HANA Cloud. This is similar to a Rank() functionality in SQL.

For reference - This blog shows the similar functionality in CDS views for on S/4 HANA on Premise. I want to achieve this same functionality in S4 Cloud.

https://blogs.sap.com/2018/11/30/delete-duplicate-entries-in-abap-cds-views-using-table-function-and-sql-window-function/

From my understanding we do not have access to write any custom code like AMDP class or table functions in S4 HANA Cloud we only have access to create CDS views through the GUI editor on web.