se14 : accidentally delete Data in Table

[Former Member]

Hallo experts,

i delete accidentally with the data in a Table in our testsystem.

But we need this data.

We have an Integration System, where i have the Data.

How can i transfer this date?

The table is a customer own customized table.

The strukture of the Tables are different, the testtable have new fields at teh end.

I need a very fast answer, also i have to enter the data manully.

I hope for help.

Torsten

[Former Member]

if the table was not diligently logging (posmotrtite utilities in the table)

try to unload data from

another system on your computer such as eksel plate through the function and then upload them to a file in the system you need.

DOWNLOAD

WS_DOWNLOAD

UPLOAD

WS_UPLOAD

[Former Member]

Hi,

I think as it is in DV write program get the data from the table in which u have data move it to the table in which u want to update , then insert the internal table data to the table ..I think this is the fastest for u .. hope this may help .

[Former Member]

Hy DAV_999,

thanks for the answer.

Can you tell me, witch tool i have to use?

Can You tell me the steps, i have to do?

The last possibility is to write a programm, that read the data thom the other system (RFC).

ragards

Torsten

[Former Member]

1) If you have an opportunity to use the RFC between systems or create TSM59.

Storing

system where the table is not empty - System A

system where the table is empty - System B

write to the system and the RFC-function which, as a result of the transfer all the rows you are looking for a table

that something like

Select * From DB_table Into exp_table

in system B wriete Report

then call this function through the RFC and do

modify of your table From exp_table.

2)if you can not use the RFC or write (transport) function in the system A

running a function or UPLOAD WS_UPLOAD in the system A (see how to fill data in the system) unloaded data to a computer fail C

now fail with load - running in the B function download or ws_download.

then through Transaktion se16 or sm30 edit table

[Former Member]

If you don't care about data in the new fields, then there are many ways to do it:

Method 1:

Ask BASIS if they made a backup of your current environment lately. If they did then BASIS can restore it for you. Usually Dev and test systems are not backed up so this may not be a good option. Also, if you don't want others to find out then ignore this option.

Method 2:

If your table length is <1023 characters long, then go to source system, display all records with table length 1023. From the menu download to text file. Next, open this file and delete all unwanted rows. Write a simple program in your development system and upload this file. If you table length is longer than 1023, it becomes painful ...

Method 3:

in SM59 check if you have an RFC connection between your source and target systems. If there is one, then there is a RFC function module to read table contents of an external system (I forgot what that is, will post it in this thread when I recollect), call this FM and upload it to your current table.

[Former Member]

Hy experts,

thak you all for the answers.

I write a simple Program (rfc).

Call this in an other Program and save the data.

--> it works.

regards

Torsten