Upload / Download Tables.

[Former Member]

Hi All,

I have a requirement in which I am suppose to use some tables in one system (For Ex : A) to make some reports and other operations like BDC etc., in another system (For Ex : B).

Both system A and B are not related or can be connected to each other since they belong to different projects altogether.

My question is : Is there a way by programming or by using a tool I can download these dictionary tables from system 'A' and later upload it to system 'B'.

Thanks in advance for the help.

DJ.

[Former Member]

Use GUI_download function module and download ur table data into excel file.

Use GUI_UPLOAD function module to upload tht data from excel sheet into the database table.

Write a program using this FM

[Former Member]

Hi Raj,

Thanks for the lightning response, however will this take care of "Technical Settings" and Foreign Key relationships.

Thanks and Regards,

Dipesh Jhala.

[Former Member]

It sounds like you want to replicate the tables in B as well.

If that is the case, you can simply tranport these tables form A to B. Each table will be associated with a tr. request when created. You can ask the BASIS team to move the table to B. The entire table will be created in B.

Similarly if you want the table entries, you can configure to tranport the entries as well.

Regards,

Ravi

Note - Please mark all the helpful answers

[Former Member]

Dear Ravi,

Thanks for the reply, my issue is both the system's are owned by different clien't (owners / companies) so I do not think mutual transfer is possible.

Do you think if there is anything else available ?

Regards,

Dipesh Jhala.

[Former Member]

Hi Dipesh,

Copy this Program and execute:

<b>This has 3 paramenter : Table Name to transfer:

From Client:

To Client:</b>

REPORT YMNDTCOPY MESSAGE-ID US NO STANDARD PAGE HEADING.

PARAMETERS: TABLE LIKE DD02L-TABNAME,

MANDT_FM LIKE T000-MANDT DEFAULT '207',

MANDT_TO LIKE T000-MANDT DEFAULT SY-MANDT.

TABLES: DD02L, T000.

DATA: LINES LIKE SY-DBCNT VALUE 0.

DATA: ICURSOR TYPE CURSOR.

DATA: ICURSOR1 TYPE CURSOR.

DATA: BEGIN OF TMP OCCURS 1000,

MANDT LIKE T000-MANDT,

REST(8189) TYPE C,

END OF TMP.

DATA: BEGIN OF TMP1 OCCURS 1000,

MANDT LIKE T000-MANDT,

REST(8189) TYPE C,

END OF TMP1.

data : ws_flag, ws_ans.

*OPEN CURSOR WITH HOLD ICURSOR1 FOR

• SELECT * FROM (TABLE) CLIENT SPECIFIED WHERE MANDT = MANDT_to.

*do.

• FETCH NEXT CURSOR ICURSOR1 INTO TABLE TMP1 PACKAGE SIZE 1000.

• IF SY-SUBRC = 0.

• ws_flag = 'X'.

• CLOSE CURSOR ICURSOR1.

• EXIT.

• ENDIF.

*enddo.

*

*if ws_flag = 'X'.

• CALL FUNCTION 'POPUP_TO_CONFIRM'

• EXPORTING

• TITLEBAR = ' '

• DIAGNOSE_OBJECT = ' '

• TEXT_QUESTION = text-001

• TEXT_BUTTON_1 = 'Ja'(001)

• ICON_BUTTON_1 = ' '

• TEXT_BUTTON_2 = 'Nein'(002)

• ICON_BUTTON_2 = ' '

• DEFAULT_BUTTON = '1'

• DISPLAY_CANCEL_BUTTON = 'X'

• USERDEFINED_F1_HELP = ' '

• START_COLUMN = 25

• START_ROW = 6

• POPUP_TYPE =

• IV_QUICKINFO_BUTTON_1 = ' '

• IV_QUICKINFO_BUTTON_2 = ' '

• IMPORTING

• ANSWER = ws_ans

• TABLES

• PARAMETER =

• EXCEPTIONS

• TEXT_NOT_FOUND = 1

• OTHERS = 2

• .

• IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

• ENDIF.

*

*endif.

*if ws_ans = '1'.

DELETE FROM (TABLE) CLIENT SPECIFIED WHERE MANDT = MANDT_TO.

COMMIT WORK.

OPEN CURSOR WITH HOLD ICURSOR FOR

SELECT * FROM (TABLE) CLIENT SPECIFIED WHERE MANDT = MANDT_FM.

DO.

FETCH NEXT CURSOR ICURSOR INTO TABLE TMP PACKAGE SIZE 1000.

IF SY-SUBRC <> 0.

CLOSE CURSOR ICURSOR.

EXIT.

ENDIF.

LOOP AT TMP.

TMP-MANDT = MANDT_TO.

MODIFY TMP.

LINES = LINES + 1.

ENDLOOP.

INSERT (TABLE) CLIENT SPECIFIED FROM TABLE TMP.

CALL FUNCTION 'DB_COMMIT'.

ENDDO.

WRITE: / 'for table', TABLE, LINES, 'lines are copied.'.

Reward points if this Helps.

Manish

[Former Member]

Hi Dipesh,

By Making RFC's you can connect two tables and share the data among two systems. I know it is expensive in case if these two tables are transactional tables.

Why can't create transport request and release another project system(taking permissions from the right people). I understand some time it is not possible.

Another solution is to create a BDC for SE11 and upload the structures from A to B. Write another BDC for data.

Regards

Bhupal Reddy

[former_member583013]

You can read my blog:

<a href="/people/alvaro.tejadagalindo/blog/2006/03/14/taking-good-care-of-z-tables good care of Z tables</a>

Also, you may be interested in my other blog...

<a href="/people/alvaro.tejadagalindo/blog/2006/03/16/taking-good-care-of-z-data good care of Z Data</a>

Greetings,

Blag.

[Former Member]

Hey Alvaro,

Thanks for sharing your work with me, however I couldn't figure out the upload part, if you could please throw some light there it would be great.

Once I download the tables from one system, how do I upload them using your program in the other system. I cannot transport since they both belong to different owners and hence I will not be allowed to connect those.

Please let me know if the above is not clear to you and does not allow you to answer.

Regards,

Dipesh Jhala.

[Former Member]

Hey Alvaro / Blad,

Thanks for sharing your work with me, however I couldn't figure out the upload part, if you could please throw some light there it would be great.

Once I download the tables from one system, how do I upload them using your program in the other system. I cannot transport since they both belong to different owners and hence I will not be allowed to connect those.

Please let me know if the above is not clear to you and does not allow you to answer.

Regards,

Dipesh Jhala.

[Former Member]

Hi Bhupal,

Thanks for the reply. I cannot create a RFC since owners of both SAP system are different they are not interlinked at all. Its like one SAP system belongs to Company A and other to Company B.

However, if you could throw a little more light on how to use RFC to share the data among two systems and would be really nice. I could use it for any future issues I may face.

Regards,

Dipesh Jhala.

[former_member583013]

Hi Dipesh:

BTW, my nickname is Blag...Not Blad -;)

The only way to upload the tables from system A to system B....Is to load the program on system B....If you can't do that....There's no much help I can give you....My program allows to download or upload depending on one parameter...."D" for Download and "U" for Upload.

Greetings,

Blag.