topic VALUE Operator in SQL Statement in Application Development and Automation Discussions

VALUE Operator in SQL Statement

former_member1305611 — Thu, 22 Jun 2017 12:33:50 GMT

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?

Re: VALUE Operator in SQL Statement

fabianlupa — Thu, 22 Jun 2017 13:03:02 GMT

On 7.50 this should work:

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

Re: VALUE Operator in SQL Statement

retired_member — Thu, 22 Jun 2017 19:15:37 GMT

Correct ...

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

Re: VALUE Operator in SQL Statement

former_member1305611 — Fri, 30 Jun 2017 18:33:14 GMT

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.