BEx query data into ECC System

[Former Member]

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

[Former Member]

Resolved myself.

[Former Member]

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

Will it be okay if the data is exported as a flat file? Will that solve the case? If so, in BW server, you can goto RSANWB and create a general APD model. The datasource = Query ZTEST_BI_ECC; The target = FLATFILE. Using a ABAP program at ECC end you can populate the data to the R/3 system using a small csv read. Do let me know your comments?

[Former Member]

Hi Arun !

Thanks for your reply. I have already resolved that CSV to ECC Z table & it is working fine. But I am trying to use BEx query to ECC. If you can guide. it will be of great help.

With Regards

Rekha