VALUE Operator in SQL Statement

[former_member1305611]

Hi,

I have the following SQL statement and was wondering if it is possible to rewrite it using the VALUE operator to avoid the DATA statement.

DATA(lv_initial) = VALUE /scwm/guid_hu( ).
SELECT * FROM /scwm/tu_dlv 
      WHERE lgnum     = @lv_lgnum
        AND top_hu    = @lv_initial
      INTO TABLE @DATA(lt).

I.e., I would like to have something like:

SELECT * FROM /scwm/tu_dlv
      WHERE lgnum     = @lv_lgnum
        AND top_hu    = @VALUE #( )
      INTO TABLE @DATA(lt).

Is this possible? Any suggestions?

[fabianlupa]

On 7.50 this should work:

SELECT * FROM /scwm/tu_dlv
  WHERE lgnum  = @lv_lgnum
    AND top_hu = @( VALUE #( ) )
  INTO TABLE @DATA(lt).

[retired_member]

Correct ...

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenopen_sql_host_...

[former_member1305611]

Thank you both! I was not aware of this. Unfortunately, I am working on release 7.40 at the moment, but at least I can stop searching now.