topic Re: Error in Modify in Application Development and Automation Discussions

Error in Modify

sergio_cifuentes — Fri, 07 Nov 2008 17:14:01 GMT

Hi, i'm creating a FM that all that have to do is insert some data from one itab into a ztable, but when i use the MODIFY command doesn't insert the values that the itab have, it only insert one record with all the values with blanks, i check the sy-subrc but it says 0, heres my code:



FUNCTION YPRUEBA.
*"----------------------------------------------------------------------
*"*"Interfase local
*"  TABLES
*"      PZDSDE_INVENTARIO STRUCTURE  ZDSDE_INVENTARIO
*"----------------------------------------------------------------------

DATA: ti_zcmtt_inventario TYPE STANDARD TABLE OF zcmtt_inventario WITH HEADER LINE,
      wa_zcmtt_inventario LIKE zcmtt_inventario.

LOOP AT pzdsde_inventario.
  CLEAR wa_zcmtt_inventario.

  wa_zcmtt_inventario-clientesap = pzdsde_inventario-kunnr.
  wa_zcmtt_inventario-fecha = pzdsde_inventario-datum.
  wa_zcmtt_inventario-material = pzdsde_inventario-matnr.
  wa_zcmtt_inventario-uniliq = pzdsde_inventario-zunidades.

  APPEND wa_zcmtt_inventario TO ti_zcmtt_inventario.
ENDLOOP.

MODIFY zcmtt_inventario FROM ti_zcmtt_inventario.

ENDFUNCTION.

Thanks,

Sergio

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 17:19:23 GMT

I dont understand why are you using Modify, use append.

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 17:23:44 GMT

use commit work after the modify .

modify .....
if sy-subrc eq 0.
 commit work.
endif.

Re: Error in Modify

sergio_cifuentes — Fri, 07 Nov 2008 17:27:29 GMT

APPEND to a ztable? how?

Re: Error in Modify

sergio_cifuentes — Fri, 07 Nov 2008 17:27:50 GMT

thank's but it doesn't work.

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 17:30:00 GMT

Hi,

You have to use MODIFY z...FROM TABLE ...

Ex..

MODIFY zcmtt_inventario FROM TABLE ti_zcmtt_inventario.

Thanks

Naren

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 17:31:27 GMT

Check the internal table have all the data which you want to save.

Try to do that:

MODIFY zcmtt_inventario FROM  TABLE ti_zcmtt_inventario[].

Edited by: Alvaro Achin on Nov 7, 2008 6:32 PM

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 17:31:31 GMT

Hello

Try changing

MODIFY zcmtt_inventario FROM ti_zcmtt_inventario

to :

MODIFY zcmtt_inventario FROM TABLE ti_zcmtt_inventario

Regards

Greg Kern

Re: Error in Modify

sergio_cifuentes — Fri, 07 Nov 2008 17:32:50 GMT

Thanks Naren it Works!!

Re: Error in Modify

Former Member — Fri, 07 Nov 2008 18:26:48 GMT

Sergio,

Sorry I did not read your question properly.