topic Re: Table maintainence generator in Application Development and Automation Discussions

Table maintainence generator

Former Member — Wed, 02 Nov 2005 02:05:02 GMT

Can someone elaborate on table maintainence generator ?

What is it used for ?

Regards,

Tushar

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 02:21:19 GMT

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

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 06:18:26 GMT

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

Re: Table maintainence generator

andreas_mann3 — Wed, 02 Nov 2005 07:15:23 GMT

Hi ,

have a look here:

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

Andreas

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 07:24:16 GMT

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

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 17:52:36 GMT

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

Re: Table maintainence generator

RichHeilman — Wed, 02 Nov 2005 18:02:22 GMT

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

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 18:37:37 GMT

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..

Re: Table maintainence generator

Former Member — Wed, 02 Nov 2005 18:52:00 GMT

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

Re: Table maintainence generator

RichHeilman — Wed, 02 Nov 2005 18:52:35 GMT

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

Regards,

Rich Heilman