Sending data from R/3 Table to SQL Server Table

[Former Member]

Dear All,

I want data for one R/3 table PA0002 for fields GBDAT, PERNR, VORNA & NACHN to be sent to some SQL Server database table.

Please suggest me a step by step process for configuring the receiver and the sender. If any blogs are there thn kindly forward me the links.

Warm Regards,

N.Jain

[Former Member · Accepted solution]

Hi

1)Write an RFC in R/3 which fetches the fields you want to insert in SQL table.(If you need the code tell me)

It will be a RFC-JDBC Scenario.

2)Provide credentials of the R/3 system and import the RFC

3)Configure RFC Sender and JDBC Receiver

Links for RFC Sender

http://help.sap.com/saphelp_nw04/helpdata/en/26/64f62ffa8911d386e70000e82011b8/frameset.htm

For JDBC

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

thanks

[Former Member · Accepted solution]

Hi,

Thanks for ur reply. If possible please send the code for RFC.

Warm Regards,

N.Jain

[Former Member]

Hi Jain,

I have done similar interface.. i was unable to attach screen shots.. to this mail.

anyway i can breifly describe the steps:

R3:

-

---

best approach is to create an Remote Enabled Function module @ R3,

create a report program to trigger this interface or if you want this interface to be triggered while executing any transactions call this RFC in user exit.

make sure there is no code inside the RFC, only import/export/tables parameters...

code should be written in the report program for example

Report name.

code...

code...

code...

call "Function Module" IN BACKGROUND TASK

DESTINATION " RFCDESTINATION"

COMMIT WORK.

create RFC Destination SM59 , Type T and use Resistered server program.

XI:

---

Integration repository

create data type, message type, messge interface for Receiver (SQL database).

and import the RFC for sender (R3)

Message mapping

Interface mapping

in Integration Directory

for Sender COmm Channel:

Adpater Type: RFC

Transport protocol : RFC

Application Server (Gateway)

Application Server (Service)

Program ID

above mentioned 3 paramaters should be same as you have mentioned while creating RFCDESTINATION (SM59) in R3.

and enter logon details.

For Receiver Comm Channel:

Adapter type: JDBC

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://SERVER(IPADDRESS)\AAAA:3329;DatabaseName=XXXX

enter logon details of Sql database

create sender agreement, receiver agreement, receiver determination, interface determination.

thats it...

This should work for your case.

Jeff

[santhosh_kumarv]

Hi

<b>Chech out this Blog for Receiver JDBC</b>

<a href="/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step Receiver Adapter -- Synchronous Select</a>

WIKI

<a href="https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC">JDBC XI JDBC</a>

Regards

Santhosh

[url=; Use a Good Subject Line, One Question Per Posting - Award Points[/url]