topic Re: Copying Production Data into Development. in Application Development and Automation Discussions

Copying Production Data into Development.

Former Member — Wed, 12 Oct 2011 08:33:08 GMT

Hello,

There are some FI postings that have been done via transaction F-42 for the month of September 2011 in Production system.

My client requires a copy of those entries posted from production to development server.

They are not ready for a Client-copy at any cost due to space constraints.

Is then any other solution via which I can transfer the entries from Production to development server ?

Regards,

Danish.

Re: Copying Production Data into Development.

Former Member — Wed, 12 Oct 2011 09:00:46 GMT

Hi,

If you know from which tables you require the entries then you can retrieve the data from those tables from production server.

Let me know if know the tables involved, so that i can give you that solution.

If you dont know the tables then we have look for different solution..

Regards,

Rahul

Re: Copying Production Data into Development.

Former Member — Wed, 12 Oct 2011 09:13:10 GMT

Hi,

It is very much risky to insert data into accounting tables like BKPF, BSAS, BSIS etc. It is not possible to get all the SAP tables which are updated during this transaction.

Regards,

Danish.

Re: Copying Production Data into Development.

deepak_dhamat — Wed, 12 Oct 2011 10:27:43 GMT

Hi ,

Dont Create entries in Development using Production Data , because there are many tables where entries get created and updated during Posting . if you do so You will wasting your time in Debugging the data . if you don't get correct Result .

It is better to do all Process again in development -Create same Senario in Development .

ASK your functional team member do entries again via transaction F-42 .

regards

Deepak.

Edited by: Deepak Dhamat on Oct 12, 2011 12:28 PM

Re: Copying Production Data into Development.

ThomasZloch — Wed, 12 Oct 2011 15:11:04 GMT

A very big gun is the SAP add-on product TDMS (test data migration server), which allows transfer of reduced data between production and other systems. If you are regularily facing issues like this, it might be worth a look (search for additional information on SCN and the SAP marketplace).

Otherwise you would have re-post the documents in development e.g. using a download from production and an upload via LSMW. Takes some time to build, but can be re-used as needed.

Thomas

Re: Copying Production Data into Development.

Former Member — Wed, 12 Oct 2011 16:28:27 GMT

This is similar to migrating SAP data when integrating several existing SAP systems: If you need more than a 100 or so documents .

The steps are:

Extract the data you need via Query or other tool.

Load it via LSMW into the system you want.

The challenge will be getting the master data correct as it may not be true that the data is the same.

Re: Copying Production Data into Development.

Former Member — Fri, 14 Oct 2011 04:31:54 GMT

Hi,

We have found that there are hardly 12 entries in production for the month of September 2011.

Client has agreed to post the entries manually in development as it will take hardly 30 minutes to post the entries.

Thanks Guys.

Regards,

Danish.