Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SM30 data display restriction

Former Member

‎2017 Apr 06 7:18 PM

0 Likes
3,294

Hi All,

Wanted to know the best way to restrict the data displayed using SM30. Currently SM30 displays all the records from database table if no filter applied. I want to restrict the data displayed like say only 200 records for a table (Similar to SE16).

As of now I modified the PBO of table maintenance screen by deleting TOTAL internal table. Wanted to know is there any better way.

Thanks,

John

4 REPLIES 4
Read only

Jelena_Perfiljeva
Active Contributor

‎2017 Apr 06 10:14 PM

0 Likes
2,043

Why do you need this and have you tried searching in Google for SM30 events?

Read only

Former Member

‎2017 Apr 06 10:22 PM

0 Likes
2,043

Hi Jelena,

We have tables whose sizes are so huge it brought the entire server down while displaying the data using SM30.

There is no event in SAP which gets called Before data is displayed and have access to TOTAL table.

Thanks,

John

Read only

TuncayKaraca
Active Contributor

‎2017 Apr 06 11:06 PM

0 Likes
2,043

Hi John,

I think only way is utilizing Table Maintenance events; you are on the right path.

Read only

Former Member

‎2017 Apr 07 10:49 AM

0 Likes
2,043

Hi John,

I'm not sure you can put a limit on the number of entries displayed in a maintenance view, but i know that you can act on the selection conditions via table "DBA_SELLIST" during initialization events such as number 19. Probably it'll be easier to have the user specify some restrictions.

Regards.

Guido.