Skip to Content
0

Open AfO-Workbook in Role with transaction

May 05, 2017 at 11:04 AM

82

avatar image
Former Member

Hi all,

based on a CDS-View I created an Excel with Analysis For Office that is stored in SAP NetWeaver in a Role.

Is it now possible, to open this workbook with a transaction or a report?

Thanks in advance

Thorsten

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Sep 25, 2017 at 07:17 PM
0

If anybody is interested in this, I have found a solution.

You can choose, if you want to open the query in AoF or in RSRT:

*&---------------------------------------------------------------------*
*& Report ZP_MM_REP_QUERY
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ZP_PP_REP_QUERY.


  DATA:
    l_t_rspar TYPE TABLE OF rsparams,
    l_s_rspar LIKE LINE OF l_t_rspar.


SELECTION-SCREEN BEGIN OF BLOCK SEL WITH FRAME TITLE TEXT-001.
PARAMETERS: P_SEL01 RadioButton Group SEL1,               "Choose if AoF
            P_SEL02 RadioButton Group SEL1 default 'X'.   "or RSRT
SELECTION-SCREEN END OF BLOCK SEL.


* Selektionstabelle füllen


if P_SEL01 = 'X'.


    l_s_rspar-selname = 'P_T_DOC'.
    l_s_rspar-kind    = 'P'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


    l_s_rspar-selname = 'P_T_QV'.
    l_s_rspar-kind    = 'P'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


    l_s_rspar-selname = 'P_T_QU'.
    l_s_rspar-kind    = 'P'.
    l_s_rspar-low     = 'X'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


    l_s_rspar-selname = 'P_T_NONE'.
    l_s_rspar-kind    = 'P'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


    l_s_rspar-selname = 'P_APP'.
    l_s_rspar-kind    = 'P'.
    l_s_rspar-low     = '00'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


*   set query name
    l_s_rspar-selname = 'P_QUERY'.
    l_s_rspar-kind    = 'P'.
    l_s_rspar-low     = '2CZC_V_QUERY'.
    APPEND l_s_rspar TO l_t_rspar. clear l_s_rspar.


    SUBMIT rs_ao_launcher WITH SELECTION-TABLE l_t_rspar AND RETURN.


    else.


   SUBMIT rsrt_bics WITH genuniid = '2CZC_V_QUERY'
              AND RETURN.


    endif.

Share
10 |10000 characters needed characters left characters exceeded