Skip to Content
0
Former Member
Nov 03, 2009 at 09:01 PM

SELECT DISTINCT with JOIN

649 Views

Hi,

how Do I write this select in rigth way in ABAP

SELECT ska1ktopl AS ktopl ska1saknr AS saknr

t370k_t~eartx AS eartx

INTO TABLE lt_ska1 FROM ska1

JOIN (SELECT DISTINCT damage_gl FROM zzpm_cost_elem ) ON ska1saknr = zzpm_cost_elemdamage_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