topic Re: SM30 data display restriction in Application Development and Automation Discussions

SM30 data display restriction

Former Member — Thu, 06 Apr 2017 18:18:56 GMT

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

Re: SM30 data display restriction

Jelena_Perfiljeva — Thu, 06 Apr 2017 21:14:59 GMT

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

Re: SM30 data display restriction

Former Member — Thu, 06 Apr 2017 21:22:47 GMT

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

Re: SM30 data display restriction

TuncayKaraca — Thu, 06 Apr 2017 22:06:04 GMT

Hi John,

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

Re: SM30 data display restriction

Former Member — Fri, 07 Apr 2017 09:49:05 GMT

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.