Table data transfering form one client to another

[Former Member]

Dear all,

I want to know the approch to transfer the table Data of one client to another client .

Can any one suggest?

-Maharshi

[Former Member]

Hi,

For transferring data from one client to another you have to create transport request.

You can use two different procedures for transporting user master records depending on the type of transport :

1. Transports between clients (within an SAP System)

User master records and authorization components are client-dependent. You therefore need to maintain individual user master records and authorization components for each client in your SAP System.

To transport user master records and authorization profiles from other clients, choose Tools -> Administration -> System administration, Administration ->Client admin. ->Client copy ->Local copy in the target client. Use the profile SAP_USER

2. Transport Between SAP Systems

You can copy user master records from one SAP System to another. Decide on the transport method that is appropriate for you, depending on the components to be transported.

For more details go through the link :

http://help.sap.com/erp2005_ehp_03/helpdata/EN/52/6716d2439b11d1896f0000e8322d00/frameset.htm

http://help.sap.com/erp2005_ehp_03/helpdata/EN/57/38dea84eb711d182bf0000e829fbfe/frameset.htm

Thanks,

Nitesh Jain

[Former Member]

Hi,

You cannot directly transport table entries from one client to another.

There are two possible ways to do this;

1) You have to download all table entries to Flat file and then upload it in the other client using your own upload/download programs.

2) If you think you need to use the table entries in all clients just remove the MANDT field(in case its a Ztable) to make the table cross client.

Revert back if you have any queries.

Regards

Karthik D

[Former Member]

Hi,

You can use the ALE distribution model to distribute the data between different clients.

each client can be a logical system. and if you setup a Distribution model so that the sender is client 100 and the receiver is client 200 for example.

BD64 is the transaction to setup the Distrubtion model for messages.

You will also need to setup the partner profiles in WE20 where you would need to give outbound parameters in the sending system for the receiving system and inbound parameters in the receiving system under the sending system.

Example :

Lets say you have ERP_100 and ERP_200

In we20 of ERP_100, in the logical system ERP_200 you should maintain the outbound parameters for the messages that you want to send to ERP_200.

In we20 of ERP_200, in the logical system ERP_100 you should maintain the inbound parameters for the message that you want to receive from ERP_200

If you are confused, you can first start by creating the ALE Model where you define which messages should be sent from the source system to the targer system and then simply generate the Partner profiles by clicking on the Environment-->Generate Partner Profile.

Best regards,

Advait

[Former Member]

closing