topic Re: Changing the Existing Row's Data in Application Development and Automation Discussions

Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 04:40:12 GMT

Objective :

Change the data in a Existing row of a table

Problem.

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

thanks

prasad

Re: Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 05:42:48 GMT

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

Re: Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 05:58:00 GMT

Hi,

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

regards,

mahantesh

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

Re: Changing the Existing Row's Data

prasanth_kasturi — Fri, 30 May 2008 06:06:21 GMT

hi,

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

prasanth

Re: Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 06:31:05 GMT

Hi,

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.

Regards

Sayee

Re: Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 08:43:31 GMT

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

Thanks

Venugopal

Re: Changing the Existing Row's Data

Former Member — Fri, 30 May 2008 11:38:31 GMT

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

Re: Changing the Existing Row's Data

Former Member — Tue, 08 Jun 2010 06:32:30 GMT

Answered