Skip to Content
0
Former Member
Dec 01, 2005 at 07:03 AM

avoid inner join

122 Views

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 aaufpl = daufpl )

INNER JOIN prps AS b ON aprojn = bpspnr

INNER JOIN proj AS c ON bpsphi = cpspnr

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