Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Copy entries from one DB table to another table

Former Member
0 Kudos

Hello experts,

I have created a DB table zvbak1 copied through VBAK. If I now want to copy all the entries of VBAK to ZVBAK1, how should I go about it?

Thanks,

Ajay.

1 ACCEPTED SOLUTION

I355602
Advisor
Advisor
0 Kudos

Hi,

Refer:

Hope this helps you.

Regards,

Tarun

8 REPLIES 8

I355602
Advisor
Advisor
0 Kudos

Hi,

Refer:

Hope this helps you.

Regards,

Tarun

dev_parbutteea
Active Contributor
0 Kudos

Hi,

Just create a z-program where you can do :

1. select * from vbak into i_vbak

2. insert zvbak1 from table i_vbak.

Edited by: Dev Parbutteea on Mar 6, 2009 6:40 AM

Former Member
0 Kudos

hi,

please refer this link

select * from tab1

into table itab

where .....

insert tab2 from table itab accepting duplicate keys.

thanks

former_member226203
Active Contributor
0 Kudos

fetch all the entries from vbak into an internal table.

now, modify ur ztable from this internal table.

Former Member
0 Kudos

hi,

select *

into table itab

from vbak.

insert zvbak1 from table itab.

if the values you want to copy are across the systems.

then

select *

into table itab

from vbak.

use fm gui_download

use FM gui_upload to upload the details into required system.

insert zvbak1 from table itab.

Thanks

Sharath

Former Member
0 Kudos

Hello Ajay,

Did you check SCN before posting...

this was asked many times and answerd many times....

Reported!!!

Former Member
0 Kudos

Using the FM "SE16N_INTERFACE". Copy the source data from this FM and save it into the target DB table.

Regards,

Joan

Former Member
0 Kudos

Hi,

Step 1: Excute VBAK table then yuo will get allrecords. Download all records.

Step 2: Write a BDC proram or LSMW to upload this records.

Or

Write program

select * from vbak into i_vbak

insert zvbak1 from table i_vbak.

commit.

Regards

Md.MahaboobKhan