SUBMIT the report using ALV

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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....

[Former Member]

hi Thanks for all for providing the solution

Mohan