Select With Internal Table

[mark_fryu]

hi,

I have to do a Select with an internal table in Inner Join, but I get this error:

This is how I build the internal table:

[Sandra_Rossi]

Please paste the code in text format, because people generally don't spend time in retyping the code to test on their system.

[raymond_giuseppi]

Could you paste the code in text, definition of lt_odv (explicit or inplicit) and the long text on the second line of error (after 'or it is a')

[turkaj · Accepted solution]

Hi,

The following coding should work. However, if you are in S/4HANA, then CDS views are recommended.

    SELECT vbeln
      INTO TABLE @DATA(lt_odv)
        FROM vbak .

    "Important to check, otherwise everything will be read.
    IF lt_odv IS NOT INITIAL.
      SELECT kunnr, land1
        INTO TABLE @DATA(lt_vbpa)
          FROM vbpa
            FOR ALL ENTRIES IN @LT_odv
              WHERE vbeln = @LT_odv-vbeln.
    ENDIF.

lt_odv is not a database table but an internal table. Hence the error message.