topic Re: cross clent data transfer in Application Development and Automation Discussions

cross clent data transfer

Former Member — Mon, 16 Jul 2007 08:37:30 GMT

How can wer transfer data of a table from a client to the table on a separate clent?

Re: cross clent data transfer

Former Member — Mon, 16 Jul 2007 08:38:30 GMT

Hi Tanuj,

You can do this using transaction SALE.

Regards,

Atish

Re: cross clent data transfer

Former Member — Mon, 16 Jul 2007 08:43:35 GMT

Hi Tanuj,

Client in sap is the highest entity having its own set of data and master records. So data transfer between one client to another is as good as data transfer between distributed systems. So data can be transfered using ALE / IDOCS. ALE is the method means set of configurations you do and IDOC is data container.

Reward points if useful,

Aleem.

Re: cross clent data transfer

Former Member — Mon, 16 Jul 2007 08:47:20 GMT

If you want to transfer all data of the table you can create a request by SE09:

-a) U can create a maintenace view (SM30) in order to create a request;

-b) Create an empty request

- Add new insert with parameter R3TR/TABU/<TABLE NAME>: this request'll overwrite the table of destination client;

-c) If the clients are in the same machine, you can create a z-program in order to read the data from original client and past them in current client:

SELECT * FROM <TABLE> CLIENT SPECIFIED INTO WA_TABLE 
                                                           WHERE MANDT = <CLIENT>. 
  INSERT <TABLE> FROM WA_TABLE. 
ENDSELECT.

Max

Re: cross clent data transfer

Former Member — Mon, 16 Jul 2007 09:45:21 GMT

You can put all ur data in a transport request and then using tcode SCC1 u can import data from source client to target client..

Reward if useful

Regards

Prax

Re: cross clent data transfer

Former Member — Mon, 16 Jul 2007 11:25:17 GMT

Hi,

Create a Logical system for the sender SAP system and the receiving XI system using Transaction - ‘SALE’:

Assign Client to the Sender Logical System

Create RFC destination of type ‘3’ for SAP XI system using transaction – SM59:

Make sure that the name of the RFC destination and Logical system for SAP XI is the same.

Create a Distribution Model through ‘SALE’ transaction:

Create a Distribution Model by selecting ‘Create Model View’:

Specify the name of the model view and a description.

For the model view created above, add the message type of the idoc that you wish to send to SAP XI using this model view. Select ‘Add Message Type’ option and then specify the sender logical system and the receiver logical system.

Save your Model view before proceeding further.

Generate the partner profiles by selecting the navigation path from the main menu, Environment --> Generate Partner profiles

Upon selecting the generate partner profiles option, then execute it with the default parameters displayed on the selection screen

From the main screen navigate through the menu option, EDIT --> MODEL VIEW --> DISTRIBUTE. Upon receiving the message shown here, it means the distribution is successful

Go to transaction BD10 to send a material out of IDES:

Go to transaction WE02/WE05 to check the status of the IDOC in the sendign system

<b>Pls do reward points.</b>

Regards,

Ameet