Hanatize Ranges

[former_member737178]

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.

[former_member737178]

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

[ziolkowskib]

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

[matt]

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).

[former_member737178]

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

[matt]

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

[joltdx]

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...