topic Re: SUBMIT statement in Application Development and Automation Discussions

SUBMIT statement

Former Member — Sun, 13 Apr 2008 13:01:43 GMT

Hi experts,

If i have to SUBMIT a report 5 times within a subroutine of my main report, how is that going to be achieved? Is DO ENDDO a solution to it?

The situation is that i have the following code in my main report main_delete:

IF p_as = 'X'.

OPEN CURSOR WITH HOLD lv_cursor FOR

SELECT * FROM dd02l

WHERE as4local = 'A' AND

( tabclass = 'TRANSP' OR

tabclass = 'POOL' OR

tabclass = 'CLUSTER' ) .

DO.

FETCH NEXT CURSOR lv_cursor

INTO CORRESPONDING FIELDS OF TABLE lt_result

PACKAGE SIZE lv_package_size.

IF sy-subrc <> 0.

EXIT.

ELSE.

****Schdule jobs in parallel for packet of entries as defined by ****

****lv_package_size

PERFORM state_entries TABLES et_result.

Now in the subroutine state_entries, i have to call the other report get_delete 5 times using a SUBMIT statement and pass it to a FUNCTION MODULE . How should i achieve this?

Also, in get_delete, there are about 10 lakh records that are being processed. So how will the report know when is the next lot of 2 lakh records going to be processed (as defined by lv_package_size)? Will the FETCH NEXT CURSOR take care of this?

I will reward all the helpful answers.

Thanks,

Ajay.

Re: SUBMIT statement

Sm1tje — Sun, 13 Apr 2008 20:31:00 GMT

First: Indeed you can use DO 5 TIMES. .SUBMIT xxxx .... ENDDO.

But this will only make sense when you are using different values for the data on the selection screen from the report your are calling in SUBMIT. Else, the report will do the same thing 5 TIMES, while the first time is already enough??!!

Second: What do you mean by: 'Pass this to a function module'. Pass what to a function module and why?

Third: There is a question about get_delete. Like I already wrote above, call the GET_DELETE report with different selection parameters. By the way: What is LAKH (1000?).

The fetch cursor can take care of this, but than you will have to use the PERFORM state_entries TABLES et_result before the EXIT i believe. Your code is not complete, so I'm taking a guess here.

BUT: Do not use the FETCH and DO 5 TIMES. SUBMIT. ENDDO together. The one or the other.

Edited by: Micky Oestreich on Apr 13, 2008 10:31 PM

Re: SUBMIT statement

former_member125661 — Mon, 14 Apr 2008 02:41:15 GMT

LAKH is hindi word for 100,000.

Re: SUBMIT statement

Former Member — Wed, 16 Apr 2008 13:40:34 GMT

Hi Micky,

I have to pass the report get_delete in the FM 5 times (for 200000 entries each)

Lakh means 100000.

Thanks,

Ajay.