SAP Best Practices Client Copy and Before Copying

What are some of the activities that we must to do before a SAP system copy?

---

These are what you can do: 

1. Export the users, roles and authorisations with Tx SCC8 using profile SAP_USER.

2. RFCDES RFCATTRIB and RFCDOC 

a. Create file export_sm59.r3t contents: 

Export 

file 'C:\exp\EXPORT_SM59.DMP' 

delete from rfcattrib 

select * from rfcattrib 

delete from rfcdes 

select * from rfcdes 

delete from rfcdoc 

select * from rfcdoc 

b. Create file import_sm59.r3t contents: 

import 

file = 'C:\exp\EXPORT_SM59.DMP' 

c. Run an export on source: 

R3trans -w c:\exp\EXPORTSM59.log c:\exp\export_sm59.r3t 

d. When ready, import on destination: 

R3trans -w c:\exp\IMPORTSM59.log c:\exp\import_sm59.r3t 

e. Reset the secure Store with Tx SECSTORE 

3. You will have to copy the Background jobs and recreate them afterwards.

For your information, it's possible to copy the tables of all background Jobs. To do this I created a file export_jobs.r3t with the following contents and I tested it and it worked well (please test it as not all system are alike).

Export 

file 'C:\jobs\JOBS.DMP' 

delete from TBTCA 

select * from TBTCA 

delete from TBTCB 

select * from TBTCB 

delete from TBTCCNTXT 

select * from TBTCCNTXT 

delete from TBTCCTXTT 

select * from TBTCCTXTT 

delete from TBTCCTXTTP 

select * from TBTCCTXTTP 

delete from TBTCI 

select * from TBTCI 

delete from TBTCJSTEP 

select * from TBTCJSTEP 

delete from TBTCO 

select * from TBTCO 

delete from TBTCP 

select * from TBTCP 

delete from TBTCR 

select * from TBTCR 

delete from TBTCS 

select * from TBTCS 

4. It is not considered good/best practice to perform a system copy into the development system.  However, if there is no other way you can keep the version management with SAP note 130906.

Points to note:

It is NOT a best practice to copy Production data into the Development system. 

It is best practice for the Development and Configuration to be consistent across the landscape but not necessarily in terms of data.

You should not have production data in the Development system because: 

1. Data protection reasons. The developers and Configuration team do not need actual data. They should create their own sample data. the Project team has more access in the Development / Customising client.

2. Volume of data. If your development system has production data, it can take longer to perform the development.

SAP BC Tips

See Also
Copy users from DEV to PRD

Get help for your Basis problems
Do you have a SAP Basis Question?

SAP Basis Admin Books
SAP System Administration, Security, Authorization, ALE, Performance Tuning Reference Books

SAP Basis Tips
SAP BC Tips and Basis Components Discussion Forum

Administration In SAP - Sapgui, Unix, SAP ITS, Router, Client Copy and IDES 

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.