topic Re: UPDATE DATBASE TABLE in Application Development and Automation Discussions

UPDATE DATBASE TABLE

Former Member — Thu, 24 Aug 2006 04:55:26 GMT

All

I hv a transparent table ZVXXSAU with following fields

belnr-p.k.

blart-p.k.

gjhar

matnr

maktx

vbeln

flag

now i m fetching belnr,blart,gjahr into a int table ITAB

My problem :

If the data is Succesfully downlaode then i have to Set the value of flag in Database table ZVXXSAU-FLAG = X

for each downloaded data.

How can i do it.

i have used this query

LOOP AT T_ITAB

UPDATE ZVXXSAU

SET FLAG= 'X'

WHERE BELNR EQ ITAB-BELNR

AND BLART EQ ITAB-BLART .

i want to update table in single short..plz suggest best way to do it.

Thanks

Saurabh

Former Member — Thu, 24 Aug 2006 05:03:57 GMT

Hi,

Select * all the fields from the table ZVXXSAU and store it in the internal table ITAB.

Update the flag field with 'X'.

WA_ITAB-FLAG = 'X'.

MODIFY ITAB FROM WA_ITAB TRANSPORTING FLAG

WHERE FLAG = ' '.

UPDATE ZVXXSAU FROM TABLE ITAB..

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

Former Member — Thu, 24 Aug 2006 05:12:11 GMT

Hi Tiwari

Your code is right

only you might be missing the commit the changes.

regards

Dhananajy