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.
Showing results for 
Search instead for 
Did you mean: 

Changing the Existing Row's Data

Former Member
0 Kudos

Objective :

Change the data in a Existing row of a table


I am unable to change an existing row's data

I think it is in inactivate state

please provide me a solution for my query




Former Member
0 Kudos

If you are changing the eixting row of the database table,

try to specify all the key fileds and se the MODIFY statement in the code.

Reward me if this is usefull !!!!

Former Member
0 Kudos


You have to delete the existing row and add the new one.

You can do easily using SM30 for this you have generate the Table Maintainance.

Or you can do it using the program, read the data and using the modify statement you can do it..



Edited by: Mahantesh Patil on May 30, 2008 7:58 AM

Active Contributor
0 Kudos


you can change from se11

firstle check is the table in display or change mode. if in display goto change mode

after you display the values check the check box by the side of the row you want to change and press change(f6) you can change values except the primary key values

or if you have TMG you can do the same from sm30

you can write a cusrtom program and change the values using modify statement

if you want to change the primary key values you must delete rhe row and enter new row thats only way

reward if helpful


Former Member
0 Kudos


Possible reasons could be:

1. As you said the table whose records you are trying to modify the data, may be inactive.

2. We will not be able to change the contents of a table if the table view maintenance is not specified as display/maintenance allowed.

So check for these points.

3. If you dont find any problem with the table view maintenance, then check for your code whether you have used the modify statement specifying all the key fields.



Former Member
0 Kudos

hi lakshmi prasad,

are you trying to change data of an existing row of a n internal table in a report.

then comment the MODIFY statement line and then activate the report.

then once again uncomment the MODIFY statement and use it like

MODIFY internal tabel from Work are transporting <MATNR> - if you are modifying MATNR field.

Hope this will resolve your problem or do explain us in more detals where exactly you are facing the problem.

Encourage others in answering your queries by suitably rewarding them



Former Member
0 Kudos

use update statement with where condition on active database table..

Former Member
0 Kudos