Table Maintenance without SM30 access

[Former Member]

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.

[Former Member]

Hi,

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

Martin

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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!!

[vinod_vemuru2]

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.

[Former Member]

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

Thank you!

[Former Member]

Great , please remember mark the answer like correct answer

Best regards!