topic Modify statement in Application Development and Automation Discussions

Modify statement

Former Member — Sun, 16 Jul 2006 05:04:34 GMT

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.

Re: Modify statement

Former Member — Sun, 16 Jul 2006 05:30:05 GMT

Hi shejal,

loop at t_period into wa_period where rvari_vnam = 'SAP_SCMA_PERIOD'.

t_period-poper = tvarvc-tvarv_val .

modify t_period from wa_period.

endloop.

Regards,

Azaz Ali.

Re: Modify statement

Former Member — Sun, 16 Jul 2006 05:31:07 GMT

Hi,

Note: dont forget to declare work area wa_period for the above code.

Re: Modify statement

Former Member — Sun, 16 Jul 2006 05:36:00 GMT

Thanks Azaz,

I will try and would get back.

Shejal.

Re: Modify statement

Former Member — Sun, 16 Jul 2006 06:02:28 GMT

Hi Shejal,

The update statement will be like

UPDATE tvarvc

SET tvarv_val = t_period-poper

WHERE rvari_vnam = 'SAP_SCMA_PERIOD'.

What i feel is, here the database table where condition is rvari_vnam = 'SAP_SCMA_PERIOD' , since internal table doesnt contain this field name, instead of using the internal table you can use data field then the update statement will be like

UPDATE tvarvc

SET tvarv_val = variable name

WHERE rvari_vnam = 'SAP_SCMA_PERIOD'.

Regards

Arun

Re: Modify statement

Former Member — Sun, 16 Jul 2006 06:32:10 GMT

Hi Shejal,

FYI..

The following statement in the above code,

t_period-poper = tvarvc-tvarv_val .

tvarvc-tvarv_val means the value which you want to pass to field poper declared in internal table t_period depending on your requirement.

Regards,

Azaz Ali.

Re: Modify statement

Former Member — Sun, 16 Jul 2006 06:44:07 GMT

Thanks Friends,

Shejal.