Is Database Table update from one system to another possible?

[Former Member]

Hi,

Unfortunatley my data in LIPS table (in Dev System) got deleted. Now I need to upload the same which is available in another system. Is there anyway to do this apart from ABAP coding (i.e. thru data base table transfer etc.,)?

Thank you,

Regards,

Sudh...

[Former Member]

Hi,

Unfortunatley my data in LIPS table (in Dev System) got deleted. Now I need to upload the same which is available in another system. Is there anyway to do this apart from ABAP coding (i.e. thru data base table transfer etc.,)?

Thank you,

Regards,

Sudh...

[sridhar_k1]

You can copy table data from database to database using SQL*Plus command COPY FROM need to be done by DBA.

If the systems have differen client numbers(MANDT), it can be modified from SQL* too.

Regards

Sridahr

[Former Member]

Hi Sridhar,

Thanks for you prompt reply. Can we do any validations using this procedure? The only validation what I need to do is to check whether the record exists in the header table (LIKP).

Regards,

Sudh...

[sridhar_k1]

Yes you can check the record exist in LIKP using SQL scripts at the database level. I would recommend a simple ABAP program to upload records into LIPS with all validations in it.

Regards

Sridhar

[former_member181966]

Make RFC connection with the system in SM59. Use

<b>FM "RFC_READ_TABLE"</b>... The data will come in internal table , write an ABAP code and update data in table .

Hope this’ll give you idea!!

<b>Pl... award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[Former Member]

Thanks for your inputs, but the problem in writing the ABAP program is to take care of huge volume of data (around 17 lacs).

So I am looking for an alternative at Database level.

Regards,

Sudh...

[former_member181966]

You can restrict the number of entries in the FM ...

moreover, you can also transfer data from SAP DBA utility . ( your SAP DBA can help you )

Thanks

Saquib

[Former Member]

Hi Sudhakar,

If you want to do it at database level. you can do that using R3TRANS on unix command. For that you have to create the .ctr file will select information and it will create a .dat file to you. and use same R3trans to import that file. I don't remember the syntex. But you can check it on web.

Regards,

Amit

[Former Member]

Sudhakar,

I would suggest a three-step approach.

Steps:

1) Break the fingers of the knucklehead that deleted the entries from a CORE table

2) Remove their authority to maintain SAP data dic and code objects

3) Perform a database level table copy to resolve the issue

Steps 1 and 2 should help to prevent the issue in the future.

[Former Member]

Hello Sudhaker,

This the way how you have to use R3trans.

Create in the system source the file: export.ctl

Export

File = 'export.dat'

Client = 201

Select * from table

And in the system target create the file: import.ctl

Import

File = 'export.dat'

Client = 301

Then execute in the source systems:

R3trans export.ctl

This creates a file named export.dat, then copy this file to target system and execute in the target system:

R3trans import.ctl

there are some open you can check with R3trans

http://www.easymarketplace.de/r3trans.php

Thanks,

Amit