Skip to Content
0
Former Member
Jul 16, 2006 at 05:04 AM

Modify statement

238 Views

HI friends,

I want to modify the data base table and need to modify only one field by checking another field in the same database table. However i need to modify through an internal table and my internal table has many fields.

Here is the code that i am using.

DATA : BEGIN OF t_period OCCURS 0,

bdatj TYPE bdatj,

bumon TYPE bumon,

butag TYPE butag,

poper TYPE poper,

END OF t_period.

t_period is the internal table.

UPDATE tvarvc-tvarv_val values t_period-poper

WHERE tvarvc-rvari_vnam = 'SAP_SCMA_PERIOD'.

here TVARVC is my database table

Thanks ,

Shejal.