Skip to Content
avatar image
Former Member

Data as Pivot Table

Hi Exports

How to export the data in ALV as Pivot Table.

Pls help me on this.

Thanks in advance.

Regards

Rajaram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 11, 2008 at 05:53 AM

    Hi Raja Ram,

    Use this funciton module and problem will be solved:

    FUNCITON MODULE: XXL_FULL_API.

    AND CHECK THIS REPORT AND EXECUTE THIS REPORT FOR BETTER UNDERSTANDING.

    REPORT: XXLTTEST

    Award points if helpful.

    Kiran Kumar.G.A

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2008 at 05:53 AM

    Hi,

    On the ALV screen, just select export button and in that you will get the option to export in Pivot file.

    Regards,

    Pankaj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Inwhich the available formats are

      MHTML format

      XML Format

      Internal XML Format

      Internal Table

      XXL Format

      yar, not pivot table, what could be the reason actually.

  • avatar image
    Former Member
    Jan 11, 2008 at 06:24 AM

    Hi Raja,

    The following explanation helps u in understanding the process of exporting the data.

    Please find the following SAP Note 700206.

    Symptom

    Excel export gives error "List object is too large to be exported" when a large list object is exported. This message comes only on usage of function module XXL_FULL_API for Export to Excel functionality.

    Other terms

    Excel Export, XXL Export, i_oi_spreadsheet, Size Limit,

    Reason and Prerequisites

    Older technology used and old MS Office release has limitaion of exporting only 16384 lines of data. This change is valid only for the SAP R3 release higher than 4.6C and MS Office release higher than Office 97.

    On The pop-up dialog "Export list object to XXL" with three options

    "Excel SAP macros", "Table" and "Pivot table", this change is valid only

    for "Table" and "Pivot table" option and not for "Excel SAP macros".

    Choice of "Excel SAP macros" option is not linked with this change for any R3 relaese.

    This correction is done in function module XXL_FULL_API and is only valid when XXL_FULL_API is called for Exporting the list to Excel.

    Solution

    Increased the Max Size Limit to 65536 rows and 256 columns. For Table and Pivot Table option of Excel Export. This change is available for office integration technology only and no adaption is possible to old SAP

    Macros. Import the relevant ABAP patch.

    NOTE: If you Export a Large list object there could be a performance problem and the same will be dirctly proportional to the amount of DATA (size of list object) Exported. The Maximum limits with XXL Export: Number of Rows - 65536. Number of Columns - 256. Size of individual cell - 255 Characters.

    Reward if helpful.

    Thankyou,

    Regards.

    Add comment
    10|10000 characters needed characters exceeded