Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inner join taking more time

Hi Experts,

I have joined two table prps and proj by inner join . But it is taking more time.

pls advice.

the code is:

select prps~posid

prps~post1

prps~objnr

prps~pbukr

prps~prctr

prps~erdat

prps~zz_can

into table itab_prps_all

from proJ inner join prps

on projpspnr = prpspsphi

where prps~posid IN sel_wbs

AND prps~pbukr IN sel_comp

AND prps~prctr IN sel_prct

AND prps~erdat IN sel_date

and proj~pprof NE wa_pprof.

thanks in advance,

SG

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question