topic Re: MODIFY in Application Development and Automation Discussions

MODIFY

Former Member — Tue, 26 Jun 2007 10:10:46 GMT

HI,

WHAT IS THE DIFF B/W MODIFY AND UPDATE

THANK YOU

ASHOK KUMAR

Re: MODIFY

former_member491305 — Tue, 26 Jun 2007 10:12:32 GMT

Hi Ashok,

Update:It will update the table records only if there is entry in the table.

Modify:It will update the table records ,if there is entry in the table.If not then it will insert that record.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:13:05 GMT

hi,

Modify will update already exitsing record, create a new record if it not already exits in databse.(it work both functional create ,update)

Update will update if it already exits in databse.

Regards,

Richa

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:14:32 GMT

HI.

Modify:it will update already exitsing record,create new one if it not already exits in databse.(it work both functional create ,update)

Update:update if it already exits in databse.

Rewards all helpfull answers.

Regards.

Jay

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:15:18 GMT

Hi,

Update

It will update the table records only if there is entry in the table.

Modify

It will update the table records ,if there is entry in the table.If not then it will insert that record.

Regards,

Ranjit Thakur.

Please Mark The Helpful Answer.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:16:10 GMT

HI,

see this link

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/modify_d.htm

rgds,

bharat.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:22:45 GMT

HI ,

I MY TABLE NO DATA IS FOUND . BUT IA USING UPDATE WHAT WILL HAPPENS

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:24:39 GMT

Hi.

It will insert a new record.

Reward if helpful.

Regards,

Umasankar.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:35:23 GMT

Update:It will update the table records only if there is entry in the table.

Modify:It will update the table records ,if there is entry in the table.If not then it will insert that record.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:36:36 GMT

If there is no record, and you are using update

it will not update . ( Coz there is no entry )

here sy-subrc will be set other than zero .

Here you need to use 'modify'.

it will insert the same record .

modify = update + insert

~ Laxmi

Reward helpful answers

Re: MODIFY

former_member491305 — Tue, 26 Jun 2007 10:36:56 GMT

Hi Ashok,

If you are updating a table using Update statement and assume that no records is there in that table,then the update statement willl return sy-subrc = 4 which means that no record is updated or inserted.

Re: MODIFY

jayanthi_jayaraman — Tue, 26 Jun 2007 10:37:41 GMT

Hi,

Data will be inserted.Sy-subrc eq 4.

If you use modify,data will inserted in such a situtation.

data : itab type standard table of mara,

wa type mara,

wa1 type mara.

select * from mara into table itab.

loop at itab into wa.

wa-matnr = '12345'.

modify mara from wa.

commit work.

exit.

endloop.

Re: MODIFY

Former Member — Tue, 26 Jun 2007 10:39:00 GMT

Hello Ashok,

update is to update table entries.

modify is also to update the table entries... if no record is there it will insert new record.

Regards

Sasidhar Reddy Matli.

Re: MODIFY

Former Member — Thu, 08 May 2008 14:54:38 GMT

Re: MODIFY

Former Member — Thu, 08 May 2008 14:58:21 GMT

sounds that MODIFY is better and should always be used, but that is not true. Why not?

Re: MODIFY

christine_evans — Thu, 08 May 2008 16:50:15 GMT

Because MODIFY is a bit more expensive because it has to check whether the record exists or not before it tries to update or insert it? But I would have thought that the extra time taken would be miniscule and hardly noticeable. Though that would depend on the number of records you were updating..

In some situations, you need to do different things when you insert or update, and MODIFY wouldn't be any good then.

Re: MODIFY

Former Member — Thu, 08 May 2008 17:23:16 GMT

If the report you are creating will be used for changing values in a table and you aren't sure if the record exist in a table, you should user MODIFY. You have to be aware that MODIFY only changes values in fields that aren't key fields, otherwise the record would be inserted in the table instead of be updated.

But, if the report will be used only for changing values in a table, you should use UPDATE.