Restricting user to maintain entries in production through table maintenanc

[Former Member]

Dear All,

I have created one table maintenance generator.

I am sending entries of table to quality and production server through transport request.

But user can directly maintain the entries in quality and production server also.

I want to restrict user that he will not be allowed to maintain the entries directly in quality and production server and entries always go through transport request from development to quality and production server.

Any idea how to restrict user to maintain entries in quality and production server.

Any pointers will be helpful and appreciated.

Kind Regards,

Tarun

[former_member156446]

the table maint will be assigned to a authorization group, dont let your basis team give access to the Function group in Q and PRD.

[How to transport table entries>>|http://searchsap.techtarget.com/tip/0,289483,sid21_gci1240876,00.html]

[ThomasZloch]

Table should be classified as "C" (Customizing), the quality and production clients should be marked as "no changes allowed", also "current settings" must not be checked in SOBJ for the customizing object.

Thomas

[Former Member]

Hi Thomas,

How can we mark the quality and production clients as "no changes allowed" and can u please let me know about object SOBJ. What is the purpose of SOBJ transaction and what it intends to do?

Many thanks for your kind help.

Best Regards,

Tarun

Edited by: tarun gupta on Apr 1, 2009 11:34 AM

[ThomasZloch]

> How can we mark the quality and production clients as "no changes allowed"

Transaction SCC4.

> What is the purpose of SOBJ transaction and what it intends to do?

Settings for the maintenance object. Actually a better entry is via the table maintenance generation screen in SE11, there choose "environment -> maintenance objects -> display". Check box "current settings" must be unchecked.

Thomas

[Peranandam]

Hi tarun,

for your requirement you have to create events(create new entry) in table maintanace generator for creating new entry.

create 05 event and give suroutine name as new_entry.

form new_entry.

message 'authorizatioh restricted for creating new entry' type 'E'.

or

create authorization objects then give authorization for perticular user for maintaining data in the table

by creating authorization objects.

endform.

you can also refer below link for how to create events in TMG.

https://forums.sdn.sap.com/click.jspa?searchID=-1&messageID=7246565

Regards,'

Peranandam

Edited by: peranandam chinnathambi on Apr 1, 2009 4:55 PM

[Former Member]

there is no need to use ANY coding for your requirement its just one radio button.

goto SE11 input your table.

then goto utilities->table maintainance generator.

at the bottom you got the Frame Dialo Data transport details.

select the upper radio button (standard recording routine) as a recording routine.

Now you will not be able to customize this table anywhere else than in Dev system.

[ThomasZloch]

> Now you will not be able to customize this table anywhere else than in Dev system.

It's not quite that simple, the settings I described above also play a role. But I agree, no programming necessary here.

Thomas