Skip to Content
0
Former Member
Aug 29, 2007 at 02:00 PM

need tip for performace

34 Views

hallow

i wont option for this select for better perfomace (i haerd about up to 1 row but if i use it here i get the same results?)

SELECT SINGLE pspnr pbukr

FROM prps

INTO (project_type ,l_pbukr)

WHERE pspnr = ps_psp_pnr.

SELECT SINGLE waers

FROM t001

INTO l_waers

WHERE bukrs = l_pbukr.

Regards