Skip to Content
Since this is my very first blog entry on SDN, I first probably should briefly introduce myself. My name is Erwin Tenhumberg, and I recently joined SAP. In my role as an Open Source Program Manager in the Global Ecosystem and Partner Group I’m looking into all kinds of Open Source related topics. Before I joined SAP, I worked at Sun Microsystems where I was deeply involved in Open Source as well. At Sun my focus areas included OpenOffice.org and the OpenDocument Format (ODF) in addition to things like Open Source business models. In this and future blog entries I want to explain how various SAP products integrate with different open source technologies. In addition, I hope that you will write comments to my blog entries, so that I can get a better understanding of the level of open source technology support that SAP customers and developers would like to see within SAP products. Finally, I will use my blog to report about SAP’s contributions to the Open Source world like SAP’s contributions to Eclipse or the Open Source related investments by SAP Ventures.  Due to my past involvement in OpenOffice.org and ODF, I was curious to find out if and where the SAP products already support the ISO standard OpenDocument Format. I was happily surprised when I found out that ODF is already supported by the SAP List Viewer component (also known as the ABAP List Viewer or ALV), which is used many many times in all kinds of areas for displaying tabular data in a grid. The SAP List Viewer component allows exporting to ODF spreadsheet files in addition to Microsoft Excel files. This feature is available on systems with release numbers 6.40 and higher and works for all 3 members of the SAP GUI family including the SAP GUI for Java. For more details about the feature please take a look at the SAP Note 876916  (https://service.sap.com/sap/support/notes/876916)! For example, this SAP Note lists details about supported releases and required support packages.   In order to illustrate how this feature works, I provide some kind of step-by-step tutorial including screenshots below. I first thought about doing a screencast, which I still might decide to do later, but then I realized that it might be easier for others to test the feature, if they can easily follow each single step. But don’t worry! The export feature is very easy to use and intuitive. For the simple test / demo I will use a simple test report that should be available on every system. Thus, it should be easy for everybody to test the feature.   O.k., let’s get started! First, a SAP GUI has to be started, and one has to login into a system. Again, please keep in mind that the release number has to be 6.40 or higher.  image  After the ABAP Editor has been started via the transaction SE38, we enter the report name “BCALV_TEST_GRID” …  image  … and click the “Execute” button:   image   In the following screen we can simply accept the defaults …  image  … and press the “Execute” button again:   image  Now some airline / airfare data is displayed in an SAP List Viewer grid:   image  We can call the export feature simply by clicking the “Export” button from the toolbar right above the grid:   image  Clicking the button brings up a dropdown menu from which we select the top item, i.e. the one called “Spreadsheet”:   image  In the dialog that pops up next, we select the middle option for the creating an OpenOffice.org / ODF spreadsheet file:   image  Now we have to select a directory and file name for the to-be-exported ODF spreadsheet file:   image  Once we have clicked the “Save” button, OpenOffice.org gets started and the SAP List Viewer data shows up in the OpenOffice.org spreadsheet application Calc. Since the application gets started via the mimetype assocation, this export feature should also work with any other application supporting ODF including KOffice or IBM Lotus Symphony. BTW, the ODF export feature of the SAP List Viewer component includes support for sub-totals and totals.  image  In cases where the SAP List Viewer component contains address information, it’s also easily possible to create form letters from the exported data. In order to do so, one simply has to create a new text document in OpenOffice.org and call the built-in Mail Merge Wizard:  image  In step 3 of the OpenOffice.org Mail Merge Wizard, …   image  … one simply has to click on the “Select Different Address List…” button …  image  … to add a new address list file by clicking “Add…” …   image  … and selecting the ODF spreadsheet file that we created earlier:   image
To report this post you need to login first.

34 Comments

You must be Logged on to comment or reply to a post.

  1. Cleber Santz
    Hi Erwin,
      i`m using BASIS 700 and SAP GUI For Java (710rev4), but this feature is not avaliable for me. There additional patch to be installed ?

    PS.: Tks for this info, i looking for this feature for a long time.

    (0) 
    1. Cleber Santz
      I Found the problem, must have a user parameter SLI=ODS10 to StarOffice option appear. I test it with OpenOffice 2.4 and work fine.

      I want know if have API to handle/write OpenDocument`s, i can`t find anything about this.

      Tks,
      Cleber

      (0) 
        1. Cleber Santz
          No, i want know if have any framework/function in ABAP for write/read ODF. Today i must create documents by hand(iXML methods or XSL Transformations) using ODF specs, there other way to do this ? Like TXXL function group for Excel ?

          Regards,
          Cleber

          (0) 
          1. Erwin Tenhumberg Post author
            I will look into this, but since I’m still fairly new to SAP, it might take me a few days to find out what the situation looks like.

            Best regards,
            Erwin

            (0) 
      1. Erwin Tenhumberg Post author
        Thanks a lot for pointing out the issue, and thus reminding me that my blog entry had gaps! Setting the user parameter is not the right solution. Please look at the SAP Note 876916 for details about the supported releases and required support packages.
        (0) 
      2. Cleber Santz
        Erviw,

          Even using ABAP 700 i can`t have this option, because this “cl_gui_alv_grid=>m_third_party ca cl_alv_bds=>mc_ods_frontend” return false.

           When using NW 2004s SP this option appear enable but i can`t open the document created.

        Best regards,
        Cleber Santz.

        (0) 
        1. Peter Van Avermaet
          We have the support packages required by OSS-notes 876916 and 1080608, but the ODS file produced by a “download to spreadsheet” in the ALV cannot be opened by Lotus Symphony 1.2 , so it seems.
          (0) 
  2. Jim Spath
    Edward – what a cool job title (“Open Source Program Manager in the Global Ecosystem & Partner Group”); I hereby dub thee “Open Sorcerer” ;-).  Funny, I use OpenOffice most often with SDN to spell check my blogs.  If there was an interface to launch that editor from Firefox instead of the standard pop-ups that would be awesome.  Just a thought.
    Perhaps we will meet soon?  Jim
    (0) 
    1. Erwin Tenhumberg Post author
      I will look into this, but since I’m still fairly new to SAP, it might take a few days for me to find out what the situation is around EarlyWatch Alerts.

      Best regards,
      Erwin

      (0) 
    2. Erwin Tenhumberg Post author
      I will look into this, but since I’m still fairly new to SAP, it might take a few days for me to find out what the situation is around EarlyWatch Alerts.

      Best regards,
      Erwin

      (0) 
  3. Sebastian Lauffer
    Hello Erwin,
    i surprised that ODF is already supported by SAP.
    Actually i try to create a concept/protoyp for import RFC/BAPI into IBM Symphony Spreadsheet.
    I have some trouble/difficulties with that, may you want here more about that.
    Best regards
    Sebastian
    (0) 
  4. Laurent Henry
    Hello,
    Very intereting Issue.
    Do you know if it is possible to have the same kind of function in BI.
    I would like to export web query result to openoffice instead of MS Excell ?

    Regards

    (0) 
  5. Laurent Henry
    Hello,
    Very intereting Issue.
    Do you know if it is possible to have the same kind of function in BI.
    I would like to export web query result to openoffice instead of MS Excell ?

    Regards

    (0) 
  6. Menelaos Maglis
    ALV export to openoffice.org is working fine for our basis 700 sp14 server, but not on our basis 640 sp22 one.

    The note 876916 clearly suggests otherwise…

    We use the latest sapgui (wingui 710 patch 9, javagui 710r6).

    Any ideas on what to look for?

    Thanks,
    Menelaos Maglis

    (0) 
  7. Sagar Bhosale
    I save a SAP Report in Spreadsheet format. The file opens with MS Excel without any problem. But when I open the same excel file into Open Office It asks for Character Set – Unicode to import.
    Is there any setting in Open Office or SAP, due to which the character set should not be asked while opening the file in OPen Office.

    Thanks
    Sagar

    (0) 
  8. Lorenzo Martínez
    Hi.

    We are swtiching to OpenOffice but we have found no way to execute the option “Export / Export to XXL” en Profit Reports such as KE30 (this option appears in SAPGUI for Windows, both 6 and 7 releases).

    We are on SAP ECC 6.0 / 700/0017 release level and have tested it both in SAPGUI Win 7.10 patch 11 and in Ubuntu 9.04 / SAPGUI for Java 7.10 rev 8. In SAPGUI for Java the option even dont appears.

    We are also suffering the same behavior already described of having OpenOffice (both 2.4 and 3.01) asking for character set when opening an exported spreadsheet, and when exporting to StarOffice as in your example, our result is an XML file shown in OpenOffice Calc as text (with all the file content in the first two rows).

    Any suggestions?

    Thanks.

    (0) 
      1. Jörn König
        Hello,

        we are also facing the topic of integrating SAP BW (BEx) and open office. Is it possible? are there any experiences?

        Best Regards
        Joern

        (0) 
  9. Egor Malov
    Erwin,
    thank you for this great introduction of ODF integration.
    Are there any further plans concerning OO integration? I’m particularly interested in officially supported OO integration into DOI (office document integration).
    Our customer is evaluating the possibility of switching to OO, so the feature request is to view & edit (inplace) ms-office documents with no MSOffice installed on the client (OO only).
    As of now it seems impossible.
    (0) 
  10. Raja Gopalan
    Hello Erwin,
    I am asking a question more about the OpenSource-to-Microsoft bridge functionality.  Some SAP Solution Manager documents will open automatically ONLY if MS Word is installed.  Can you please advise if SAP is planning a configuration location where Open Office may be used instead?  Please let me known if you prefer that i open an OSS message on this subject.

    Raja Gopalan

    (0) 
    1. Don Hardaway
      I would encourage SAP to work with the group that develops Open Office so that Open Office could be used instead of Microsoft Office in the product duet. I was told recently by a Vice President at SAP that there is no reason for SAP to work with Open Office. In fact, it was his impression that it was owned by Oracle. Clearly, there are some people that need to be educated about the licensing aspects associated with open source software. Everywhere I see ties to Microsoft Office or file formats I would like to see open source alternatives. This allows customers to have a choice.
      (0) 
      1. Kjetil Kilhavn
        Interesting reasoning. There is no reason to work with OpenOffice.org integration because Oracle owns OpenOffice.org, whereas there is good reason to work on Microsoft Office integration since that suite uses a free document format.

        I guess that Vice President needs to be told “it’s the document format, stupid”.

        (0) 

Leave a Reply