Solved: Copy data from tables from Production to QAS

Former Member · ‎12-10-2007

Hi all,

We are having the following issue on our SAP system: We recently made a client copy from our PRD system to our QAS system using the copy profile SAP_ALL and according to the remote client copy log this action was successfully made. But then, some days later when we were making some tests for a new report that we are developing we noticed that all the information of some "Z" tables was missing, and therefore we can not make the proper tests to this new report.

The thing here is that we do not know why the information of these tables developed by our consultants was not copied during the remote client copy and only the table structure was copied to QAS.

So the question here is how can we copy ONLY the information contained on the "Z" tables on the PRD system to the QAS system without trying to copy it using a client copy. Is there any way to do that ?

I hope that somebody please help.

The data of our system is:

SAP ERP Central Component 5.0

DB MS SQL Server 2000 SP4

1 app server and 1 db server for PRD.

1 server to QAS-DEV-SOL-DB.

Best Regards,

Erik Espinosa

uwe_schieferstein · ‎12-10-2007

Hello Eric

You can create an workbench transport request and add the following entries manually:

- table E071 (object entries): R3TR TABU <Z-table>

For each TABU entry you enter a generic key:

- table E071K (object keys):

'100*' (assumption: client-dependent table in client 100), ELSE

'*' (assumption: client-independent table)

Release the request in PRD and import it into the required client in QAS.

Regards,

Uwe

uwe_schieferstein · ‎12-10-2007

Hello Eric

You can create an workbench transport request and add the following entries manually:

- table E071 (object entries): R3TR TABU <Z-table>

For each TABU entry you enter a generic key:

- table E071K (object keys):

'100*' (assumption: client-dependent table in client 100), ELSE

'*' (assumption: client-independent table)

Release the request in PRD and import it into the required client in QAS.

Regards,

Uwe

Former Member · ‎12-12-2007

Hi Uwe,

I tryied to do what you have told me to and I got the following error message:

Transport control program tp ended with error code 0247

Errors: addtobuffer has problems with data- and/or cofile

Do you know what is happening here?

Best Regards,

Erik Espinosa

uwe_schieferstein · ‎12-12-2007

Hello Erik

This error message usually occurs when the TMS does not have access to the co-file of the transport request.

Assuming that your PRD and QAS systems share a common transport directory then you can go to STMS (on QAS) and add the request to the import queue (menu: Extras -> Other Requests -> Add). This corresponds to the tp command ADDTOBUFFER.

Regards,

Uwe

Former Member · ‎12-12-2007

Hi Uwe,

The procedure that you are mentioning on your suggestion is actually what I did when the error occurred, I went to the TMS and then tried to import the transport using Extras->Other Requests-> Add. Seems to me that the system is not configured to import / export transports reversal from PRD to QAS - DEV.

Do you have any suggestion or workaround for this issue?

Best Regards,

Former Member · ‎12-12-2007

Erik - you should let your basis people sort this out. It doesn't look like an ABAP problem.

Rob

Former Member · ‎12-12-2007

You think this could be because, I was trying to add the new transport request directly from the TMS? Is there any procedure to make an import / export of tables due a transport request? I could not find it on marketplace....

Best Regards,

Erik Espinosa