Skip to Content
Sometimes back there was a  question (Re: access database table or flat file in Web template) in   BI Suite – Business Explorer (SAP Business Explorer (SAP BEx))  forum about reading SAP table from web  template at runtime. I had suggested using AJAX  (http://en.wikipedia.org/wiki/AJAX)  programming. In this weblog i will try and demonstrate how to read data returned  by “BAPI_FLIGHT_GETLIST” dynamically at runtime from BW web template.Within the web template XMLHTTPRequest is used to  execute the BSP application and get the data back. The returned XML is converted  into HTML table in two ways a) using XSL Transformations  (http://www.w3.org/TR/xslt) b)  reading the XML elements using JavaScript.    Once the Webtemplate is created save it and run from browser to see the result.   The result will look like below.  image
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    Hey Raja,

    Why we need BW for displaying R/3 data directly, no ETL (datawarehousing)???

    Anyways, its a good BSP/Web Application Example.

    Cheers!!!!!!!

    (0) 
  2. Former Member
    Interesting reading, thanks.

    Is it possible to use a library like dojo for handling the ajax call instead of coding all this manually? If so, maybe you can blog about this with more details?

    (0) 
  3. Former Member
    Hello sir,
    i have problme while excuting the template,in my data.xml,when i pass airline name to data.xml via URL variable,passed airline variable is blank to data.xml,and thats y it is not runing properly,can u solve my problme…
    (0) 

Leave a Reply