topic Re: Table Maintenance without SM30 access in Application Development and Automation Discussions

Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 15:29:12 GMT

Hello,

We have a requirement to create a custom maintenance view/screens for custom tables, I know we could use VIEW_MAINTENANCE Function modules, however users don't have SM30 access in PRD.

Suggestions please?

Thanks.

Re: Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 15:48:59 GMT

Hi,

You don't need SM30 access, you can create a tcode for each view maintenance.

Martin

Re: Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 15:54:22 GMT

Hi Chatterjee,

You can create a transantion for this table on SE93 calling sm 30. Then you could give acces to the users for this transaction:

Regards!!

Carla

Re: Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 16:10:04 GMT

Can you give more details please?

I am creating a custom table and generate the table maintenance (with recording routine as 'no, or user recording routine'.

When I create a tcode via SE93 (Transaction with parameters (parameter transaction)), in the default values section what should be the transaction??

Thanks much in advance.

Re: Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 16:17:23 GMT

Yes, it can be done this way, but this still needs SM30 in the background. Just exploring other options to achieve the same.

Re: Table Maintenance without SM30 access

Former Member — Tue, 15 Oct 2013 16:49:48 GMT

Are you sure you need permission? we proceed this way many times when users have no autorization to SM30, and it is working fine.

Another way is create a report which call the FM VIEW_MAINTENANCE_CALL

exporting

action = 'U'

view_name = p_view "maint.View

Regards!!

Re: Table Maintenance without SM30 access

vinod_vemuru2 — Tue, 15 Oct 2013 23:46:55 GMT

Hi,

Authorization can be controlled at 2 levels.

1. Access to the t-code directly.

2. Access to a t-code when it is called from some other program/t-code.

Solution mentioned by Carla works fine without having access to SM30. Please check with your BASIS folks to get correct access.

Thanks,

Vinod.

Re: Table Maintenance without SM30 access

Former Member — Wed, 16 Oct 2013 21:21:43 GMT

You are right Carla, parameter transaction doesn't require SM30 access. Somehow I assumed it requires SM30.

Thank you!

Re: Table Maintenance without SM30 access

Former Member — Thu, 17 Oct 2013 12:22:41 GMT

Great , please remember mark the answer like correct answer

Best regards!