SAP HR Manager Desktop

MANAGERS DESKTOP SHORTCUT
You can directly access Managers Desktop reports by creating a shortcut on your desktop. Enter the following menu path or transaction code. The following screen will be displayed : Menu Path: Human Resources > Managers Desktop Transaction Code: PPMDT
1. Select this icon.
1. By selecting this icon, the following screen will appear.
2. You can enter your own title or leave the default value of Managers Desktop: CMU Management Reports
MDT MANUAL R/3 4.70
11/19/2007
3. This is the icon that is created on your desktop.
3. Click on this icon to sign into Managers Desktop 4. Enter your password here to sign directly into MDT.
4. Enter your SAP password, and then select OK. This will take you directly into the Managers Desktop menu.
MDT MANUAL R/3 4.70
11/19/2007
Table of Contents
Managers Desktop Overview....................................................................................................... 1 Finance and Budget Info .........................................................................................................A-1 Education and Training Bookings with History ................................................................................................... B-1 Education History ........................................................................................................... B-7 Instructor History ... Human Resources Address Labels- Campus ................................................................................................ B-1 Address Labels- Home.................................................................................................... B-7 Birthdays ...................................................................................................................... B-13 Change in Staffing Levels . Employee List .............................................................................................................. B-15 New Hires ..................................................................................................................... B-18 Salary List for 9/10 Month Employees ......................................................................... B-21 Salary List for Staff....................................................................................................... B-23 Seniority Report ........................................................................................................... B-26 Seniority / Gender Reports............................................................................................ B-30 Staffing Changes........................................................................................................... B-38 Telephone Directory ..................................................................................................... B-44 Personnel Development Qualifications Overview . Time Management Info Absences by Type ........................................................................................................... C-8 Absences FMLA Only .................................................................................................. C-16 Dept. Leave Quota Info................................................................................................. C-32 Employee Quota Info ................................................................................................... C-28 Timesheets Biweekly Staff ............................................................................................. C-1 Timesheets Semi-Monthly ............................................................................................. C-3 Timesheets Student/Temp .............................................................................................. C-6 Travel Travel data/totals Trip Receipts Trip Receipts as list Cost Assignment
Ad Hoc Query............................................................................................................................. D-1
MDT MANUAL R/3 4.70
11/19/2007
MANAGERS DESKTOP OVERVIEW

Managers desktop is a tool that allows deans, department chairs, department heads and their designated assistants to obtain HR information on the employees within their department, as well as financial information on their cost centers. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT
The initial screen is divided into two main sections: The left side contains the Selected Functions list or list of reports available The right side is the organizational structure that you are responsible for as chief (or are allowed to view as assistant chief.) Your name should be on top.
MDT MANUAL R/3 4.70
11/19/2007
Selected Functions All the HR reports listed on the left side of the screen will automatically run based on the Organizational Structure selected. The Finance & Budget Info (FM Report Tree) reports run exactly as they do within the existing Funds Management Tree. You can hide reports that you do not want to see or will never run by going to the menu, Settings > Function list > User settings and then deselecting the reports you do not want to see. Settings > Function list > Standard functions - returns all the reports to the selection screen.
Organizational Structure Your Organizational Structure listed here consists of all positions attached to the Organizational Unit, along with the persons currently holding those positions as well as the cost center that is attached to those positions. The Organizational Structure is sorted by position number. To see the detailed information on your Organizational Structure, go to the menu path and choose: Settings > Column View. The following selections appear:
ID the number attached to that org unit, position, person or cost center Code short text for the org unit, position, person or cost center Relationship text Not applicable Validity dates the org unit, position, person or cost center is valid from and to
MDT MANUAL R/3 4.70
11/19/2007
Relationship period Date this item was assigned to the org unit or the personnel subarea changed Percentage Percentage of the person assigned to the position Master Cost Center Cost Center the position is attached to. Select the fields desired and click on the green checkmark. From now on these selections will show each time you enter Managers Desktop.
Tip If you cannot see the entire column, move your mouse over the column divider line until the arrow changes into a +. Click and drag the line to increase or decrease the width of the column Icons
Find and Find again - Allows you to search for employees quickly
Highlight the Person line and select the green check mark
Youll then see a screen where you can type in the last name of the person you are looking for in your organizational structure. Type the name, hit enter and youll receive a list of employees with that last name. Click the check box next to the person you are looking for, and the system will bring you directly to that person in your organizational
MDT MANUAL R/3 4.70
11/19/2007
structure and highlight them. If the system does not find that person in your Organizational Structure, it will tell you no hits found.
Expand all expands the ENTIRE organizational structure:
Collapse all collapses the entire org structure:
Expand expands one level at a time:

I highlighted BENEFIT SPECIALIST and clicked on Expand Icon
Collapse collapses one level at a time

MDT MANUAL R/3 4.70 11/19/2007
Refresh - not applicable Legend Explains symbols in org structure as follows:
Not applicable for CMU.
Select Columns Allows you to select or hide columns in the Organizational Structure same selection options that appear under Settings Column View as described above.
MDT MANUAL R/3 4.70
11/19/2007
RUNNING REPORTS To run a report, you must select four things: 1. The group of employees you wish to report on 2. The time period you wish to report on 3. The organization level you wish to report on 4. Select the report to run
1. Select a tab for the group of employees desired as described in table one below. 2. Select the time period report is desired for by clicking on the icon. See table two 3. Highlight the level of reporting desired as described in table three.
4. Select the report youd like to run.
MDT MANUAL R/3 4.70
11/19/2007
TABLE ONE (1)

Selection Tab Directly subordinate employees Description Those employees reporting directly to the chief User Action and Value System defaults to this tab when entering Managers Desktop. Select this tab if you want a report of your direct line employees. Select this tab if you want a report of all employees reporting to your department
All subordinate employees
Employees and departments who indirectly report to the chief
TABLE TWO (2)

Date Time period From Time Period To Description The beginning date of the report selection The end date of the report selection User Action and Value Click on icon and enter begin date of time period you wish to see Click on icon and enter end date of time period you wish to see
TABLE THREE (3)

Icon Description Employee currently occupying the position (ID = P) Department name and system assigned number (ID = O) Positions are held by persons within your department; positions stay while persons come and go (ID = S) The Head of the Organizational unit Object Removed Object to be added User Action and Value Highlight a person when you want the report for just that person Highlight the org unit to report on all persons assigned to this department, either directly or indirectly Highlight a position when you want the report for anyone occupying that position Do not select reports by chief Demonstrates movement within Organizational Unit Demonstrates movement within Organizational Unit
The procedures for executing each report are attached.
Use the green back arrow the previous screen.
or the yellow EXIT icon or Shift F3 to return to
MDT MANUAL R/3 4.70
11/19/2007
10
Education and Training

Bookings with History Education History Instructor History
MDT MANUAL R/3 4.70
11/19/2007
11
Bookings with History
Report Description This report gives you a list of training classes your employees have attended. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab 2. Select the time period report is desired for.
3. Highlight the level of reporting desired run by person only. 4. Select the report you wish to run.
This report can only be run by person. To select more than one employee at a time, hold your control key down, and highlight multiple employee names before clicking on the report name on the left.
MDT MANUAL R/3 4.70
11/19/2007
12
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Education and Training; then click on BOOKINGS WITH HISTORY.
Youll see the following report after clicking the the report name:
Each column of the report is described in the following table:

