Skip to Content

Issue in creating Zreport from Standard report

Hi I need to copy standard report RPTQTA10 into normal report and adding Excel download functionality.

Here I am facing one issue that the report output is from fm 'REUSE_ALV_GRID_DISPLAY'

Where field-catlog-SUM = 'x' .

When I download from the Internal table i.e. passed to FM 'REUSE_ALV'''... The data that is not formated will be downloaded ....

How can I pass the original O/P data to Excel that is downloaded???? Is there A way

How can we avoid this situation..Please help me.Thanks in advance.

Regards

Sas

Edited by: saslove sap on Apr 13, 2010 2:04 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 13, 2010 at 10:52 PM

    What's wrong with the standard dropdown menu that allows you to save to a file? Isn't that available? Please tell the users that you have checked every dropdown menu path and that there is no possible download option....the absolute last thing you should do is "clone" SAP code. In fact, you'll probably spend much less time and effort just writing a report that does what you need instead of trying to copy the SAP version, which is designed, after all, to be all things to all people...so there's always a LOT of functionality for which you have no need in the SAP version.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2010 at 12:12 PM

    REUSE_ALV_GRID_DISPLAY has Excel download function built in, why do you want to add this?

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 12:08 PM

    Do i get you right, the download is not formatted/sorted while the display is?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 12:10 PM

    Hi Sas,

    What i have inderstood from your question is :

    Why don't you pass the internal table final values to some other final internal table.

    Concatenate the header descriptions, Values in the fields , loop the final internal table and append one by one.

    Ex:

    CONSTANTS :  c_delim TYPE c VALUE cl_abap_char_utilities=>horizontal_tab

    .

    CONCATENATE  'Desc1'
                   'Desc2'
                   'Desc3'
          INTO wa_excel_dwnld-line
                                   SEPARATED BY c_delim.
         APPEND wa_excel_dwnld TO it_excel_dwnld.
         CLEAR: wa_excel_dwnld.
    
         LOOP AT it_output INTO wa_output.
         CONCATENATE   wa_output-field1
                                     wa_output-field2
                                     wa_output-field3
    
         INTO wa_excel_dwnld-line
                                   SEPARATED BY c_delim.
         APPEND wa_excel_dwnld TO it_excel_dwnld.
         endloop.

    Edited by: Mishra.Manas on Apr 13, 2010 2:11 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 08:13 PM

    > I need to copy standard report RPTQTA10 into normal report...

    "Normal report"??

    Perhaps you just want to check your "normal authorizations" for object S_GUI actvt '61'?

    A lot of "normal code" is wasted on working around SAP owned authorization-checks and the intentions behind them, but in this case you are a bit stumped because it is a central "base" check.

    As a workaround, you can take multiple screenshots if you can successfully run the report, change the layout or debug the internal tables...

    Cheers,

    Julius

    Add comment
    10|10000 characters needed characters exceeded