Category: ALV

new ALV concept IDA with HANA as secondary database

Discovering IDA recently i like the new interface of ALV with HANA support, however i faced many issues. Day by day i have overcome this issues and now want to share a few of my experiences. Firstly IDA is so fast that it directly reflects HANA experience. Moreoever it provides paging mechanism which divides database load into small pieces .And finally i can summarize that IDA is very useful when you have a CDS view or database view with restricted number of fields to display. Since HANA is column based you have to decrease the number of columns that you request from HANA server.

export spool list with many pages in SM37

When you call a list screen your report generates a downloadable report after execution. This report seems as a spool list if you run your program in background. There are two ways to generate a list screen. First one is using WRITE command and the second one is using REUSE_ALV_GRID_DISPLAY which serves to output internal table as an ALV list.