ALV

[Former Member]

Hi friends,

I'm unable to download to spreadsheet or a local file or unable to print.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

• I_INTERFACE_CHECK = ' '

• I_BYPASSING_BUFFER = ' '

• I_BUFFER_ACTIVE = ' '

i_callback_program = i_repid

• I_CALLBACK_PF_STATUS_SET = ' '

• I_CALLBACK_USER_COMMAND = ' '

i_callback_top_of_page = 'TOP_OF_PAGE'

i_callback_html_top_of_page = 'HTML_TOP_OF_PAGE'

• I_CALLBACK_HTML_END_OF_LIST = ' '

• I_STRUCTURE_NAME =

• I_BACKGROUND_ID = ' '

• I_GRID_TITLE =

• I_GRID_SETTINGS =

is_layout = layout

it_fieldcat = i_fcat[]

• IT_EXCLUDING =

• IT_SPECIAL_GROUPS =

• IT_SORT =

• IT_FILTER =

• IS_SEL_HIDE =

• I_DEFAULT = 'X'

I_SAVE = 'A'

• IS_VARIANT =

it_events = event[]

• IT_EVENT_EXIT =

• IS_PRINT =

• IS_REPREP_ID =

• I_SCREEN_START_COLUMN = 0

• I_SCREEN_START_LINE = 0

• I_SCREEN_END_COLUMN = 0

• I_SCREEN_END_LINE = 0

• I_HTML_HEIGHT_TOP = 0

• I_HTML_HEIGHT_END = 0

• IT_ALV_GRAPHICS =

• IT_HYPERLINK =

• IT_ADD_FIELDCAT =

• IT_EXCEPT_QINFO =

• IR_SALV_FULLSCREEN_ADAPTER =

• IMPORTING

• E_EXIT_CAUSED_BY_CALLER =

• ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab = it_final[]

EXCEPTIONS

program_error = 1

OTHERS = 2

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

FORM html_top_of_page USING document TYPE REF TO cl_dd_document.

DATA: text TYPE sdydo_text_element.

CALL METHOD document->add_gap

EXPORTING

width = 155.

text = 'West Bengal Value Added Tax Rules,2005'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = 'The West Bengal Value Added Tax Rules,2005:'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 180.

text = 'FORM 54'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

data:wa_text(100).

concatenate wa_str16(2) '.' wa_str14(2) '.' wa_str1(4) into wa_text.

text = 'Statement of Issue of way bill in Form 50 received up to:'.

concatenate text wa_text into text separated by space.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = text.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = '[See* Sub-rule(3) of rule 110 sub-rule(3) of rule 111/Sub-rule(3) of rule 112]'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->new_line.

ENDFORM. "html_top_of_page

[Former Member]

Hi friends,

I'm unable to download to spreadsheet or a local file or unable to print.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

• I_INTERFACE_CHECK = ' '

• I_BYPASSING_BUFFER = ' '

• I_BUFFER_ACTIVE = ' '

i_callback_program = i_repid

• I_CALLBACK_PF_STATUS_SET = ' '

• I_CALLBACK_USER_COMMAND = ' '

i_callback_top_of_page = 'TOP_OF_PAGE'

i_callback_html_top_of_page = 'HTML_TOP_OF_PAGE'

• I_CALLBACK_HTML_END_OF_LIST = ' '

• I_STRUCTURE_NAME =

• I_BACKGROUND_ID = ' '

• I_GRID_TITLE =

• I_GRID_SETTINGS =

is_layout = layout

it_fieldcat = i_fcat[]

• IT_EXCLUDING =

• IT_SPECIAL_GROUPS =

• IT_SORT =

• IT_FILTER =

• IS_SEL_HIDE =

• I_DEFAULT = 'X'

I_SAVE = 'A'

• IS_VARIANT =

it_events = event[]

• IT_EVENT_EXIT =

• IS_PRINT =

• IS_REPREP_ID =

• I_SCREEN_START_COLUMN = 0

• I_SCREEN_START_LINE = 0

• I_SCREEN_END_COLUMN = 0

• I_SCREEN_END_LINE = 0

• I_HTML_HEIGHT_TOP = 0

• I_HTML_HEIGHT_END = 0

• IT_ALV_GRAPHICS =

• IT_HYPERLINK =

• IT_ADD_FIELDCAT =

• IT_EXCEPT_QINFO =

• IR_SALV_FULLSCREEN_ADAPTER =

• IMPORTING

• E_EXIT_CAUSED_BY_CALLER =

• ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab = it_final[]

EXCEPTIONS

program_error = 1

OTHERS = 2

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

FORM html_top_of_page USING document TYPE REF TO cl_dd_document.

DATA: text TYPE sdydo_text_element.

CALL METHOD document->add_gap

EXPORTING

width = 155.

text = 'West Bengal Value Added Tax Rules,2005'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = 'The West Bengal Value Added Tax Rules,2005:'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 180.

text = 'FORM 54'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

data:wa_text(100).

concatenate wa_str16(2) '.' wa_str14(2) '.' wa_str1(4) into wa_text.

text = 'Statement of Issue of way bill in Form 50 received up to:'.

concatenate text wa_text into text separated by space.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = text.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->add_gap

EXPORTING

width = 150.

text = '[See* Sub-rule(3) of rule 110 sub-rule(3) of rule 111/Sub-rule(3) of rule 112]'.

CALL METHOD document->add_text

EXPORTING

text = text

sap_emphasis = 'Strong'.

CALL METHOD document->new_line.

CALL METHOD document->new_line.

ENDFORM. "html_top_of_page

[Former Member]

Hi,

Check this link-

[Former Member]

Check your filed cat.. Surly there will b some issue in your field cat even though they are displaying in Grid correctly.

Thanks,

Ananth

[Former Member]

hi Hosmath

in ALV, download functionality available,

In menu list->export there u can download

this option is disable when you create your own PF Status with excluding STANDARD PF STATUS

try make use of standard button excel download

Regards

Deva

[Former Member]

Hi,

How to download or print along with top-of-page text.

When u download,top-of-page & end-of-list datas not coming..........

How to do it.

[Former Member]

usually

while calling the alv itself there will be an option for downloading the list to local file

or else type %pc in the command bar

it will prompt u to a popup asking for type type of file which u need to download

try this

in case if u have any issues let me know

[Former Member]

Hi,

It's not coming along with heading in top-of-page know....

and %PC is not working on the alv output screen....