Senior Vice-President of HCM Solutions Danielle Larocca has worked in the SAP HCM space for over 20 years. An SAP Mentor and featured speaker at numerous conferences, Danielle has authored four best-selling books on SAP, is the Technical Editor for the SAP Professional Journal, and often the Voice of the Expert on SAPInsider’s Ask the Expert series for HR.
A sample custom infotype for a customer tracking recruitment details can be seen below.
You can find the simple instructions for how to add your own custom infotypes in the SAP Community Wiki here.
Query tools for HCM
If you are using the SAP certified Query Manager solution for HCM reporting, you are likely limited to the on-premise tools delivered by SAP. If that is is the case then you will need to perform an additional step to make the new infotype available in your data source.
Once you have added your own custom infotypes you will want the ability to report from them using the traditional Query tools for HCM, accessible via transaction code SQ01, which include the SAP Query and the Ad Hoc Query.
Both Query solutions can use a variety of sources to retrieve their data. The thousands of infotypes mentioned above often have complex relationships and hierarchies between them and as such, reporting of Human Capital Management information is often seen as the single largest challenge for AP HCM and Payroll customers.
The most common data source that is used for HR and Payroll query-based reporting in R/3 is an InfoSet. InfoSets are often designed based on a logical grouping of all of the relevant infotypes in a logical database containing all the infotypes that you would like to report on. Three logical databases are available within R/3 in Human Capital Management including
The most common query reporting often leverages the PnP logical database because it includes the most frequently used Personnel Administration data for employees, name, pay, title, address etc.
Adding custom infotypes to your Infoset
Now that you have made your own custom infotypes you simply need to add them to your InfoSet so that they can be available for reporting in the SAP Query and the Ad Hoc Query. Adding custom infotypes to an InfoSet is the same process as adding traditional infotypes to an InfoSet.
To add basic infotypes to an existing InfoSet for use with a query-based reporting tool, follow the steps detailed below.
More information and help
Now that you know how to create custom infotypes and add them to SAP Query reporting please be sure to take a moment and review an update on the use of the Ad Hoc Query and SAP Query solutions in HCM available here: SAP HCM Reporting: Are Query tools ancient history?