topic Re: how to write MODIFY to update data into the data base table in Application Development and Automation Discussions

how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:48:41 GMT

plz send me code.

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:50:11 GMT

Changing a database table

- MODIFY dbtab FROM wa.

- MODIFY (dbtabname) FROM wa.

- MODIFY dbtab FROM TABLE itab.

- MODIFY (dbtabname) FROM TABLE itab.

- MODIFY dbtab.

- MODIFY *dbtab.

- MODIFY dbtab VERSION vers.

- MODIFY *dbtab VERSION vers.

Changing an internal table

- MODIFY itab [FROM wa] [INDEX idx] [ASSIGNING <fs>|REFERENCE INTO dref] [TRANSPORTING f1 ... fn].

- MODIFY TABLE itab [FROM wa] [ASSIGNING <fs>|REFERENCE INTO dref] [TRANSPORTING f1 ... fn].

- MODIFY itab [FROM wa] TRANSPORTING f1 ... fn WHERE cond.

Changing a list line

- MODIFY LINE n.

- MODIFY LINE n OF CURRENT PAGE.

- MODIFY LINE n OF PAGE m.

- MODIFY CURRENT LINE.

Changing the properties of a screen field

- MODIFY SCREEN.

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:51:12 GMT

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

Re: how to write MODIFY to update data into the data base table

sreeramkumar_madisetty — Mon, 23 Apr 2007 09:52:02 GMT

By writing the MODIFY command in the ABAP Editor and press F1.

You can get the complete help on that key word including with syntaxes.

Regards,

Sreeram

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:52:57 GMT

HI,

*Modify from internal table

Modify mara from table it_mara. "should be of same structure

*Modify from work area

Modify mara from wa_mara. "should be of same structure

reward if useful

regards,

nazeer

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:53:17 GMT

hi,

check out sample coding:

MODIFY <tabname> FROM <workarea>.

MODIFY <tabname> FROM table <internal table>.

regards,

Navneeth.K

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:53:50 GMT

hi,

modify wil insert the value if its not in DB otherwise it will update the fields which is mentioned in it....

data: itab like mara occurs 0 with header line.

itab-matnr = 10.

itab-ernam = 'john'.

..........................

modify mara from itab. *itab is an internal table

data wa type mara.

wa-matnr = 10.

wa-ernam = 'john'.

..........................

modify mara using wa *where wa is external work area

reward if this helps u

ravi

Message was edited by:

ravi r

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:54:11 GMT

Hi nagalakshmi,

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

Don't forget to reward if useful...

Rgds,

P.Naganjana Reddy

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:54:34 GMT

Hi,

Here you will get all syntaxes as per your requirement..

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.

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

A shortened form of the above statement is:

MODIFY <dbtab>.

Inserting or Changing Several Lines

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

MODIFY <target> FROM TABLE <itab> .

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

Don't forget to reward if useful

Re: how to write MODIFY to update data into the data base table

Former Member — Mon, 23 Apr 2007 09:56:31 GMT

Hi Nagalakshmi,

Check this info.

MODIFY:

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.

UPDATE:

The Open SQL statement for changing data in a database table is:

UPDATE <target> <lines>.

It allows you to change one or more lines in the database table <target>. You can only 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.

In Brief,

UPDATE is only for database tables updation.

But MODIFY can be used to Modify Database tables, Internal Tables, Output Lists, and also for changing screen attributes.

Hope this resolves your query.

<b>Reward all the helpful answers.</b>

Regards