Skip to Content
avatar image
Former Member

How to retrieve the data from SAP database.

Hi Pals,

How to retrieve data from SAP R/3 System to my third party software. I will make my query little bit more clear. There is a list of assets entered and stored in the SAP system. For example 3 mobile phones.

1) Mobile 1- Nokia

2) Mobile 2 - Samsung

3) Mobile 3 u2013 Sony

Now think I do not know what all assets is there. Now I have to retrieve the data and get it on my third party software. Just display the list of assets. Lets say SAP XI is also there. Now how will I map it and get the details.

Please give me step by step method.

N.B: Just to read the data from SAP database.

Please make the flow clear step by step.

Thanking you

AK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 06, 2008 at 09:37 AM

    Hi Anil,

    You can use synchronous JDBC adapter to query the database which will read the data and will return the records as queried from the table.

    Regards,

    Subhasha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2008 at 10:48 AM

    Hi Anil,

    The scenario is that you have details of mobiles stored in a table in SAP R/3 system.You need to display the details of the same in some Non SAP system.

    The process is Synchronous and use File Adapter at sender and reciever side use RFC adapter. Create a Function modules which takes the input and dispalys the data from specified table.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2008 at 07:57 AM

    Hi,

    Use Proxies For Your Sender SAP System side and Use the Appropriate Adapter at Receuver side according to the Requirement

    Now scenario willl be Proxy-Xi---

    Logic:

    1) Write the Logic inside the Proxy report to pick the records from the tables

    2) And send it to Xi, Xi will routew the data to the third party System based on the adapter you selected

    ABAP Proxies Pre-requisites

    /people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies

    ABAP Client Proxies

    /people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2008 at 08:14 AM

    Not fully known!

    I have to do more R&D for this...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2008 at 09:58 AM

    Hi ,

    you can use in sender side jdbc adapter and receiver side xi adapter.

    once Integration repository,integration directory is activated after that

    schedule a communication channel.

    regards,

    surya

    Add comment
    10|10000 characters needed characters exceeded