backup table

[Former Member]

hi!

i need to backup sap table, how do i do it?

regards

yifat

[athavanraja]

check out this online help

http://help.sap.com/saphelp_470/helpdata/en/0d/d304c54a0c11d182b80000e829fbfe/frameset.htm

Regards

Raja

[Former Member]

hi!

i need to backup this table in order to implement an oss note.

it doesnt have to done on regular basis.

also the sap help link is for oracle database.

is there any FM that we can download the records from the table to a file and then upload them again?

regards

yifat

[Former Member]

Hi Yifat,

Suppose u want to backup for MARA.

Then select * from mara into table it_mara.

then use GUI_DOWNLOAD to download it into front end or use OPEN DATASET and TRANSFER to write file on application server.

Thanks & Regards,

Ankur

[athavanraja]

In such a case, you dont need a back up, just do the modification to the table and once done use the database utility (SE14) to adjust and activate the table with the <b>Save Data</b> radio button selected. This would make sure that you dont loose the existing entries.

But in case if you want to be doubly sure that youdont loose the entries, just download the data to a local file and in case if something goes wrong you could write a simple program to load the data into the table from the file.

Regards

Raja

[Former Member]

Which note?

Rob

[Former Member]

Hi,

Table bakup can be done by archiving .

create a archive object.

use follwoing tcode aobj,sara,sari.

refer program sbooka,sbookr,sbookd.

else.

conctact Basis people for backup

Regards

Amole

[Former Member]

It is always better to do it either using the archiving technique or a database backup. If you write your own program to download and upload, you will have to deal with a lot of conversion related issues if the table has numbers, quantities, currencies etc. If it is a simple table then you may be ok downloading and uploading.

Srinivas