Search help supporting only 5000 entries

[Former Member]

Hi,

I have created a search help, my data base table consists of

22,676 records. when I am executing my search help,

I am getting a pop up saying 'Only first 5000 wil be displayed'

Can anyone tel me how to show all records.

Regards,

Shilpa

[prasanth_kasturi]

hi,

In the search help (SE11)

give the dialog behaviour as Display values Immediately

(or)

in the help menu

goto setting

in the F4 tab

you can restrict the hits

give in field your required value Max. number of hits to be displayed

regards

prasanth

[Former Member]

Hi,

Thanks for your reply

I already did the two things.

But of no help.

Can u suggest anything else.

Regards,

Shilpa.

[prasanth_kasturi]

hi,

then bring all those in a internal table

and use the function module

POPUP_GET_VALUES_USER_HELP

regards

prasanth

[matt]

>

> Hi,
> 
> I have created a search help, my data base table consists of
> 22,676 records. when I am executing my search help,
> I am getting a pop up saying 'Only first 5000 wil be displayed'
> 
> Can anyone tel me how to show all records.
> 
> Regards,
> Shilpa

Why do you need to show all records? If you display 22, 676 records, how does that help the user find the data they're looking for. Your search help should rather allow the user to filter the list to find the appropriate values.

[Former Member]

make the table full buffered from which u are creating help.

[raymond_giuseppi]

The user wont page-up/down thousand times, at least they will use the search option, so better add some criteria to your search help, and change the dialog type to "C" "Dialog depends on value set"

Dialog depends on value set: If the hit list contains less than 100 entries, it is displayed immediately. If the hit list contains more than 100 entries, the dialog box for restricting values is displayed.

Regards