ABAP Freak Show: February 18, 2009


In this episode of the ABAP Freak Show we will take a look at how to retrieve data from a NetWeaver ABAP system via web services, and consume that data inside of SAP Business Objects Xcelsius. We will start by creating the web service provider in NetWeaver, and finish up by creating the web service connection and building our model in Xcelsius.  For this demonstration we will be working with a NetWeaver 7.01 system and Xcelisus 2008 SP1.

[blip.tv http://blip.tv/play/Ae3Sb5POSw%5D

Tags: , ,

7 responses to “ABAP Freak Show: February 18, 2009”

  1. Graham Robbo says :

    Good example Rich. Liked it a lot.

    Cheers
    Graham Robbo

  2. Ed Herrmann says :

    Excellent show, Rich. I think you should throw this link up on all the many repeated SDN forums about how to get Flex working with an ABAP web service. I have added it to the SDN wiki page that I created for consuming ABAP web services from Flex.

    Great show; thanks for filling in for Thomas while he was off partying in Cancun. 🙂

    Cheers,
    ewH

  3. Alex Schuchman says :

    I actually tried something similiar a while back using the “QUERY_VIEW_DATA” Web service from SAP BI. This way I could pull in BI data without having to use the Query as a web service. Plus it’s always nice to use the ABAP stack as a giant caching engine for Dashboard information.
    Really liked your end-to-end example. Very detailed and easy to follow.

    I also think it shows the selling point of web services and Xcelsius. If you asked one of the product people from BOBJ, they would have told you to use a Crystal Report to pull the R/3 data and then create a Live Office connection to pull that into Xcelsius. No one but a true ubergeek would use the Netweaver web services to link directly to Xcelsius.
    Keep um coming…

  4. Marv Monk says :

    Is there a download associated with this demonstration? Where do I get the function z_get_sales_data_by_country?
    Marv

  5. Rich Heilman says :

    Hi Marv. There is no associated download, and you just made me realize that I had just blown away the actual object from my system when I did a DB restore. So I can not provide it now anyway. It really was a very simple FM, actually it had a basic exporting parameter which used a table type which used a simple structure. Then I simply filled the table directly using dummy data in the FM code. So you could create your own very quickly. It does not have to be the same as my example.

    Cheers,
    Rich Heilman

  6. Thomas says :

    Hello, great show. We did the everything described in the video and in other documentations, but we still get an error message 2170. Are there some other sepcial settings we have to do?
    Thomas

  7. Dev_d says :

    Hello,
    Good show and very userfull one …Thanx for taking out some time from your busy schedule ………….Thanx again Heilman

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: