Skip to Content
author's profile photo Former Member
Former Member

Data table

I need to create same table similar to a one in another client with all the data.Is there some easy method of transfering data from one table to another between 2 clients?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2006 at 08:47 PM

    Hi bharat

    In target client write a program with the following statement.

    select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '<Source client>'

    for ex

    if src client is 001

    and target client is 002

    then in 002 write

    select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '001'.

    use CLIENT SPECIFIED along with your update/modify/insert statements to be able to update target client table from source client.

    Please check that both of the clients should be in smae applicn server

    Regards

    Naresh

    Add a comment
    10|10000 characters needed characters exceeded

    • If you choose write a program to transfer data from one SAP system (e.g. R/3) to another SAP System (e.g. CRM) maybe you might need to do that frequently, you have to setup RFC connection between SAP systems then you can write a RFC enabled function module to select and update the data, so you can call this function module from other SAP system.

  • Posted on Oct 24, 2006 at 08:40 PM

    Tables are client independent, so the table itself should already exists in the other clients, you simply need to copy the data from the one client to the others. You can do this with a simple ABAP program.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 08:22 PM

    Then if is entirely different system...

    Then you probably have to manually create the table in the target system..

    Then write a program to insert the values...

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.