cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction export

Former Member
0 Kudos

Hi All,

Is there a way I can export the transaction documents such as PO , SO , Inventory Transfer , Production Order and Good Receipt Po from one database to another database? Only the transactions not the database itself.

The situation is we need to rollback the current database to yesterday but we want to keep the transactions for today and import it back once the changes has been done.

Accepted Solutions (0)

Answers (4)

Answers (4)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer thread:

http://scn.sap.com/thread/3596072

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

It is not an easy job to transfer all those transactions from one db to another. It might be easier to do it manually.

First, you may run a query as:

SELECT * from JDT1 T0

JOIN OJDT T1 ON T1.TransID=T0.TransID

WHERE DateDiff(dd,T0.CreateDate,Getdate())=0

All those financial related documents should be found first. Then you can deal with Sales Order, PO ets.

Thanks,

Gordon

KennedyT21
Active Contributor
0 Kudos

HI David..

You can use Quick Copy in the following scenarios:

  • Copying data between companies – If your company uses multiple company databases for different branches, you can copy data between these databases using Quick Copy. You may also want to copy data to other company databases for archiving purposes. For partners, you can save best practice configurations and standard industry data and customizations to quick copy data files. You can then copy information to company databases in future SAP Business One implementation projects, or to multiple customers' company databases.

Regards

Kennedy

Former Member
0 Kudos

Hi Kennedy,

Seems like this method is to only copy the master data file but not the transactions itself?

Thanks

KennedyT21
Active Contributor
0 Kudos

I think the best way using the DTW to import the marketing documents details...

Rgds

Kennedy

Former Member
0 Kudos

Hi Kennedy,

Any guide to do this?

KennedyT21
Active Contributor
kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer SAP file for Quick copy which meets your purpose.

http://help.sap.com/saphelp_sbo900/helpdata/EN/45/ffa2efa23004aae10000000a114a6b/content.htm

Thanks & Regards,

Nagarajan