Skip to Content
avatar image
Former Member

Abap Report exection depending on the no of rows in excel sheet.

I have one report-1 and one excel sheet where data is there (eg:- several rows) Now my report-1 executes perfectly for one row of sheet . My requirement is that I want to run that report-1 for all rows of excel . So for that I want to execute report-1 from report-2 for all rows of excel sheet . How to achieve this?

Add comment
10|10000 characters needed characters exceeded

  • "Executes perfectly" but where? Are you triggering an SAP report from Excel? If so then how do you do that exactly? Do you start a report from SAP GUI? Then how exactly is it connected to Excel?

    Please add more details so that this question could be answered intelligently.

  • Get RSS Feed

2 Answers

  • Apr 18, 2018 at 03:23 PM

    Hi,

    If report-1 is a custom report, then i don't think there is any need for another report. After converting the excel data into an internal table you can loop in that internal table and write the logic of your program inside it.

    If you want to call report-1 from another report then you can use SUBMIT <report-1> AND RETURN. But then you have to think of a way to pass values to report-1 as well. So better to do it in a single program.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2018 at 04:04 PM

    Hi Manali,

    1. Consider calling function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' to get excel data into internal table and read (Loop) it.

    2. Below SAP documentation to help you working with submit.

    https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abapsubmit.htm

    Regrads,

    Add comment
    10|10000 characters needed characters exceeded