Skip to Content
0
Former Member
Dec 01, 2008 at 07:00 AM

problem with selection query

400 Views

i want to remove inner join from this selection query ie need to write three differnt select query from this one ...

m new to abap can smbdy guide me in this...

SELECT equnr kunum eaufnr gewrk ilart pm_objty eqmnum

dobjnr fgstrp aufpl d~auart user4

INTO CORRESPONDING FIELDS OF TABLE itab FROM afih AS e

INNER JOIN afko AS f

ON faufnr = eaufnr

INNER JOIN aufk AS d

ON daufnr = eaufnr

INNER JOIN crhd AS c

ON egewrk = cobjid

INNER JOIN pmsdo AS g

ON dobjnr = gobjnr

WHERE e~aufnr IN aufnr

AND e~equnr IN equnr

AND e~ilart IN ilart

AND f~gstrp IN gstrp

AND d~gsber IN gsber

AND c~arbpl IN arbpl

AND c~objty IN objty

AND g~vkbur IN vkbur.

Edited by: nikita mishra on Dec 1, 2008 8:00 AM