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 generator for standard table

Former Member
0 Kudos

hi

can we create table maintenance geerator for standard tables

if so what are the parameters we need to check before creation

4 REPLIES 4

Former Member
0 Kudos

go to sm30 -> enter your table name -> click on maintain

You will be taken to an overview screen..click on the change button and change the record,save it and come out..data will be changed

if table maintainance is not there in SM30 when you enter the table name and click on display a message will be displayed

to create a table maintainance go the se11->enter table name -> display -> on the top menu click on Utilities -> "Table maintainance Generator"

it will take you to a different screen

enter authorisation group..if you dont have any enter &NC&

A function group needs to be assigned here ...so when you create a function group the screens(which is given below) will be saved in this function group

In 1 step maintainance you will have an overview screen as a table control where you can enter values where as in 2 step there is an overview screen and another screen which contains only record at a time which can be changed

click on either one and click on "find scr.numbers" on the top to automatically fill the screen number..you can give manually but it the function group contains a screen already then it will give a message and we need to change it

Click on create..SAve and activate whenever prompted..

once done successfully if you go to SM30 and enter table name and click on "maintain" you can change the values of any record in that table...

Former Member
0 Kudos

hi,

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

refer to::

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

or refer to:

hope this helps you...

regards,

praveena.

Former Member
0 Kudos

Hi Ram,

Table Maintenance generator is required to do Manual entries in the Table. If the requirement is to update the table only programmatically and not manually then table maint. generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified ) using transaction SM 30, if the table maintenance for the table is generated.

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

chk a sample 1.

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

some more helps

Check out this thread:

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Regards

Kiran Sure

Former Member
0 Kudos

It is possible to create table maintenance for SAP standard table in two steps:

1) use SE11 to create maintenance view (radio button "View" --> "Maintenance View") - in "Table/Join conditions" tab list "Tables" specify SAP standard table to maintain. Activate view object.

2) still being in maintenance view window go to Utilities menu and choose "Table maintenance generator", enter required values (auth. group, function group, etc.) and save. Now it is possible to maintain SAP standard table through SM30.