Column Abbr. Attendee Name Event/Event Type Bus. Event Start date/End Date Days Hours Fee Crcy Bookings BP Description Last Name of Employee Full Name of the employee Not applicable Name of class employee attended Dates the employee attended the class Number of days for class Number of hours for class Not applicable Not applicable Not applicable Not applicable
MDT MANUAL R/3 4.70
11/19/2007
13
The report produces totals at the end. If you run for one employee youll see a total number of hours the employee has been to training over the period of time you specified in the time period. Or, if you have run multiple employees you can highlight the Attendee name column and select the subtotal icon and youll have a total for each employee. The Icons available on this report are as follows:
Allows you to view all info about one line of the report. Highlight a particular column and click this icon to sort in ascending order. If you wish to sort on multiple columns, select the same column and hit sort again. You can then select multiple sort criteria Highlight a particular column and click this icon to sort in descending order
Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list. Sums the total number of hours and days your employees spent in training. Select column Days, Hours or both and hit the SUM button. The totals will appear at the bottom. Subtotal button. If you have run the report for multiple employees, select the employee name column and hit the subtotal button. This will provide subtotals between each employee for the number of days and hours they have attended training.
Allows you to change to the Print Preview mode for the report.
Brings the information on the screen direct to MSWord as mail merge fields. Be sure to click the No Password button. Brings the information on the screen direct to MSExcel. Be sure to click the Excel Display radio button.
Allows you to save the report to your local pc. Select the icon, and then select the location to save the file to, and name the file. SAP Mail not applicable.
MDT MANUAL R/3 4.70
11/19/2007
14
Provides statistical analysis for report. Select one of the numerical columns and hit the ABC button to review the analysis information provided. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
Tip If you cannot see all of the columns, move your mouse over the column divider lines until the arrow changes into a +. Click and drag the line to increase (or decrease) the width of the column.
or the yellow EXIT icon or Shift F3 to return to Use the green back arrow the Managers Desktop Screen.
MDT MANUAL R/3 4.70
11/19/2007
15
Education History Report
Report Description This report gives you a listing of the degrees your employees hold. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
3. Highlight the level of reporting desired.
4. Select the report you wish to run.
This report can only be run by Organizational Unit. All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Education and Training; then click on EDUCATION HISTORY.
MDT MANUAL R/3 4.70 11/19/2007
16

Column Personnel No. First Name Last Name Education establishment text Certificate text Educ/train text Department Institute/location Cost ctr Description Employee number within SAP First name of employee Last name of employee Type of school employee attended Type of degree/certificate the employee holds Not applicable Not applicable Name of Institution employee attended Not relevant for this report
MDT MANUAL R/3 4.70
11/19/2007
17
The Icons available on this report are as follows:
Allows you to view all info about one line of the report. Highlight a particular column and click this icon to sort in ascending order Highlight a particular column and click this icon to sort in descending order
Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list.
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts.
MDT MANUAL R/3 4.70
11/19/2007
18
Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
MDT MANUAL R/3 4.70
11/19/2007
19
Instructor History Report
Report Description This report gives you a list of training classes your employees have instructed, and have been recorded in the Training & Events module of SAP. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
3. Highlight the level of reporting desired run by person only.
This report can only be run by person. To select more than one employee at a time, hold your control key down, and highlight multiple employee names before clicking on the report name on the left.
MDT MANUAL R/3 4.70
11/19/2007
20
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Education and Training; then click on INSTRUCTOR HISTORY.

Column Resource Type Resource Bus. Event Start date/End Date Start time/End Time No. Hours Description Indicates Instructor Full Name of the employee Name of class employee attended Dates the employee attended the class Time the class was scheduled Number of hours for class
The report produces totals at the end. If you run for one employee youll see a total number of hours the employee has been to training over the period of time you specified in the time period. Or, if you have run multiple employees you can highlight the
MDT MANUAL R/3 4.70
11/19/2007
21
Attendee name column and select the subtotal icon and youll have a total for each employee. The Icons available on this report are as follows:
Allows you to save the report to your local pc. Select the icon, and then select the location to save the file to, and name the file. SAP Mail not applicable. Provides statistical analysis for report. Select one of the numerical columns and hit the ABC button to review the analysis information provided.
MDT MANUAL R/3 4.70
11/19/2007
22
Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
Use the green back arrow or the yellow EXIT icon or Shift F3 to return to the Managers Desktop Screen.
MDT MANUAL R/3 4.70
11/19/2007
23
Finance and Budget Reports

The FM Report Tree accessed through Managers Desk Top is the same that is accessed through the FM module of SAP. If you wish to learn more about the different reports and how to execute them, you need to attend one of the FM Report Training Classes offered monthly. You can view the dates and times of the training at www.controller.cmich.edu/Accounting/training.htm. The FM Report Tree is not tied to the organizational structure; therefore it is NOT necessary to select an org unit or time period for reporting at this level. The funds center and dates are entered directly in the FM Report Tree. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT All the executable reports are located on the left hand side of the screen. Execute any Finance and Budget report by opening the Finance and Budget folder, then clicking on the FM Report Tree line, then select the report you wish to run from the FM Report Tree.
MDT MANUAL R/3 4.70
11/19/2007
24
MDT MANUAL R/3 4.70
11/19/2007
25
Human Resources Employee Data

Address Labels - Campus Address Labels Home Birthdays Change in Staffing Levels Employee List New Hires/Terminations Salary List for 9/10 Month Employees Salary List for Staff Seniority Report Seniority / age Staffing Changes Telephone Directory
MDT MANUAL R/3 4.70
11/19/2007
26
MDT MANUAL R/3 4.70
11/19/2007
27
ADDRESS LABELS - CAMPUS

Report Description This report gives you a list of all your employees along with their campus address. The information can be imported into Word so labels can be printed. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
2. Select the time period report is desired for.
3. Highlight the level of reporting desired 4. Select the report you wish to run.
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on CAMPUS ADDRESS LABELS.
MDT MANUAL R/3 4.70
11/19/2007
28
The following report appears:
Icons This report contains several different icons. Descriptions for some of them are as follows:
: Print Preview: Clicking on this icon changes the layout of the page to look like a
report instead of a table. Example:
MDT MANUAL R/3 4.70
11/19/2007
29
SAP Email do not use : Brings the information on the screen direct to Excel; be sure to click on the No Password button : Brings the information on the screen direct to MSWord Word Processing - as mail merge fields. Be sure to click the No Password button. You may have difficulty going directly to Word if your PC uses Windows XP. To create labels using Windows XP, save to Excel file first, then bring the Excel file into the Mail Merge in Word. The following instructions are based on Office 2000.
To create labels, click on the Word Processing Icon. A pop up box will appear. Select Form letter processing with MS Word and also select Start MS Word in this pop up box. Next, click on the No Password button and the green check mark. This is what you see in Word:
Go to: Tools > Mail Merge
1. Click Create
2. Then select Mailing Labels from the drop down menu
MDT MANUAL R/3 4.70
11/19/2007
30
4. Then select Setup
3. Select Change Document Type
5. Select the desired label and click ok
6. Click on Insert Merge Field
MDT MANUAL R/3 4.70
11/19/2007
31
7. Arrange the fields as you would like to see them on the label
8. Click ok
9. Then click Merge
10. Click Merge again
MDT MANUAL R/3 4.70
11/19/2007
32
Your labels are ready to print:
Other Icons available There are other icons available within the report that allows you to hide columns, sort, etc. described below:
Allows you to view all info about one line of the report. Highlight a particular column and click this icon to sort in ascending order Highlight a particular column and click this icon to sort in descending order Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list. Allows you to save the report to your local pc. Select the icon, and then select the location to save the file to, and name the file. SAP Mail not applicable.
Graph- shows you a graphical representation of your report.
MDT MANUAL R/3 4.70
11/19/2007
33
MDT MANUAL R/3 4.70
11/19/2007
34
ADDRESS LABELS - HOME

