topic Re: logic needed pls help in Application Development and Automation Discussions

logic needed pls help

Former Member — Tue, 19 Feb 2008 08:43:21 GMT

i need to update and the data base table using fiel symbol and i need to count the records

following is the code. pls hepl me.

FIELD-SYMBOLS : <fs_op> TYPE zfifn_op .

SELECT * FROM zfifn_op INTO TABLE zfifn_op_upd

WHERE opbel = itab_custom-opbel

AND bukrs = itab_custom-bukrs.

SORT zfifn_op_upd BY opbel.

LOOP AT zfifn_op_upd ASSIGNING <fs_op>.

READ TABLE itab_custom WITH KEY opbel = <fs_op>-opbel.

IF sy-subrc = 0.

<fs_op>-opbel = itab_custom-opbel.

ENDIF.

ENDLOOP.

UPDATE zfifn_op

FROM TABLE zfifn_op_upd.

COMMIT WORK AND WAIT.

Points will be reward

Re: logic needed pls help

JozsefSzikszai — Tue, 19 Feb 2008 08:48:10 GMT

hi Kumar,

while LOOPing the internal table you don't write back the changed values.

DATA : lv_tabix TYPE sy-tabix.

LOOP AT zfifn_op_upd ASSIGNING <fs_op>.

lv_tabix = sy-tabix.

READ TABLE itab_custom WITH KEY opbel = <fs_op>-opbel.

IF sy-subrc = 0.

<fs_op>-opbel = itab_custom-opbel.

MODIFY TABLE zfifn_op_upd FROM <fs_op> INDEX lv_tabix.

ENDIF.

ENDLOOP.

New lines are in bold.

hope this helps

Re: logic needed pls help

Former Member — Tue, 19 Feb 2008 08:52:07 GMT

I dont want to update the table one by one.

for example my file having 100,000 records means it ll affect performance. first i need to update structure. then i need to update data base table

Re: logic needed pls help

former_member416498 — Tue, 19 Feb 2008 08:52:39 GMT

Hi please see this sample code, might be useful.

1. For selecting data using field symbol.

SELECT * FROM

<db table name> INTO TABLE <fs_itab>.

2. Modify database table using field symbol.

MODIFY <db table name> FROM TABLE <fs_itab>.

Note: <fs_itab> is a field symbol of type any table.

Please get back if you need some more info.

Re: logic needed pls help

JozsefSzikszai — Tue, 19 Feb 2008 08:58:46 GMT

Kumar,

the changes I suggested only updates the internal table, other part of the source code has to remain the same (I just did not include them), only the LOOP is changed. this means the DB update will be in one go, like before. Pls. give it a try!

Re: logic needed pls help

Former Member — Tue, 19 Feb 2008 09:14:36 GMT

Your code looks absolutely correct. I tried following code bundle and it is working.

data: zfifn_op_upd like ztest125 occurs 0 with header line.

FIELD-SYMBOLS : <fs_op> TYPE ztest125 .

SELECT * FROM ztest125 INTO TABLE zfifn_op_upd

WHERE matnr = '22510G'.

SORT zfifn_op_upd BY matnr.

LOOP AT zfifn_op_upd ASSIGNING <fs_op>.

<fs_op>-mtart = 'HM01'.

ENDLOOP.

UPDATE ztest125

FROM TABLE zfifn_op_upd.

COMMIT WORK AND WAIT.

Thanks and regards,

Atanu