topic Re: Update table VBAK in Application Development and Automation Discussions

Update table VBAK

Former Member — Thu, 20 Jul 2006 06:38:58 GMT

Hi All,

I have a record in vbak table . need to update only a few fields for this particular record. the fields to be updates are in a internal table .

how do i update the table so that only that record is changed ?

Thanks and Regards,

Amit

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 06:43:23 GMT

Hi ,

you can use following stmnt.

UPDATE <target> FROM TABLE <itab>.

Regards,

Sumit.

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 06:44:08 GMT

You have to use

MODIFY TABLE <itab> FROM <wa> [TRANSPORTING <f1> <f 2> ...].

The fields that u entered in TRANSPORTING only omdified.

Regards

Abhishek

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 06:47:18 GMT

You can use the MODIFY statement

MODIFY <TABLENAME> FROM <INTERNAL TABLE OR WORK AREA> TRANSPORTING FIELDS <F1> <F2>.

where the fields F1 , F2 are the fields you want to get uodated

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 06:55:39 GMT

Hi Amit,

Use the MODIFY option.

Inserts new lines or updates existing lines in a database table (s. relational database). If a line with the specified primary key already exists, an UPDATE is executed. Otherwise, an INSERT is performed.


MODIFY  vbak     FROM TABLE it_vbak.
IF sy-subrc EQ 0.
MESSAGE 'Table updated successfully' TYPE 'S'.
ENDIF.

Regards,

Arun S.

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 06:56:23 GMT

Hi All,

Thanks for the reply.

I can transport only the specified fields but these will be mass update . my internal table doesnt have primary key .where do i specify this ... so that only that record is updated ?

Thanks,

Amit

Re: Update table VBAK

former_member186741 — Thu, 20 Jul 2006 06:58:00 GMT

WHAT FIELDS DOES THE INTERNAL TABLE CONTAIN..... AND WHERE IS THE VBAK KEY FIELD HELD?

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 07:01:32 GMT

Then use UPADTE


UPDATE vbak    SET   <DB table field1> = <new value> 
               WHERE <DB table field2> =         <b>AND</b>
                     <DB table field3> =         .

Effect

WHERE condition

Updates only those lines which satisfy the

WHERE clause condition.

Regards,

Arun S.

Message was edited by: Arun Sambargi

Re: Update table VBAK

Former Member — Thu, 20 Jul 2006 07:08:34 GMT

fields in the internal table are from the append structure . key(vbeln) is available in a field which is not a part of internal table.