XI sender RFC adapter? Is it a little strange? Let's work out the scenario RFC to JDBC.
Key Point:
- Develop a RFC function module.
- How to configure the RFC sender adapter.
- How to design JDBC interfaces.
In the SAP Application system, go to T-Code SE37, copy BAPI_BANK_GETLIST to ZBAPI_BANK_GETLIST, and delete ALL the source codes. We are going to use this function later.
Create a RFC sender adapter, input all neccesary parameters and activate it.
Create TCP/IP type RFC destination with the same Program ID, in the SAP Application system.
And make sure you have a connection test without problem.
Then prepare a table with the following SQL script in Oracle database:
CREATE TABLE "HR"."ZBANK"
(
BANK_CTRY varchar2(5),
BANK_KEY varchar2(10) PRIMARY KEY NOT NULL,
BANK_NAME varchar2(50),
CITY varchar2(20)
)
;
Any other thing is ready. Let me show you a test.
Please be aware that this only happens after you have finished in IR & ID part.
Run the function in SE37 with the TCP/IP RFC connection.
RUN! RUN!
There are 4 entries which retrieved from the database.
It works. In this scenario we can run RFC function to retrieve data from non-SAP systems.
I'll talk about interface designing later.