ABAP SQL DISTINCT

 

"Using the DISTINCT addition

SELECT DISTINCT cityfrom

  FROM zdemo_abap_flsch

  WHERE carrid = 'LH' AND

        cityto = 'NEW YORK'

  INTO TABLE @DATA(itab_distinct).

"Not using the DISTINCT addition

SELECT cityfrom

  FROM zdemo_abap_flsch

  WHERE carrid = 'LH' AND

        cityto = 'NEW YORK'

  INTO TABLE @DATA(itab_no_distinct).

Serkan AKKAVAK

Computer Engineer BSc

Head of SAP & Software Department

Contact : serkurumsal@yandex.com