topic Documents transfer from SAP to SQL DB in Application Development and Automation Discussions

Documents transfer from SAP to SQL DB

Former Member — Mon, 18 Dec 2006 10:49:38 GMT

Hi All,

Please let me know how attachments/documents (word,excel..)with the meta data which are stored in SAP R/3 database will be transfered to another database i.e.,SQL Server and vice versa, where the SQL DB has .NET interface..the transfer of documents in either way is triggered based on the .NET interface actions

sure rewards!!

Thanks & regards

Yasar

Re: Documents transfer from SAP to SQL DB

Former Member — Mon, 18 Dec 2006 11:35:48 GMT

U need to use FTP function modules....

1) HTTP_SCRAMBLE.

2) SAPGUI_PROGRESS_INDICATOR

3) FTP_CONNECT

4) FTP_R3_TO_SERVER (From SAP to external system)

FTP_SERVER_TO_R3 (From external system to SAP)

5) FTP_DISCONNECT

6) RFC_CONNECTION_CLOSE

Re: Documents transfer from SAP to SQL DB

Former Member — Mon, 18 Dec 2006 12:41:16 GMT

Do you want to store documents inside a table in SQL Server?

Thanks & Regards,

Govind.

Re: Documents transfer from SAP to SQL DB

Former Member — Tue, 19 Dec 2006 05:28:31 GMT

hi Govind,

not necessary to store the actual documents in the SQL table but it should be avaliable in the .net interface.

Thanks & regards

yasar

Re: Documents transfer from SAP to SQL DB

Former Member — Tue, 19 Dec 2006 07:14:08 GMT

hi Ramesh,

Can you please provide me the code iam in urgent need of it ....

please mail me at arafathit@gmail.com

Many Thanks

Yasar