topic Re: moving data between tables in Application Development and Automation Discussions

moving data between tables

Former Member — Tue, 26 Jun 2007 13:15:29 GMT

Hi, I have 2 tables: l_eket_obj and itab

TYPES: BEGIN OF eket_obj,

werks LIKE ekpo-werks,

matnr LIKE ekpo-matnr,

menge TYPE i,

wemng TYPE i,

objednane TYPE i,

END OF eket_obj.

DATA: l_eket_obj TYPE eket_obj OCCURS 0 WITH HEADER LINE.

DATA: BEGIN OF itab OCCURS 0,

werks like ekpo-werks,

matnr LIKE ekpo-matnr,

zamowione type i,

END OF itab.

How to move all data from field l_eket_obj-objednane into field itab-zamowione?

Thanks,

Joanna

Re: moving data between tables

Former Member — Tue, 26 Jun 2007 13:19:25 GMT

Hi Joanna,

Write code like this

Loop at l_eket_obj.
itab-zamowione = l_eket_obj-objednane. 
Append itab .
clear itab.
endloop.

Reward if useful.

Regards

Aneesh.

Re: moving data between tables

Former Member — Tue, 26 Jun 2007 13:19:51 GMT

HEllo

do like this.


loop at l_eket_obj .
read table itab with key werks eq l_eket_obj-werks
                                   matnr eq l_eket_obj-matnr.
if sy-subrc =  0.
itab-zamowione = l_eket_obj-objednane.
modify itab transporting zamowione where werks eq l_eket_obj-werks
                                   matnr eq l_eket_obj-matnr.

endif.
endloop.

Hope this solve ur problem.

Regards,

Vasanth

Re: moving data between tables

Former Member — Tue, 26 Jun 2007 13:53:22 GMT

Hello,

It doesn't work, the field itab-zamowione is still empty.

Regards,

Joanna

Re: moving data between tables

Former Member — Tue, 26 Jun 2007 20:29:59 GMT

can you paste the code.

The Vasanth M options looks good, just make sure u ll fill data in ITAB before reading it.

Move corresponding fields like matnr werks to ITAB then only the read statement will work.

Thank-You

vinsee

Re: moving data between tables

Former Member — Wed, 27 Jun 2007 04:17:47 GMT

hi joanna,

u will have to write the code in following fashion....

loop at l_eket_obj.

itab-werks = l_eket_obj-werks.

itab-matnr = l_eket_obj-matnr.

itab-zamowione = l_eket_obj-objednane.

append itab.

clear itab.

endif.

hope this will be helpfull...

please reward in case usefull...

regards,

prashant

Re: moving data between tables

Former Member — Wed, 27 Jun 2007 09:09:19 GMT

Thanks Vasanth,

it solves my problem, it doesn't work because of wrong data.

Regards,

Joanna