Client copy -Only Transaction Data

[Former Member]

Dear Experts,

We have a specific requirement where we need the production data needs to be copied in one our testing client in the development server.

We have some zee programs available in DEV server which is not there in Production.

To test the zee program we need the production transaction data.

But if we do client copy our team feels that the zee programs will get deleted in that specific client.

is there any way to copy the transaction data alone without affecting the existing zee programs.

I could see the following profiles for client copy, which one will help for our requirement.

SAP_ALL All Client-Specific Data w/o Change Documents

SAP_APPL Customizing and Application Data w/o Change Docs

SAP_APPX SAP_APPL w/o Authorization Profiles and Roles

SAP_CUST Customizing

SAP_CUSV Customizing and User Variants

SAP_CUSX Customizing w/o Authorization Profiles and Roles

SAP_PROF Only Authorization Profiles and Roles

SAP_RECO Recovery (Only if Source Client = Target Client)

SAP_UCSV Customizing, User Master Records and User Variants

SAP_UCUS Customizing and User Master Records

SAP_UONL User Without Authorization Profiles and Roles

SAP_USER User Master Records and Authorization Profiles

Expecting your valuable answers.

Regards,

Vijay

[Former Member · Accepted solution]

Dear Vijaya,

Please do the Client Export & Import method as my Previous message.

I hope it will be work

Regards

Thomas.T

[former_member197667]

Hi VIjaya,

Nothing happens to your ABAP "Zxxxxx" programs.

i.e.. if you export client Data from PRD server and import in to your QUA or DEV.

your requirement is very clear - you need Transaction data to test your new "Zxxxxx" programs / Z T-codes.

you can export your production client data, with the available following options only

SAP_ALL All Client-Specific Data w/o Change Documents

SAP_EXPA SAP_ALL with Cross-Client Customizing

SAP_RECO Recovery (Only if Source Client = Target Client)

SAP_ALL is a good option to get your client specific Data.

so, please export your PRD client with SAP_ALL & import in to you QUA.

after import , execute scc7. once the background job is completed, you can check your "Zxxxx" programs or T-codes with the latest transaction data.

Note: please take backup of QUA before importing. as a precautionary measure.

Kind regards,

Raghavendra Rao N

[former_member197667]

Hi VIjaya,

Nothing happens to your ABAP "Zxxxxx" programs.

i.e.. if you export client Data from PRD server and import in to your QUA or DEV.

your requirement is very clear - you need Transaction data to test your new "Zxxxxx" programs / Z T-codes.

you can export your production client data, with the available following options only

SAP_ALL All Client-Specific Data w/o Change Documents

SAP_EXPA SAP_ALL with Cross-Client Customizing

SAP_RECO Recovery (Only if Source Client = Target Client)

SAP_ALL is a good option to get your client specific Data.

so, please export your PRD client with SAP_ALL & import in to you QUA.

after import , execute scc7. once the background job is compleated, you can check your "Zxxxx" programs or T-codes with the latest transaction data.

Note: please take backup of QUA before importing. as a precautionary measure.

Kind regards,

Raghavendra Rao N

[Former Member]

Hi Vijaya,

The following profiles will be delivered additionally as of Client Export (SCC8 only) in order to be able to copy client-independent Customizing data between two systems: ( DEV to PRD )

• SAP_EXB Customizing including client-independent customizing and user data

• SAP_EXPA All client-dependent data and client-independent Customizing

• SAP_EXPC Customizing including client-independent Customizing

Regards

Thomas.T

[Former Member]

Hi Vijaya,

You might be interested to know the features of TDMS.

http://wiki.sdn.sap.com/wiki/display/TDMS/TestDataMigration+Server

Also, please goto the following link

https://websmp207.sap-ag.de/tdms

and choose FAQs.

Br,

Venky.

[Former Member]

This might not be a good way to test.Why not export the tables whichever the z program is hitting.Thanks.

[Former Member]

Hi,

maybe I am wrong but I don't think there is any way copy transaction data alone. as it can lead to database inconsistency.

Regards

Bhuban

[sunny_pahuja2]

Application data will be consistent only if customizing/workbench will be same in source and target system. That is the reason copying only application data is not possible.

Thanks

Sunny