TIME_OUT

Former Member — Wed, 01 Feb 2012 03:41:16 GMT

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

Re: TIME_OUT

madhu_vadlamani — Wed, 01 Feb 2012 03:53:13 GMT

Hi Sekhar,

Did you traces where it is taking more time.Check the tables declaration also.From flag tables delete if there is any duplicates.

Regards,

Madhu.

Edited by: madhurao123 on Feb 1, 2012 9:23 AM

topic Re: TIME_OUT in Application Development and Automation Discussions

TIME_OUT

Re: TIME_OUT