topic Re: updation in Application Development and Automation Discussions

updation

Former Member — Wed, 18 Feb 2009 06:14:34 GMT

hi all,

can anyone tell me how to update database table row by row???

Re: updation

Former Member — Wed, 18 Feb 2009 06:18:15 GMT

Hi,

try this code.



UPDATE t352r from  table it_rev   " t352r is the name of data bse  it_rev is the name of internal table

"or

UPDATE t352r from wa_rev   " t352r is the name of data bse  wa_rev is the name of work area

thanks

Arun

Edited by: Arun Kayal on Feb 18, 2009 7:19 AM

Re: updation

Former Member — Wed, 18 Feb 2009 06:19:39 GMT

This can be done using update statement inside a loop and using of where clause with the update statement.

Re: updation

Former Member — Wed, 18 Feb 2009 06:20:11 GMT

hi .

it is a sample code for update ztable

DATA: it_zsdo LIKE STANDARD TABLE OF zsdo WITH HEADER LINE,
      wa_it_zsdo LIKE zsdo,
      count_loop LIKE sy-tabix.
" Here i am updating zsdo u should change it according to ur need
SELECT * FROM zsdo
  INTO  CORRESPONDING FIELDS OF TABLE it_zsdo.
*  WHERE kunnr in sokunnr
*    and bsid in sobsid.
*  WHERE ssok = '1'.
BREAK-POINT.
LOOP AT it_zsdo INTO wa_it_zsdo.
*  count_loop = sy-tabix.


*  wa_it_zsdo-samp_flag = 'X'.
  MODIFY zsdo FROM wa_it_zsdo." INDEX count_loop.

ENDLOOP.
" Just paste in in editor window and execute it. after this it will update ur DB table

Re: updation

Former Member — Wed, 18 Feb 2009 06:23:38 GMT

USE UPDATE in loop.

Loop at itab in wa_itab.

update <database table> FROM <wa_itab>.

Endloop.

Amresh.

Re: updation

Former Member — Wed, 18 Feb 2009 06:24:17 GMT

Hi,

If you update ztable through internal table you will not get the success or failure update for individual record, but if you do record by record you will get update for each row.

Both statements will work it depends on your requirement and performance

Re: updation

Former Member — Wed, 18 Feb 2009 06:27:18 GMT

Hi,

[UPDATE|http://www.sapdb.org/7.4/htmhelp/34/ee7fba293911d3a97d00a0c9449261/content.htm]

Check with this link.

thanks,

Neelima.

Re: updation

Former Member — Wed, 01 Apr 2009 04:55:30 GMT

hi,

problem solved.

thanks