Skip to Content
avatar image
Former Member

example required

what would be scenario when it is <b>file to idoc and idoc to JDBC[/b

can any one explain me in what cases these can be implemented..

i have to give a demo to the client...and if they where can u implement in our compnay....then i should suggest them...

<b>About the company:</b>

it is FMCG Company....it has got branches allover...

can anyone explain me what is that i should say them...

null

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2007 at 08:18 AM

    Hi Harsha,

    FILE --> XI --> IDOC Scenario.

    This is the case where any third party system (i.e. non SAP ) wants to transfer data to SAP R/3 system. The first step is to convert the flat file into XML format as XI only works with XML . XI maps the file in and corresponding XML IDOC structure is created. At receiver side a Receiver IDOC Adapter is used to post the IDOC into R/3 system

    IDOC --> XI --> JDBC

    In this case if you want to transfer data from any SAP R/3 system to Any DBMS.

    again at sender side you dont need to specify sender IDOC adapter as XI pulls data from R/3 system. you just need to provide RFC destinations in XI as well as in R/3

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      SOAP to RFC:

      Consider your webapplication support customer to track their order status in such case webservice can call RFC to get information from R/3.

      Regards,

      Gourav

  • avatar image
    Former Member
    Mar 30, 2007 at 09:18 AM

    HI,

    FIle -- XI -- IDoc

    In general , from file data / legacy systems or EDI systems to SAP R3 then we will use this type of scenarios. so Also updating the Master data, customer data, Orders related Sales , Purchase Orders, delivery, CRM, Bank, custoer idoc related data into SAP R3.

    Idoc --Xi -- JDBC

    In general SAP R3 data like explained above will be moved to SQL server or Oracle database or AS400 or DB or similar kind of Database in such situations we will use this, say for example the storage locations or plant using the old database, so we should transfer the SAP R3 data to such database,

    See the below links

    /people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

    /people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping

    File-XI-IDoc Scenario

    /people/anish.abraham2/blog/2005/12/22/file-to-multiple-idocs-xslt-mapping

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

    Receiver JDBC scenario - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

    /people/ajay.kumar/blog/2005/03/24/writing-bsp-for-sap-r3-version-46

    /people/sugree.phatanapherom/blog/2005/08/14/configuring-sld-in-sneak-preview-sap-netweaver-04-sneak - SLD preview

    /people/sanyam.kapur/blog/2005/04/30/custom-fields-and-bw-extractors-making-a-mixed-marriage-work-part-ii

    Regards

    Chilla

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 30, 2007 at 08:18 AM

    Depends on the application You can select your scenario.....

    Suppose If you are integrating with two applications like SAP and Database,then the scenario would be like IDOC to JDBC.....You have to use IDOC adapter for SAP and JDBC adapter for Database integration.....

    Go through this link....

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/media/uuid/0b95b488-0701-0010-57b9-e861b1ad572f

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 30, 2007 at 08:24 AM

    still any help plz...

    Add comment
    10|10000 characters needed characters exceeded