Extract Report Painter result to SAP-BI

[Former Member]

Hi pros,

currently we use R/3 reports done with report painter to generate excel files which are afterwards imported to BI via Flatfile connection. This "§$§&!s but the data is needed there and no standard extractor would deliver the data.

I thought about a datasource with function module.... to call a report via ABAP and transfer the data to BI.

Any Idea of how this could work? + Every month another restriction is needed for those reports.

thx

chris

[maxilopez]

Hi Christian,

There is a how-to guide about datasources based on function modules that could be helpful:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8df33&override...

Inside function module code, to invoke the report and get values, I think that you can use something like:

SUBMIT zreport EXPORTING LIST TO MEMORY
AND RETURN
WITH P_VKORG = P_VKORG
WITH S_KUNNR IN S_KUNNR.

DATA: ABAPLIST LIKE ABAPLIST OCCURS 0.
CALL FUNCTION 'LIST_FROM_MEMORY'
TABLES
LISTOBJECT = ABAPLIST
EXCEPTIONS
NOT_FOUND = 1
OTHERS = 2.

I hope it helps you.

Regards,

-

Maximiliano

[Former Member]

Hi Maximiliano,

thx for the response. How to create an export datasource using FM is clear.

The main issue was how it is possible to execute an retrieve data from an report painter

query.

It is not executable via "submit" as it is not a SE38 program....

[former_member256474]

Hi Christian,

You can create a generic extractor based on the table used by the Report painter report. Or use the standard extractor for the area of the report.

For example, if your report painter report is based out of GLT0, you can used the standard extractor 0FI_GL_1.

Primarily, find out the table behind the report painter report.

Then find out the corresponding standard extractor if it exists

If not create a generic extractor based on the report painter table.

Rest of the build can be done in BW.

Roy

[maxilopez]

Hi Christian,

I see your point. Try to execute the report through GRR3 transaction and go to "System" -> "Status" menu option.

In "SAP Data", "Repository data", "Program" field, you should find the technical name of the ABAP program associated to the report.

I found a how-to that uses that program name to create a transaction through SE93. Alternatively, I think that you can use it to write an invocation inside the function module.

I hope this helps you.

Regards,

-

Maximiliano

[Former Member]

Hi Christian,

when submitting the R/3 report generated from the report painter report you cannot access the data. In order to be able to get the data you can use function module CRIF_RW_WEB_CALL_REPORT.

Cheers and best regards to the folks in K13 ...

Claus

[Former Member]

Hello Claus,

Could please let me know how to use the function Module CRIF_RW_WEB_CALL_REPORT. Iam trying to get the values of the report writer using this FM however the FM is stopped on the Selection Screen of the report writer - giving a message "Check the Selection".

We are on ECC 5. I am using the below logic  to pass the values to the FM  -

ATA: i_data TYPE STANDARD TABLE OF grwwebdata,

      i_params TYPE STANDARD TABLE OF alv_s_param_wp,

      wa_params TYPE alv_s_param_wp,

      i_msgs TYPE STANDARD TABLE OF bapiret2.



wa_params-pname = '$PARAMETER[$6-KOKRS'.

wa_params-pvalue = '1000'.

APPEND wa_params TO i_params.



wa_params-pname = '$SELECT-OPTION[_6ORDGRP'.

wa_params-pvalue = 'I[EQ[TEST3000'.

APPEND wa_params TO i_params.



CALL FUNCTION 'CRIF_RW_WEB_CALL_REPORT'

  EXPORTING

    i_report_group        = '6OBU'

*   I_PERS_APPL           =

*   I_NEW_SELECTION       =

*   I_DISPLAY_LIST        =

*   I_APPL_ID             =

*   I_VAR                 =

  tables

   IT_PARAMS             = i_params

    et_data               = i_data

    et_messages           = i_msgs

          .



if sy-subrc EQ 0.

  endif.

Please let me know your thoughts.

Thanks!

[Former Member]

Hi ritesh,

I have the same issue ("Check the Selection") when i trying to call a custom report trough 'CRIF_RW_WEB_CALL_REPORT', how you solved?