01-08-2008 11:21 AM
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
01-08-2008 11:23 AM
01-08-2008 11:25 AM
UPDATE zinv_header SET invoice_core = p_perinv
invoice_created = inv_cnt
username = sy-uname
systemdate = sy-datum
systemtime = sy-uzeit WHERE MANDT = '001'.
01-08-2008 11:28 AM
loop at table into workarea.
update dbtable from workarea set field = workarea-field
where
workarea-field = ''.
thnkx
bhanu