topic Re: SELECT DISTINCT with JOIN in Application Development and Automation Discussions

SELECT DISTINCT with JOIN

Former Member — Tue, 03 Nov 2009 21:01:16 GMT

Hi,

how Do I write this select in rigth way in ABAP

SELECT ska1_{ktopl AS ktopl ska1}saknr AS saknr

t370k_t~eartx AS eartx

INTO TABLE lt_ska1 FROM ska1

JOIN (SELECT DISTINCT damage_gl FROM zzpm_cost_elem ) ON ska1_{saknr = zzpm_cost_elem}damage_gl.

The problem with the select "SELECT DISTINCT damage_gl FROM zzpm_cost_elem " which I have to put table name instead of it

What should I do ?

Thx

Re: SELECT DISTINCT with JOIN

Former Member — Tue, 03 Nov 2009 21:32:32 GMT

Hi Friend ,

Please see this example how you can use the select DISTINCT statement



DATA: ITAB TYPE STANDARD TABLE OF SPFLI,
      WA LIKE LINE OF ITAB.

DATA: LINE(72) TYPE C,
      LIST LIKE TABLE OF LINE(72).

LINE = ' CITYFROM CITYTO '.
APPEND LINE TO LIST.

SELECT DISTINCT (LIST)
       INTO CORRESPONDING FIELDS OF TABLE ITAB
       FROM SPFLI.

IF SY-SUBRC EQ 0.
  LOOP AT ITAB INTO WA.
    WRITE: / WA-CITYFROM, WA-CITYTO.
  ENDLOOP.
ENDIF.

Regards,