A Primer for ALV Display with Integrated Data Access for SAP HANA

  • by Rehan Zaidi, Senior SAP Technical Consultant
  • October 16, 2017
Learn about the basics and advantages of the Integrated Data Access version of the ABAP List Viewer and the steps required to create simple reports using the standard classes provided for this purpose. See how to access the field catalog and functions and how to specify sort and grouping criteria for your report output.
Learning Objectives

Reading this article, you will learn:

  • The advantages of the Integrated Data Access (IDA) version of the ABAP List Viewer (ALV)
  • The steps required to create a program using ALV with IDA
  • How to access a field catalog and hide certain fields of a table
  • The steps to sort fields and create field groupings
  • The code to disable standard ALV toolbar buttons
  • How to generate ALV output from Core Data Services (CDS) views  
Key Concept

ABAP List Viewer (ALV) Integrated Data Access (IDA) is a new and improved version of the traditional ABAP ALV. It is optimized for the SAP HANA database. It has the same look and feel for users, and it is easy to use without any additional training.

With ABAP 740, SAP provides a new, improved, and faster form of the ABAP List Viewer (ALV). This is known as the Integrated Data Access (IDA) version of ALV. Due to its numerous advantages, including fast performance, memory consumption optimization, and compactness of code and effort on the part of the developer, it is a must-learn topic for ABAP developers today.

I start with an overview of IDA as it pertains to the ALV display and the advantages it provides. I cover the details of the class CL_SALV_GUI_TABLE_IDA in detail and the useful methods it offers. Next, I cover the main steps involved in creating the IDA ALV display, along with the concept of IDA ALV field catalogs. You will see how to enable various functions for the IDA ALV, as well as how to create an ALV via Core Data Services (CDS) views.

Throughout the article, there are fully working coding examples. The examples and screenprints are from an SAP NetWeaver 7.50 system. The coding shown in this article works regardless of whether the underlying database is SAP HANA. For ALV in IDA, both full-screen and container display are possible. However, the emphasis of this article is on full-screen display.

Rehan Zaidi

Rehan Zaidi is a consultant for several international SAP clients (both on-site and remotely) on a wide range of SAP technical and functional requirements, and also provides writing and documentation services for their SAP- and ABAP-related products. He started working with SAP in 1999 and writing about his experiences in 2001. Rehan has written several articles for both SAP Professional Journal and HR Expert, and also has a number of popular SAP- and ABAP-related books to his credit.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.