172.book Seite 3 Dienstag, 30. Oktober 2007 5:18 17 - IProCon
172.book Seite 3 Dienstag, 30. Oktober 2007 5:18 17 Hans-Jürgen Figaj, Richard Hassmann, and Anja Junold HR Reporting with SAP Bonn Boston
172.book Seite 5 Dienstag, 30. Oktober 2007 5:18 17 Contents at a Glance Part I 1 2 Process-Oriented Reporting Concept . Basics of Reporting in SAP ERP HCM . Part II 3 4 5 6 Fundamentals 27 37 Reporting Tools Standard SAP Report . 73 Queries . 81 HR Reporting with SAP NetWeaver BI . 117 Customer Report . 177 Part III Reporting in HCM Modules 7 8 9 10 11 12 13 14 15 16 Introduction to Part III . Personnel Administration . Organizational Management . Recruitment . Payroll . Personnel Time Management . Personnel Development . Benefits . Training and Event Management . Personnel Cost Planning . 189 193 225 245 259 283 311 325 339 361 Part IV Retrieving Reports 17 18 19 20 Area Menu . Human Resources Information System . Manager’s Desktop (MDT) . SAP NetWeaver Portal . 371 377 383 395 Appendix A B C D Further Reading . Standard Reports in the SAP HCM Modules: Overview . Sample Codings for Chapter 4, Queries . Authors . 415 417 425 429
172.book Seite 7 Dienstag, 30. Oktober 2007 5:18 17 Contents Acknowledgments . Introduction . PART I 1 Fundamentals Process-Oriented Reporting Concept . 27 1.1 1.2 1.3 1.4 2 17 19 Determining Key Figures . Defining Reports . Selecting Tools . Retrieving Reports for Users . 28 30 31 33 Basics of Reporting in SAP ERP HCM . 37 2.1 2.2 2.3 2.4 2.5 2.6 Data Structures in SAP ERP HCM . 2.1.1 Personnel Administration Infotypes . 2.1.2 Payroll and Time Management Data Clusters . 2.1.3 Personnel Planning Infotypes . Logical Databases . 2.2.1 Properties of a Logical Database . 2.2.2 Logical Database PNP . 2.2.3 Logical Database PNPCE . 2.2.4 Logical Database PCH . 2.2.5 Logical Database PAP . HR Report Categories . Authorization Checks in HR Reporting . 2.4.1 Calling Reports . 2.4.2 Simplified Authorization Check for Reports . 2.4.3 Cluster Authorizations . 2.4.4 Query . 2.4.5 Manager’s Desktop . 2.4.6 Customer Reports . 2.4.7 Special Issues . Reporting Basics . 2.5.1 Central Data for Successful Reports . 2.5.2 Special Features of International Reporting . Summary . 38 38 40 41 44 44 45 48 50 50 51 55 56 58 59 60 62 62 63 64 65 67 69 7
172.book Seite 8 Dienstag, 30. Oktober 2007 5:18 17 Contents PART II 3 Standard SAP Report . 73 3.1 3.2 3.3 3.4 3.5 4 4.2 4.3 4.4 4.5 4.6 4.7 4.8 73 74 76 77 79 InfoSets . 4.1.1 Creating Your Own InfoSets . 4.1.2 Extending InfoSets . 4.1.3 Special “Switches” . 4.1.4 Enabling the Use of InfoSets . QuickViewer . Ad Hoc Query . 4.3.1 Set Operations . 4.3.2 The Report-Report Interface . 4.3.3 Applications and Limitations of Ad Hoc Query . SAP Query . 4.4.1 Multiline Lists . 4.4.2 Additional Local Fields . 4.4.3 Interactive Lists . Integration of Payroll Results . Integration of Time Evaluation Results . SAP Query Transport Tool . Critical Success Factors . 82 82 85 87 88 89 93 97 99 99 100 102 104 107 109 111 112 114 HR Reporting with SAP NetWeaver BI . 117 5.1 5.2 8 Starting a Report . Period Selection . Selection Variables . Using ALV Lists . Summary . Queries . 81 4.1 5 Reporting Tools Architecture of SAP NetWeaver BI . 5.1.1 Extraction Layer . 5.1.2 Modeling Layer . 5.1.3 Reporting and Analysis Layer . Business Explorer Analyzer . 5.2.1 BEx Analyzer Functions . 5.2.2 Working with the BEx Analyzer . 5.2.3 Navigation in the Query . 5.2.4 Filtering Characteristics . 5.2.5 Graphical Display of Data . 118 119 123 127 129 130 135 138 140 141
172.book Seite 9 Dienstag, 30. Oktober 2007 5:18 17 Contents 5.3 5.4 5.5 5.6 5.7 5.8 5.9 5.10 6 5.2.6 Working in Design Mode . BEx Query Designer . 5.3.1 Query Designer Functions . 5.3.2 Creating Queries . 5.3.3 Variables . 5.3.4 Structures . 5.3.5 Hierarchies . 5.3.6 Exceptions . 5.3.7 Conditions . BEx Web Analyzer . BEx Report Designer . BEx Information Broadcaster . Standard Content . 5.7.1 Standard Content for HCM Modules . 5.7.2 Standard Content for Benchmarking . 5.7.3 The Organizational Structure in the Standard Content . 5.7.4 Conclusion . Authorizations in SAP NetWeaver BI . 5.8.1 Specific Authorization Objects of SAP NetWeaver BI . 5.8.2 Tools for Authorization Check . Structural Authorization . 5.9.1 Overview . 5.9.2 Process . Critical Success Factors . 5.10.1 Defining Objectives . 5.10.2 Establishing a Project Team . 5.10.3 Final Implementation Tips . 142 144 144 146 150 150 153 154 154 155 158 160 162 163 164 165 166 167 167 169 170 170 171 172 172 173 174 Customer Report . 177 6.1 6.2 6.3 6.4 Defining Requirements . Specifications for Programming . Using a Company-Specific Logical Database . Critical Success Factors . 177 179 180 184 PART III Reporting in HCM Modules 7 Introduction to Part III . 189 9
172.book Seite 10 Dienstag, 30. Oktober 2007 5:18 17 Contents 8 Personnel Administration . 193 8.1 8.2 8.3 8.4 8.5 9 193 194 195 197 198 199 199 200 201 201 202 202 203 204 205 205 206 208 210 212 212 212 214 215 216 218 219 220 223 Organizational Management . 225 9.1 9.2 10 Employee-Related Reports . 8.1.1 Flexible Employee Data . 8.1.2 HR Master Data Sheet . 8.1.3 Date Monitoring . 8.1.4 Education . 8.1.5 Time Spent in Pay Scale Group/Level . 8.1.6 List of Maternity Data . 8.1.7 Employees Entered/Left the Company . 8.1.8 Anniversary of Years of Service . 8.1.9 Power of Attorney . 8.1.10 Family Members . 8.1.11 Birthday List . 8.1.12 Vehicle Search List . 8.1.13 Telephone Directory . Organizational Data . 8.2.1 Headcount Change . 8.2.2 Headcount Development . 8.2.3 Assignment to Wage Level . 8.2.4 Salary According to Seniority List . 8.2.5 Other Reporting for an Organizational Unit . Documents . 8.3.1 Logged Changes in Infotype Data . 8.3.2 Log of Report Starts . SAP NetWeaver BI Standard Content . 8.4.1 Headcount InfoCube . 8.4.2 Headcount and Personnel Actions InfoCube . 8.4.3 Employee – Education ODS Object . 8.4.4 Queries for the Headcount and Personnel Actions InfoCube . Conclusion . Organizational Unit . 9.1.1 Existing Organizational Units . 9.1.2 Staff Functions for Organizational Units . Job . 9.2.1 Existing Jobs . 9.2.2 Job Index . 9.2.3 Job Description . 225 225 226 227 227 227 228
172.book Seite 11 Dienstag, 30. Oktober 2007 5:18 17 Contents 9.3 9.4 9.5 9.6 9.7 9.2.4 Complete Job Description . Position . 9.3.1 Existing Positions . 9.3.2 Staff Functions for Positions . 9.3.3 Periods When Positions Are Unoccupied . 9.3.4 Staff Assignments . 9.3.5 Position Description . 9.3.6 Vacant Positions . 9.3.7 Obsolete Position . 9.3.8 Complete Position Description . 9.3.9 Authorities and Resources . 9.3.10 Planned Labor Costs . Work Center . 9.4.1 Existing Work Centers . 9.4.2 Authorities and Resources . 9.4.3 Restrictions/Health Examinations . General Remarks . 9.5.1 Existing Objects . 9.5.2 Structure Display . 9.5.3 Displaying and Maintaining Infotypes . 9.5.4 Starting HR Reporting . SAP NetWeaver BI Standard Content . 9.6.1 Staffing Assignments InfoCube . 9.6.2 Queries for the Staffing Assignments InfoCube . Conclusion . 229 230 230 230 231 231 232 232 233 233 234 234 236 236 236 236 237 237 237 238 238 240 240 243 244 10 Recruitment . 245 10.1 10.2 10.3 Applicants . 10.1.1 Variable Applicant List . 10.1.2 Applicants by Name . 10.1.3 Applicants by Actions . 10.1.4 Education of Applicants . 10.1.5 Applications . 10.1.6 Applicant Statistics . 10.1.7 Planned Activities . Vacancy . 10.2.1 Vacancy Assignments . 10.2.2 Vacancies . Job Advertisements and Recruitment Instruments . 10.3.1 Job Advertisements . 245 245 246 247 247 247 248 249 250 250 250 251 251 11
172.book Seite 12 Dienstag, 30. Oktober 2007 5:18 17 Contents 10.4 10.5 10.3.2 Recruitment Instruments . SAP NetWeaver BI Standard Content . 10.4.1 Applications and Applicant Actions InfoCube . 10.4.2 Queries for the Applications and Applicant Actions InfoCube . Conclusion . 252 253 254 255 257 11 Payroll . 259 11.1 11.2 11.3 11.4 Remuneration Statement . 11.1.1 Remuneration Statement (Standard Version) . 11.1.2 Remuneration Statement with HR Forms . Reports for Infotypes and Payroll Results . 11.2.1 Payroll Journal . 11.2.2 Wage Type Reporter . 11.2.3 Displaying Payroll Results . 11.2.4 Garnishment Details Report . 11.2.5 US Workers’ Compensation Summary Report . SAP NetWeaver BI Standard Content . 11.3.1 Employee-Specific Payroll Data InfoCube . 11.3.2 Posting Documents InfoCube . 11.3.3 Posting Documents and Auditing Information Combined InfoCube . 11.3.4 Time and Payroll Data MultiCube . 11.3.5 Queries for InfoCubes in Payroll . Conclusion . 259 259 261 263 263 266 268 271 273 274 275 277 277 277 278 282 12 Personnel Time Management . 283 12.1 12.2 12.3 12 Work Schedule . 12.1.1 Personal Work Schedule . 12.1.2 Daily Work Schedule . Absences and Attendances . 12.2.1 Attendance/Absence Data – Overview . 12.2.2 Attendance/Absence Data – Calendar View . 12.2.3 Attendance/Absence Data – MultipleEmployee View . 12.2.4 Attendance Check . 12.2.5 Graphical Overview of Attendance/Absence . Time Accounts . 12.3.1 Time Statement . 283 283 285 286 286 289 291 292 294 295 295
172.book Seite 13 Dienstag, 30. Oktober 2007 5:18 17 Contents 12.3.2 12.3.3 12.3.4 12.3.5 12.3.6 12.4 12.5 Cumulated Time Evaluation Results . Display Time Accounts . Display Absence Quota Information . Display Time Evaluation Messages . Display Time Evaluation Results (Cluster B2) . SAP NetWeaver BI Standard Content . 12.4.1 Time and Labor Data InfoCube . 12.4.2 Reports for the Time and Labor Data InfoCube . Conclusion . 297 298 299 301 302 304 304 308 310 13 Personnel Development . 311 13.1 13.2 13.3 13.4 13.5 Profiles . 13.1.1 Profile Matchup . 13.1.2 Profiles of an Organizational Unit . 13.1.3 Profile Evaluation . Qualifications . 13.2.1 Searching for Qualifications . 13.2.2 Expired Qualifications . Other Reports . 13.3.1 Appraisal Evaluations . 13.3.2 Profile Matchup: Positions/Holders for an Organizational Unit . SAP NetWeaver Standard BI Content . 13.4.1 The Qualifications InfoCube . 13.4.2 The Appraisals InfoCube . 13.4.3 Queries for the Personnel Development InfoCubes . Conclusion . 311 311 313 314 315 315 316 317 317 318 320 320 320 322 323 14 Benefits . 325 14.1 14.2 Participation . 14.1.1 Eligible Employees . 14.1.2 Participation . 14.1.3 Changes of Benefits Elections . 14.1.4 Change of Eligibility Status . 14.1.5 Changes in General Benefits Information . Costs and Contribution . 14.2.1 Health Plan Costs . 14.2.2 Insurance Plan Costs . 325 325 326 326 327 328 328 328 329 13
172.book Seite 14 Dienstag, 30. Oktober 2007 5:18 17 Contents 14.2.3 14.2.4 14.2.5 14.2.6 14.3 14.4 14.5 Savings Plan Contributions . FSA Contributions . Stock Purchase Plan Contributions . Costs/Contributions for Miscellaneous Plans . 14.2.7 Vesting Percentages . 14.2.8 Contribution Limit Check . Statistics . 14.3.1 Employee Demographics . 14.3.2 Benefit Election Analysis . 14.3.3 Enrollment Statistics . SAP Netweaver BI Standard Content . 14.4.1 The Benefits InfoCube . 14.4.2 Queries for the Benefits InfoCube . Conclusion . 330 330 331 331 331 332 332 332 333 334 334 334 336 337 15 Training and Event Management . 339 15.1 15.2 15.3 15.4 14 Attendances . 15.1.1 Attendee List . 15.1.2 Attendance List . 15.1.3 Employee list . 15.1.4 Bookings per Attendee . 15.1.5 Attendee’s Training History . 15.1.6 Attendance Prerequisites . 15.1.7 Attendee’s Qualifications . 15.1.8 Attendance Statistics . 15.1.9 Cancellations per Business Event/Attendee . Business Events . 15.2.1 Business Event Demand . 15.2.2 Business Event Information . 15.2.3 Business Event Dates . 15.2.4 Resources Not Yet Assigned per Business Event . Resources . 15.3.1 Resource Equipment . 15.3.2 Instructor Information . 15.3.3 Resource Reservation . SAP NetWeaver Standard BI Content . 15.4.1 The Training and Event Management InfoCube . 341 341 341 343 344 345 345 346 347 348 349 349 350 351 352 353 353 353 354 355 355
172.book Seite 15 Dienstag, 30. Oktober 2007 5:18 17 Contents 15.5 15.4.2 The Professional Training Provider InfoCube . 15.4.3 The Resource Reservation InfoCube . 15.4.4 Queries for the Training and Event Management InfoCube . Conclusion . 357 357 358 360 16 Personnel Cost Planning . 361 16.1 16.2 16.3 16.4 Data Basis . Cost Plans . SAP NetWeaver BI Standard Content . 16.3.1 The Personnel Cost Plans InfoCube . 16.3.2 The Planned Personnel Costs per Cost Object InfoCube . 16.3.3 The Plan/Actual Comparison of Personnel Costs MultiCube . 16.3.4 Queries for the Personnel Cost Planning InfoCubes . Conclusion . 361 362 363 363 364 365 366 368 PART IV Retrieving Reports 17 Area Menu . 371 18 Human Resources Information System . 377 18.1 18.2 18.3 Using the HIS . 377 Customizing the HIS . 380 Using the HIS in Practice . 381 19 Manager’s Desktop (MDT) . 383 19.1 19.2 19.3 19.4 Functions of the MDT . Using the MDT . Customizing the MDT . 19.3.1 Editing Scenarios in Customizing . 19.3.2 Views . 19.3.3 Function Codes . Using the MDT in Practice . 383 384 386 386 388 389 393 20 SAP NetWeaver Portal . 395 20.1 Manager Self-Service . 395 15
172.book Seite 16 Dienstag, 30. Oktober 2007 5:18 17 Contents 20.2 20.3 20.4 20.1.1 Customizing the Report Launchpad . 20.1.2 Implementing MDT Data in an MSS Reporting Launchpad . 20.1.3 Key Figure Monitor . 20.1.4 Web Templates for the MSS . BEx Web Application Designer . Visual Composer . Using the SAP NetWeaver Portal in Practice . 396 398 399 401 401 407 411 Appendix . 413 A B C D Further Reading . Standard Reports in the SAP HCM Modules: Overview . B.1 Administration . B.2 Organizational Management . B.3 Recruitment . B.4 Payroll . B.5 Time Management . B.6 Personnel Development . B.7 Training and Event Management . B.8 Personnel Cost Planning . B.9 Benefits . Sample Codings for Chapter 4, Queries . Authors . 415 417 417 418 419 420 420 421 422 422 423 425 429 Index . 431 16
172.book Seite 37 Dienstag, 30. Oktober 2007 5:18 17 Before running a report, you first have to examine the data that you intend to use as a basis for the report. Among the things you need to look at are the data’s technical structure and content. The latter has to contain information that is relevant to the purpose of the report. We explain these basic topics in this chapter. 2 Basics of Reporting in SAP ERP HCM SAP ERP HCM contains many different data structures. These data structures can be divided into three areas: 왘 Personnel administration master data 왘 Payroll and time management results data 왘 Personnel planning data The structures of the data in each of these areas are fundamentally different. The structure of applicant management data is identical to that of personnel administration data, so we mention it here only when we want to draw your attention to something in particular. Personnel administration master data is the basis of all SAP ERP HCM modules. When an employee’s data is entered in the system, the data is stored in what are known as infotypes. Once the employee is “created” in this way, the data can then be used in other modules. The payroll and time management areas, for example, use this data and store their results in data clusters. The structure of these data clusters consists of several related tables that are different for each application. Personnel planning data consists of a wide variety of objects that are related to each other by means of links. The individual properties of these objects are also stored in infotypes. Section 2.1 deals with these data structures in more detail. 37 Data structures in SAP ERP HCM
172.book Seite 38 Dienstag, 30. Oktober 2007 5:18 17 2 Basics of Reporting in SAP ERP HCM Logical database The fundamental technology provided by SAP for reporting on these structures is the logical database. Almost every report is based on the functionalities of a logical database, which retrieves data for reporting purposes from any infotype you want. The logical database presents you wit
Bonn Boston Hans-Jürgen Figaj, Richard Hassmann, and Anja Junold HR Reporting with SAP 172.book Seite 3 Dienstag, 30. Oktober 2007 5:18 17
ATP 172 checklist for the 172 model you will be flying. Model Number Year of Production 172 K 1969–70 172 L 1971–72 172 M 1973–76 172 N 1977–80 172 P 1981–86 172 R 1996–2009 172 S 1998–Present EARLY MOD
tyrolia Bindungen Seite 4 StanderhöhungenSeite 5 SkiSchuhe Seite 5 - 6 fREERIDE . BoardS Seite 12 BindingS Seite 12 BootS Seite 12 Ski & SnowBoard helmetS Seite 13 Body Protection Seite 13 . 111650 lX 12 3,5-12 schwarz-weiß 189,95 111,74 Super Light
Der Mensch an Stelle Gottes Seite 360 Adelsrepublik im Himmel Seite 361 Summum bonum ist Gott Seite 362 . Die Freiheitsmütze: Revolte gegen die etablierte Ordnung. Seite 373 Das große Siegel der Vereinigten Staaten Seite 374 Selbst die Flagge kam nicht davon Seite 374
September 2015 2.0 Flugkosten 3.0 Hotel 4.0 Reisekosten (Transport auf dem Landweg) 5.0 Extras 6.0 Teilnahme Seite 2 Seite 2 Seite 3 Seite 4 Seite 5 Seite 5 7.0 Nicht-Teilnahme 8.0. Reiseverlängerungen . Amway übernimmt die Kosten für den Hin-und Rückflug zur Eventdestination. Heimatflughäfen dürfen nach
Unity Dienstag, 09.11. Nachbörse ( /-) 11,8 % Coinbase Dienstag, 09.11. Nachbörse ( /-) 11,9 % Palo Alto Dienstag, 16.11. Nachbörse ( /-) 7,0 % . Trade Desk freilich auch den Einstieg in den südost-asiatischen Markt, und das in einer völlig neuen Größenordnung - und mit entsprechenden Wachs - tumsaussichten. Heute allerdings dürfte .
Das Klinikum investiert weitere 17 Millionen Euro zum Wohle der Patienten Zahlen, Daten Fakten (Seite 12) Der Wirtschaftsplan für das laufende Jahr ist verabschiedet Neurologie (Seite 18) Die neue Hauptabteilung unter Leitung von Dr. Konhäuser ist in Betrieb Kindersegen (Seite 22) Am 22. Juli erblicken gleich sieben Babys am Klinikum das .
Inhaltsverzeichnis Vorwort ab Seite 3 Verknüpfungsmöglichkeiten ab Seite 4 zu Kapitän Albatros Band 1 und 2 Ergänzende Leistungsnachweise ab Seite 5 zu Kapitän Albatros Band 1 und 2 Schreib- und Planungstipps ab Seite 43 Der kleine Sprachbegleiter ab Seite 57 eine Wörtersammlung i
BROADCASTING CORPORATION THIS DEED is made the 7 November 2016 BETWEEN: HER MAJESTY’S SECRETARY OF STATE FOR CULTURE, MEDIA AND SPORT (“the Secretary of State”) and THE BRITISH BROADCASTING CORPORATION whose chief office is at Broadcasting House, Portland Place, London W1A 1AA (“the BBC”). BACKGROUND (1) The BBC was first incorporated, for a limited period of time, by a Royal Charter .
