Make sense of your SAP ERP HCM reporting options:
An exclusive one-hour Q&A today
with HR expert Danielle Larocca

Participate in a live Q&A today, Tuesday, June 21 from 1-2pm EDT with Danielle Larocca, a leading HR consultant with SpinifexIT.

Ask Danielle your questions on HR reporting tools – from SAP standard reports to SAP Query to ABAP custom reporting – and learn about the strengths and limitations of each of your HR reporting options. Danielle will post her answers to questions in the Forum thread.

A transcript of this Q&A is now availalbe, or view the full discussion thread below.

Register to get a preview of Danielle's newly updated HR Expert article “5 HR Reporting Options: How Do You Choose?”, normally available only to HR Expert subscribers.
 
If you are not yet an Insider Learning Network member, join today!

Sponsored by 

Hi Danielle - is there a way End Users can have the ability to run Adhoc Reports in Background mode and have the output sent out to them over email? 

Would like to have end users have the ability to execute reports faster and at the same time would like to avoid them the need to access various Transactions to get the output extracted.

regards'

Anand

Ok I have answered both questions with 1 reply, see below.

Re Scheduling & Email:

With the Query tools you can schedule them as jobs and have them sent to files or email but you will need to write an ABAP Function module to do that.  I have includedthe instructions on how to do that below.

CALL FUNCTION  'SX_TABLE_LINE_WIDTH_CHANGE‘    

                                EXPORTING  LINE_WIDTH_SRC = 134

                                LINE_WIDTH_DST = 255

                                TABLES  CONTENT_IN = bufferpdf "table from FM           CONVERT_ABAPSPOOLJOB_2_PDF

                                CONTENT_OUT = out_table

                                EXCEPTIONS ERR_LINE_WIDTH_SRC_TOO_LONG = 1

                                ERR_LINE_WIDTH_DST_TOO_LONG = 2

                                ERR_CONV_FAILED  = 3

                                OTHERS = 4.

Re: Allowing end users access:

IF the reports created via SQ01 are based on an SAP standard delivered logical database (like pnpCE) then yes it’s the same as them having access to the reports in the Easy Access menu.  There are conference presentations available on this site that provide the instructions for how to set it up correctly such that the security and performance are not a concern for end users using the SAP Query.

And of course if you want to see the only real-time reporting solution that runs live inside SAP in real time for all core SAP HR and Payroll data that is SAP certified – check out www.spinifexit.com/easy-reporter/. 

Danielle, thank you for joining us today! Before you respond to questions, I'd like to start with one. 

I know at this year’s HR conference in Amsterdam there was a lot of talk about ad hoc query versus SAP query, and there is a lot of confusion out there on this topic.  What are your thoughts?"

Hi Danielle,

Can you tell me a little about how you set up subtotals with an SAP Query report?

Thanks!
Laura