How to transport Data ONLY?

[Former Member]

Hi,

I would like to transport data without the configuration. However, I found out that Copy Profiles available all would transport the configuration as well.

Can someone tell me if SAP standard tools could achieve this.

If yes, how?

If no, is there any documentations stating so?

Thanks.

Regards,

Nac

[martin_juen2]

there is a second possibility:

You can transport data of tables only.

to do that create a transport and edit it manually. the dataobject to write on the transport request is R3TR TABU <tablename>

regards,

Martin

[martin_juen2]

hi.

if you want to transport all entries of a table or all entries of one table per client you can do it on os-basis.

you can write a script like this for exporting data in the source system

EXPORT

client = all

File= <Path_to_file>

select * from <table>

select * from <table_2>

...

you can write additional scripts for removing the data in the target-system (parameter REMOVE) and for import (target system / parameter IMPORT).

You can run the script with R3trans. E.g. R3trans -w ../log/export.log export.sh (on Unix)

First export the data on the source system, then remove the data in the target and last import the data in the target system. Attention - it's dangerous 🐵

regards,

Martin

[Former Member]

Hi Nac,

I think you can chose profile 'SAP_APPL' to copy the application data from the source client to target client. It can be achieved in 2 ways, either using client export/import or performing a client copy using SCC9.

Hope this helps.

Thanks,

Naga

[Former Member]

I think you mean copy client. As you found out, you can only copy data along with configuration because if you transport data without changes to configuration, it can lead to inconsistencies.

If you want to transport master data, you have to go to specific tables and create a new transport only of data.

Regards.