topic Re: sap data import and export in Application Development and Automation Discussions

sap data import and export

Former Member — Wed, 01 May 2013 06:15:38 GMT

Hi Experts

can we import and export the data of SAP ides system into word,excel or text format .And same can we upload it to an SQL server ?

Thanks

Shambuling Kulkarni

Re: sap data import and export

manukapur — Wed, 01 May 2013 09:04:31 GMT

There are lot of ways to do that.

What exactly are you trying to do? Let me know your requirements. Will tell you the most appropriate one.

Regards,

Manu

Re: sap data import and export

former_member188827 — Wed, 01 May 2013 10:24:19 GMT

Check Functional module "GUI_DOWNLOAD" for downloading data.

Re: sap data import and export

arindam_m — Wed, 01 May 2013 10:57:04 GMT

Hi,

You can certainly export and import data from SAP. You can do it in programs using various FM also if you just want to download in local file you can also do that. About uploading to SQL server you might need programs in SAP or SQL clients to achieve the same. If you can be more specific I can suggest the exact ones that you can use.

Cheers,

Arindam

Re: sap data import and export

Former Member — Wed, 01 May 2013 12:53:31 GMT

Hi manu

Thanks for reply

i am trying to download the SAP ides system data into Excel,word or text document and upload that data into SQL server\ database.

Is this the proper way to migrate the SAP Data to SQL database or there are any other option do the same ..

Thanks

Shambuling

Re: sap data import and export

Former Member — Wed, 01 May 2013 12:58:08 GMT

This message was moderated.

Re: sap data import and export

matt — Wed, 01 May 2013 13:19:45 GMT

Why can you not do a system copy/database migration? The volume of data is way to high to sensibly do this task by uploading and downloading.

Re: sap data import and export

manukapur — Wed, 01 May 2013 13:35:44 GMT

If its for a small amount of data and limited data, you can download the table records into excel / text files or use function modules and write abap programs.

but if it something which is huge I suggest you use database migration techniques.

Regards,

Manu

Re: sap data import and export

Former Member — Wed, 22 May 2013 11:49:10 GMT

Hi Manu

Thanks for reply .

how i can perform the database migration . what are the techniques .

actually we have downloaded the sap data using R\3 load and now it is saved in the hard drive

whether we directly upload that data into SQL or we must upload that data to SAP and then we can migrate it to the SQL database .

Thanks

Shambuling

Re: sap data import and export

Former Member — Wed, 22 May 2013 11:51:26 GMT

hi Arindam

Actually we have downloaded the sap data using R\3 load and now it is saved in the hard drive

whether we directly upload that data into SQL or we must upload that data to SAP and then we can migrate it to the SQL database .

Thanks

Shambuling

Re: sap data import and export

manukapur — Wed, 22 May 2013 15:11:58 GMT

Hi Sambuling,

If you have already downloaded the data in certain format, then you can use the import functionality of the SQL Server to import data onto it.

If there is a large volume of data, and you have to do more periodic, I suggest use SAP DataServices to do the Migration.

Regards,

Manu