Skip to Content
Author's profile photo Former Member

CDS ALV report in seconds with 7.5 SP 03

This quick ALV report development will show 1) performance use case of HANA / CDS as a development tool, and 2) usability of ABAP CDS annotations.

Typically data restrictions must be used to limit the amount of records selected from database, for example with large FI document header table BKPF. Using CDS as development tool for performance purposes, we can circumvent typical data selection limitations, i.e. returning >7.5M records in less than one second in this case. Furthermore, the ABAP CDS annotation quickInfo text from CDS view definition flows to ALV output with no coding required.

Consider CDS for any future reporting purposes with large datasets because annotations show in ALV output without any coding required. All development resides in CDS view definition itself.

Create CDS view from ADT using folder Core Data Services, right-click to create New -> DDL Source

Create wrapper program which leverages standard SAP class CL_SALV_GUI_TABLE_IDA

CDS view on HANA DB quickly displays 2M threshold of >7.5M total BKPF records including the custom ABAP CDS annotations

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Joachim Rees
      Joachim Rees

      Yeah, CL_SALV_GUI_TABLE_IDA seems pretty cool!

      I haven't tried it yet, but plan to do so!




      Author's profile photo ricky luo
      ricky luo

      THx.I wonder can I use it on CDS view with parameter?

      Author's profile photo Abraham Bachar
      Abraham Bachar


      if I need to pass a parameter from a select option on the selection screen, How I can parse the parameter to be evaluated for the CDS view based on your code?

      without the long way through the CDS Table function and Call AMDP methods in the Program likeĀ

      Maybe something else knows a better way,

      Thanks in advance.