topic Re: submit problem-URGENT in Application Development and Automation Discussions

submit problem-URGENT

Former Member — Fri, 20 Apr 2007 14:35:47 GMT

Hi all,

i am facing a problem with the SUBMIT. I am submtting a report from within another program. it is running fine for small set of data like 4000 records, but my report has around 1,15000 records and the submit throwa time out error.

the piece of code is as follows...

FORM SUBMIT_ZCOU_CO44.

CLEAR WC_AUFNR.

DESCRIBE TABLE R_AUFNR LINES WC_AUFNR.

IF NOT ( WC_AUFNR IS INITIAL ).

LOOP AT R_AUFNR1.

SUBMIT ZCOU_CO44 AND RETURN

*select-options:

WITH AUART IN R_AUART "for caufv-auart,

werks for caufv-werks,

WITH DISPO IN R_DISPO "for caufv-dispo,

fevor for caufv-fevor,
WITH AUFNR IN R_AUFNR "for caufv-aufnr matchcode object orde, "change proj:810000068

WITH AUFNR IN R_AUFNR1 "for caufv-aufnr matchcode object orde,

WITH MATNR IN R_MATNR

*parameters:

WITH SELID = P_SELID " selection profile status

gltrp like caufv-gltrp,

WITH INTTECCL = P_EXDATE " Exceeding days

*selection-screen end of block selec.

WITH FLG_TECL = 'X' "like cosfcact-flg_tecl radiobutton group actn,

WITH MAXCOUNT = '99999'

WITH TASK_NUM = '1'

WITH TESTRUN = ' '. " Update -> no test

ENDLOOP.

IMPORT SUCCESS_COLLECTOR FROM MEMORY ID 'ZDONE'.

IMPORT ERROR_COLLECTOR FROM MEMORY ID 'ZERR'.

IMPORT CAUFV_TAB FROM MEMORY ID 'ZCAFV'.

ENDIF. " wc_aufnr not initial

ENDFORM.

i have divided the entire range into sets of 5000 records each and i am submitting prog2 into a loop of r_aufnr1 which has ranges for every 5000 reocrds...i.e...the submit will run for 5000 reocrds at a time and then again go in loop and submit next 5000 reocrds.

i have read that i cannot run this submit in background since my program1 is depended upon the output from the program run in submit.

Please suggest me something.

Regard

Re: submit problem-URGENT

Former Member — Fri, 20 Apr 2007 14:47:43 GMT

Have you tried running it in the background? That should speed it up.

- April King

Re: submit problem-URGENT

abdul_hakim — Fri, 20 Apr 2007 14:50:30 GMT

Hi Ruchi,

Welcome to SDN.

<b>Run Your Program in Background If you have Huge Volume of Records..</b>

Cheers,

Hakim

Mark all useful answers..

Re: submit problem-URGENT

Former Member — Fri, 20 Apr 2007 14:57:23 GMT

I didn't understand the purpose of calling SUBMIT in LOOP AT R_AUFNR.

ANy way you are using IN R_AUFNR while SUBMITTING... so that will consider all data in R_AUFNR at a time. So no need of calling in LOOP.

So while SUBMITTING try to use only... one entry in R_AUFNR instead of IN R_AUFNR

Re: submit problem-URGENT

Former Member — Fri, 20 Apr 2007 15:00:42 GMT

thanks, let me try and run the job in background.

if that solves the query , then i would definitely reward the points

regards

Ruchi

Re: submit problem-URGENT

Former Member — Fri, 27 Apr 2007 19:31:09 GMT

Thanks,

i have tried this thing and its working ok

however since i m now running this submit in background...

so my final display does not include any records that might have been returned by that submit..!!

but i think thats fine

Re: submit problem-URGENT

Former Member — Fri, 27 Apr 2007 19:35:18 GMT

u can run in background and at same time import the data from the called program. then u can display the data also using write statements in background.