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.
Strangely excel upload functions like TEXT_CONVERT_XLS_TO_SAP, ALSM_EXCEL_TO_INTERNAL_TABLE, KCD_EXCEL_OLE_TO_INT_CONVERT are not existing in CRM systems. Hence in order to upload excel files into CRM SAP system i had to use GUI_UPLOAD or CL_GUI_FRONTEND_SERVICES methods.