Data Transfer between two Ztables.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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..

[Former Member]

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...

[Former Member]

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.

[Former Member]

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