topic Re: backup table in Application Development and Automation Discussions

backup table

Former Member — Sun, 12 Feb 2006 07:01:37 GMT

hi!

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

regards

yifat

Re: backup table

athavanraja — Sun, 12 Feb 2006 07:14:06 GMT

check out this online help

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

Regards

Raja

Re: backup table

Former Member — Sun, 12 Feb 2006 07:50:52 GMT

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

Re: backup table

Former Member — Sun, 12 Feb 2006 08:45:36 GMT

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

Re: backup table

Former Member — Sun, 12 Feb 2006 09:27:09 GMT

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

Re: backup table

athavanraja — Sun, 12 Feb 2006 09:37:47 GMT

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

Re: backup table

Former Member — Sun, 12 Feb 2006 15:43:45 GMT

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

Re: backup table

Former Member — Sun, 12 Feb 2006 19:11:41 GMT

Which note?

Rob