topic Re: Copy data from data base table in Application Development and Automation Discussions

Copy data from data base table

Former Member — Wed, 29 Nov 2006 13:54:53 GMT

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.

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 13:57:00 GMT

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

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 13:58:59 GMT

Thanks Ravi,

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

Shejal.

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 14:01:57 GMT

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.

Re: Copy data from data base table

andreas_mann3 — Wed, 29 Nov 2006 14:08:38 GMT

hi,

use se09-display object list

insert new line with:

R3TR TABU "ZTAB01"

-> insert key:

Mandt = sy-mandt

and key = *

Message was edited by:

Andreas Mann

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 14:17:09 GMT

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.

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 14:34:31 GMT

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

Re: Copy data from data base table

Former Member — Wed, 29 Nov 2006 14:43:47 GMT

Thanks Chandrashekhar.

I will try this out.

Shejal