Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from emohtadi on Apr 14 at 2:31 AM 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. __.____._ | | emohtadi Programmer/Developer - Software | | _.____.__ |