ALV

Former Member — Thu, 03 Apr 2008 09:57:49 GMT

Hi,

I have one ALV program which extract and displays Source Status,but at output while downloading the data into local system as excel format,it doesnt download properly.

Please give me some solution for this,how is the download option comes???

Definitely reward will be given.

Thanks in advance.

Re: ALV

Former Member — Thu, 03 Apr 2008 10:01:57 GMT

Hi,

Check the following link:

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

Regards,

Bhaskar

Re: ALV

Former Member — Thu, 03 Apr 2008 10:03:01 GMT

WHich Option you are using.

you can have following options

Local File-> Unconverted

Localfile->Spread sheet, Try both and see..

Re: ALV

Sm1tje — Thu, 03 Apr 2008 10:04:23 GMT

What's wrong with the output?

There are some notes on the download limitations:

For example NOTE 358644

Summary

Symptom

Generally, the ALV supports three ways of connecting to Excel:

1. XXL interface:

ALV list (REUSE_ALV_LIST_DISPLAY), ALV Grid Fullscreen (REUSE_ALV_GRID_DISPLAY)

Menu path: List->Export->Spreadsheet

ALV Grid class (cl_gui_alv_grid):

Toolbar: Export->Spreadsheet

2. Local file in spreadsheet format:

ALV list (REUSE_ALV_LIST_DISPLAY), ALV Grid Fullscreen (REUSE_ALV_GRID_DISPLAY)

List->Export->Local file->Spreadsheet

ALV Grid class (cl_gui_alv_grid):

Toolbar: Export->Local file->Spreadsheet

3. Excel inplace as of Basis Release 4.6C

ALV Grid Fullscreen (REUSE_ALV_GRID_DISPLAY)

Menu path: Views --> Microsoft Excel STRLSHIFTF7

ALV Grid class (cl_gui_alv_grid):

Toolbar: Icon Views --> Excel Inplace

Note the following restrictions:

1. XXL interface

The date appears in the internal format (yyyymmdd) during a download to an Excel file in the ALV. By starting the Report again you can change to the external dislay across the system. You must have implemented Note 316814 for Basis Releases 4.5, 4.6B and 4.6C or imported the corresponding Support Package for the Note.

Currency fields are displayed exclusively with 2 decimal places in Excel.

Quantity fields are output with their original field definitions (for example, with three decimal places)

The system sorts or groups the columns together according to characteristics and key figures

The prerequisite for a correct grouping is that at least one characteristic column is displayed in the ALV Grid.

A filter entered in the ALV is not taken into account in Excel.

Rows are sorted differently in Excel.

If you are using conversion exits, refer to Note 764272.

For technical reasons, the Excel export provided in the ALV cannot support the functions mentioned above.

You must use the R/3 dialog box to exit the Excel window (see Note 329797) to ensure that the connection between SAP R/3 and Microsoft Excel is closed correctly. It is not possible to open multiple Excel windows.

2. Local file in spreadsheet format:

The system copies all features of the ALV display, regardless of ALV List, ALV Grid Fullscreen or ALV Grid class. This process includes:

Filter

Sorting

Control break

Totals

Column arrangement

Conversion exits

Currency formats

You must import the file into a separate Excel Sheet by using Excel tools.

3. Excel inplace

As of 4. 6C, you can display data in the inplace in almost the same way as in the Grid for ALV Grid Fullscreen and ALV Grid class. However, certain preconditions (for example Excel Templates) must be fulfilled for you to do this. Refer to Note 305900; this gives you the optimal solution for the existing disadvantages of the XXL interface and information about how to download into a local file.

Different Excel worksheets are displayed:

Format: The formatted output of the table in Excel

Header: Format + HTML header data for the ALV Fullscreen

Pivot: Data in Pivot format (cross table)

Sub1 to Sub10: n-level output of subtotal lines

RawData: Raw data without formatting

RawHeader: Raw header without formatting

In the Excel print dialog, you can choose "Selected pages". Then the system only prints the Excel sheet currently displayed.

The Excel print preview and Excel save functions do not work because Excel is running in the inplace.

The HEADER sheet is filled only if the application has filled the HTML header of the ALV Fullscreen using the REUSE_ALV_COMMENTARY_WRITE service function module. If "free" HTML was generated using the object reference of a dynamic document, this header cannot be mapped in Excel.

The application can of course decide which ALV function is considered to be useful. To do this, it can hide certain functions.

Internal note:

Note especially that deep structures are not supported during the export, and that it may be necessary to hide the function codes for the export, Word, ABC analysis and spreadsheet.

Other terms

SAP List Viewer

ExcelExport, XXL, table, spreadsheet, Third Party

Reason and Prerequisites

Execute one of the activities described above in the ALV.

764272 - XXL: special visualisations/conversions are not retained

540779 - FAQ: Information system

316814 - ALV Export Excel: Switching date in ALV with Excel download

Related notes:

Re: ALV

Former Member — Thu, 03 Apr 2008 10:08:05 GMT

Step 1: Select the 2nd radio button while saving ur ALV to local file

Step 2: During this save;actually the file got saved in 'UniCode' format. So once more u plz salect 'save as' from the 'file' menu and save it as Excell format..

Check it..

Re: ALV

Former Member — Thu, 03 Apr 2008 10:14:08 GMT

Hi,

Thanks for the answer,I tried with both the options...still it's not coming properly...means...

Plnt Group GrC Task list description Srce.list Material

1018 11-Nov 9901

1018 13-Nov 9911

1018 129694-5 9901

1018 200100-1 9901

1018 NAS1189E08P10 153309

that means it down loads date in place of group srce list.....

please give me some solution.

topic Re: ALV in Application Development and Automation Discussions

ALV

Re: ALV

Re: ALV

Re: ALV

Re: ALV

Re: ALV