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.