topic Re: Limitations with Selection in Application Development and Automation Discussions

Limitations with Selection

prince_isaac — Fri, 20 Mar 2009 15:14:29 GMT

Hie guys,

I have a report running and on selection screen if no values are specified it should pick all Business Partners in the system however this is not happening. The selection is restricted to 5000 hits yet i have not specified any limitations on selection screen. I have checked the user settings and i find no specifications to do with limitations on selection. What could be the cause of this?

regards

Prince Isaac

Re: Limitations with Selection

Former Member — Fri, 20 Mar 2009 15:19:08 GMT

Can you paste your query here please?

Re: Limitations with Selection

prince_isaac — Fri, 20 Mar 2009 16:19:31 GMT

hie

heres a snippet:


*selection screen 
SELECTION-SCREEN BEGIN OF BLOCK bli WITH FRAME TITLE text-bli.
SELECT-OPTIONS: material FOR mara-matnr.
SELECTION-SCREEN END OF BLOCK bli.
.
.
.

* selection
  SELECT * FROM mara INTO table xmara WHERE matnr IN material
                                AND mtart EQ 'ZSER'.

If i put break-point i find out that xmara contains 5000 entries. If i execute the number of entries in table mara and i remove the restrictions of number of hits and i leave blank stil only 5000 entries are shown.

regards

Isaac Prince

Re: Limitations with Selection

Former Member — Fri, 20 Mar 2009 16:23:05 GMT

Hi,

Did u check if the table has only 5000 entries for your selection ?

Regards,

Arun

Re: Limitations with Selection

Former Member — Fri, 20 Mar 2009 16:25:10 GMT

I think for that selection criteria number of entries is 5000.u check ur internal table if all the entries in it belongs zser.

Re: Limitations with Selection

prince_isaac — Fri, 20 Mar 2009 16:30:16 GMT

hie guys

from SE11 there are more than 5000 entries of ZSER in table MARA. During debugg the number of enties in XMARA is exactly 5000.

regards

Isaac Prince

Re: Limitations with Selection

former_member376453 — Fri, 20 Mar 2009 16:33:55 GMT

Check in MARA table through SE11, with MTART = ZSER. check the number of entries in MARA table.

Kuntal

Ignore above coment... I havn't checked you have already given this

Edited by: Kuntal Nandi on Mar 20, 2009 11:34 AM

Re: Limitations with Selection

Former Member — Sat, 21 Mar 2009 03:38:25 GMT

just hint- may b building the RANGES table may helps!!

thanq

Re: Limitations with Selection

Former Member — Sat, 21 Mar 2009 05:48:39 GMT

How you declared XMARA internal table in your prorgam?

thanks!

Brunda

Re: Limitations with Selection

prince_isaac — Wed, 25 Mar 2009 15:55:44 GMT

Thanx for all the iput guys but i still have not found the answer however i am closing the thred.