topic Re: In-memory optimized ALV in Application Development and Automation Discussions

In-memory optimized ALV

Gairik — Thu, 11 Apr 2013 15:47:41 GMT

Hi HANA Experts

I have started working on ECC on HANA and now checking the various options for In-memory optimized ALV . I have 2 questions on the same

1. Is it possible to pass any "External View" name in the parameter "iv_table_name" ? If yes, please confirm whether this is also true for those external views which are based on "Analytic View" in HANA

2 If I'm processing the data in a HANA database procedure , is there any possibility to use the procedure data ( may be output parameter ) in the in-memory optimized ALV without sending it back to application server ?

Regards

Gairik

Re: In-memory optimized ALV

yeushengteo — Tue, 16 Apr 2013 08:54:19 GMT

Hi,

1. Yes. An External View can be consumed like other tables or views in ALV.

2. Not sure what you mean the procedure to process the data. Where is the procedure being called?

Regards.

Re: In-memory optimized ALV

Gairik — Tue, 16 Apr 2013 17:54:49 GMT

Hi Yeu Sheng

Thanks for the point 1.

Regarding point 2, I'm using a hana procedure to process,aggregate and calculate the final data and then calling this procedure using CALL DATABASE PROCEDURE command from ABAP. Then , I 'm displaying the data returned by the procedure in an ALV report . Please make a note that the returned table of the procedure is just an internal table. Now, how can I display this returned table using in-memory optimized ALV .

Regards

Gairik

Re: In-memory optimized ALV

yeushengteo — Wed, 17 Apr 2013 10:20:51 GMT

Hi Gairik,

I believe using an internal table is not possible since the class import parameter is looking for a real table/view.

Anyway, the ALV on HANA introduction is to use HANA DB as much as possible without the need for internal table anymore. As such, is it possible for you to build a scripted calculation view including your logic into the view directly.

Subsequently, you can have an external view just like point 1 and it should be sufficient?

Regards.

Re: In-memory optimized ALV

ashish_bansal — Thu, 08 Aug 2013 15:31:32 GMT

Hi,

I tried to use the External view and consumed it in the HANA ALV succesfully but the field names are not filled automatically from the data element type of the fields. I found from the HANA ALV wiki that we have to set the fields manually using set_field_header_texts for currency and UOM but for other fields it should come directly from the data element type. Could you please help me in finding why this is not working. Thanks.

Regards,

Ashish