topic Updating a table using update in Application Development and Automation Discussions

Updating a table using update

Former Member — Fri, 26 Mar 2010 11:19:15 GMT

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?

Re: Updating a table using update

Former Member — Fri, 26 Mar 2010 11:30:22 GMT

Not sure why you're directly updating a database table...not a good practice...but...

You can loop at an internal table and (slowly) do what you're doing here, moving the table columns to the w_whatever work area.

For mass updates, I'd probably use MODIFY dtab from itab statement, but that would require some changes in your approach.

Re: Updating a table using update

former_member632458 — Fri, 26 Mar 2010 11:31:00 GMT

HI,

Use commit statement after Update.

Regards,

Rajesh S

Re: Updating a table using update

Former Member — Fri, 26 Mar 2010 11:31:17 GMT

It is as simple as it looks like

UPDATE BSEG FROM TABLE it_invoice

Updating the database table according to a where condition

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 .

Edited by: Bhanu Malik on Mar 26, 2010 12:31 PM

Re: Updating a table using update

Former Member — Fri, 26 Mar 2010 11:59:43 GMT

its not recommended to use update stmt to update SAP standard table..

Re: Updating a table using update

Former Member — Fri, 26 Mar 2010 12:06:17 GMT

Don't use update statement to directly update the database table. This will lead to inconsistent data.

Re: Updating a table using update

Former Member — Fri, 26 Mar 2010 13:40:19 GMT

Really bad idea - have you considered the effect on other tables like BSID?

Rob