topic Re: IN UPDATE TASK in Application Development and Automation Discussions

IN UPDATE TASK

Former Member — Mon, 25 Jun 2007 05:17:08 GMT

I have written commit work inside the calling program but my database table is not getting updated with new value ie 30. Please help me.

report zfuncton_update.

CALL FUNCTION 'ZUPDATE' in update task

EXPORTING

ITEM = 30.

commit work.

data: itab1 type standard table of zupdatetable1, “ Zupdatetable1 is my database table containing only 2 fields MANDT and POSNR.

wa_itab1 type zupdatetable1.

select * from zupdatetable1 into corresponding fields of table itab1.

loop at itab1 into wa_itab1.

write: / wa_itab1-posnr.

endloop.

And following is my ‘ZUPADTE’ FM

FUNCTION ZUPDATE.

*"----

""Update Function Module:

""Local Interface:

*" IMPORTING

*" VALUE(ITEM) TYPE POSNR

*"----

data: itab type standard table of zupdatetable1,

wa_itab type zupdatetable1 .

wa_itab-posnr = item. “ item is of type POSNR and I have declared it as an import parameter in Zupdate FM

append wa_itab to itab.

update zupdatetable1 from table itab .

ENDFUNCTION.

Regards,

ravish

Re: IN UPDATE TASK

former_member150733 — Mon, 25 Jun 2007 05:18:46 GMT

Have you marked the FM: ZUPDATE as an update function module in the FM attributes Tab?

Re: IN UPDATE TASK

Former Member — Mon, 25 Jun 2007 05:20:11 GMT

Hi,

After

update zupdatetable1 from table itab .

Try with writing commit-work.

May be this serves your purpose.

Reward if useful!

Re: IN UPDATE TASK

Former Member — Mon, 25 Jun 2007 05:21:44 GMT

thanks for replies bt the query has been resolved

Re: IN UPDATE TASK

varma_narayana — Mon, 25 Jun 2007 05:27:57 GMT

Hi,

In the Attributes of the FM

Set the Processing type to : Update Module (Immediate start).

AND

In the FM source code

there is no need to declare the internal table as you are updating a single record.

You can use the code

update zupdatetable1 set POSNR = ITEM where POSNR = ?.

Hope this will hep you.

regards