Table maintainance thru Sm30

[Former Member]

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.

[Former Member]

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

regards,

Advait.

[Former Member]

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

[Former Member]

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

Thx again.

[Former Member]

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

[Former Member]

Hi Sandeep,

Did u go to change mode while editing the fields?

[Former Member]

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

[Former Member]

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

[Former Member]

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