Report Description This report gives you a list of all your employees along with their home address. The information can be imported into Word so the labels can be printed. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
3. Highlight the level of reporting desired 4. Highlight the report you wish to run.
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on HOME ADDRESS LABELS.
MDT MANUAL R/3 4.70
11/19/2007
35
Icons This report contains several different icons. A description of their functionality can be found with the report CAMPUS LABELS. You may have difficulty going directly to Word if your PC uses Windows XP. To create labels using Windows XP, save to Excel file first, then bring the Excel file into the Mail Merge in Word. The following instructions are based on Office 2000.
To create labels, click on the Word Processing ( ) Icon. A pop up box will appear. Select Form letter processing with MS Word and also select Start MS Word in this pop up box. Next, click on the No Password button and the green check mark.
MDT MANUAL R/3 4.70
11/19/2007
36
This is what you see in Word:
Go to: Tools > Mail Merge
1. Click Create
2. Then select Mailing Labels from the drop down menu
MDT MANUAL R/3 4.70
11/19/2007
37
4. Then select Setup
3. Select Change Document Type
5. Select the desired label and click ok
6. Click on Insert Merge Field
MDT MANUAL R/3 4.70
11/19/2007
38
7. Arrange the fields as you would like to see them on the label
8. Click ok
9. Then click Merge
10. Click Merge again
MDT MANUAL R/3 4.70
11/19/2007
39
Your labels are ready to print:
MDT MANUAL R/3 4.70
11/19/2007
40
BIRTHDAYS Report
Report Description The Birthday report details all of the birthdays of the selected employees. This report is sorted by Personnel Number. You can sort the report differently using the icons with in the report. It provides the employees ages as of the date you indicated on the Time Period selection on the front of the MDT screen. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources Employee Data; then click on Birthdays.
MDT MANUAL R/3 4.70
11/19/2007
41

Column Personnel Number Last Name First Name Entry Leaving date Date of Birth Day DoB Year Month Gend Cost Center Org Unit Age Description HR assigned employee number of the selected employees Last Name of the employee First Name of the employee Not applicable Date the employee is to be terminated from IT0000 Date of Birth of the employee Day of month employee was born DDMM Day and Month employee was born Year the employee was born Month the employee was born Gender of Employee 2=Female, 1=Male Cost Center Employee is assigned to on IT0001 Organizational Unit Employee is assigned to on IT0001 Age of the employee as of the begin date on selection
MDT MANUAL R/3 4.70
11/19/2007
42
MDT MANUAL R/3 4.70
11/19/2007
43
Change In Staffing Level

Report Description The Change in Staffing Level report provides you with information about the employment changes that your employees have experienced. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, you can specify a time period if you wish. This allows you to select employee data at different points in time. This will search for employees that are active within the period you select. All the executable reports are located on the left hand side of the screen. Execute this report by clicking the report just below the Human Resources folder. Click on Change In Staffing Levels.
1. Select a tab
3. Highlight the level of reporting desired. 4. Select the report you wish to run.
Youll see the following report after your selection:
MDT MANUAL R/3 4.70
11/19/2007
44
For this report, the columns are as follows:

Column Name Personnel No. First Name Last name Entry Action Name of Action Type From Org Unit Name of Org Unit PArea Personnel Area Text ESgrp EE Subgroup Name EE Grp Name of Employee Group Cost Center- IT1 Description This is the employee personnel number This is the employees first name. This is employee Last Name. This is the date the employee was hired/returned to work at CMU. This is a number associated with the type of change. Type of change that has occurred. Date the change took place. This is the Organization Unit Number the employee is assigned to. Name of the Organizational Unit the employee is assigned to. Personnel Area code. Personnel Area text name. Employee Sub Group code. Employee Sub Group text name. Employee Group code. Employee Group code text name. Cost Center Employee is primarily assigned to.
MDT MANUAL R/3 4.70
11/19/2007
45
The Icons available on this report are as follows:
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts.
MDT MANUAL R/3 4.70
11/19/2007
46
MDT MANUAL R/3 4.70
11/19/2007
47
Employee List
Report Description The employee list provides you with a list of employees for your department, and includes position data information. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, you can specify a time period if you wish. This allows you to select employee data at different points in time.
All the executable reports are located on the left hand side of the screen. Execute this report by clicking the report just below the Human Resources folder. Click on Employee List.
1. Select a tab
3. Highlight the level of reporting desired. 4. Select the report you wish to run.
MDT MANUAL R/3 4.70
11/19/2007
48
For this report, the columns are as follows:

Column Name Personnel number Cost Center Cost Center Text Last name First name Position Number Position Text Description This is the employee personnel number This is the cost center number for the employees primary assignment This is the name associated with the cost center. This is employees Last Name. This is the employees First Name. This is the employees position control number for their primary assignment This is the Position Title for the employees primary assignment
There are many different icons that can be used from this screen. SOME of them are described below:
MDT MANUAL R/3 4.70
11/19/2007
49
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts.
MDT MANUAL R/3 4.70
11/19/2007
50
MDT MANUAL R/3 4.70
11/19/2007
51
NEW HIRES/TERMINATIONS Report

Report Description The New Hires/Termination report provides you information relating to when they were hired, and if they have a termination set up in the system. It is sorted by the employee number. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on NEW HIRES/TERMINATIONS.
1. Select a tab
3. Highlight the level of reporting desired
MDT MANUAL R/3 4.70
11/19/2007
52

Column Personnel No. First Name Last Name Entry Date Leaving Date Description HR Employee number of the selected employees First Name of employee Last Name of the employee Date employee was hired or came back to work for CMU If date shown is 12/31/9999 they do not have an anticipated termination date in system. If there is an end date in this column,
MDT MANUAL R/3 4.70
11/19/2007
53
Org Unit Name of Organizational Unit
there is a date scheduled in the system for termination. There may be multiple entries in the report for employees depending on the period dates you selected on the initial screen. Organizational Unit number where employee is assigned in system. Text name of Organizational Unit where employee is assigned
Icons This report contains several different icons. A description of their functionality follows:
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green
MDT MANUAL R/3 4.70
11/19/2007
54
SALARY LIST 9/10 MONTH EMPLOYEES Report

Report Description This report is a list of all the 9/10 month salaries located on infotype 35 (subtype Z8). Currently, this subtype is used for 9 or 10 month faculty and graduate assistants. These employees should not have an annual salary listed on their basic pay infotype so they will appear on the SALARY LIST STAFF report with a zero. (There are some exceptions to this). Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on SALARY LIST 9/10 MTH EMP
MDT MANUAL R/3 4.70
11/19/2007
56

