Ask the HR Expert: How to Add Custom Infotypes to Your Queries for HR/Payroll Reporting

  • by Danielle Larocca, Senior Vice President, Human Capital Management, EPI-USE Labs
  • October 15, 2004
You can improve your SAP and Ad Hoc queries by adding custom infotypes with these step-by-step instructions.
Key Concept

Dear HR Expert,

How do you add custom infotype fields or even standard SAP infotypes such as date specifications to the Ad Hoc Query?

— Lynn White, Senior Business Analyst, HR

Thanks for the question. You use the same process to add both custom and standard infotypes to the SAP Query and the Ad Hoc Query. Before I explain that process, I’m going to give you some background on reporting in R/3.

The most common data source that is used for HR and Payroll query-based reporting in R/3 is an InfoSet. InfoSets were known as functional areas in versions earlier than 4.6. The InfoSet is made up of a logical database containing all the infotypes that you would like to report on. Three logical databases are available within R/3 for HR and Payroll:

  • PaP — HR Recruitment applicant master data

  • PnP — HR Personnel Administration (PA) master data

  • PcH — HR Personnel Development (PD) organizational data

Danielle Larocca

Danielle Larocca is currently the Senior Vice President of Human Capital Management for EPI-USE Labs. Previously she was the Executive Vice President of Operations/Chief Knowledge Officer at a technology start-up. She has more than 20 years of strategic leadership experience in multi-national business, business process re-engineering, and project and people management. Danielle is an expert on SAP Human Resources (HR) and reporting and has authored four best-selling books on SAP. She is a regular speaker at numerous conferences around the world on topics such as HR, technology, change management, and leadership. She is an official SAP Mentor, a global designation assigned to less than 160 professionals worldwide, who serve as influential community participants in the SAP ecosystem. This group is nominated by the community and selected by the SAP Mentors’ Advisory Board to keep SAP relevant. Danielle also serves as an expert advisor for SAP Professional Journal.

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.