reg update

Former Member · ‎2008 Jan 08

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 · ‎2008 Jan 08

Hi,

Try using COMMIT WORK after update statement.

Regards,

Satish

Former Member · ‎2008 Jan 08

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 · ‎2008 Jan 08

loop at table into workarea.

update dbtable from workarea set field = workarea-field

where

workarea-field = ''.

thnkx

bhanu