Skip to Content
avatar image
Former Member

submitting of report using selection screen

Hi,

My requirement is iam having one report so it is executed when we r given site and date it gives one excel file data so now iam having 150 sites so now I want to write the report as date as selection screen and I want to submit that report in this one (new report) so it wants to take the sites automatically from werks (t001w table) and it wants to execute in a loop upto 150 times then it gives 150 excel files so now how can I pass the sites and date to the submitting selection screen date as same for all but only the site wants to varry in the submitting report pls provide the coding ..

Thanks & Regards,

Mohan Reddy.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 18, 2008 at 06:42 AM

    Hello Mohan Reddy,

    I think we can try in this way

    data: y_v_rspar_line LIKE LINE OF y_v_rspar_tab,

    y_v_rspar_tab TYPE TABLE OF rsparams,

    y_lk_parm3 TYPE char5 VALUE 'SPERR'. " Selection screen variable name

    y_v_rspar_line-selname = y_lk_parm3.

    y_v_rspar_line-kind = y_k_p.

    y_v_rspar_line-sign = y_k_i.

    y_v_rspar_line-option = y_k_eq.

    y_v_rspar_line-low = y_k_e. "Excel file site value.

    APPEND y_v_rspar_line TO y_v_rspar_tab.

    SUBMIT Program name USING SELECTION-SCREEN '1000'

    WITH SELECTION-TABLE y_v_rspar_tab AND RETURN.

    But try in 2different ways i.e

    1) Keep the submit program in the loop of the excel file internal table

    and take the site value in the variable and pass the value to this y_v_rspar_line-low

    and call submit program.

    2) Sort the excel file internal table then pass all the values to y_v_rspar_line-low and use the append statement in the same way and then call the SUBMIT program outside the loop.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2008 at 08:01 AM

    Hi,

    Try like this

    SUBMIT <called program name>
                  WITH <selection screen element> EQ <value passed>
                 WITH <selection screen element1> EQ <value passed1>
             VIA SELECTION-SCREEN.
    

    Add comment
    10|10000 characters needed characters exceeded