Skip to Content
avatar image
Former Member

SUBMIT the report using ALV

Hi Experts,

i want to prepare the report as i want to submit the another report using varint in alv report so pls provide the solutuion

and at the same time i want to download the dat from the alv output

Thanks & Regards

Mohan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 08, 2008 at 11:34 AM

    Hi,

    In the function module REUSE_ALV_GRID_DISPLAY, use the paramter IS_VARIANT and I_SAVE.

    Then write a program to call your report.

    Regards,

    Dhanunjaya Reddy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 11:41 AM

    Hi,

    First declare a parameter for a variant of layout for an ALV report.

    And add a code to download the internal table which is used for alv display using FM gui_download .

    Now in the second program use the submit statement shown in the below sample code.

    REPORT report1.

    DATA text TYPE c LENGTH 10.

    SELECTION-SCREEN BEGIN OF SCREEN 1100.

    SELECT-OPTIONS: selcrit1 FOR text,

    selcrit2 FOR text.

    SELECTION-SCREEN END OF SCREEN 1100.

    ...

    Calling program

    REPORT report2.

    DATA: text TYPE c LENGTH 10,

    rspar_tab TYPE TABLE OF rsparams,

    rspar_line LIKE LINE OF rspar_tab,

    range_tab LIKE RANGE OF text,

    range_line LIKE LINE OF range_tab.

    ...

    rspar_line-selname = 'SELCRIT1'.

    rspar_line-kind = 'S'.

    rspar_line-sign = 'I'.

    rspar_line-option = 'EQ'.

    rspar_line-low = 'ABAP'.

    APPEND rspar_line TO rspar_tab.

    range_line-sign = 'E'.

    range_line-option = 'EQ'.

    range_line-low = 'H'.

    APPEND range_line TO range_tab.

    range_line-sign = 'E'.

    range_line-option = 'EQ'.

    range_line-low = 'K'.

    APPEND range_line TO range_tab.

    SUBMIT report1 USING SELECTION-SCREEN '1100'

    WITH SELECTION-TABLE rspar_tab

    WITH selcrit2 BETWEEN 'H' AND 'K'

    WITH selcrit2 IN range_tab

    AND RETURN.

    Regards,

    Padmaja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 11:43 AM

    Hi,

    This is going to be the same as any other report..... Use SUBMIT statement and call the ALV report .....it Variant is nit fixed..then make the Variant a part of Selection Screen of the Called Report and provide its name in the SUBMIT statement along with "WITH" option.....

    For Excel Download..you need not to do anything its a standard functionality with ALV....

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2008 at 11:48 AM

    hi Thanks for all for providing the solution

    Mohan

    Add comment
    10|10000 characters needed characters exceeded