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: 

Table Maintenance

Former Member
0 Kudos

Hi,

Plz tell me how to create Table Maintenance for a table .

Thanks

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi Uday,

Go to Se11

create Ztable .

Save and Activate it.

Goto Utilities menu->Table maintenance Generator

Give &NC& in Authorization group.

Give Function group name( anything starting with 'Z ' )

Select maintenance step : One step

under Maint. Screen No. :Overview screen = 1.

Single screen = 0.

under recording routine : selectNo,or user, recording routine.

Click on create button on application tool bar.

<b><i>Reward points if useful</i></b>

Chandra

7 REPLIES 7

former_member404244
Active Contributor
0 Kudos

Former Member
0 Kudos

Hi,

Table maintanance Generator is used to manually

input values using transaction sm30.The 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

follow below steps

go to se11 check table maintanance check box under

attributes tab

utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

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

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.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=...

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Regards,

Priyanka.

Former Member
0 Kudos

hi Uday,

Go to Se11

create Ztable .

Save and Activate it.

Goto Utilities menu->Table maintenance Generator

Give &NC& in Authorization group.

Give Function group name( anything starting with 'Z ' )

Select maintenance step : One step

under Maint. Screen No. :Overview screen = 1.

Single screen = 0.

under recording routine : selectNo,or user, recording routine.

Click on create button on application tool bar.

<b><i>Reward points if useful</i></b>

Chandra

former_member15255
Active Participant
0 Kudos

1 Create Function group thru SE37

2 Goto Se11

3 Enter table name

4 Click on Change

5 In the Utilities->Table Maintenance Generator

6 Enter Authorization group as &NC&

7 Enter Function group created

8 click on the find screen number

9 Click on the New Button this wud create a table maintainance generator

Regards

Suresh

andreas_mann3
Active Contributor
0 Kudos

use tcode se54

A.

Former Member
0 Kudos

Hi Uday,

Refer to the blog updated by me.

http://theguruspeaksaboutsap.blogspot.com/2007/07/table-maintenance-in-sap-step-by-step.html

Reward if helpful.

Regards,

Harini.S