How to retrieve the data from SAP database.

[Former Member]

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. 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

[Former Member]

Not fully known!

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

[Former Member]

Hi,

So your scenario will be this way

RFC->XI->SOAP(Thrid party system)

For this below is the blog

/people/community.user/blog/2006/10/24/exposing-bapi-as-web-services-through-sap-xi

Thanks

Vikranth

[Former Member]

Hi,

This may help you

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1334 [original link is broken] [original link is broken] [original link is broken]

Regards

Seshagiri

[Former Member]

Hi,

You can use RFC or ABAP Proxy to make synchronous call with SAP.

Under RFC or ABAP Proxy Program you can get the data from SAP tables. Direct access to SAP Database is not preferrable even if its possible.

The better way to go for RFC or PROXY.

You will send the request from Third party system and the it will be as input parameters from RFC/ Proxy it will response based on it.

This got it all..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5474f19e-0701-0010-4eaa-97c4f78d...

/people/siva.maranani/blog/2005/09/03/invoke-webservices-using-sapxi

/people/stefan.grube/blog/2006/09/21/using-the-soap-inbound-channel-of-the-integration-engine

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit - File to RFC

HTTP to RFC - A Starter Kit

/people/community.user/blog/2006/12/12/http-to-rfc--a-starter-kit

Refer

Thanks

Swarup

Edited by: Swarup Sawant on Jun 4, 2008 9:32 AM

[Former Member]

Hi,

You can use either proxies or RFC to get the data from R/3 or download that data into a file on your presentation svr and trigger from there the XI.

Check this for file to SOAP.

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

check this for RFC to SOAP

/people/community.user/blog/2006/10/24/exposing-bapi-as-web-services-through-sap-xi

for proxies

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

Thanks,

Vijaya.