topic update table in Application Development and Automation Discussions

update table

Former Member — Tue, 16 Oct 2007 10:04:46 GMT

Hi everyone,

I want a to update field Name_co value in ADRC table through a program for a customer.

Please help me in regard.

Thanks and regards,

Deepthi.

Former Member — Tue, 16 Oct 2007 10:06:41 GMT

UPDATE ADRC set NAME_CO = 'ABCD'

where ADDRNUMBER = '01234'.

COMMIT WORK.

Former Member — Tue, 16 Oct 2007 10:06:48 GMT

update adrc set name_co = <value> [where <condn>].

example

update adrc set name_co = 'ABC Ltd' Where name1 = 'Test1'.

Former Member — Tue, 16 Oct 2007 10:06:49 GMT

Please give me reward points..

former_member404244 — Tue, 16 Oct 2007 10:09:19 GMT

Hi,

Try like this..u can also do by use of BDC(which is better than updating directly).

data : i_adrc type table of adrc,

wa_adrc type adrc.

get the data in i_adrc.

loop at i_adrc into wa_adrc.

wa_adrc-Name_co = <gve the value>.

modify i_adrc from wa_adrc.

endloop.

modify adrc from table i_adrc..

reward if helpful.

Regards,

Nagaraj