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: 

How to directly edit contents of a table?

Former Member
0 Kudos
9,165

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
2,365

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

5 REPLIES 5

Former Member
0 Kudos
2,365

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
0 Kudos
2,365

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
0 Kudos
2,366

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

0 Kudos
2,365

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
0 Kudos
2,365

<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>