How to maintain SAP TABLES

Sometimes it becomes necessary to update that table without writing any report program. Here's how to do it!

In SAP you cannot maintain tables unless you have authorization. Like for ex. MARA, one can see the data but can't

modify the data itself. Sometimes it becomes necessary to update that table without writing any report program. Here's how to do it! The code below was written in v.4.6.


Goto se16 and give the table name DD02L. Press enter. In the table name, give the name of the table which is to be maintianed (ex. MARA). Press F8 or execute button. You will see the record corresponding to the table name. Double click on that. After that in the command field type /h and press enter 2 times. It will go into debug mode. Directly the currsor will come on the code show below.
" refresh exclude_tab.
if code = 'SHOW'.
set titlebar 'TAB' with name 'anzeigen'(100).
elseif code = 'EDIT'.
set titlebar 'TAB' with name 'andern'(101).
elseif code = 'INSR'.
"
in the field name type "code" and press enter. You will see the value of the code field to be as SHOW. Make it EDIT and press "Change FLD Contents" and press F8. Now you can edit the parameters of the table. There is one attribute of the table called as "Tab.Maint.Allowed" make that field as "X" and press F8. Now comeout and go into se16 again and now give the respective table name (in this case, MARA) so that you can make the changes there itself. If you want to remove the table maintainance option again, go into se16->DD02L->Double Click record->Debug Mode->make the "Tab.Main.Allowed" to ' '.

This was first published in July 2002

Dig deeper on SAP ABAP

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close