Column Name PERS NUM SUBTYPE EMPLOYEE NAME BEG DATE END DATE SALARY AMOUNT Description HR assigned number for the employee Z8 annual salary for 9/10 month employees Name of the selected employee Beginning date of the salary End date of the salary Salary of employee
MDT MANUAL R/3 4.70
11/19/2007
57
SALARY LIST STAFF REPORT

Report Description This report gives a list of all the selected active employees that have an annual salary listed on the basic pay infotype. It is sorted by employee name. This report will NOT include employees (such as nine or ten month faculty, students and temporary employees) that are paid using another method. If a person is a nine or ten month staff employee (i.e. Residence Hall Director), the annual salary reflected in this report will not be the correct amount. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on SALARY LIST STAFF.
1. Select a tab
MDT MANUAL R/3 4.70
11/19/2007
58

Column Name Pers.no. Last name First name ESgrp Annual salary Start date End date Description HR assigned number for the employee Name of the selected employee Employee sub group Annual salary listed on basic pay infotype 8 Beginning date of the salary End date of the salary
There are many different icons that can be used from this screen. SOME of them are described below:
Initial value icon returns the report back to the original columns and sort specifications Highlight a particular column and click this icon to sort in ascending order
MDT MANUAL R/3 4.70
11/19/2007
59
Highlight a particular column and click this icon to sort in descending order Highlight a particular column and click this icon to hide that column Click on this icon to unhide the columns Click on a particular column and then this icon to fix the column in position This icon changes the display to a table where it can be further manipulated. Use the green back arrow to return to the previous screen. Brings the information on the screen direct to MSWord as mail merge fields. Be sure to click the No Password button. Note: If you wish to bring the information into MSWord as a table, first click the then click the icon. icon and
Brings the information on the screen direct to MSExcel. Be sure to click the Excel Display radio button.
MDT MANUAL R/3 4.70
11/19/2007
60
MDT MANUAL R/3 4.70
11/19/2007
61
SENIORITY LIST REPORT

Report Description This report provides a report for employees based on the seniority dates stored in the system (from Infotype 041). It is sorted by employee personnel number. This report will only include regular employees (it excludes student and temporary employees). There are three types of seniority dates currently stored in the system. All three are reflected on the report, and each is used for different purposes. The following is an explanation of each of the dates and what they are used for: Orig. Hire: The Original Hire date is the date the employee first started working for the University (either as a regular or temporary employee). In many cases, this date is used as the start date to calculate Service Awards. Normally, breaks in CMU employment are not counted towards Service Awards. For example, if an employee begins working at CMU in 6/1983, works continuously until 5/1993, at which time they terminate. Hires back in 6/2001. The Original Hire date would stay 6/1983, however the Service Award would not count the period between 6/93 and 5/2001, as the employee was not working for CMU during this time. Leave Accrual: The Leave Accrual date is used for all employees that are eligible for benefits. It is used for seniority calculations for the groups that recognize the university wide seniority/service rules. The groups currently recognizing this policy are the Broadcasting, Office Professional, Supervisory Technical, P&A, and Senior Officer. It is also the date the system uses to determine how many years of service the employee has when calculating Sick and Vacation Accrual amounts. EE Group Start: The EE Group Start date is the date used to calculate seniority for the Service Maintenance and Police groups. It reflects the date the employee began working in their current employee group, and reflects continuous service in this group.
Because there are differences between how the dates are used, seniority calculated is different depending on the employee group in reference. So, if the report displays different dates for the different categories, and you are questioning actual service, contact Human Resources for information of how to determine the appropriate seniority for the employee. Differences could be the result of lapses in service with CMU or time spent as a temporary employee.
MDT MANUAL R/3 4.70
11/19/2007
62
Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT To run the Seniority Report, highlight the group or individual you wish to run the report for on the right side of the Managers Desktop screen, and then select SENIORITY REPORT on the left side of the screen. Refer to the following screen shot displaying how to run the report.
1. Select a tab.
2. Select time period report is desired for.
3. Highlight the level of reporting desired.
MDT MANUAL R/3 4.70
11/19/2007
63

Column Name Pers.num. Name Orig. Hire Hire Years Leave Accrual Leave Years EE Group Start EE Group Years Description HR assigned number for the employee Name of the selected employee Original Hire date (see description above) Calculated number of seniority years for the Original Hire Date Leave Accrual date (see description above) Calculated number of seniority years for the Leave Accrual Date. Employee Group Start date (see description above) Calculated number of seniority years for the Employee Group.
MDT MANUAL R/3 4.70
11/19/2007
64
You may either print directly from Managers Desktop, or you may download it to your PC as a spreadsheet file and open with Excel if youd like to sort the report differently than it appears on your screen. To download the report to your PC, use the following menu path (from the toolbar at the top of the screen) once the report appears on your screen: System List Save Local File
Youll see the following popup box:
Make sure the Spreadsheet option is selected, and then click on the green check mark. Youll see another popup box. This tells the system where you want to save the report. To change the default, select the drop down on the file name line as shown below: Click on the icon to select a location to save the file
After you select the location, click on the Transfer Button
Once you click on the icon to save to a different location, you can save the report directly to your own pc directories. After you have selected the location and the name of the file, select the TRANSFER button and the report will be downloaded to your pc. You can now go into Excel and open this report file, and sort any way youd like. This procedure will work for ALL reports throughout SAP that does not readily have an Excel icon available to it.
MDT MANUAL R/3 4.70
11/19/2007
65
SENIORITY/GENDER Reports
Report Description The Seniority/Gender report is a statistical report listing the years of service, and percent of males and females by seniority. This report is selected as of the current date or the Time Period To Date if it is earlier than the current date. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on Seniority/Gend-fac/staff or Seniority/Gend-students. Running the fac/staff report will provide information on your regular staff and faculty members only, and running the students report will provide information on your student/temporary employees.
MDT MANUAL R/3 4.70
11/19/2007
66

Column years Gender Number Share in % Description Number of years of seniority Text for either Male or Female possible line for each Gender Number of MALE or FEMALE employees with that many years of seniority Percent of MALE or FEMALE employees with that many years seniority
MDT MANUAL R/3 4.70
11/19/2007
67
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button.
MDT MANUAL R/3 4.70
11/19/2007
68
Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
MDT MANUAL R/3 4.70
11/19/2007
69
STAFFING CHANGES Report

Report Description The Staffing Changes report details all of the actions that occurred to the employees selected in the reported time period. This report is sorted by personnel number of the employee. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on Staffing Changes.
MDT MANUAL R/3 4.70
11/19/2007
70
Scroll over to see the rest of the columns:
MDT MANUAL R/3 4.70
11/19/2007
71

