Extend the Table Introspector Utility Class to Support Long Text Data

  • by David Duncombe, SAP Analyst, Powerlink Queensland
  • December 15, 2014
David Duncombe shows how to use an extended table introspector utility class to dynamically generate a formatted representation of internal tables at run time, with added support for output to a Microsoft Excel workbook. This offers a more natural way to format long text data.
Learning Objectives

By reading this article, you will be able to:

  • Describe the basic options available to export data to Microsoft Excel workbooks from the SAP NetWeaver environment
  • Extend the previously described table introspector utility class to include support for output to a Microsoft Excel workbook
  • Understand how the extended table introspector utility class can handle processing long text data stored as SAPscript text objects
  • Integrate the extended table introspector utility class into a client program to take advantage of the new functionality
Key Concept
The iXML library is an API that offers core Extensible Markup Language (XML) services. These services can be exploited to construct XML documents that represent information in a Microsoft Excel workbook.

In my first article on the table introspector utility class, I showed how it was possible to dynamically generate a formatted representation of internal tables at run time, with support for subsequent output to various formats. Now I present an extension to the table introspector utility class. This extended implementation builds on the original implementation by offering support for output to a Microsoft Excel workbook.

I outline why this additional output format is so useful and then briefly compare some of the options available to export data to Microsoft Excel from an SAP NetWeaver environment. Next, I describe a demonstration program focusing on the new capabilities of the class. I also explain the implementation changes made to the class to accommodate the extended functionality.

David Duncombe

David Duncombe is an SAP Analyst at Powerlink Queensland. He has more than five years experience as a developer, and specializes in ABAP Objects and SAP NetWeaver Process Integration. He holds an honors degree in information technology from Queensland University of Technology.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.