Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

What is the need of Table maintenance??

Former Member
0 Kudos

Hi

Can u pls let me know, why do we need table maintanance ?? cant we enter the records directly?

Regards

Rama

11 REPLIES 11

former_member196299
Active Contributor
0 Kudos

Hi,

Table Maintenance generator is required to do user as manually in tabl e entries.

suppose if u want to update a table automatically rather programatically u can go for tbale maintenance generator

Manual entries in table can be maintained ( New record can be inserted / existing can be modified )

use transaction SM 30, if the table maintenance for the table is generated.

Regards,

Ranjita

Former Member
0 Kudos

TMG is required to handle table directly and easily.

you can insert modify delete data using TMG(SM30).

you can attach it with a tcode, so the process become easier.

Reward if useful

Regards

ANUPAM

paruchuri_nagesh
Active Contributor
0 Kudos

hi

user will not be having acces to SE16 & SE11 in production environment wnever user wnts to update the records

he can update database by using Table Miantanence Generator(SM30)

table maintanence generator updates database manuallly rather than programatically

Reawrd points for useful inputs

Regards

Nagesh.Paruchuri

Former Member
0 Kudos

hi

good

Table Maintenance Generator is used to create table

maintenance program to add, modify or delete records in the

database table. This can be accessed using transaction SE54

or in SE11 using the menu Utilities->Table Maintenance

Generator.

procedure

-


Please try this.

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

thanks

mrutyun^

0 Kudos

Hi,

u r right but two screen table maintenance step is better then single step maintenance, because one is for display screen and next is for multiple entry.

Former Member
0 Kudos

Hi

Table Maintenance Generator (TMG) is a tool which is used to create a equipment by which customized tables created by end users can be changed as required,such as making an entry to that table,deleating an entry etc.

Table maintenance is generally used when creatng maintaince view.To update the table u need to activate the table maintance generator,so that in the maintance view one can maintain the table.

http://help.sap.com/saphelp_nw04/helpdata/en/67/86b139415811d1893d0000e8323c4f/frameset.htm

0 Kudos

Fine

Table Maintenance Generator is not only for maintenance view as per client requirement we need to create Table Maintenance Generator in ztable also.

thanks

Former Member
0 Kudos

Hi,

we can create entries using Table maintenace also,

why we do this is u can insert only one record at a time in data dictionary where as by using TM u can insert multiple no of entries at a time and also u can delete or append records and also we can chage records.

In real time u get much use of this TM.

Transaction code for TM is sm 30.

first u specify the table maintence in database table in utilites then go to sm30 press maintain .

Former Member
0 Kudos

Table maintaenance is necessary if you are going to maintain mass data entries for a table this will be usefull in the production system for the user who do not have authorization For se11 and se16.

We can even maintain entries from se11 and se16 for a table if the table attribute is set as TABLE MAINTENACE ALLOWED.

Sathishkumar.V

Former Member
0 Kudos

Hi

check this link

http://fuller.mit.edu/misc/creating_sm30_transaction.htm

and start creating this as a part of exercise

and this will help u and guide u with screenshots

Hope this will help u if u try once with the creation and find wht it does

Reward points if useful

Regards

Sreenivas

Former Member
0 Kudos

Hi this answers ur question.

Table maintanance Generator is used to manually

input values using transaction sm30

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

3)

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

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

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

/message/2831202#2831202 [original link is broken]

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

with regards,

Hema Sundara.

pls give points if u find it helpful.