Column Personnel No. First Name Last Name Entry Action / Name of Action Type From Org Unit/Name of organizational unit PArea/Personnel Area Text EE subgrp / Text EE group /Text Cost ctr / Text Description HR Employee number of the selected employees First name of employee. Last Name of the employee Date employee hired or came back to work for CMU. Number and description of the action Date the action occurred Org unit number and text for Organizational Unit (or your department name) Personnel Area code and text name of Personnel Area where employee is assigned. Employee subgroup code and name Employee group code and name Cost center number and name of the employee
Allows you to save the report to your local pc. Select the icon, and then select the location to save the file to, and name the file.
MDT MANUAL R/3 4.70
11/19/2007
72
SAP Mail not applicable.
Graph- shows you a graphical representation of your report. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
MDT MANUAL R/3 4.70
11/19/2007
73
TELEPHONE DIRECTORY Report

Report Description The Telephone directory lists all the external telephone numbers and addresses of the selected employees sorted by last name. The telephone number listed comes from information entered on info type 0006 Addresses. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Human Resources --> Employee data; then click on Telephone Directory.
MDT MANUAL R/3 4.70
11/19/2007
74
Important note If you see the word CONFIDENTIAL in one of the address lines, this means the employee has requested their address information not be released. Please take special care protecting this information.

Column Name Address Communications Number Description Name of the employee Permanent address listed on infotype 0006 Addresses Telephone number listed on infotype 0006 Addresses
MDT MANUAL R/3 4.70
11/19/2007
75
Personnel Development
Qualifications Overview
MDT MANUAL R/3 4.70
11/19/2007
76
Qualifications Overview Report

Report Description The Qualification Overview report details all of the qualification/skills that have been set up in the system during the reported time period. This report is initially sorted by Organization Unit, then by Qualification. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Personnel Development; then click on Qualification Overview.
MDT MANUAL R/3 4.70
11/19/2007
77
Scroll over to see the rest of the columns:
MDT MANUAL R/3 4.70
11/19/2007
78

Column ID rel. obj Organizational Unit Object ID Qualification Group Object ID Qualification Qualification fulfilled Average Average Proficiency ID of related object Last Name Name Proficny Proficiency text Description Not applicable Organizational Unit name Not applicable Qualifications/skills are grouped together this is the higher level Not applicable Type of qualification/skill employee has obtained Indicates the qualification was obtained successfully Not applicable Indicates the level the qualification was obtained Employee number assigned within system Last Name of employee Full Name of employee Not applicable Indicates the level of the qualification i.e. ATTENDED, PASS, FAIL
Brings the information on the screen direct to MSWord as mail merge fields. Be sure to click the No Password button.
MDT MANUAL R/3 4.70
11/19/2007
79
Brings the information on the screen direct to MSExcel. Be sure to click the Excel Display radio button.
Allows you to save the report to your local pc. Select the icon, and then select the location to save the file to, and name the file. SAP Mail not applicable. Provides statistical analysis for report. Select one of the numerical columns and hit the ABC button to review the analysis information provided. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
MDT MANUAL R/3 4.70
11/19/2007
80
Absence & Leave Information

Absences by Type Absences FMLA Only Dept Leave Quota Info Employee Quota Info Timesheets Biweekly Staff Timesheets Semi-Monthly Timesheets Student/Temp
MDT MANUAL R/3 4.70
11/19/2007
81
Absences by Type
Report Description The Absences by Type report details all of the absences by absence category (i.e. sick pay, vacation pay, etc.) for the period selected. It is sorted first by the employees home cost center and then by employee number. It does NOT include the family medical leave absences. Those must be accessed using the report FMLA Absences. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab 2. Select the time period report is desired for. Best to enter an end date as well
MDT MANUAL R/3 4.70
11/19/2007
82
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Time Management Info; then click on Absences by type. NOTE: If you do not enter an end date in the selection period (if you leave it as 12/31/9999), youll see another screen come up before the report. Simply hit the execute button (green check mark at top left of screen), and the report will come up next.
Click on the execute button to continue to the report.
There are 11 different absence types that could appear on the report: CS COURT REQUIRED SERVICES SF SICK LV FOR FAMILY CU COMPTIME USED SH SICK PAID AT 50% FL FUNERAL LEAVE SP SICK PAY AT 100% HP HOLIDAY PAY UP UNPAID ABSENCE PA PAID ABSENCE VP VACATION PAY PP PERSONAL LEAVE
MDT MANUAL R/3 4.70
11/19/2007
83

Column Name Cost ctr Hrs Plnd hrs Hrs/plnd Days Plan.days Days/plnd No.records Description Home cost center (infotype 0001) for the selected employees Total absences in hours for selected employees Total hours selected employees were scheduled to work Percent of absences in hours to total hours scheduled Total absences in days for selected employees Total days selected employees were scheduled to work Percent of absences in days to total days scheduled Number of individual records of absences
TIP If nothing is selected in your report, verify that you have the proper begin and end dates selected. The end date MUST be the current date or earlier because the system is scanning for absences that have already been entered in the system. Icons This report contains several different icons. A description of their functionality follows:
MDT MANUAL R/3 4.70
11/19/2007
84
: Clicking on this icon changes the layout of the page to look like a report instead of a
table Example:
Click on the green arrow to go back to the previous view.

:
SAP Email do not use : Information icon not applicable to this report : Brings the information on the screen direct to Excel; be sure to click on the No Password button : Brings the information on the screen direct to MSWord as mail merge fields. Be sure to click the No Password button. : Expands (or collapses) the information on the selected line only.
MDT MANUAL R/3 4.70
11/19/2007
85
Example:
Select a person and click on the Expand< > Collapse icon again for more detail:
MDT MANUAL R/3 4.70
11/19/2007
86
: Selecting this icon expands the entire report down to the lowest detail. Example
: Selecting this icon changes the appearance of the report and eliminates the
blank lines. Example:
MDT MANUAL R/3 4.70
11/19/2007
87
Selecting it again adds the blank lines back in.
MDT MANUAL R/3 4.70
11/19/2007
88
This icon summarizes the information by Leave Type within Cost Center:
Note: You can return to the previous screen at any time by using the Green Back Arrow .
From expanded mode: : Highlight a particular line for an employee, and then click on this icon to see each absence entered for the selected employee by the time entry clerks.
MDT MANUAL R/3 4.70
11/19/2007
89
Example:
1. Click here
2. Then click here
The following detail appears:
MDT MANUAL R/3 4.70
11/19/2007
90
Note: If you select an employee line with the asterisks in the A/A type column and click on the detail icon youll see:
2. Select the detail icon. 1. Highlight this line.
The following appears:
MDT MANUAL R/3 4.70
11/19/2007
91
Other Icons of report

Highlight a particular column and click this icon to sort in ascending order Highlight a particular column and click this icon to sort in descending order
Use the green back arrow
to return to the previous screen.
Return to Managers Desktop Screen (Select yellow EXIT icon or Shift F3).
Click Yes
MDT MANUAL R/3 4.70
11/19/2007
92
ABSENCES FMLA ONLY Report

Report Description The FMLA Absences Only report details only the absences related to the Family Medical Leave Act, FMLA dependent (LD) and FMLA self (LS), for the period selected. It is sorted first by the employees home cost center and then by employee number. All other absence types can by seen by selecting the Absences by Type report. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab
2. Select the time period report is desired for. Hint it is best to enter an end date.
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Time Management Info; then click on FMLA Absences Only.
MDT MANUAL R/3 4.70
11/19/2007
93
NOTE: If you do not enter an end date in the selection period (if you leave it as 12/31/9999), youll see another screen come up before the report. Simply hit the execute button (green check mark at top left of screen), and the report will come up next.
There are only two FMLA absence types: LD FMLA DEPENDENT LS FMLA SELF The following report appears:

