Merge SAP Data Directly into a Microsoft Word Document

  • by Jim Fang, Partner, ReachNett Consulting Inc.
  • Dawn Burns, QA Manager, Howrey LLP
  • June 15, 2005
It takes a lot of effort to enter names and other relevant information into form letters. Create a custom program that allows you to download SAP R/3 data into Microsoft Word document templates to expedite this process.
Key Concept
Object Linking and Embedding (OLE) is a technology that allows you to create objects in an application and use them with other applications via embedded or linked objects (e.g., SAP and Microsoft Word, Oracle and Excel). You can integrate desktop applications that provide their functionality into R/3 via a specific version of OLE, an OLE2 automation server such as Excel or Word. ABAP supports the OLE2 automation technique through its open object interface. From R/3 3.0, SAP has provided a set of ABAP statements for OLE automation that enable an ABAP program to communicate with desktop applications. SAP R/3 uses OLE to send R/3 data to Microsoft Word. For more information on SAP OLE automation, refer to the SAP documentation at ae3cac488f11d189490000e829fbbd/frameset.htm.

Do your end users spend a lot of time manipulating SAP data into programs like Microsoft Word? An SAP R/3 program that systematically downloads SAP data directly into a Word document could simplify the lives of your end users. Imagine how much your users might enjoy executing an SAP R/3 program that would download the SAP data directly into a training and events certificate or a service anniversary award letter into a Word document.

Jim Fang

Jim Fang is a techo-functional SAP HCM consultant with over 11 years experience. He has been a key player for numerous major SAP HR/Payroll and e-Recruiting projects. He has extensive experience with HCM business processes, payroll schema, taxations for US/UK/Canada, BSP, Web Dynpro, and HCM Processes and Forms. Currently he is a partner and senior consultant with ReachNett Consulting.

See more by this author

Dawn Burns

Dawn Burns is an SAP-certified human resources senior consultant and Quality Assurance Manager and HR Consultant with Howrey LLP. She is a former SAP Human Resources instructor for SAP America and has more than 12 years of experience in human resources and information technology.

See more by this author


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.