UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

[Former Member]

Hi,

can any one tell me how to update database table with only those fields that have received a new value in the dialog screen(0100)

thanks

[Former Member]

Hi Bobby,

Once you identify the rows/data changed in your table.. you can use the below statement for updation in table

UPDATE dbtab FROM TABLE itab.

Effect

Mass update of several lines in a database table. Here, the primary key for identifying the lines to be updated and the values to be changed are taken from the lines of the internal table itab . The lines of the internal table must satisfy the same conditions as the work area wa in addition 1 to variant 2.

The system field SY-DBCNT contains the number of updated lines, i.e. the number of lines in the internal table itab which have key values corresponding to lines in the database table.

The return code value is set as follows:

SY-SUBRC = 0 All lines from itab could be used to update the database table.

SY_SUBRC = 4 At least one line of the internal table itab in the database table, had no line with the same primary key. The other lines of the database table were updated.

Regards,

Raj

[Former Member]

Hi,

By using UPDATE you an do this.

For updating particluar value use UPDATE <table> set (valus)

where <use key>. For more information use F1 Help.

Thnaks,

saleem.