update statement where condtion

Former Member — Fri, 14 Nov 2008 04:56:00 GMT

HI,

I am using update statement in the Z table.Please find the code for refrence

LOOP AT g_tait_control_itab2 INTO g_tait_control_wa .

READ TABLE it_panel INTO wa_panel WITH KEY quantity = g_tait_control_wa-quantity.

IF sy-subrc NE 0.

UPDATE zsd_tab_pan_bid SET quantity = g_tait_control_wa-quantity

WHERE sno = g_tait_control_wa-sno

AND panel = g_tait_control_wa-panel

AND speck = g_tait_control_wa-speck

AND make = g_tait_control_wa-make

AND rate = g_tait_control_wa-rate

AND curr = g_tait_control_wa-curr

AND itemnum = g_tait_control_wa-itemnum

AND tendernum = pa_tend.

endloop.

while excuting this code my where condtion is mismatching.I am not getting exact values of Z tables that are in the work area of internal table it is taking the first value of the Z table.

Please suggest me how to match exact where condtion of Z table

Thanks in advance correct inputs are rewarded

Rasheed

Re: update statement where condtion

Former Member — Fri, 14 Nov 2008 09:05:48 GMT

Hi Check this

PARAMETERS: table TYPE c LENGTH 30,

column TYPE c LENGTH 30,

old_curr TYPE sycurr.

DATA: set_expr TYPE string,

condition TYPE string.

CONCATENATE column ` = 'EUR'`

INTO set_expr.

CONCATENATE column ` = old_curr`

INTO condition.

TRY.

UPDATE (table)

SET (set_expr)

WHERE (condition).

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Error in update!` TYPE 'I'.

ENDTRY.

Hope this helps,

Murthy.

topic update statement where condtion in Application Development and Automation Discussions

update statement where condtion

Re: update statement where condtion