Column Name Cost ctr Hrs Plnd hrs Hrs/plnd Days Plan.days Days/plnd No.records Description Home cost center (infotype 0001) for the selected employees Total absences in hours for selected employees Total hours selected employees were scheduled to work Percent of absences in hours to total hours scheduled Total absences in days for selected employees Total days selected employees were scheduled to work Percent of absences in days to total days scheduled Number of individual records of absences
MDT MANUAL R/3 4.70
11/19/2007
94
TIP If nothing is selected in your report, verify that you have the proper begin and end dates selected. The end date MUST be the current date or earlier. Icons This report contains several different icons. A description of their functionality follows:
: Clicking on this icon changes the layout of the page to look like a report instead of a
table Example:
SAP Email do not use : Information icon not applicable to this report : Brings the information on the screen direct to Excel; be sure to click on the No Password button : Brings the information on the screen direct to MSWord as mail merge fields. Be sure to click the No Password button. : Expands (or collapses) the information on the selected line only.
95
MDT MANUAL R/3 4.70
11/19/2007
Example:
Click the Expand< > Collapse icon
MDT MANUAL R/3 4.70
11/19/2007
96
Select a person and click on the Expand< > Collapse icon again for more detail:
: Selecting this icon expands the entire report down to the lowest detail.
MDT MANUAL R/3 4.70
11/19/2007
97
: Selecting this icon changes the appearance of the report and eliminates the
blank lines.
Selecting it again adds the blank lines back in. Note: You can return to the previous screen at any time by using the Green Back Arrow .
From expanded mode: : Highlight a particular line for an employee, and then click on this icon to see each absence entered for the selected employee by the time entry clerks.
MDT MANUAL R/3 4.70
11/19/2007
98
Example:
2. Then click here
1. Select an employee line.
MDT MANUAL R/3 4.70
11/19/2007
99
Note: If you select an employee line with the asterisks in the A/A type column then click on the detail button:
The following appears:
MDT MANUAL R/3 4.70
11/19/2007
100
Other Icons of report

Highlight a particular column and click this icon to sort in ascending order Highlight a particular column and click this icon to sort in descending order
Use the green back arrow
to return to the previous screen.
Return to Managers Desktop Screen (Select yellow EXIT icon or Shift F3).
Click Yes
MDT MANUAL R/3 4.70
11/19/2007
101
DEPT LEAVE QUOTA INFO Report

Report Description The leave quota information report allows you to view the remaining leave balances for each of your employees as well as the amount of leave already taken. It is sorted by employee number and does not include students, temporaries and other employee subgroups that do not accrue leave. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab 2. Select the time period report is desired for. You should select the current calendar year 3. Highlight the level of reporting desired 4. Select the report you wish to run.
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Time Management Info; then click on Dept Leave Quota Info.
MDT MANUAL R/3 4.70
11/19/2007
102
Note: This report is selected for the current calendar year only regardless of the time period selected.
The first row is the Pers no and the second is Name of the employee. The remaining rows contain the following information:
Column Name Pers. No. Name Quota Unit Entitlement Used Total remain Description ID number for employee Employee Name Type of Leave Balance Unit of the leave balance shown in hours Total balance YTD including accrual amounts Amount of leave requested by employee Total remaining balance available for use
MDT MANUAL R/3 4.70
11/19/2007
103
Choose: Select an employee and click this icon to detail information in a different format. It will display the same information you see on the original screen, except in a different format. Summary: Clicking on this icon is not useful in this report. Excel: Brings the information on the screen direct to Excel.
MDT MANUAL R/3 4.70
11/19/2007
104
Employee Quota Info Report

Report Description The leave quota information report allows you to view the remaining leave balances for individual employees. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, you can specify a time period if you wish, however, you will be able to override this within the report as well. Also note the personnel number of the person you wish the information on, as you will need it for the report.
All the executable reports are located on the left hand side of the screen. Execute this report by opening the Time Management Info folder, and then click on Employee Quota Info.
1. Select a tab
2. Select the time period the report is desired for.
3. Note the ID number for the employee you wish to view data for. You will need it after you select the report
MDT MANUAL R/3 4.70
11/19/2007
105

2. Type the ID number for the employee you wish to view in the Personnel no. field. Then hit enter to refresh your screen. You can obtain the employee ID number from the front screen.
3. After you fill in the dates, select the Absence Quotas tab. 1. Choose the time period you wish to view for the report. You can select from today, the current period, calendar year or all. Fill in the dates according to what you wish to view.
The initial screen defaults to the selection dates. Fill in the dates according to what you wish to view, then click on the Absence Quotas tab. This will bring you to the following display:
MDT MANUAL R/3 4.70
11/19/2007
106
For this employee the columns are as follows:

Column Name Abs. Quota Quota Text Unit Entitl. Description Number associated with the quota Text for type of quota type of balance Unit balance is displayed in hours. This is the total amount of leave that the employee had at the beginning of the leave year, plus any accruals they have received during the year. This is the balance that the employee has left to use. This is the total number of hours the employee has requested to use. Not relevant for CMU
Rem. Requested Compensated
MDT MANUAL R/3 4.70
11/19/2007
107
TIMESHEETS BIWEEKLY STAFF
Report Description: This program will provide time sheets for your biweekly staff employees. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT
OR:
Click on the CMU TIMESHEETS tab on the front MDT Screen or at the top of the CMU Management Reports screen.
As in all other Managers Desktop reports, first select the period for the report in the TIME PERIOD at the top of the screen. With all Timesheets, enter the PAY PERIOD in the selection box. The following is an example of what you would enter to run the 26th pay period for a Biweekly Timesheet run:
After you enter the period dates, hit the green check mark to accept the dates. Then select the group you want to run the program for on the right side of the screen, and click on the report you want to run on the left. If you want to only print timesheets for certain employees, highlight their name on the right then click on the report on the left. If youd like to run for more than one at a time, hold your control key down while selecting the employee names on the right, then click on the report on the left. Your output will appear on your screen. Once they appear on your screen, you may select the print icon at the top of the page and print to the printer where you normally print SAP.
MDT MANUAL R/3 4.70
11/19/2007
108
1. Select a tab
2. Select the time period for timesheets payroll period
4. Select Timesheets Biweekly Staff to run report
3. Highlight the level of report you desire.
After the Timesheets appear on your screen, print utilizing the Print Icon at the top of the screen.
MDT MANUAL R/3 4.70
11/19/2007
109
TIMESHEETS SEMI-MONTHLY
Report Description: This program will provide all time sheets for your Semi-Monthly employees. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT
OR:
As in all other Managers Desktop reports, first select the period for the report in the TIME PERIOD at the top of the screen. With all Timesheets, enter the PAY PERIOD in the selection box. The following is an example of what you would enter to run the 10th pay period for a Semi-Monthly Timesheet run:
After you enter the period dates, hit the green check mark to accept the dates. Then select the group you want to run the program for on the right side of the screen, and click on the report you want to run on the left. If you want to only print timesheets for certain employees, highlight their name on the right then click on the report on the left. If youd like to run for more than one at a time, hold your control key down while selecting the employee names on the right, then click on the report on the left.
Your output will appear on your screen. Once they appear on your screen, you may select the print icon at the top of the page and print to the printer where you normally print SAP.
MDT MANUAL R/3 4.70
11/19/2007
110
1. Select a tab
2. Select the time period for timesheets payroll period
4. Select Timesheets Semi-Monthly to run report
3. Highlight the level of report you desire.
After the Timesheets appear on your screen, print utilizing the Print Icon at the top of the screen.
MDT MANUAL R/3 4.70
11/19/2007
111
Timesheets Student/Temporary Employees

