cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying a Bex Query results list in a Web Dynpro ABAP

Former Member
0 Kudos

Hello,

I'm interested in knowing how to integrate BeX Queries in WD Abap.

Assuming that i know the name of the BW Query, how do I get to call the Query passing the appropriate parameters (typically a select-option), and display the result in a Web Dynpro View?

By looking on the SDN, I found out that the right UIElement is BIApplicationFrame, but I cannot manage to display anything, even following the [example in this thread|http://forums.sdn.sap.com/thread.jspa?messageID=5272710#5272710].

Fact is, I barely know how to open the BeX Designer, so I have to follow a trial-and-error approach.

On the BIApplicationFrame UIElement, i set the properties:

dataProviderStateName: ZEQU_TESTQUERY (I also tried prepending the Infoarea name)

dataProviderStateType: Query

server: host.name:8010 (i assumed it's the same as the web dynpro abap)

Then on the WDDOMODIFYVIEW i wrote the following coding:


  DATA: lt_parameters TYPE if_wd_bi_applframe_method_hndl=>tt_name_value,
        ls_parameters TYPE if_wd_bi_applframe_method_hndl=>t_name_value.

  DEFINE add_parameter.
    clear ls_parameters.
    ls_parameters-name = &1.
    ls_parameters-value = &2.
    append ls_parameters to lt_parameters.
  END-OF-DEFINITION.

  IF first_time = abap_true.
    wd_this->m_appl_frame ?= view->get_element( 'BIAF_QUERY' ).
    wd_this->m_method_handler ?= wd_this->m_appl_frame->_method_handler.
  ENDIF.

  REFRESH lt_parameters.
  add_parameter 'CMD' 'PROCESS_VARIABLES'. " This is for Execute button
  add_parameter 'SUBCMD' 'VAR_SUBMIT'. " This one also for Execute Button

  wd_this->m_method_handler->execute_command( lt_parameters ).

When testing the WDA, the Element remains blank although the Web Browser displays some messages in the status bar that hint to the WDA connecting with something.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I only got the port number wrong, problem solved.

saravanan_narayanan
Active Contributor
0 Kudos

Hello Giuseppe ,

I think the host name should be your BW server name and not the webdynpro server name.

BR, Saravanan