How to maintain SAP TABLES

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

    Requires Free Membership to View

Click record->Debug Mode->make the "Tab.Main.Allowed" to ' '.

This was first published in July 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.