cancel
Showing results for 
Search instead for 
Did you mean: 

How to retrieve the data from SAP database.

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

Not fully known!

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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