topic Re: SQL DUMP in Application Development and Automation Discussions

SQL DUMP

Former Member — Wed, 24 Jun 2009 07:23:17 GMT

Hi Friends

i have declared one internal table like this it like pa0001 occurs 0 with header line ,

and am using SQL query like this ,

select pernr endda begda werks persg persk btrtl orgeh plans ename

from pa0001 into corresponding fields of table

it where pernr in pnppernr and

endda ge sy-datum and

begda le sy-datum and

werks in pnpwerks and

persg in pnppersg and

persk in pnppersk and

btrtl in pnpbtrtl and

( ( orgeh in pnporgeh ) or

( orgeh in pnpobjid ) ).

but am getting dump some time when so many records are there and dump saya that too many input parameters and no more space for input parameters

What i shd do to correct this ?

Regards

Smeeta

Re: SQL DUMP

jaideepsharma — Wed, 24 Jun 2009 08:21:40 GMT

Hi,

Can you please send us screenshot of your code including the data declaration part ?

KR Jaideep,

Re: SQL DUMP

former_member219399 — Wed, 24 Jun 2009 13:47:03 GMT

Hi,

This could be because of more numbe rof entries with the select options or ranges that you are using.

Try to reduce the number of entries in these and do another filter.

May be this will resolve the short dump.

With regards,

Vamsi

Re: SQL DUMP

Former Member — Wed, 24 Jun 2009 14:12:12 GMT

Check if you can add subty, objps and sprps as aditional search parameters, this way you'll be using almost all the table key and thus receive a great speed bump, so the search will not timeout even if it has many entries.

Perhaps you'll need to remove some of your parameters to pull this off (if there are too many parameters), and the postprocess the internal table to add the missing filters.

Re: SQL DUMP

Former Member — Wed, 24 Jun 2009 17:17:20 GMT

Most probable cause: Length of your SQL when converted to Native SQL it lengthy by supported by database. Tyr reducing the lenth. IN clause increases SQL length significantly.

Re: SQL DUMP

Former Member — Thu, 25 Jun 2009 04:20:22 GMT

Dear Friends-

Problem is i have to match with all Selection Screen parameters so am using those so many IN in SQL query to get the exact matching record i can't reduse them so is there any other valuable suggestion i can use ?

Regards

Smeeta

Re: SQL DUMP

Former Member — Thu, 25 Jun 2009 04:35:17 GMT

Hi,

Please chk whether u r passing the values in the same order in the selection query

as in the Internal table.

And also as u r selecting many fields check the range of the fields

Re: SQL DUMP

Former Member — Thu, 25 Jun 2009 13:10:27 GMT

As I've mentioned, you can remove some of those parameters from the original select, receive more records and then use the removed parameters in a loop over the resulting records to postprocess and eliminate those records that are not needed as per selection.

Re: SQL DUMP

Former Member — Fri, 26 Jun 2009 09:32:37 GMT