Skip to Content
0
Former Member
Mar 26, 2010 at 11:19 AM

Updating a table using update

44 Views

Hello,

I have to update the BSEG table using the following update stmt.

UPDATE BSEG SET BUPLA = W_BUPLA

WHERE BUKRS = W_BUKRS

AND BELNR = W_BELNR

AND GJAHR = W_GJAHR

AND BUPLA EQ SPACE

AND QSSKZ NE SPACE .

For one invoice update ( i.e. one belnr value ) i can run the above stmt and it works fine. But if i have multiple invoice values saved in in internal table say it_invoice and i want to run a sinlge update for all invoice nos in it_invoice, keeping the other paramaters like w_bukrs, w_gjahr same, how do i do it?