Exceede maximum permitted runtime

[Former Member]

Hello All,

I am handling sales tax return report. It’s working fine in development system but in production system because of heavy data it’s dumping. The reason for this dump is “Has exceeded the maximum permitted runtime “, below one is the statement where it’s dumping.

SELECT fwste MWSKZ FWBAS from bset INTO (itab3-fwste,ITAB3-MWSKZ,ITAB3-FWBAS) WHERE belnr = itab1-beln and mwskz in ('B1','B2','B3','B4','B6','B5','A3').

DO anyone now what’s may be the main reason for this error & have the solution for it.

Regards,

Mahesh

[Former Member]

Hi Mahesh,

The only reason of the dump analysis is that the query you hv written taking to much time to extract data from BSET table.

Please consider primary key combination while extracting data from any table.

Use the following code for fine tunning.

<b>SELECT fwste MWSKZ FWBAS from bset INTO (itab3-fwste,ITAB3-MWSKZ,ITAB3-FWBAS)

WHERE bukrs = itab1-bukrs and

belnr = itab1-beln and

gjahr = itab1-gjahr and

mwskz in ('B1','B2','B3','B4','B6','B5','A3').</b>

<b>Please select teh data based on company code, document number and fiscal year combination.</b>

This will work more faster then wt you hv written.

<b>

Rewards points if useful.</b>

Regards,

Kinjal

[Former Member]

Hi Rathod

There is tremendous improvement by using company code.

Wonderful. I have just tested.

I am benefitted by this question.

Thanks

Vijaya Chamundi

[Former Member]

Hi Kinjal,

Thanks for your reply. It really helped me lot. I haven't tested it in production system, it take some time to test there, I think it should work well there also.

I do need another clarification from your side, If I use all the primary key for the selection, can't you think there may be chances of losing some of the records, because fiscal year may be 2007 or 2008. This report is used for <b>Quaterly Return statement of Exports.</b>

[Former Member]

Hi Vijay,

How did you check the improvement, using company code. Please tell me the process which I need to follow to compare the improvement of the both the programs( With company code & without company code).

Regards,

Mahesh

[Former Member]

time limit may be very less..

Ask ur BASIS person for extending time limit.

U have to take care of proper Primary key for better performance.

If even then dump occurs, u have to increase the time limit.

regards

Prax

[Former Member]

Hi Prax,

I am not authorized to check the time limit. I think we can increase the time limit upto some extent, after that limit we can't increase it seems, mine some other reports also dumping in production system, if you clearly tell me how to check the time limit & also how to convenience BASIS people it will be very helpful for me, since I am working in client side.

Thanks & Best Regards,

Mahesh

[Former Member]

Hi Mahesh,

If you are concerned with fiscal year then use the function module which gives you fiscal year based on your system date or date you processed. By using this you can definitely solve fiscal year problem.

Regards,

Kinjal