Skip to Content

Open AfO-Workbook in Role with transaction

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25, 2017 at 07:17 PM

    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.
    
    Add comment
    10|10000 characters needed characters exceeded