Database Statistics Reports Monitor the Size and Scope of Personnel Development Tables

  • by A.J. Whalen, SAP Marketing Director, Velocity Technology Solutions
  • December 15, 2004
The output of standard R/3 reports that monitor the Personnel Development database can shed light on areas that may benefit from cleanup of excess objects and infotypes or reduction of table size. Check out four of the reports to see which ones best meet your needs.
Key Concept
Database statistics reports are delivered as standard functionality in R/3. They allow system administrators to monitor key criteria such as database size, number of objects, and distribution of object types and infotypes.

One challenge facing both database administrators and SAP HR professionals is monitoring and auditing the tables, objects, plans, and infotypes that make up Personnel Development (PD) functionality in R/3. Database requirements for PD and Organizational Management (OM) tables can grow significantly over time for even the smallest organizations, necessitating the use of regular audits of both object counts and database size.

Even when sizing is not an issue, OM professionals need to understand the impact of their database tables on their system performance as well as the cleanliness and efficacy of their object hierarchies. Simply translated, a lot of clutter in the organizational object structure can cause problems with online performance, slowing users trying to navigate their way through the myriad of objects and relationships in search functions and organizational displays in R/3.

Database statistics reports are a tool for you to use in identifying potential areas of concern. The actions you take to address performance issues or clean up PD data will vary based on your database platform, system hardware, and business requirements. Whether you choose to archive your older records or perform detailed reporting to identify unused or obsolete records for removal, database statistics reporting provides the impetus for that effort.

A.J. Whalen

A.J. Whalen has successfully combined more than two decades of global business expertise with in-depth experience in the strategic development, management, and delivery of large-scale projects and education for SAP ERP HCM. Prior to his current role as SAP Marketing Director at Velocity Technology Solutions, he served as lead consultant for several global SAP implementations and engagements as well as an SAP Conference Producer for Wellesley Information Services. A.J. has been invited to speak at nine annual SAP educational events and holds an MBA degree from the Stern School of Business at New York University.

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.