Skip to Content
0
Former Member
Feb 06, 2012 at 09:36 AM

BEx query data into ECC System

136 Views

Hi Friends !

We need to pull the data from BEx query to ECC system. By referring forum got few sample code. But not sure how to view the data & move further.

Sample Code 1 :

DATA: r_request TYPE REF TO cl_rsr_request.

DATA: r_dataset TYPE REF TO cl_rsr_data_set.

DATA: wa_repdir TYPE rsrrepdir.

SELECT SINGLE * FROM rsrrepdir INTO wa_repdir

WHERE compid = 'ZTEST_BI_ECC' AND

objvers = 'A'.

CREATE OBJECT r_request

EXPORTING

i_genuniid = wa_repdir-genuniid.

r_dataset = cl_rsr_data_set=>get( i_r_request = r_request ).

r_dataset->refresh( i_version = 1 ).

2) Sample Code 2 :

DATA:

print_axis_data TYPE rrws_thx_axis_data,

wa_axis_data LIKE LINE OF print_axis_data.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

i_infoprovider = '0FIAR_C05'

i_query = 'ZTEST_BI_ECC'

IMPORTING

e_axis_data = print_axis_data.

3) Sample Code 3 :

DATA:

query_name TYPE rszcompid,

s_cubename TYPE rsinfoprov,

t_cell_data TYPE rrws_t_cell.

s_cubename = '0FIAR_C05'.

query_name = 'ZTEST_BI_ECC'.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

i_infoprovider = s_cubename

i_query = query_name

IMPORTING

e_cell_data = t_cell_data

EXCEPTIONS

no_applicable_data = 1

invalid_variable_values = 2

no_authority = 3

abort = 4

invalid_input = 5

invalid_view = 6

OTHERS = 7.

Ques : In which table the data is stored? How to view the data? How can we know whether all the data is extracted properly from BEx query to ECC system? Do any further coding is required?

With Regards

Rekha