Hi Team
Can you please check the below mentioned code and suggest me the solution, how to resolve TIME_OUT error issue
Code works like,
its looping 4 times
1 st time, it takes it_bsis - 500 records and cross check with table faglflexa and append into itab
2nd time, it takesit_bsas1 - 3500000 records and cross check with table faglflexa and append into itab - here TIME_OUT error fires
find the below mentioned code for your reference
DO c_4 TIMES.
CLEAR: gwa_whr_line.
REFRESH git_whr.
UNASSIGN <gfs_bsis_bsas>.
CASE sy-index.
WHEN c_1.
CHECK NOT it_bsis IS INITIAL.
ASSIGN it_bsis TO <gfs_bsis_bsas>.
lv_flag = c_x.
WHEN c_2.
CHECK NOT it_bsas IS INITIAL.
ASSIGN it_bsas TO <gfs_bsis_bsas>.
lv_flag = c_x.
WHEN c_3.
CHECK NOT it_bsak IS INITIAL.
ASSIGN it_bsak TO <gfs_bsis_bsas>.
CONCATENATE 'BUZEI =' '<GFS_BSIS_BSAS>-BUZEI' INTO gwa_whr_line SEPARATED BY space.
lv_flag = c_x.
WHEN c_4.
CHECK NOT it_bsad IS INITIAL.
ASSIGN it_bsad TO <gfs_bsis_bsas>.
lv_flag = c_x.
ENDCASE.
CHECK lv_flag = c_x.
if not s_prctr[] is initial.
SELECT RYEAR
DOCNR
RBUKRS
RTCUR
RACCT
PRCTR
WSL
DRCRK
BUDAT
BUZEI
FROM faglflexa
APPENDING TABLE git_faglflexa
FOR ALL ENTRIES IN <gfs_bsis_bsas>
WHERE ryear = <gfs_bsis_bsas>-gjahr
AND rbukrs = <gfs_bsis_bsas>-bukrs
AND docnr = <gfs_bsis_bsas>-belnr
AND (gwa_whr_line)
AND prctr IN s_prctr.
else.
SELECT ryear
docnr
rbukrs
rtcur
racct
prctr
wsl
drcrk
budat
buzei
FROM faglflexa
APPENDING TABLE git_faglflexa
FOR ALL ENTRIES IN <gfs_bsis_bsas>
WHERE ryear = <gfs_bsis_bsas>-gjahr
AND docnr = <gfs_bsis_bsas>-belnr
AND rbukrs = <gfs_bsis_bsas>-bukrs
AND (gwa_whr_line).
endif.
clear lv_flag.
ENDDO.
Thanks in Advance
Sekhar
Moderator Message: Duplicate post. Thread locked.
Edited by: Suhas Saha on Feb 1, 2012 10:12 AM
Bluesky
