topic Re: update the table in Application Development and Automation Discussions

update the table

Former Member — Thu, 13 Dec 2007 09:21:52 GMT

hi guyz ,

i wanna update the table with cancellation code in the table...this is my code..structure contains the updated field but table doesnt...

LOOP AT gt_header INTO gs_header.

IF NOT gs_header-to_number IS INITIAL.

gs_header-canx_code = '99'.

ELSE.

gs_header-canx_code = '00'.

ENDIF.

ENDLOOP.

CHECK NOT gt_header[] IS INITIAL.

UPDATE ztcptab_orderhdr FROM TABLE gt_header.

IF sy-subrc = 0.

COMMIT WORK AND WAIT.

ENDIF.

Thanks

Re: update the table

amit_khare — Thu, 13 Dec 2007 09:25:03 GMT

You need to modify the internal table first with structure.

LOOP AT gt_header INTO gs_header.

IF NOT gs_header-to_number IS INITIAL.

gs_header-canx_code = '99'.

ELSE.

gs_header-canx_code = '00'.

ENDIF.

modify gt_header by gs_header transporting canx_code.

ENDLOOP.

Re: update the table

former_member386202 — Thu, 13 Dec 2007 09:30:16 GMT

Hi,

Try like this

&----

*& Form SUB_READ_UPDATE_BSEG

&----

text

----

FORM sub_read_update_bseg.

IF NOT it_final[] IS INITIAL.

LOOP AT it_final INTO wa_final.

UPDATE bseg SET zuonr = wa_final-ccnum

WHERE bukrs EQ wa_final-bukrs

AND belnr EQ wa_final-vbeln

AND rfzei EQ wa_final-rfzei

AND saknr NE ' '.

ENDLOOP.

*--Message data updated successfully

MESSAGE i888 WITH text-002.

LEAVE LIST-PROCESSING.

ELSE.

*--Message No data found

MESSAGE i888 WITH text-003.

LEAVE LIST-PROCESSING.

ENDIF.

ENDFORM. " SUB_READ_UPDATE_BSEG

Regards,

Prashant

Re: update the table

Former Member — Thu, 13 Dec 2007 09:30:34 GMT

Hi Sudheer,

Try this,

LOOP AT gt_header INTO gs_header.

IF NOT gs_header-to_number IS INITIAL.

gs_header-canx_code = '99'.

ELSE.

gs_header-canx_code = '00'.

ENDIF.

ENDLOOP.

CHECK NOT gt_header[] IS INITIAL.

MODIFY ztcptab_orderhdr FROM gt_header.

IF sy-subrc = 0.

COMMIT WORK AND WAIT.

ENDIF.

Please make sure that before modifying , you use dequeue and enqueue to avoid locking of tables.

Reward if useful.

Regards,

Chitra

Re: update the table

Former Member — Thu, 13 Dec 2007 09:37:56 GMT

Use Modify statement instead of Update and lock the table using Enque before modifying it.

Re: update the table

Vijay — Thu, 13 Dec 2007 09:40:49 GMT

try like this if u have multiple records in gt_header

create another internal table gt_header1 of type gt_header.

______________________________________________________________

LOOP AT gt_header INTO gs_header.

IF NOT gs_header-to_number IS INITIAL.

gs_header-canx_code = '99'.

ELSE.

gs_header-canx_code = '00'.

ENDIF.

append gs_header to gt_header1.

ENDLOOP.

CHECK NOT gt_header1[] IS INITIAL.

UPDATE ztcptab_orderhdr FROM TABLE gt_header1.

IF sy-subrc = 0.

COMMIT WORK AND WAIT.

ENDIF.

______________________________________________________________

regards

vijay

reward points if helpfull