topic Re: reg update in Application Development and Automation Discussions

reg update

Former Member — Tue, 08 Jan 2008 11:21:36 GMT

hi all

UPDATE TABLE zinv_header .

SET invoice_core = p_perinv

invoice_created = inv_cnt

username = sy-uname

systemdate = sy-datum

systemtime = sy-uzeit.

this statement is not working, so i add a field mandt in the z table. i have to give the where condition, how can i give?

support please

regards

karthik

Former Member — Tue, 08 Jan 2008 11:23:35 GMT

Hi,

Try using COMMIT WORK after update statement.

Regards,

Satish

Former Member — Tue, 08 Jan 2008 11:25:01 GMT

UPDATE zinv_header SET invoice_core = p_perinv

invoice_created = inv_cnt

username = sy-uname

systemdate = sy-datum

systemtime = sy-uzeit WHERE MANDT = '001'.

Former Member — Tue, 08 Jan 2008 11:28:23 GMT

loop at table into workarea.

update dbtable from workarea set field = workarea-field

where

workarea-field = ''.

thnkx

bhanu