Table maintenance in production

[Former Member]

Hello Folks,

We have setup SM30 access to users to update Z tables in production. How do we get them to update it without the need for a transport request in Production each time they maintain it?

Is there some setting in SE06 that we need to setup for all custom tables?

Thanks

Prakash

[Former Member]

Hi,

If the Z-table is not a customising table, then it will not ask for a TR in production system.

Regards,

Ankur Parab

[Former Member]

Hi,

In SE11, go to the technical settings.

In that check the type of the table. If it is 'C' then it will ask for a reuest.

If it is 'A' (application) then it will not.

Regards,

Ankur Parab

[Former Member]

Where do i see that?

[Former Member]

Hi Prakash,

You will require to change the properties of Table Maintainance Generator:

1) Go to SE11, Display table

2) Click on "Utilities" -> "Table Maintainance Generator"

3) For Recording Routine select 2nd radio button i.e. "no, or user, recording routine"

and Activate the Maintainace.

Now if you add the table entry it will not ask for transport. You have to move these changes to Production to take effect.

Hope this answers your query.

Regards

Shital

[Former Member]

You might also want to use the search, also in http://service.sap.com/notes for the term "current settings".

This is a special case for production and test clients.

Cheers,

Julius

[Former Member]

Dear,

you need not give SM30 access to the users instead you can create a tcode and give that tcode to update the ZTABLE any how table maintenance generator will be maintained for that particular ZTABLE so it will not ask transport request number .

Cheers

fareed

[Former Member]

hi

instead of giving SM30 access to the users u can better create a Z transactions for the

tables and can give that to them right?

Coming to ur problem check the attributes of the table

in the tab Delivery and Maintenance if the Delivery Class is 'C' (Customizing Table)

then it will ask for a Transport Request every time when u update entries in the table

so make it to 'A' (Application Table) the n it will not ask.

Regards