topic Re: select-options memory in Application Development and Automation Discussions

select-options memory

Former Member — Wed, 02 Apr 2008 15:54:20 GMT

I am processing a report and doing some validations thru select options.

Is there any limitations memory for select options?

I am processing here 2. million records and validation them thru selection option internal table(which contains low, high and option values).

Please help me.

Thanks

Re: select-options memory

nivin_varkey — Wed, 02 Apr 2008 16:04:38 GMT

Hi,

yes there is a limit to the size, if the select-options variable is used to select data from a table and if the data selection is of huge size..then there is a chance of having a short dump..

Re: select-options memory

Former Member — Wed, 02 Apr 2008 16:09:53 GMT

hi,

Yes there is a limit and the number is limited based on the memory ...

Regards,

Santosh

Re: select-options memory

Former Member — Wed, 02 Apr 2008 16:32:04 GMT

Hi MICR,

Maximum limit select option can hold is 1624 entries

chk this program , if u increase the do loop to 1625 or above it will give dump

REPORT ychatest LINE-SIZE 350.

TABLES : mara.

SELECT-OPTIONS : s_matnr FOR mara-matnr.

DATA : BEGIN OF itab OCCURS 0.

INCLUDE STRUCTURE mara.

DATA: END OF itab.

DO 1600 TIMES.

s_matnr-sign = 'I'.

s_matnr-option = 'BT'.

s_matnr-low = ''.

s_matnr-high = ''.

APPEND s_matnr.

CLEAR s_matnr.

ENDDO.

SELECT * FROM mara INTO TABLE itab WHERE matnr IN s_matnr.

WRITE : 'hi'.

Re: select-options memory

Former Member — Wed, 02 Apr 2008 17:09:30 GMT

hi ,

yaa there is a limitation for the memory over the select options as said by chandrasekhar ...when ur prossing the more no of records to an internal table it is better to use the statement PACKAGE SIZE in the declaration of itab.

regards,

venkat.

Re: select-options memory

Former Member — Wed, 02 Apr 2008 17:30:22 GMT

Hi,

As Chandra said, There is a limitation on the number of entries in the select options. The generated SQL command for your SELECT statement is too large as i understand it should not be more than some predefined bytes.

If there are too many parameter values the program will dump with 'SAPSQL_STMNT_TOO_LARGE'.

In my experience the number of entries is roughly around 1600. But i think Chandrasekhar should be right in the exact count, i feel.

Hope this helps. Reward points if helpful.

Thanks

Balaji

Re: select-options memory

Former Member — Wed, 02 Apr 2008 18:11:04 GMT

Hi,

There is a limitation for select-options memory.

The reason why one get the short dump for select statements like this is based on the system setting (memory allocation is normally 64KB) for variables in the select.

It doesnt matter when your field is camparing with select-options or manually entered long ranges of values.

SAP doesnt advice to increase the memory allocation for Select statements as the execution time for this select may result a dead lock for other queries or other processes in queue.

The original SAP code was

"select from where field in s_option ".

which dumps with over 8,000 single entries. It's not a runtime error, as it dumps straight away, so presumably fails on the number of single values.

You can see in SQL trace when the statement was executed successfully. Therefore if R3 throws dump because statement couldn't be accepted by database server if your select-options table is too big.

The OSS note changed it to

select for all entries in S_OPTION where field = s_option_low.

which doesnot dump , and the report displays all the entries selected.

Please try the above statement and inform whether it works or not.

Reward points if helpful.

Thanks and Regards.

Edited by: Ammavajjala Narayana on Apr 2, 2008 8:11 PM