In-memory optimized ALV

[Gairik]

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

[yeushengteo]

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.

YS

[Gairik]

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

[yeushengteo]

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.

YS

[ashish_bansal]

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