Limitations with Selection

[prince_isaac]

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

[Former Member]

Can you paste your query here please?

[prince_isaac]

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

[Former Member]

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

[prince_isaac]

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

[former_member376453]

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

[Former Member]

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

thanq

[Former Member]

How you declared XMARA internal table in your prorgam?

thanks!

Brunda

[prince_isaac]

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

[Former Member]

Hi,

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

Regards,

Arun