CODEWITHSUNDEEP
abapopensql
guettli
guettli

Reputation: 27997

SELECT FROM @itab causes syntax error. Why?

I try to use SELECT FROM @itab like explained here in SAP docs.

I have never used this feature, but think this is great. You can query a internal data structure which just exists in the RAM of the interpreter like it would be a real table in the database. I am impressed.

Here is the ABAP code:

data: lt_get_auth_values TYPE STANDARD TABLE OF US335.

CALL FUNCTION 'GET_AUTH_VALUES'
     EXPORTING
            OBJECT1 = 'Z:FOO'
            USER    = sy-uname
     TABLES
            VALUES  = lt_get_auth_values.

SELECT highval from @lt_get_auth_values as mytab WHERE field = 'WERKS' 
        INTO TABLE @DATA(static_perm_filter_fields).

I can't active the function because "from @lt_get_auth_values" is a syntax error according to my system.

What's wrong with this line?

SAP Version: 740 (sorry, it first I thought it was 752)

Upvotes: 2

Views: 6205

Answers (1)

Sandra Rossi
Sandra Rossi

Reputation: 13656

SELECT ... FROM @itab appeared in 7.52 so it should work.

On my 7.52 system it works but you must indicate a table alias. There's an example in the ABAP documentation (cf first link above).

Upvotes: 5

Related Questions