Table maintainence generator

[Former Member]

Can someone elaborate on table maintainence generator ?

What is it used for ?

Regards,

Tushar

[Former Member]

Hi Tushar,

Table Maintenance will be created to a table where user want to maintain data of that table. From there user can enter data, delete data and modify data.

After creating table maintenance, From SM30 transaction user can do maintenance.

You can create table maintenance, from SE11 after creating table, you will find table maintain generator in the utilities and there you have to give function group and authorization. System will create screens in that function group.

Let me know if you any doubts.

Regards,

Satya

[Former Member]

Hi,

I still have one doubt.

Now in my SAP system the users are able to maintain a custom table going in SPRO transaction after they click on the table which are attached to nodes as IMG activities.

So now user don't have to go to SM30 but they can edit the table going in SPRO.

So can we say that by using Table control we can do the same task as done by Table maintainence generator ?

Should table maintaainance option of table be on even if we are using table control for editing tables?

Regards,

Tushar

[RichHeilman]

You do not have to have the table maintenance flag set or a generated table maintenance program to update your table with a custom program. If you wanted to develop your own maintenance program and put it in SPRO, you can do that. Then the only way to maintain it would be thru SPRO, and users wouldn't be allow to edit thru SM30.

Regards,

Rich Heilman

[Former Member]

But Rich, can we do like SAP generated maintainence program and then attach it to SPRO intead of my own developed maintainence program attaching to SPRO.

So like this we can do maintainence from both SM30 as well from SPRO..

[Former Member]

Then the solution here didn't work for you?

Please close one of the threads, if they are related.

Please let us know exactly what is it that you are not able to do in the steps outlined in the link above.

Srinivas

[RichHeilman]

Sure, there's no difference between a custom program and a table maintenance program.

Regards,

Rich Heilman

[Former Member]

Hi Tushar,

Table Maintainence Generator is generally used so that users can maintain these tables through SM30 or a transaction code that you can create for this table, without using transaction code SE11.

Thanks and Regards,

Vanita

[andreas_mann3]

Hi ,

have a look here:

http://help.sap.com/saphelp_47x200/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

Andreas

[Former Member]

There are two ways of entering data into a database table.

1. throu SE11 or SM30.

2. secondly you can do it from a program, using INSERT statement.

if table maintenance generator is off in SE11, then you would not be able to do direct entries.

so if you want to do entries directly into a table from se11 or sm30, you have to switch on table maintenance generator.

further you can have table maintenance generator with single step or double step.

go into sap help given by Andreas.

also you can write your own subroutines inside table maintence generator if you want to apply some validation on a field.

regards