topic Re: Regarding SM30 tcode autorization in Application Development and Automation Discussions

Regarding SM30 tcode autorization

Former Member — Wed, 06 Jul 2011 06:42:10 GMT

Hi all,

We don't want users to use SM30 on this particular Z table so, we created a Z transaction which basically call SM30 and open up that Z table.

If users are not authorized to use SM30 tcode , can they use that z transaction which basically call SM30?

Your reply would be very helpful for me.

Thanks & Regards

Subhanshu Shrivastava

Edited by: Subhanshu Shrivastava on Jul 6, 2011 8:42 AM

Re: Regarding SM30 tcode autorization

Kiran_Valluru — Wed, 06 Jul 2011 06:50:27 GMT

Hi.,

No. It will Display Error Message. You are not authorized to use..

If you want to call SM30.,

Then in Your Z Transaction (Report )

Call Function Module C160_TRANSACTION_CALL and Pass TCode SM30.

CALL FUNCTION 'C160_TRANSACTION_CALL'

exporting

i_tcode = 'SM30' .

hope this helps u.,

Thanks & Regards,

Kiran

Re: Regarding SM30 tcode autorization

Former Member — Wed, 06 Jul 2011 06:55:58 GMT

Hi,

I think the user who don't have authorization to SM30 can access the z t-code you have created for the same.

Why dont you give a try. Its just matter of minutes.

Re: Regarding SM30 tcode autorization

SuhaSaha — Wed, 06 Jul 2011 06:56:20 GMT

Hello,

The authorisation object controlling the table maintenance activities is S_TABU_DIS.

If you want to restrict the table maintenance to specific users, when defining the TMG specify an auth. group(don't use &NC&).

In the roles assigned to the users(who can maintain the table) you have to maintain the above mentioned auth. group against the S_TABU_DIS along with the correct activity!

In fact you need not worry about the profiles & roles You have to let the Basis & Security team know the auth. group maintained in the TMG & the list of user who can maintain the table. They should take it forward from there!

BR,

Suhas

Re: Regarding SM30 tcode autorization

Former Member — Wed, 06 Jul 2011 06:57:59 GMT

Hello,

you can use the function module VIEW_MAINTENANCE_CALL this is the same that call sm30. There are no problems of autoritzation. You must create a program where you call this function with your view_name.



CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
  EXPORTING
    ACTION                               = 'U'
    VIEW_NAME                            = l_view_name
    NO_WARNING_FOR_CLIENTINDEP           = 'X'
  TABLES
    DBA_SELLIST                          = l_dba
    EXCL_CUA_FUNCT                       = l_pfstatus
  EXCEPTIONS
    CLIENT_REFERENCE                     = 1
    FOREIGN_LOCK                         = 2
    INVALID_ACTION                       = 3
    NO_CLIENTINDEPENDENT_AUTH            = 4
    NO_DATABASE_FUNCTION                 = 5
    NO_EDITOR_FUNCTION                   = 6
    NO_SHOW_AUTH                         = 7
    NO_TVDIR_ENTRY                       = 8
    NO_UPD_AUTH                          = 9
    ONLY_SHOW_ALLOWED                    = 10
    SYSTEM_FAILURE                       = 11
    UNKNOWN_FIELD_IN_DBA_SELLIST         = 12
    VIEW_NOT_FOUND                       = 13
    MAINTENANCE_PROHIBITED               = 14
    OTHERS                               = 15.
IF SY-SUBRC <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

Re: Regarding SM30 tcode autorization

Former Member — Wed, 06 Jul 2011 07:00:24 GMT

HI,

yes. they can use the Custom Tcode to maintain the Ztable.

but the user has an authorization for that also. if not ask basis people to provide access.

Hope this will helps you.

if you create the table maintanence Generator for the table. you can access it through SE16N.

provide table name and press enter. in the application tool bar you can see 'View Maintanence'. using this we can maintain the table.

Regards,

Kiran

Edited by: kiran kumar on Jul 6, 2011 9:02 AM

Re: Regarding SM30 tcode autorization

eduardo_hinojosa — Wed, 06 Jul 2011 09:35:39 GMT

Go to tcode SE54 for this table/view / generated objects and change/view. See what value do you have in authorization group. See the help for field and how can you use in S_TABU_DIS (see in SE16N the table TDDAT) in PFCG.

Check also all objects for S_TABU*

I hope this helps you

Regards

Eduardo

Re: Regarding SM30 tcode autorization

former_member611181 — Wed, 06 Jul 2011 18:37:46 GMT

It all depends on what authorization object provided when table maintenance generator is created.

Anyways when creating skip first screen during transaction code creation it will not check Sm30 authorization.

It does not depend on whether user has SM30 access or not.