avoid inner join

Hi,

I need to increase the performance of my preport by avoiding the joins its using many joins.

please see the code.

*Select ALL Orders which have Purchase Requisitions ! ! !

SELECT c~pspid " Project definition - External

b~posid " Work Breakdown Structure Element - External

b~pspnr " WBS element - Internal

a~objnr " Object number - Network Activity

a~vornr " Activity Number

a~banfn " Purchase requisition

a~ltxa1 " Activity Short text

a~aufpl " Routing number for operations in the order

a~prctr " Profit center

b~akstl " Requesting cost center - WBS

b~zzmain_tool " WBS Custom field - Main Tool

b~zzsub_tool " WBS Custom field - SUB Tool

d~aufnr " Network number

INTO CORRESPONDING FIELDS OF TABLE i_afvc_prps_proj

FROM ( afvc AS a INNER JOIN afko AS d ON a_{aufpl = d}aufpl )

INNER JOIN prps AS b ON a_{projn = b}pspnr

INNER JOIN proj AS c ON b_{psphi = c}pspnr

WHERE

• a~banfn <> ' '

a~objnr LIKE 'NV%'

AND b~akstl IN s_akstl

AND c~pspid IN s_pspid.

could you tell me how to avoid use joins??

advance thanks to ur kindly help.

regards

priya vasuki