topic Re: Hanatize Ranges in Application Development and Automation Discussions

Hanatize Ranges

Former Member — Tue, 23 Mar 2021 07:15:10 GMT

Hi Experts,

Is it possible to get the result in select statement without using the loop. As hana db is more powerful now, wondering if these kind of statements can be achieved at DB level rather than application server.

  SELECT ebeln
     FROM ekko
     INTO TABLE @lt_ebeln
     WHERE ebeln = '<demo_value>'.

  LOOP AT lt_ebeln INTO ls_ebeln.
    CLEAR ls_range.
    ls_range-sign   = 'I'.
    ls_range-option = 'EQ'.
    ls_range-low    = ls_ebeln-ebeln.
    APPEND ls_range TO gt_ebeln.
    CLEAR ls_ebeln.
  ENDLOOP.

Re: Hanatize Ranges

ziolkowskib — Tue, 23 Mar 2021 07:24:43 GMT

Hi april.
Based on your example it might look like the following:

DATA lr_ebeln TYPE RANGE OF ekko-ebeln.

SELECT 'I', 'EQ', ebeln
  FROM ekko
  INTO TABLE @lr_ebeln[].

Regards,
Bartosz

Re: Hanatize Ranges

matt — Tue, 23 Mar 2021 07:38:58 GMT

No need for the []. There's no ambiguity. Ranges do not have a header line.

You could also use:

SELECT 'I' AS sign, 'EQ' AS option, vbeln AS low, @space AS high
  FROM vbak
  INTO TABLE @DATA(range_of_document_numbers).

Re: Hanatize Ranges

joltdx — Tue, 23 Mar 2021 07:50:38 GMT

There are answers below already for how to do what you ask. But what will you be using your gt_ebeln for?

Both with and without HANA there is also the possibility to join tables in one select instead of making two (ore more) selects where the first one is only used to get the keys for the WHERE clause of the second one...

Re: Hanatize Ranges

Former Member — Tue, 23 Mar 2021 08:12:42 GMT

Thanks Bartosz and Matthew for the inputs. It is very helpful.

Re: Hanatize Ranges

matt — Tue, 23 Mar 2021 10:24:46 GMT

Also possible in non-HANA system. It just needs a high enough ABAP stack.