cancel
Showing results for 
Search instead for 
Did you mean: 

SE16 Usage causes application servers to crash

Former Member
0 Kudos

We currently allow all users to access SE16 to view tables that we do not currently have reports for. With this we have seen many users who are not aware of how many records are in a given table and try to download the entire table to Excel. Even though the user has selected to only display 100 records on the screen the download process still try to download all data that matches the criteria in the selection fields. This then may try to download 10+ million records causing the application servers to run out of memory and paging space based on the download. We have contemplated trying to make a custom SE16 that hard codes how to only limit the # of records that can be downloaded at at time. Does anybody know of another way to do this besides creating a custom report for every user need? Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

alen_mikulic
Participant
0 Kudos

Hi,

Allowing access to direct se16 is not a good practice, you can provide them access to tcodes sq01/2 where users can create querys using tables. This can be useful where a non technical person can work with tables.

The long term idea would be the usage of reports and updating their roles to access the same.

Cheers Sam

Former Member
0 Kudos

We have some use of SQ01 but users typically have to be more technical to use that tcode. Unfortunately, we have enough problems and we have decided as a company that SQ01 is not our final tool at this point. SE16 is something we want to take away from all users except for on an exception only basis but we are not at that point yet. Since most users have been told to use this method it will be hard to migrate them off of it without a better option that is as easy as SE16. Thanks.

alen_mikulic
Participant
0 Kudos

Hi,

There is no short way would suggest custom abap reports, BW system for reporting.

Possibly to restrict usage to specific tables with specified search criteria to use se93 to create z-tcodes and restrict access to only these tcodes and the variant involved.

Cheers Sam

Former Member
0 Kudos

Hello Dennis!

In my view and following the SAP Best Practicies , the SE16 should be restricted to Basis and Developer otherwise, the users abuse the system by misusing the se16.

The best way to prepare the ABVAP reports of users whcih are frequently required .

Regards

Anwer Waseem

Answers (0)