Differences in the Data Flow

Using SAP List Viewer with IDA on an in-memory database, compared with using SAP List Viewer on a conventional database, leads to considerable improvement in performance and reduced memory consumption at the same time. These advantages are the result of the various architectural solutions, which are described below:

Data Flow Process with SAP List Viewer

Data Flow Standard ALV

  • All data is transferred from the database to the application server in an internal ABAP table.
  • The application completes the business logic and UI info fields and fills the contents of the whole table. It is not possible to fill the data only for the visible area.
  • This table is then passed as a reference to the ALV, and the ALV services operate directly on this table (no copy is made). This means that the table is also resorted directly. The ALV filter only saves the indexes of the data to be displayed, it does not reduce the size of the table.
  • The data in the visible area is sent in external format to the front end.

Data Flow Process with SAP List Viewer with IDA

Data Flow ALV with HANA

  • All intensive computational and data filtering operations have already been performed on the database.
  • On the application server the internal table (which in this case is an integral component of ALV) is filled with the visible area.
  • The application can use the calculated fields (see List Fields) to add UI information and locally-restricted business logic.
  • The data in the visible area is sent in external format to the front end.