Skip to Content
0
Former Member
May 28, 2008 at 10:53 AM

performance issue

15 Views

hi friends,when i execute this in development it is working fine but in production it is taking more time..

in production while accessing tranaction se11 for the same condition, it is coming in fraction on seconds,

please if you know the solution ,update me onthis.

if not it_skb1[] is initial.

if not s_gjahr is initial.

select shkont sbelnr sbudat sgjahr s~wrbtr

swaers sdmbtr sbukrs sshkzg

into corresponding fields of table it_open1

from bkpf as k join bsis as s

on kbukrs = sbukrs and

kbelnr = sbelnr and

kgjahr = sgjahr

where k~bukrs = p_bukrs

and s~hkont in s_saknr

and k~gjahr eq s_gjahr

and k~budat in s_budat

and k~waers <> 'INR'

and k~bstat = ''.

else.

select shkont sbelnr sbudat sgjahr s~wrbtr

swaers sdmbtr sbukrs sshkzg

into corresponding fields of table it_open1

from bkpf as k join bsis as s

on kbukrs = sbukrs and

kbelnr = sbelnr and

kgjahr = sgjahr

where k~bukrs = p_bukrs

and s~hkont in s_saknr

and k~budat in s_budat

and k~waers <> 'INR'

and k~bstat = ''.

endif.