Report Description: This program will provide all time sheets for your Student/Temporary employees. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT
OR:
As in all other Managers Desktop reports, first select the period for the report in the TIME PERIOD at the top of the screen. With all Timesheets, enter the PAY PERIOD in the selection box. The following is an example of what you would enter to run the 26th pay period for a Biweekly Student Temporary Timesheet run:
After you enter the period dates, hit the green check mark to accept the dates. Then select the group you want to run the program for on the right side of the screen, and click on the report you want to run on the left. If you want to only print timesheets for certain employees, highlight their name on the right then click on the report on the left. If youd like to run for more than one at a time, hold your control key down while selecting the employee names on the right, then click on the report on the left.
For example, to run the Biweekly Timesheets for your Students and Temporary employees, select the group on the right, and the report TIMESHEETSSTUDENT/TEMP on the left.
MDT MANUAL R/3 4.70
11/19/2007
112
You will be presented with a selection screen like the following. Begin by clicking on the variant icon as shown:
1. Click on the variant icon
Once you click on the variant button as shown above, youll see the following pop up box. Double click on the MDT line or on your saved variant name.
Double click any where on the MDT line
MDT MANUAL R/3 4.70
11/19/2007
113
The following screen appears with several options already selected for you. You need to change the Other Period number (shown here as 1) to the pay period you wish to run the Timesheets for. Also, you need to select the cost center you wish to run the Timesheets for. If you are selecting multiple cost centers within the same run, follow the additional procedures below.
1. Change the Other Period to the pay period number you require. 2. Replace the existing 20000 entry with your cost center number. If you need to run multiple cost centers (i.e. for college work study) follow procedures below.
If you need to run the report for multiple cost centers, on the same line where you entered your cost center (as shown above), to the far right on that line, there is an arrow pointing to the right. Click on that arrow, and youll see the following:
MDT MANUAL R/3 4.70
11/19/2007
114
1. Replace the top line (showing as 20000) with your first cost center for the report. On the next line(s) enter the rest of the cost centers you wish to see on your report. If you need more than the number of lines displaying, you can use the scroll bar on the right of the screen to page down. 2. Once you have entered all your cost centers, click on the COPY button.
After you have filled in your cost centers (either on the first screen, or the secondary screen for multiple cost centers), Click on the execute button at the top of the selection screen or hit your F8 button on your keyboard. Your output will appear on your screen. Once it appears on your screen, you may select the print icon at the top of the page and print to the printer where you normally print SAP. SPECIAL NOTE: This program will take approximately 2-3 minutes to run. Therefore, to continue to work in SAP at the same time, make sure you have opened more than one session at a time. To do so, select the create session at the top of your SAP screen prior to executing the timesheets for Student/Temporary employees.
MDT MANUAL R/3 4.70
11/19/2007
115
Travel
Travel data/totals Trip Receipts Trip receipts as list Cost assignment Travel Expense by Type
MDT MANUAL R/3 4.70
11/19/2007
116
TRAVEL DATA/TOTALS Report

Report Description The Travel Data/Totals report details all Trips your employees have taken. It is sorted first by the employee number and then by trip data, however you can use the icons to sort in any order you wish. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period and select the level desired for your report:
1. Select a tab 2. Select the time period report is desired for OPTIONAL for this report
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Travel, then open Travel Expenses; then click on Travel data/totals. Note: Entry of dates on the selection screen does not limit the dates on the report.
MDT MANUAL R/3 4.70
11/19/2007
117
You will see the following report after selection:

Column Pers. No. Trip Dur. From date Trip end date Trip destination Cty Region Reason for Trip Reimbursmt Pd by com. Total Costs Curr. Sett FI trans. AccMs/Kms Description HR Employee number of the selected employees Internal Trip number assigned to Trip. Total number of days for Trip Date the Trip began Date Trip ended Destination of Trip Country High Cost Region as defined by Travel Rules Reason associated with Trip Amount that was reimbursed for Trip Not applicable Total costs for Trip (may or may not be fully reimbursed) Currency for Trip Indicates whether the Trip was settled or not Indicates whether the Trip has been transferred to FI Mileage for Trip
MDT MANUAL R/3 4.70
11/19/2007
118
Allows you to view all info about one line of the report. Highlight a particular column and click this icon to sort in ascending order. To sort on multiple levels, Hit sort icon again. Youll then receive a pop up box like the following:
To sort on another column, highlight the column on the right and then hit the left arrow button to move it under the personnel number field on the left. You can then select whether you want it to sort ascending or descending order and if you would like subtotals to appear for the field by clicking in the appropriate boxes that are now next to the field name.
Click on the green check mark after you have your selections set. Youll notice on the report that a small red arrow appears in the column name field. This indicates which columns are sorted. Highlight a particular column and click this icon to sort in descending order
Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list. Allows you to provide or remove totals on a column. Highlight a numeric column, hit this icon and the totals will either appear or be removed.
MDT MANUAL R/3 4.70
11/19/2007
119
Not applicable to this report.
Allows you to do statistical analysis on a numeric field. Highlight the numeric field and hit this icon.
Graph- shows you a graphical representation of your report. Select multiple columns by holding the control key down while click different columns. Then select the Graph icon to see the graphical representation. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
To see individual Trip information, you can click on the Trip number within the report and drill down into the report. By clicking on a Trip number, youll see the following pop up box:
MDT MANUAL R/3 4.70
11/19/2007
120
You options are: 1. Trip Click on this button, and you be taken into the details of the trip. 2. Trip Receipts Displays the receipt information associated with this trip. 3. Cost assignment Displays where this trip was charged. 4. Trip block list displ. Provides trip details in a report display mode. 5. Cancel Takes you back to the report.
MDT MANUAL R/3 4.70
11/19/2007
121
TRIP RECEIPTS Report

Report Description The Trip Receipts report details all receipts for Trips your employees have taken. It is sorted first by the employee number and then by trip date, however you can use the icons to sort in any order you wish. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period (optional) and select the level desired for your report:
MDT MANUAL R/3 4.70
11/19/2007
122
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Travel, then open Travel Expenses; then click on Trip Receipts. Note: Entry of dates on the selection screen does not limit the dates on the report. You will see the following report after selection:

Column Pers. No. Trip Dur. From date End date Destination Cty Reason Total Costs Curr. ExpTy Name Description HR Employee number of the selected employees Internal Trip number assigned to Trip. Total number of days for Trip Date the Trip began Date Trip ended Destination of Trip Country Reason associated with Trip Total costs for Trip (may or may not be fully reimbursed) Currency for Trip Expense Type Code Expense Type Name
MDT MANUAL R/3 4.70
11/19/2007
123
LocCurrAmt Crcy Date Description
Amount of Expense Type Currency Date associated with expense type/trip Additional Information entered during recording of Trip
MDT MANUAL R/3 4.70
11/19/2007
124
Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list. Allows you to provide or remove totals on a column. Highlight a numeric column, hit this icon and the totals will either appear or be removed. Not applicable to this report.
Allows you to scroll right and left through the report.
MDT MANUAL R/3 4.70
11/19/2007
125
TRIP RECEIPTS AS LIST Report

