Save Time by Automating Your SAP Queries: Part 2

  • by Atul Bakliwal, Service Delivery Leader for SuccessFactors/SAP HR, IBM India
  • January 15, 2005
Part 1 of this series on how to automate an SAP Query, published in the October 2004 issue, showed the option of sending the output to a shared location. Part 2 explains the option of sending the output to users by email.
Key Concept
R/3 accesses the function module SX_OBJECT_CONVERT_ALI_HTM in SAPconnect to convert the SAP Query output to HTML format before sending it as an attachment in an email.

R/3 allows you to run an SAP query in the background on a regularly scheduled date. You can send the output to a shared location or by email to users in their SAP inbox or external email account in HTML, XLS, or PDF formats. You can use this process to automate any query or standard/custom reports.

Sending the output to users as an attachment requires these five steps, which I explain in detail below:

  1. Set up the query: Select the output format, dynamically default the dates, and save the query with a variant

  2. Set up the emailing option

  3. Set up the user ID

  4. Set up a distribution list

  5. Set up the job to run in the background

Atul Bakliwal

Atul Bakliwal is a seasoned, pragmatic SAP ERP HCM/SuccessFactors leader with over 20 years of deep expertise in solutioning, planning, managing, and delivering multi-faceted global implementations. He currently works for IBM India as a Service Delivery Leader for SuccessFactors/SAP ERP HCM, managing multiple implementations and AMS projects of various sizes and complexities in the SuccessFactor/SAP HR space.

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.