topic Re: Table maintainance thru Sm30 in Application Development and Automation Discussions

Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 17:52:47 GMT

Hi Gurus,

I have a requirement from the user to UPDATE a Z* table thru transaction SM30, ADD,DELETE, and MODIFY should work there, I delete a entry and update it with a new value it should work, in other words I need to EDIT the table also, pls advice..

Correct answers will be rewarded .

Thanks in advance.

Regards.

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 17:55:13 GMT

Create a table maintenance for the Z table . SE54. You will get all the functionalities you mentioned.

regards,

Advait.

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 17:57:55 GMT

Hi Sandeep,

1 . Create a table maintenance generator for that table in SE11

2. to do that ,

in SE11 , give the table name and goto display mode

utilities--->table maintenance generator

1. Give authorization group as &NC&

2. Create one Function group in SE37 and give it in function group field

3. Select one step radio button

3. Click on create button

now goto SM30 and give the table name and click on Maintain

now you can ADD, DEL, UPDATE ztable records here

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 18:25:38 GMT

I followed the same steps and tried doing it, but amnot able to EDIT the entries, can you pls ealborate

Thx again.

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 18:28:05 GMT

Hi sandip

u know why we need to do table maintenance generator?

Becoz (T-codes) se11, se16 doesn't work in production server.

So we use sm30 , se11->utilities->activate table maintenance gerators se54

Follow the below steps:

A) SE11 , give the table name and goto display mode

utilities--->Table Maintenance Generator

B) Give authorization group as &NC&

C) Create one Function group in SE37 and give it in function group field

D). Select one step radio button

( There r one step & two step)

E) Click on create button

now goto SM30 and give the table name and click on Maintain

now you can ADD, DEL, UPDATE ztable records here

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 18:29:06 GMT

Hi sandip

u know why we need to do table maintenance generator?

Becoz (T-codes) se11, se16 doesn't work in production server.

So we use sm30 , se11->utilities->activate table maintenance gerators se54

Follow the below steps:

A) SE11 , give the table name and goto display mode

utilities--->Table Maintenance Generator

B) Give authorization group as &NC&

C) Create one Function group in SE37 and give it in function group field

D). Select one step radio button

( There r one step & two step)

E) Click on create button

now goto SM30 and give the table name and click on Maintain

now you can ADD, DEL, UPDATE ztable records here

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 18:32:05 GMT

Hi Sandeep,

Did u go to change mode while editing the fields?

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 18:42:03 GMT

Sorry, For some reason the changes are not taking place.

Re: Table maintainance thru Sm30

Former Member — Thu, 19 Jun 2008 21:15:17 GMT

Sandeep,

Make sure you are in change mode in SM30.

Also, you cannot change the key fields, to do that you need to copy an entry and edit it, then delete the old entry if you dont want.

Thanks

Romit