on 02-25-2008 12:28 PM
Hi all,
I wanted to create a BSP application which retrieves the data from BW and then it displays the data .
For that i have created a BSP(for selection screen using HTML and java script).
There is a BW query which retrieves the desired data from BW.
Now can anyone please tell me how to get data from that BW QUERY data from BSP??
I think there is a function module RRW3_GET_QUERY_VIEW_DATA for that.
But i dont know how to use that.
Please help me out.
Regards,
Sumanth
/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Durairaj ,
First of all let me tell u, that u r awesome....Your blogs were too good.
Initially i tried to use your function module, but there isnt a class called cl_rsr_query_variables.
So i tried using RRW3_GET_QUERY_VIEW_DATA.
But i am getting a dump saying "Exception condition "NO_APPLICABLE_DATA" raised. ".
Here is the code im using.
zparam-NAME = 'VAR_NAME_1'.
zparam-VALUE = '0RPA_BDD'.
append zparam to zparam2.
zparam-NAME = 'VAR_VALUE_EXT_1'.
zparam-VALUE = '20080220'.
append zparam to zparam2.
CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'
EXPORTING
i_infoprovider = 'ZMC_POS_A'
i_query = 'REP_ZMC_POS_A_001_TEST'
i_t_parameter = zparam2
IMPORTING
e_axis_data = wa_axis_data
e_cell_data = wa_CELL_DATA.
Can you also tell me how to pass to i_t_parameter , if i want to use a date range.
Thanks in advance.
Regards,
Sumanth
how to pass parameter :
its the same as you would pass parameter in the url (for calling the query over web) which is explained here
http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/frameset.htm
Raja
Hi Raja,
Thanks for your reply.
My problem is solved now. Thanx for that.
But Now I am facing another problem.
After retrieving data from RRW3_GET_QUERY_VIEW_DATA , i am passing the AXIS and CELL internal tables to
CALL TRANSFORMATION, so as to convert it to XML.and i am successful doing that.
Now i have data in XML format.
and i want to display that using XSL.
Now Where to write that XSL coding??that is in layout section of the page in BSP or anywhere else???
Thanks for solving my previous problem.I will definitely reward points for that.
Regards,
Sumanth
check this blog
/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.