Exporting All Master Data from Production to Development

[Former Member]

Hi Gurus,

I need to export All the Master Data and Configuration files from Production to Development System. If anyone can Advise me to know the step by step for exporting and importing. Our PRD server is on HP-UX/Oracle and ECC6.

Eg Master Data like Customer Master, Vendor Master, Material Master...Etc.,

Please Advice

[sunny_pahuja2 · Accepted solution]

Hi,

You have do it manually.

Thanks

Sunny

[Former Member · Accepted solution]

Thanks for your reply.. Could you please explain the steps or any reference document?

Thanks

Prasad

[Former Member · Accepted solution]

Hi Dude,

Please goto Tx SCC8 ( Export Client ) and select the profile SAP_UCSV ( Customizing, User Master Records and User Variants) or else SAP_UCUS ( Customizing and User Master Records ) then select the Target system (As of DEV) then execute.It has been generating 3 transport request files like RO,RX & RT ( It will be stored in Data & Cofiles Folder under TRANS directory.

Now you can do the create a New for Target System then manually add the O, X & T transport files to TMS Buffer and do the post installation of Client Import using Tx SCC7

Please Let me know further doubts.

Regards

Thomas

[Former Member]

If I'm understanding you correctly, then client copy isn't the answer. There is no client copy profile that copies master data but not transactional data. When I need to do this, I copy customising and users using profiles SAP_CUST and SAP_USER, and then use ALE to copy the required master data. Setting up the ALE config the first time is a bit complicated, but you only need to do it once.

In fact, if all you want to do is copy the data from PRD into an existing client in DEV you can skip the client copy steps and just use ALE to copy the required data directly from PRD. This is a relatively painless way of keeping at least the master data in DEV up to date for testing purposes, without having to do a complete system copy.

Does that make sense? Is there a better way? If so, I'd love to know what it is!

Steve.

Edited by: Steve Rumsby on Aug 18, 2011 2:20 PM

[Former Member]

Thanks steve for your answer. Yes you are right ....I see no client profile which can bring master data like, customer master, vendor master, material master etc., alone. I have not done this setting up this ALE configuration before. Could you please enlighten me with the steps or with some link with step by step.

Thanks

Prasad

[Former Member]

Hi Prasad.

I've only managed to set this up once, and that was some time ago, so I'm not sure I can re-construct the necessary steps. I'd need to do it all from scratch myself in a clean system to make sure I'd got it right! I originally figured it all out from the [online help for ALE|http://help.sap.com/saphelp_erp2005/helpdata/en/0b/2a60bb507d11d18ee90000e8366fc2/frameset.htm] - I suggest you have a read through that and see what you make of it. If you have questions about specific steps I may be able to help.

Are there any ALE experts out there that might be able to give more extensive help on setting up something like this, or who can suggest a simpler alternative?

I've publicised this question on Twitter where I hope there are some more knowledgeable ALE users. I hope that will attract someone who can help better than I have!

Steve.

Edited by: Steve Rumsby on Aug 18, 2011 5:16 PM

[Former Member]

I would not look to a client copy to do this since you will get quite a bit more data than what you need.

To set up transfers via ALE you will have to create ports, partner profiles, RFC's and so on. A description can be found on this website: [SAP-ALE-Tutorial from the SAP-CORE website|http://sap-core.com/articles/basis/interfaces/sap-ale-tutorial/]. The process can setup to run either periodically or on an as-needed basis (no pun intended).

A better long term approach may be to look into one of the client refresh products that are out there. I believe GoldClient, SelectRefresh and others have the ability to copy back sets of master data (TDMS may be able to do this as well) and importantly can mask certain parts of data that may need to be hidden due to security concerns (especially with HR data).

Hope that is helpful.

J. Haynes

Edited by: Joe Haynes on Aug 18, 2011 1:05 PM

[Former Member]

Dear Sir,

Remote Client Copy process you can do multiple ways.

Through SCC9 if your database size is small.

Throgh Export Import process , SCC8 and SCC7 T-codes ..

I recomment before start all the activity please read the Remote client copy guide procedure. Becasue for this activiy you will require the PRD downtime.

Please revert for further queries.

Regards

Pranay Agarwal