How to handle select-options condition in HANA? or how to convert string to a table? or

[Former Member]

Hi experts,

Have any experts could tell me how to handle select-options condition in HANA script? I'm working on HANA Pushdown project, and need to convert the ABAP statement to HANA script. In a ABAP statement we can use select-options/ranges in the opensql. But in HANA we can't use like this.

So far, I want to convert the select-options/ranges to a table, than JOIN this table in HANA script. In ABAP there is a function module to convert select-options/ranges to string, but I don't know how to convert string to table again in HANA.

or is there have any other solution for this kind of questions.

Thanks,

Leo

[Former Member]

Hi,

The select clause specifies an output to be returned either to the caller or to an outer select clause if one exists.

http://help.sap.com/hana/html/_csql_data_types.html

http://scn.sap.com/thread/3300583

Regards

NK

[yeushengteo]

Hi Leo,

If you can used temporary table to keep the selection-options records, you can use the tempoary table in the scrips by the SQL 'IN' syntax?

Regards.

YS