SAP Tutorials Blog


 


SELECT FROM dbtab

  FIELDS *              "All fields

  WHERE ...

  INTO TABLE @itab.     "itab has an appropriate row type


"Alternative syntax without the FIELDS addition


SELECT comp1, comp2, comp3          "Selected set of fields

  FROM dbtab

  WHERE ...

  INTO TABLE @DATA(lv_itab).        "Internal table declared inline


"Selected set of fields, existing variable

"See the note on CORRESPONDING FIELDS OF above


SELECT FROM dbtab

  FIELDS comp1, comp2, comp3                "Selected set of fields

  WHERE ...

  INTO CORRESPONDING FIELDS OF TABLE @itab.


Serkan AKKAVAK

Computer Engineer BSc

SAP Department Manager

Contact : serkurumsal@yandex.com