100% found this document useful (2 votes)

17K views

1 page

This document explains how to RESET Export to Excel Settings in SAP

Original Title

How to RESET Export to Excel Settings in SAP

Copyright

© Attribution Non-Commercial (BY-NC)

Available Formats

DOCX, PDF, TXT or read online from Scribd

Share this document

Did you find this document useful?

100% found this document useful (2 votes)

17K views1 page

How To RESET Export To Excel Settings in SAP

This document explains how to RESET Export to Excel Settings in SAP

It is a good idea to make data backups of any objects with which you plan some actions, like developments, some cleanup or a data transfer. Transaction SE16 usually is used for table data view, but there is no export to excel button in standart setting.

View table data as ALV grid

To change the view of your data in SE16 transaction, proceed to top menu Setting->User Parameters..(F8).

There you can change output type to ALV Grid Display.

Export to desirable format

ALV Grid will allow you to export to Excel and other formats, just press the button Speadsheet… (Ctrl+Shift+F7).

Note, the maximum number of hits in the table is 200 as standard for SE16. It is possible, that not all data is shown. You can change the maximum number of hits on the selection screen of the table.

Start GUI Scripting recording from Process Runner. Execute your transaction and reach to a screen where report is displayed in ALV Grid.

Step 1: Once you are in ALV Grid Report, click on side first icon to expand list of ALV buttons

Step 2: Select "Local File"

Step 3: Select Spreadsheet

Step 4: Provide filename and click Replace (this will always overwrite the file without any additional prompts)

Note: If you see a different "windows" style Save file dialogue, download operation may not work when you actually play back the recording. Applying OSS notes might resolve this issue.

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

I was given a report to develop which would have a parameter as input on selection screen and display an ALV Grid report as output with required details. The purpose of the report was to download ALV output into excel and send it to vendor.

I wanted to make this report more user friendly and hence planned to develop this report using OOPS ALV with splitters & containers. Left pane showing the list of recently created data and the right pane showing details of the selected record.

Day 2 & 3

I figured out all the required database tables, created structures, internal tables and completed the business logic.

Created screens, used splitter container and build 2 ALV Grid (30% left and 70% right) using SALV class. Wrote handlers for click and double click. Everything was working fine at this instance.

Day 4

Since report was ready, I started adding top of page. Here came the hurdle. The report was not showing the top of page as I had used containers

I commented the parameter r_container in cl_salv_table\=>factory, the report was showing properly. But this time, my hitlist(Left container) was missing.

Approach

I found the program and screen number which SALV was using to display the report. I created a docking container instead of splitter and placed the docking container on that screen. Sample code below.

Sample

CREATE OBJECT go_dockcontainer

EXPORTING

repid \= 'SAPLSLVC_FULLSCREEN' " This is the program which uses SALV

dynnr \= '0500' "Screen number

* NO_FLUSH = 'X'

* DOCK_AT = DOCK_AT_LEFT

extension \= 300

* HEIGHT = 42

EXCEPTIONS

create_error \= 1

OTHERS \= 2.

Then I placed the hit list ALV on this docking container.

Sample

TRY.

cl_salv_table\=>factory(

EXPORTING

r_container \= go_dockcontainer

IMPORTING

r_salv_table \= go_hit_list_salv

CHANGING

t_table \= gt_sflight ).

CATCH cx_salv_msg. "

EC NO_HANDLER

ENDTRY.

The rest of the logic remained the same. I also found that I had to call set_top_of_list_print along with set_top_of_list in order to get exported to excel.

Another hurdle

Now, everything looked fine but I faced another issue. SALV was not refreshing. It was expecting an event in order to get refreshed.

I had created a dummy button and assigned to PF status. Triggered this OK_CODE via below code during event handling of hit list.

Sample

cl_gui_cfw\=>set_new_ok_code(

EXPORTING

new_code \= 'DUMMY' " New OK_CODE

).

I had refreshed the grid in user command of the second ALV.

Note:

- Every time something is selected on the hit list, an event is triggered. So if data is high, it might create a performance issue.

How do I hide a column in ALV output?

if u don't want those columns in the ALV, instead of hiding them delete from the Fieldcatalog. if u hide a column by using no_out = 'X' then that column can be brought to the ALV by using change layout button in the ALV toolbar.

How do I export an ALV report to excel?

Execute your transaction and reach to a screen where report is displayed in ALV Grid..

Step 1: Once you are in ALV Grid Report, click on side first icon to expand list of ALV buttons..

Step 2: Select "Local File".

Step 3: Select Spreadsheet..

How do I export a structure to excel in SAP?

select your hier object -> go to system menu -> select list -> save -> select local file -> then select your despot -> choose path -> give csv or excel format then download. these option every where available. like that down load any file you want.

How do I change the format of a list export spreadsheet in SAP?

Procedure.

Choose List Export Spreadsheet. ... .

On the Select Spreadsheet dialog box, choose the format in which you want to save the exported data..

Confirm your settings..

In the following dialog box, enter the path and name of the file and save the file. ... .

Enter the necessary settings..