topic Re: ABAP runtime error in selection in Application Development and Automation Discussions

ABAP runtime error in selection

Former Member — Mon, 18 Feb 2008 12:53:36 GMT

Hey,

I have an old program with some select options fields. Inside the program, some select options fields are going to be filled, if they are initial at the beginning.

When using this select options field in my SQL selection, I´m getting a runtime error. How many entries are allowed in select options? In this case, I have about 3800...

Cheers

Re: ABAP runtime error in selection

Former Member — Mon, 18 Feb 2008 12:57:22 GMT

Hi,

as far as I know there must be less than 2000 entries in the Select-Option.

Look at Note 13607 - the Number is DB-dependent.

Martin

Edited by: Martin Pfeiffer on Feb 18, 2008 2:11 PM

Re: ABAP runtime error in selection

JozsefSzikszai — Mon, 18 Feb 2008 13:01:54 GMT

hi Arne,

I also had the same problem some time ago. Pls. have a look at this thread:

hope this helps

Re: ABAP runtime error in selection

Former Member — Mon, 18 Feb 2008 13:02:36 GMT

Hi,

From SAP note 635318;

"When the SQL statement is generated at runtime, you should check the

following restrictions and divide or reduce the statement if necessary.

The static length (in the ABAP editor) of any ABAP command must not

exceed 28672 characters.In Open SQL commands with dynamic subclauses

(WHERE, GROUP BY, ORDER BY, and so on), the subclauses cannot contain

more than 28672 characters."

It could be that your select statement is too long, rather than specifically the number of entries in the select-option.

Regards,

Nick

Re: ABAP runtime error in selection

RaymondGiuseppi — Mon, 18 Feb 2008 13:03:10 GMT

The exact number depends on the database OS AND of abap limit of 32768 bytes.

(Look at OSS [Note 1001257 - SQL error -1105 Too complicated SQL statement|https://service.sap.com/sap/support/notes/1001257])

If one of the select-options has too many values, try to use a FOR ALL ENTRIES if possible.

Regards

Re: ABAP runtime error in selection

Former Member — Mon, 18 Feb 2008 13:07:32 GMT

When U declare the values in only low then it's restricted .

If U can declare the values in a range then it works fine ..

s_pernr ..

If only s_pernr-low is filled with all your values .. the select goes for a

dump ..

try to give a range ..

s_pernr-low = '10000000'.

s_pernr-high = '10999999'.

s_pernr-sign = 'I'.

s_pernr-option = 'BT'.

Re: ABAP runtime error in selection

Former Member — Wed, 17 Feb 2010 13:23:12 GMT

No ongoing question anymore...