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 data from data base table

Former Member
0 Kudos

Hello friends,

I have some data in a Z-table in QAS. I want to copy all the data from QAS to the table in SDV. Is there way that I can copy without writing a program.

Thanks in advance,

Shejal.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Shejal,

If you are talking about different system landscapes, like QAS and ADV are different systems, yes, we can transport the content fo the the ZTABLE.

for that,

1. The table should have the maintenance allowed for this table.

2. use Transaction SM30, to transport the content .

Hope this helps.

Sajan.

7 REPLIES 7

Former Member
0 Kudos

You can make those as transportable entries and get them to the other system.

I think BASIS team would know how to do it.

Its there in one of the options, when you go to SM30 transaction and display the table entries.

Regards,

Ravi

0 Kudos

Thanks Ravi,

However table maintenance generator does dont exist for this table. Is it still possible?

Shejal.

Former Member
0 Kudos

Hi Shejal,

If you are talking about different system landscapes, like QAS and ADV are different systems, yes, we can transport the content fo the the ZTABLE.

for that,

1. The table should have the maintenance allowed for this table.

2. use Transaction SM30, to transport the content .

Hope this helps.

Sajan.

0 Kudos

hi,

use se09-display object list

insert new line with:

R3TR TABU "ZTAB01"

-> insert key:

Mandt = sy-mandt

and key = *

A.

Message was edited by:

Andreas Mann

0 Kudos

Thanks Andreas,

Can you explain it in detail.

When I go to SE09, it displays all the transports that I have to move to SDV.

What next.. I need to copy dat from QAS to SDV.

Shejal.

0 Kudos

hi shejal,

If ur data is less , then in SE09 put the cursor on ur task,

click on the icon display object list

click change button

add new entry with add button

R3TR TABU <table name>

double click on table name

double click on input field

add new entry

here give ur entries

then save ur request

0 Kudos

Thanks Chandrashekhar.

I will try this out.

Shejal