topic Re: Data Transfer between two Ztables. in Application Development and Automation Discussions

Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:28:33 GMT

Hi Gurus,

I have a requirement where I need to transfer some set of data from ztable1 to ztable2 on the same client. Your suggestions @ this point will be helpful and would be rewarded.

Regards

Prakash

Re: Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:35:23 GMT

Hi,

declare 2 internal tables ITAB and ITAB1 for Ztable1 and ZTable2

fetch the data from Ztable1 to ITAB.

Loop at ITAb.

Move-corresponding ITAB to ITAB1.

append ITAB1.

clear ITAB1.

endloop.

Update the ZTABLE2 by using INSERT command from ITAB1.

Insert into ZTABLE2 from ITAB1.

reward points

regards,

Anji

Re: Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:36:29 GMT

Hi Leo,

You can write a small program to select the data from ztable1 and update the same in the ztable2. This is one way. How differently you want to move. Can you give me some more details.

Regards,

Jayaram..

Re: Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:37:26 GMT

Hi...

Simple way is to write a program...

Or...

According to me, we can export data from source table and import to other table through OS level commands .. This is done by basis team... Please verify it with them...

Re: Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:37:29 GMT

Hi Leo,

If the two z tables have same structure means Create One Internal table based on the z table Structure. Then Retrive the values from first z table into internal table and than insert the datas to second z table using internal table.

hope this helpful,

Thanks.

Re: Data Transfer between two Ztables.

Former Member — Thu, 26 Apr 2007 13:43:17 GMT

Hi all,

Thanks for all your suggestions. They have the same structure with diff field names and it will be better I write a program, as they dont do OS level commands.

Thanks

Prakash