ABAP SQL Using the FIELDS Addition.

 

"All fields

SELECT FROM zdemo_abap_carr

  FIELDS *

  INTO TABLE @DATA(itab).

"Comma-separated list

SELECT FROM zdemo_abap_carr

  FIELDS carrid, carrname, url

  INTO TABLE @itab.

"Comma-separated list, data source explicitly specified

SELECT FROM zdemo_abap_carr

  FIELDS zdemo_abap_carr~carrid, zdemo_abap_carr~carrname, url

  INTO TABLE @itab.

"Data source explicitly specified, all fields

SELECT FROM zdemo_abap_carr

  FIELDS zdemo_abap_carr~*

  INTO TABLE @itab.

"Alias names    

SELECT FROM zdemo_abap_carr

  FIELDS carrid AS comp_a, carrname AS comp_b, url AS comp_c

  INTO TABLE @DATA(itab_comp_alias).

"Alias name also possible for the data source

SELECT FROM zdemo_abap_carr AS ds

  FIELDS ds~carrid, ds~carrname, ds~url

  INTO TABLE @DATA(itab_db_alias).

Serkan AKKAVAK

Computer Engineer BSc

Head of SAP & Software Department

Contact : serkurumsal@yandex.com