Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from halilkinik on Apr 14 at 7:42 AM Hi,
You have to consider table index structure.
I think,
Below structure works faster than your example.
where rldnr...
and bukrs....
and racct....
and ryear <= sdate-low+0(4)
. and. budat < sdate-low
and ......
and .........
Best regards.
| | | ---------------Original Message---------------
From: emohtadi
Sent: Tuesday, April 14, 2015 2:38 AM
Subject: Performance Issue FAGLFLEXA
Hi Masters,
How to select the data efficiently for the table FAGLFLEXA?
This is my query:
Executed time is about 10 minutes.
SELECT-OPTIONS:
s_hkont for faglflexa-racct,
s_prctr for faglflexa-prctr,
s_date for bkpf-budat.
data begin of pre_h OCCURS 0.
data racct type faglflexa-racct.
data prctr type faglflexa-prctr.
data hsl type faglflexa-hsl.
data rwcur type faglflexa-rwcur.
data end of pre_h.
select racct prctr sum( hsl ) rwcur into table pre_h
from faglflexa
where racct in s_hkont
and prctr in s_prctr
and budat < s_date-low
and drcrk = 'H'
and rldnr = '0L'
group by racct prctr rwcur.
Best Regard. |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
