cross clent data transfer

[Former Member]

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

[Former Member]

Hi Tanuj,

You can do this using transaction SALE.

Regards,

Atish

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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

[former_member235056]

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