topic Re: diff between update and modify stmt in Application Development and Automation Discussions

diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 11:48:03 GMT

what is the difference between update and modify stmt

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 11:54:51 GMT

Hi,,

Update stmt will update the database only when there is similar record...

it will fail when there no record to change..

modify will change the already existing record as update when it already exists but also will add the record if it were not present

santhosh

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 11:55:24 GMT

refer this thread.

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 11:55:28 GMT

update : it shud hv an entry in db table to update.

modify: its not req for the db table/ internal table to have an entry. if the entry matching the condition doesnt exist. it will insert a new record.

u can chk this thread too:

https://www.sdn.sap.com/irj/sdn/profile?userid=3609550

reward if helpful

regards,

madhu

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 11:56:41 GMT

Hi,

Modify statement works as INSERT statement as well as UPDATE statement.

UPDATE: update if the record already exists.

MODIFY: if the record exists modify works like UPDATE. else it Inserts the record.

Regards,

Suresh

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 12:07:44 GMT

Hi,

Update you can change database primary key value which is not

possible with modify.

modify updates database when record exist else inserts new record

and also used in internal table operations.

update modified database table only when entry exist.

while using update clause use where condition else it updates all records

of table.

Regards,

Amole

Regards

Amole

Re: diff between update and modify stmt

Former Member — Fri, 27 Apr 2007 19:49:57 GMT

Hi,

In ABAP language, Update statement means you are going to update a record that is already existing in the database table. For MODIFY statement, it is not necessary that a record must exist in the database table. Even if it is not existing then the statement will insert that record into the database table.

thanks,

sksingh

Re: diff between update and modify stmt

Former Member — Mon, 30 Apr 2007 09:38:21 GMT

Hi Jyothsna,

Go through this info.

Creating Data Objects Dynamically

All of the data objects that you define in the declaration part of a program using statements such as DATA are created statically, and already exist when you start the program. To create a data object dynamically during a program, you need a data reference variable and the following statement:

CREATE DATA <dref> TYPE <type>|LIKE <obj>.

This statement creates a data object in the internal session of the current ABAP program. After the statement, the data reference in the data reference variable <dref> points to the object. The data object that you create does not have its own name. You can only address it using a data reference variable. To access the contents of the data object, you must dereference the data reference.

You must specify the data type of the object using the TYPE or LIKE addition. In the TYPE addition, you can specify the data type dynamically as the contents of a field (this is not possible with other uses of TYPE).

CREATE DATA <dref> TYPE (<name>).

Here, <name> is the name of a field that contains the name of the required data type.

1. IF you want to change the values without modify:

First take that row into other work area change whatever values you want to change in work area by using "MOVE" statement ,delete previous row from internal table and by using "INSERT" statement insert the workarea row into that internal table..

Update you can change database primary key value which is not

possible with modify.

modify updates database when record exist else inserts new record

and also used in internal table operations.

update modified database table only when entry exist.

while using update clause use where condition else it updates all records

of table.

Don't forget to reward if useful...

Rgds,

P.Naganjana Reddy

Re: diff between update and modify stmt

Former Member — Mon, 30 Apr 2007 09:43:01 GMT

Hi Jyothsna

Inserting or Changing Lines

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

For performance reasons, you should use MODIFY only if you cannot distinguish between these two options in your ABAP program.

You can add or change one or more lines <lines> in a database table <target>. You can only insert or change lines in an ABAP Dictionary view if it only contains fields from one table, and its maintenance status is defined as Read and change. You may specify the database table <target> either statically or dynamically.

Specifying a Database Table

To specify the database table statically, enter the following for <target>:

MODIFY <dbtab> [CLIENT SPECIFIED] <lines>.

where <dbtab> is the name of a database table defined in the ABAP Dictionary.

To specify the database table dynamically, enter the following for <target>:

MODIFY (<name>) [CLIENT SPECIFIED] <lines>.

where the field <name> contains the name of a database table defined in the ABAP Dictionary.

You can use the CLIENT SPECIFIED addition to disable automatic client handling.

Inserting or Changing Single Lines

To insert or change a single line in a database table, use the following:

MODIFY <target> FROM <wa> .

The contents of the work area <wa> are written to the database table <dbtab>. The work area <wa> must be a data object with at least the same length and alignment as the line structure of the database table. The data is placed in the database table according to the line structure of the table, and regardless of the structure of the work area. It is a good idea to define the work area with reference to the structure of the database table.

If the database table does not already contain a line with the same primary key as specified in the work area, a new line is inserted. If the database table does already contain a line with the same primary key as specified in the work area, the existing line is overwritten. SY-SUBRC is always set to 0.

A shortened form of the above statement is:

MODIFY <dbtab>.

In this case, the contents of the table work area <dbtab> are inserted into the database table with the same name. You must declare this table work area using the TABLES statement. In this case, it is not possible to specify the name of the database table dynamically. Table work areas with the same name as the database table (necessary before Release 4.0) should no longer be used for the sake of clarity.

Inserting or Changing Several Lines

To insert or change several lines in a database table, use the following:

MODIFY <target> FROM TABLE <itab> .

Those lines of the internal table <itab> for which there is not already a line in the database table with the same primary key are inserted into the table. Those lines of the internal table <itab> for which there is already a line in the database table with the same primary key overwrite the existing line in the database table. The same rules apply to the line type of <itab> as to the work area <wa> described above.

SY-SUBRC is always set to 0. SY-DBCNT is set to the number of lines in the internal table.

Regards Rk