hi guru's what is yhe difference bitween modify and update

[Former Member]

hi guru's what is yhe difference bitween modify and update

[sreeramkumar_madisetty]

Hi sri

Modify : if record exists , it will modify

Update: if record exists , it will modify otherwise it will create the record.

Regards,

Sree

[Former Member]

Hi,

have a look at this link for details,

For MODIFY.

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/Utilities/AB...

For UPDATE,

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/Utilities/AB...

[Former Member]

Simply press F1 on both.

Rob

[Former Member]

Update- Updates the database table. Can use a WHERE condition also

Modify- If the record is present in the database table it performs the update

function. If there is no record then it inserts a new record.

Modify can be used for an internal table. In internal tables, only one field of a particular record can be modified using TRANSPORTING statement

But there is no Update statement for an internal table.

[Former Member]

Modify will modify and Update will modify if it exists or will create the record

Modify can be done on both internal tables and database tables but Update is not possible on internal table

Prince

[Former Member]

Hi,

MODIFY will insert record if the row is not there in the table.

UPDATE will not insert record if the row is not there in the table. It will return sy-subrc to 4.

In UPDATE you can update specific fields using SET addition.

Reward if helpful.

Regards,

Harini.S

[Former Member]

Hi Sri,

1) Update will only update the record in teh database table ,depending upon the condition u specified in the update command.

it will fail if the record does not exists in the table..mean to say it wil return Sy-subrc as zero then.

2) Modify - will do an update if record exists otherwise it wil create a new record in db table if record does not exists.

Press F1 in ur code on Update or MOdify ,u will find more on that

Reward points, if useful..

Regards,

Nitin

[Former Member]

<a href="http://www.sapinfo.quotaless.com/lesson_49.htm">MODIFY</a>

<a href="http://www.sapinfo.quotaless.com/lesson_57.htm">UPDATE</a>