How to directly edit contents of a table?

[Former Member]

Hello,

Does anyone know the transaction I can use to directly change the data in a table? I have been writing small ABAP programs to do this, but I was wondering if there was a utility transaction that allows viewing and changing table data directly.

Thanks for your help.

[Former Member]

well for tables you can generate a maintaining-view, using TA SE56.

well you CAN use TA SE16, SE16N or N as well, tho there you really should KNWO what you do.

[Former Member]

If they are custom tables it's quite easy...save the table update generator and go to SM30 and in the table properties don't forget to add update admitted.

For standard one I don't think it's possible.

Regards

[Former Member]

Hi larry,

You cannot change data of each and every table dircectly..

1) if the table maintenance is maintained for that table then you can go to SM30 and give the table name and click on maintain and you can change the values.

2) if table maintenance in not maintained.. then go to se16 . enter your table name .. hit execute... you will see the entries.. double click on the record that you want to change .. in the command box give '/H' "Debuggin on" and hit enter 2 times. it will take you to debugging.. you will see some code where ur program stops

refresh exclude_tab.

if code = 'SHOW'.

set titlebar 'TAB' with name 'anzeigen'(100).

elseif code = 'EDIT'.

set titlebar 'TAB' with name 'ändern'(101).

elseif code = 'INSR'.

set titlebar 'TAB' with name 'einfügen'(102).

elseif code = 'ANVO'.

set titlebar 'TAB' with name 'einfügen'(102).

elseif code = 'DELE'.

set titlebar 'TAB' with name 'löschen'(103).

here code variable hold the value SHOW..

in the debugging screen under field name give code and change the value of that variable to EDIT and say f8 and you will see the complete record in the edit mode you can change and save..

3) through the program that you are already doing

Thanks

Mahesh

[Former Member]

The solution from <b>'I Can Solve It'</b> is what we use most of the times.

Just a word of caution on that: making changes in the debugger are sometimes not allowed in the production systems. If that is the case then using other transactions (SM30, SE56, SE16N etc) is the only option. Even if it is allowed, all changes made using debugger are logged in the system and <b>auditors</b>, at a later time, may raise questions about such changes if they are not supported by proper approvals and documentation.

[Former Member]

<b>Hi Larry,</b>

<u><b>Follow the following steps:</b></u>

<b>Step 1.</b>

<i><b>When you create your table, allow table manatance when save the the 'technical settings'</b></i>.

<b>Step 2.</b>

<i><b>Create a maintance view of that table.</b></i>

<b>Step 3.</b>

<i><b>Then through se16 you would be allowed to change the data directly.</b></i>

<i><b>Reward point if find helpful

Debjani Lahiri</b></i>