Skip to Content
avatar image
Former Member

JDBC to IDOC scenario

Hello,  I am working on a JDBC to IDOC scenario where we are fetching the data from a database and we need to take a part of this data for an RFC call and once we get the response data from the RFC ,we need to merge the data we obtained from the JDBC and RFC and need to send vis an IDOC.  Could anyone please help in the design? I mean,how many message type and message interfaces do we need to create? is it possible without BPM?if with BPM then how we can implement in BPM? and if not then how?  Thanks for your help in advance !!  Regards,  Sambaran

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    May 16, 2013 at 06:08 PM

    Hi Sambaran,

    Yes. I don't think you need to have the BPM. What is your PI version??

    Develop all the objects considering that your scenario is simple

    JDBC-IDOC.

    In the message mapping, you can RFC look up option to get the response and use it in the mapping.

    Please refer to the below document to know more about RFC look up.

    http://scn.sap.com/docs/DOC-3805

    Regards,

    Hareesh

    Add comment
    10|10000 characters needed characters exceeded

  • May 16, 2013 at 06:13 PM

    Hi Sambaran,

    As Hareesh mentioned you could try using JDBC----->rfclookup----->IDoc scenario.

    If your lookup logic complicated then using RFC lookup not right idea,in this case i would prefer handling requirement in ECCMdevelop standard scenario JDBC---->pi-->(Proxy),in proxy implement RFC lookup logic before psoting document.

    You need to create one data type/message type/Service interface/Message mapping/Operation mapping.

    Search in scn.

    Regards,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2013 at 07:15 PM
    Add comment
    10|10000 characters needed characters exceeded

  • May 16, 2013 at 08:29 PM

    Hi Sambaran.

    This is a simple scenario if you are on PI 7.1. When you are making the RFC call ( most probably for retrieving data from ECC ) make sure you pass the data in a table and retrieve it similarly. This will avoid performance issues and you will be able to retrieve the data in a single RFC call.

    You will make the RFC call in the graphical mapping while mapping to the IDoc or to simplify, have 2 graphical mappings, one where you enrich the data through RFC call and another for mapping to the IDoc.

    Raj has already suggested on the design objects.

    Ambrish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2013 at 08:31 AM

    Hello,  I think you have misunderstood the requirement.  I need to fetch the data from the database and one part of this data will call an rfc and fetch the data from ECC.Now the I need to merge the another part of the data fetched from jdbc with the fetched data from ECC and need to send it via idoc to ECC.  Once ECC save this data,it will send an status idoc which need to be registered in the database system as well.  My idea is :  1. JDBC Request 1 ---> RFC request  2. JDBC Request 2 + RFC response --- > IDOC  Is it ok as mapping?  Thanks for your help in advance !!  Regards,  Sambaran

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sambaran,

      I have understood your requirement and have replied already. You can do 2 step mapping. To elaborate a bit more, You make the database call to first read the data, in first graphical mapping, make an RFC call to ECC and get the data back from ECC and populate an intermediate structure with enriched data. Then in second graphical mapping, map the data in intermediate structure to the target IDoc structure and post the IDoc in ECC.

      Take care of performance issues, like I have suggested in the earlier post.

      For the return leg where you need to post the data back to the database, you should treat this as another interface since IDoc communication is asynchronous.

      For this, get the response IDoc from ECC and simply map it to target JDBC structure.

      Hope it helps!

      Ambrish

      Message was edited by: Ambrish Mishra