topic Re: modify database table in Application Development and Automation Discussions

modify database table

Former Member — Tue, 21 Nov 2006 11:32:48 GMT

Can anyone tell me How to modify the Database table using the internal table? I have to change only one field value of a particular row and column ?????

I have to use only Modify command …. I have done it with update ..it’s working but with modify it is changing the entire line of the database table which I m modifying .. as

I m passing only the primary keys and the fields to be edited …. What should I do now ??

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:36:27 GMT

Hi Nilesh,

Modify Command basically overwrites the value of existing fields with the new fields. Now since you are passing only the primary key & the fields to be edited, the statement considers all other fields as blank & so the database table also gets modified.

If u still need to use modify statement, first select the data from the database table into the internal table. Then modify the fields in the internal table & then modify the database table from the internal table.

Regards,

Chetan.

PS:Reward points if this is helpful.

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:37:56 GMT

if you have to modify a few fields then..

1. try to look for some stadard SAP ransaction.

because SAP do not recommend direct modifications

2. if there is no transaction or function module then read the table with primary keys it will fetch all the old values now first modify iternal table then use MODIFY table command to update database.

hope this helps

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:37:57 GMT

Declare internal table same as ur database table

then use

Modift ztable from table itab.

but ur modify statement will append a record if doesnt exist in database table , so safe to use UPDATE

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:39:35 GMT

Hi Nilesh,

First select the original data from the database table, make changes in required fields in the internal table & then modify.

When u say modify, it overwrites all the non key fields in the database table.

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:39:35 GMT

use the following logic

Select from (dbtable)

into (itab of same type as dbtable)

loop at itab into wa_itab.

change the values required

modify itab from wa_itab.

endloop.

modify (dbtable) from table itab.

This should solve your problem

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:41:00 GMT

modify <database> from <internal table>

or else

update <database> from <internal table> where <condition>

Re: modify database table

Former Member — Tue, 21 Nov 2006 11:53:48 GMT

Hi nilesh,

1. I have to change only one field value of a particular row and column ?????

a) First SELECT the data from DBTABLE for the corresponding record in

DTAB eg.

b) then change the value of the field in that DTAB.

c) then using loop

LOOP AT DTAB.

MODIFY ZTABLE FROM DTAB.

ENDLOOP.

d) DTAB should have same structure as that of ZTABLE.

regards,

amit m.

Re: modify database table

Former Member — Tue, 21 Nov 2006 12:08:56 GMT

To insert lines into a database table regardless of whether there is already a line in the table with the same primary key, use the following:

MODIFY target lines.

If the database table contains no line with the same primary key as the line to be inserted, MODIFY works like IINSERT - that is, the line is added.

If the database already contains a line with the same primary key as the line to be inserted, MODIFY works like UPDATE - that is, the line is changed.

You cannot change the value of a key field. Select to internal table, update data in internal table .

-Regards

charitha