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