topic Re: table maintainence in Application Development and Automation Discussions

table maintainence

Former Member — Tue, 13 Mar 2007 11:42:01 GMT

Is there a tcode for table maintainence and what is it used for?

Re: table maintainence

Former Member — Tue, 13 Mar 2007 11:42:59 GMT

check in SM30

Table maintenance is used to maintain the data for that table

Re: table maintainence

Former Member — Tue, 13 Mar 2007 11:47:23 GMT

wht do u mean by maintain view of that table

Re: table maintainence

Former Member — Tue, 13 Mar 2007 11:48:18 GMT

Hi....

open a table then:

<b>UTILITIES--> TABLE MAIMTANANCE GENERATOR</b>

It will take u to table maintanance generator...

alse see the transaction SE54

See the following links:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/69/c2513a4ba111d189750000e8322d00/frameset.htm

http://help.sap.com/saphelp_erp2005vp/helpdata/en/a1/e45217a2f511d1a5630000e82deaaa/frameset.htm

Reward points if useful....

Suresh

Re: table maintainence

Former Member — Tue, 13 Mar 2007 11:51:15 GMT

Please have a look at below link. May be helpful to you.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/frameset.htm

Best Regards,

Vibha

*Please mark all the helpful answers

Re: table maintainence

Former Member — Tue, 13 Mar 2007 11:53:16 GMT

Message was edited by:

Chandrasekhar Jagarlamudi

Re: table maintainence

Former Member — Wed, 14 Mar 2007 07:01:52 GMT

Hi,

SM30 SM31 are the transactions.

Using thisYou can generate database table and view maintenance dialogs to maintain customizing data. You can create, change and delete customizing data with these maintenance dialogs. You can also use maintenance dialogs for customer database table and maintenance views.

You can modify maintenance dialogs flexibly to your requirements by defining variants of an existing maintenance view, or adding your own modules to existing maintenance dialogs. You can make further functional enhancements at predefined events in the table maintenance dialog flow. You can collect related data from more than one table/view in a view cluster.

Hope Helps u better.

Regards,

RaviKumar

Re: table maintainence

Former Member — Wed, 14 Mar 2007 07:29:20 GMT

Hi,

u must create a fn group(SE37) & activate it.

In se11, give the table name,choose utitilities-->Table maintainence generator.

Give the authorisation group name (eg:&nc&), fn group name,maintenance type:one type,maintain screen no:overview screen :1 & create the table maintenance generator.

In SE93, create transaction of type -parameter transaction,in transaction give SM30

1)in name of screen field ,give -VIEWNAME,

in value, give ur table name.

2)Then in the next line

Name of the Screen Field as 'UPDATE' and

Value as 'X'.

Now, if u execute this transaction,ur table maintenance screen displayed.

Table maintenance is used for adding / editing entries of the table.

Regards,

Viji