Application Development and Automation 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: 
Read only

Table Data Transportation (Urgent)

Former Member
0 Likes
1,065

Hi Experts,

Can you do me a favour, I can transport table structure from one client to another. but I want to transport my development client table data to production clinet. How can I do it?

Waiting for your reply with positive hope. it is Urgent.

with warm Regards

Rajiv singh

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,042

Hi..

U need to upload the data into the database table in production separately..

Do one thing..

Create a transaction(program) which will upload the text file data into the database table.

Transport this TCODE to production...and in production run this TCODE...specify filename an data will be uploaded to respective database table.

Use GUI_UPLOAD function module for the same.

Regards,

DJ.

Hi Experts,

Can you do me a favour, I can transport table structure from one client to another. but I want to transport my development client table data to production clinet. How can I do it?

Waiting for your reply with positive hope. it is Urgent.

with warm Regards

Rajiv singh

7 REPLIES 7
Read only

RaymondGiuseppi
Active Contributor
0 Likes
1,042

Create a workbench or copy transport request, open it in update mode, add object <b>R3TR TABU <filename></b>

Then via menu "Key List", and create an entry with client and then first key as "*"

This will transport the whole data.

Regards

Read only

messier31
Active Contributor
0 Likes
1,042

hi,

Goto transaction SM31, enter your table name and click transport button.

It will ask to create new request. Click ok onthis.

Now select the entries which you want to transport and then click the <b>Include button</b> on application tool bar.

These entries are now locked in request.

Release this request to transport entries to production.

Enjoy SAP.

Pankaj Singh.

Read only

Former Member
0 Likes
1,042

Dear Pankaj singh,

When I do as you said, it says

Transport is not possible for the specified data.

Read only

0 Likes
1,042

SM30/SM31 will generate transport request if so specified in transaction SE54 (or SE11 and menu)

=> Recording routine should be "Standard recording of table contents changes"

But in this case you won(t be able to maintain the table in production system if customizing is closed.

Regards

Read only

Former Member
0 Likes
1,043

Hi..

U need to upload the data into the database table in production separately..

Do one thing..

Create a transaction(program) which will upload the text file data into the database table.

Transport this TCODE to production...and in production run this TCODE...specify filename an data will be uploaded to respective database table.

Use GUI_UPLOAD function module for the same.

Regards,

DJ.

Read only

Former Member
0 Likes
1,042

Follow the steps mentioned below:

1. Goto SE01.

2. Click New and create a New Work Bench Request.

3. Then place the cursor on the TR and click on Display Object List (Shift + F11)

4. Enter PGMID as R3TR

5. Enter OBJ as TABU

6. Enter OBJECT NAME as Z<TABLE NAME>

7. Again in the menu, select 'Extras>Change object function>Key according to key list'.

Now go to the menu, 'Goto-->Key list'. In the subsequent screen, click on 'Insert line' icon (with a + sign).

Read only

Former Member
0 Likes
1,042

Hi, all

I got solution of the above query and I want to share it with all of you.

Steps is.

1. go to se16

2. enter table name

3. select records which you have to transport

4. go to menu Table entry->transport entry

it will create request no. which can be transportable to another client.

Thanks