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