Skip to Content
avatar image
Former Member

JDBC to RFC

I have to create a Asynchronous scenario, where I need to retrieve the Material Numbers from the JDBC and need to insert them into RFC.

Any help on the above scenario. Again this an Asynchronous scenario.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 22, 2007 at 08:07 PM

    Jenni,

    First create the Data type with <root> as the First node with 0..unbounded and all the fields which you are going to grab from the database. So your structure must look like..

    Step 1:

    <MT_MaterialMaster>

    <root> 0..Unbounded

    <Sub-field1/>

    ..

    ..

    ..

    <Sub-fieldn/>

    </root>

    </MT_MaterialMaster>

    Create the corresponding o/b interface for the above structure.

    Step 2: Import RFC from your R/3 system.

    Step 3: Map btw JDBC Message and RFC Message

    The rest of the objects are as usual. Could you tell us wher you got stuck so that it could be easy for us to suggest.

    raj.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2007 at 12:41 PM

    >retrieve the Material Numbers from the JDBC

    > and need to insert them into RFC.

    1. Import the RFC in IR.

    2. Create the JDBC sender data type and Data Type Message type as per JDBC format(for sender)..in this case it should look like

    3. when we import RFC in IR..Data Type, Message Type, Message Interface(in your case Inbound Asynch) not need to create.

    <Message Type Name>

    <row>

    <coloumn1>

    <coloumn2>

    <coloumn3>

    <coloumnN>

    </row>

    </Message Type Name>

    4. Create the Outbound interface for JDBC...

    5. Mapping between JDBC_MessageTypw and RFC

    6. Interface Mapping (Outbound Asynch JDBC interface and RFC)

    check ur Mapping and activate all the objects.....

    Follow all the steps in ID...

    RD, ID, SA and RA.

    Adapter ( JDBC Sender and RFC receiver..)

    Note: for retrieving data enter the valid SQL querry in the JDBC adapter...with update field = <TEST> (if u are not doing any update wile reading data.)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2007 at 07:09 PM

    Hi,

    As mentioned in two replies above, you could follow steps in Integration Repository and Integration Directory.

    However, following weblogs could be a worthy read to resolve and troubleshoot some of the technical issues, if you face them:

    For Sender JDBC Integration Repository steps as well as some finer points on JDBC adapter:

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    For JDBC sender adapter configuration:

    http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

    For RFC at receiver end in asynchronous mode, you could follow the steps explained in above-mentioned replies.

    Thanks,

    Bhavish

    Add comment
    10|10000 characters needed characters exceeded