Report Description The Trip Receipts as List report details all receipts for Trips your employees have taken. It is sorted first by the employee number by trip number, then by expense type; however you can use the icons to sort in any order you wish. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period (optional) and select the level desired for your report:
MDT MANUAL R/3 4.70
11/19/2007
126
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Travel, then open Travel Expenses; then click on Trip Receipts as List. Note: Entry of dates on the selection screen does not limit the dates on the report. You will see the following report after selection:

Column Pers. No. Trip Exp Name LocCurrA Crcy PC Receipt Date Description Description HR Employee number of the selected employees Internal Trip number assigned to Trip. Expense Type code Expense Type name Amount of expense type Currency Not applicable Date recorded on Receipt Description entered for expense
MDT MANUAL R/3 4.70
11/19/2007
127
MDT MANUAL R/3 4.70
11/19/2007
128
Allows you to provide or remove totals on a column. Highlight a numeric column, hit this icon and the totals will either appear or be removed. Not applicable to this report.
Allows you to do statistical analysis on a numeric field. Highlight the numeric field and hit this icon.
Graph- shows you a graphical representation of your report. Select multiple columns by holding the control key down while click different columns. Then select the Graph icon to see the graphical representation. Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected.
MDT MANUAL R/3 4.70
11/19/2007
129
COST ASSIGNMENT Report

Report Description The Cost Assignment report provides a list of all for Trips your employees and displays where the trip costs are charged. It is sorted first by the employee number then by trip begin date, however you can use the icons to sort in any order you wish. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT On the initial screen, specify a time period (optional) and select the level desired for your report:
MDT MANUAL R/3 4.70
11/19/2007
130
All the executable reports are located on the left hand side of the screen. Execute this report by clicking on the triangle to the left of Travel, then open Travel Expenses; then click on Cost Assignment. Note: Entry of dates on the selection screen does not limit the dates on the report. You will see the following report after selection:

Column Pers. No. Trip Dur. From date End date Destination Cty Reason Total Costs Curr. Amount Crcy Cost Ctr Description HR Employee number of the selected employees Internal Trip number assigned to Trip. Total number of days for Trip Date the Trip began Date Trip ended Destination of Trip Country Reason associated with Trip Total costs for Trip (may or may not be fully reimbursed) Currency for Trip Amount charged to Cost Center Currency for amount charged Cost Center charged for expense
MDT MANUAL R/3 4.70
11/19/2007
131
COAr Int. Order Sales Ord. SO Item
Controlling Area related to Cost Center Internal Order number if applicable Not applicable Not applicable
MDT MANUAL R/3 4.70
11/19/2007
132
Allows you to select (or filter) certain records for the report. Click on this icon, select the field you want to select on, and then choose your values. Hit the green check when you are done and you be left with your selected list. Allows you to provide or remove totals on a column. Highlight a numeric column, hit this icon and the totals will either appear or be removed. Not applicable to this report. Allows you to expand the entire report to the lowest detail, or expand individual levels. Click on the icon, and then click on a total line. Allows you to collapse entire report to just totals. Click on the icon to collapse the report.
Change Layout icon allows you to exclude columns from your report. Click on the icon, and then select the field name you want to exclude and move the field to the right by selecting the arrow or Hide Selected Field button. After you have excluded all the fields youd like, select the green check and youll be back to your report, and the column will no longer be visible. To get the column back, select the Change Layout icon again, and move the field back to the left side of the screen using the left arrow button. Saved layout. If you have previously saved a layout with this report, you can access the saved format by selecting this icon. If you have not previously saved a layout, you will receive a message that there are no saved layouts. Allows you to save a layout of this report. After you have changed the layout using the Change Layout icon, you can select the Save Layout icon and save the formatting you have selected. Allows you to scroll right and left through the report.
MDT MANUAL R/3 4.70
11/19/2007
133
In addition to the Icons, you can drill down on the Pers. No. to review the individual employee report information, and you may drill down on the Trip number. When you click on the Trip number, youll see the following:
You options are: 1. Trip Click on this button, and you be taken into the details of the trip. 2. Trip Receipts Displays the receipt information associated with this trip. 3. Cost assignment Displays where this trip was charged. 4. Trip block list displ. Provides trip details in a report display mode. 5. Cancel Takes you back to the report.
MDT MANUAL R/3 4.70
11/19/2007
134
Ad Hoc Query
MDT MANUAL R/3 4.70
11/19/2007
135
Report Description Ad Hoc Query is a reporting tool that lets you generate reports on Personnel Management data simply and efficiently. By selecting a number of output and selection fields, you have immediate access to data from all areas of Personnel Management. To learn more about Ad Hoc Query, sign up for an Ad Hoc training class. Menu Path: Human Resources > Managers Desktop > CMU Management Reports Transaction Code: PPMDT
MDT MANUAL R/3 4.70
11/19/2007
136
MDT MANUAL R/3 4.70
11/19/2007

SAP HR Manager Desktop

Uploaded by

Copyright:

Available Formats

SAP HR Manager Desktop

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SAP HR Manager Desktop

Uploaded by

Copyright:

Available Formats

MANAGERS DESKTOP SHORTCUT

1. Select this icon.

1. By selecting this icon, the following screen will appear.

MDT MANUAL R/3 4.70

3. This is the icon that is created on your desktop.

MDT MANUAL R/3 4.70

Ad Hoc Query............................................................................................................................. D-1

MDT MANUAL R/3 4.70

MANAGERS DESKTOP OVERVIEW

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

Expand all expands the ENTIRE organizational structure:

Collapse all collapses the entire org structure:

Expand expands one level at a time:

Collapse collapses one level at a time

Refresh - not applicable Legend Explains symbols in org structure as follows:

Not applicable for CMU.

MDT MANUAL R/3 4.70

4. Select the report youd like to run.

MDT MANUAL R/3 4.70

TABLE ONE (1)

All subordinate employees

Employees and departments who indirectly report to the chief

TABLE TWO (2)

TABLE THREE (3)

The procedures for executing each report are attached.

Use the green back arrow the previous screen.

or the yellow EXIT icon or Shift F3 to return to

MDT MANUAL R/3 4.70

Education and Training

MDT MANUAL R/3 4.70

Bookings with History

MDT MANUAL R/3 4.70

Each column of the report is described in the following table:

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

Education History Report

3. Highlight the level of reporting desired.

4. Select the report you wish to run.

Each column of the report is described in the following table:

MDT MANUAL R/3 4.70

The Icons available on this report are as follows:

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

Instructor History Report

3. Highlight the level of reporting desired run by person only.

4. Select the report you wish to run.

MDT MANUAL R/3 4.70

Each column of the report is described in the following table:

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

Finance and Budget Reports

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70

Human Resources Employee Data

MDT MANUAL R/3 4.70

MDT MANUAL R/3 4.70