budget sap reports - broward county public … reports matrix.pdfbudget sap reports report name...

27
BUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER All Postings Report Line item report for all documents (purchase requisitions, purchase orders, invoices, payroll postings, journal entries, etc.) updated in FM. Budget FMRP_RFFMEP1AX ECC end-user Availability Control Report Availability control report that shows the annual values of consumable (budget appropriation), consumed (expense) and available (balance) amounts. Budget FMAVCR01 ECC end-user Budget Status Report - Departments Summary report detailing other salary and non-salary budget and expenditure data by activity, function and commitment item with drill down capability. Budget BI end-user Budget Status Report - Grants Summary report detailing budget and expenditure data by fund, fund center, grant, funded program, functional area and commitment item with drill down capability. Budget BI end-user Budget Status Report - Schools Summary report detailing other salary and non-salary budget and expenditure data by activity, function and commitment item with drill down capability. Budget BI end-user Budget Status Report - Summary Summary report detailing other salary and non-salary budget and expenditure data by activity and account category with drill down capability. Budget BI end-user Comprehensive Budget Report - Schools Summary report detailing other salary and non-salary budget and expenditure data by activity with drill down capability. Budget BI end-user Display Budget Entry Documents Report to display all budget entry documents (transfers, returns, supplements, etc). Budget BI end-user Earmarked Funds Report to display any earmarked funds documents, i.e. funds reservations, funds commitments, etc. Budget BI end-user General Fund Amendment - Expense Summary report detailing general fund expense by fund, fund center, activity, function, funded program and account category with drill down capability. Budget BI super-user General Fund Amendment - Revenue Summary report detailing general fund revenue by fund, fund center, activity, function, funded program and commitment item with drill down capability. Budget BI super-user GM Billing Report Report to display billed and unbilled amounts by sponsored class and sponsored program. Grants BI end-user GM Budget Breakdown Report to display original budget, supplements, transfers, returns and total budget by grant. Grants BI end-user GM Indirect Cost Report to display GM indirect costs by grant, sponsored program and sponsored class. Grants BI end-user GM Line Item Display Line item report showing all expense in the GM ledger. Grants S_PLN_16000269 ECC/BI end-user GM Overall Expenses Compared to Budget & Percent Report to display budget, expense and billed amounts by grant, sponsored program and sponsored class. Grants BI end-user 1 of 2

Upload: vuminh

Post on 23-Mar-2018

226 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

BUDGET SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERAll Postings Report Line item report for all documents (purchase requisitions,

purchase orders, invoices, payroll postings, journal entries, etc.) updated in FM.

Budget FMRP_RFFMEP1AX ECC end-user

Availability Control Report Availability control report that shows the annual values of consumable (budget appropriation), consumed (expense) and available (balance) amounts.

Budget FMAVCR01 ECC end-user

Budget Status Report - Departments Summary report detailing other salary and non-salary budget and expenditure data by activity, function and commitment item with drill down capability.

Budget BI end-user

Budget Status Report - Grants Summary report detailing budget and expenditure data by fund, fund center, grant, funded program, functional area and commitment item with drill down capability.

Budget BI end-user

Budget Status Report - Schools Summary report detailing other salary and non-salary budget and expenditure data by activity, function and commitment item with drill down capability.

Budget BI end-user

Budget Status Report - Summary Summary report detailing other salary and non-salary budget and expenditure data by activity and account category with drill down capability.

Budget BI end-user

Comprehensive Budget Report - Schools Summary report detailing other salary and non-salary budget and expenditure data by activity with drill down capability.

Budget BI end-user

Display Budget Entry Documents Report to display all budget entry documents (transfers, returns, supplements, etc).

Budget BI end-user

Earmarked Funds Report to display any earmarked funds documents, i.e. funds reservations, funds commitments, etc.

Budget BI end-user

General Fund Amendment - Expense Summary report detailing general fund expense by fund, fund center, activity, function, funded program and account category with drill down capability.

Budget BI super-user

General Fund Amendment - Revenue Summary report detailing general fund revenue by fund, fund center, activity, function, funded program and commitment item with drill down capability.

Budget BI super-user

GM Billing Report Report to display billed and unbilled amounts by sponsored class and sponsored program.

Grants BI end-user

GM Budget Breakdown Report to display original budget, supplements, transfers, returns and total budget by grant.

Grants BI end-user

GM Indirect Cost Report to display GM indirect costs by grant, sponsored program and sponsored class.

Grants BI end-user

GM Line Item Display Line item report showing all expense in the GM ledger. Grants S_PLN_16000269 ECC/BI end-userGM Overall Expenses Compared to Budget & Percent

Report to display budget, expense and billed amounts by grant, sponsored program and sponsored class.

Grants BI end-user

1 of 2

Page 2: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

BUDGET SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERGrant Sponsors Master Data Report Report to display sponsor data for selected grant(s). Grants S_ALN_01000161 ECC/BI end-userGrants Master Data Report Report to display master data for selected grant(s). Grants S_ALN_01000079 ECC/BI end-userSponsored Classes Master Data Report Report to display sponsored class data for selected

grant(s).Grants S_ALN_01000160 ECC/BI end-user

Sponsored Programs Master Data Report Report to display sponsored program data for selected grant(s).

Grants S_ALN_01000159 ECC/BI end-user

LBR 231-1: Main Job Standard Salary Main job standard salary and fringe benefit information. Labor Z2311 ECC super-user

LBR 231-2 Other actual salary payroll postings by account coding. Labor N/A ECC N/A - Run monthly and

placed in Optispool

LBR 231-2 Grants Actual primary and other salary and fringe benefit payroll posting by account coding.

Labor N/A ECC N/A - Run monthly and

placed in Optispool

LBR 231-3 Main job actual salary and standard fringe benefit information.

Labor BI end-user

LBR 232-1 Full-time equivalent positions by cost center and job with employee detail.

Labor BI super-user

LBR 232-2 Full-time equivalent positions by job and cost center with no employee detail.

Labor BI super-user

LBR 232-4 Full-time equivalent positions by cost center, functional area and job with employee detail.

Labor BI super-user

LBR 232-5 Full-time equivalent positions by functional area, job and cost center with no employee detail.

Labor BI super-user

LBR 232-6 Full-time equivalent positions by job, functional area and cost center with no employee detail.

Labor BI super-user

One Time Payment Report Summary of one time payments for each location. Labor BI end-userPersonnel Cost Planning Actual (PCP Actual)

Annualized report of filled and vacant primary positions with cost distribution and actual salary and standard fringe benefit information.

Labor BI super-user

Personnel Cost Planning Standard (PCP Standard)

Annualized report of filled and vacant primary positions with cost distribution and standard salary and fringe benefit information.

Labor BI super-user

Supplement Report Summary of supplements at each location by periodic and annual amounts.

Labor ZHPY_SUPPLMNT_REPORT ECC end-user

Unfilled Positions Vacant primary positions with cost distribution and standard salary and fringe benefit information.

Labor ZHBI_SAL ECC end-user

2 of 2

Page 3: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

FINANCE SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USER1099 Listing Listing of 1099 activity by vendor, calendar year, and

amount. Totals in in detail and summary. Vendor must be flagged as 1099 vendor to appear on report.

Accounts Payable

ECC: S_ALR_87012143BI: Finance - RR

ECC/BI super-user

1099 Miscellaneous Listing of 1099 activity by vendor, calendar year, and amount. Totals in summary. Vendor must be flagged as 1099 vendor to appear on report.

Accounts Payable

S_PLO_09000314 ECC super-user

Address List Display a report of vendor addresses. Accounts Payable

ECC: S_ALR_87012087BI: Finance - ER

ECC/BI super-user

Check Register Generate a check register using a range of check numbers.

Accounts Payable

ECC: S_P99_41000101BI: Finance - SR

ECC/BI super-user

Display Changes Display changes made to a document Accounts Payable

Finance - SR BI super-user

Display Payment Document Checks Generate a list of AP Pmt Documents Accounts Payable

Finance - SR BI super-user

Display Recurring Entry Changes Display a Recurring Document in AP/GL. Accounts Payable

Finance - ER BI super-user

Display Vendor Line Item Display Vendor Line Item Accounts Payable

ECC: FBL1NBI: Finance SR

ECC/BI super-user

Due Data Analysis for Open Items Generate a report to obtain an analysis of due dates of open items for a vendor.

Accounts Payable

S_ALR_87012078 ECC super-user

Enhanced AP Detailed Documents List Display all documents entered and/or posted by a specific User ID. Used by AP Specialist to balance daily.

Accounts Payable

ZFAP_APDOCLIST ECC super-user

Extract Movable Equipment Report (Capital Assets - ACT021/FNC2640C)

Generate a report of capital asset activity (new purchases, returns, etc.) by date range and/or GL account.

Accounts Payable

Finance - ER BI super-user

List of Vendor Line Items Generate a report of vendor activity (payments, credits, reversals).

Accounts Payable

ECC: S_ALR_87012103BI: Finance SR

ECC/BI both

List Recurring Entries Display Recurring Entry Documents for AP and GL. This list can be sorted by document type and date range.

Accounts Payable

Finance - ER BI super-user

Open Items - Vendor Due Date Forecast Displays vendor balances in USD. Displays open items and turnaround - 7 days, 30 days, and over 30 days

Accounts Payable

ECC: S_ALR_87012084BI: Finance - ER

ECC/BI super-user

Payment List Generate a list of payments from a previous payment run. Requires run date and identification.

Accounts Payable

ECC: S_P99_41000099BI: Finance - SR

ECC/BI super-user

Reconciliation Report (No Retainage) AP activity report that is used to reconcile AP to the monthly trial balance (does not include retainage).

Accounts Payable

Finance - SR BI super-user

Reconciliation Report (Retainage Only) AP activity report that is used to reconcile retainage to the monthly trial balance special ledger.

Accounts Payable

Finance - SR BI super-user

1 of 5

Page 4: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

FINANCE SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERTransaction Figures: Account Balances Generate a report for vendor account balances Accounts

PayableECC: S_ALR_87012079BI: Finance - ER

ECC/BI super-user

Vendor Balance Display The vendor business report displays vendor balances which include the prior year carry forward, [and ac]cumulated debits and credits by fiscal year.

Accounts Payable

Finance - SR BI super-user

Vendor Balances in Local Currency Display vendor balances in USD. Can be used for normal balances and/or special ledger (Retainage). Displays Carry forward, Debit and Credit balances. By period, range of periods or fiscal year.

Accounts Payable

S_ALR_87012082 ECC super-user

Vendor Business Display accumulated totals for one or more vendors. Accounts Payable

ECC: S_ALR_87012093BI: Finance - SR

ECC/BI super-user

Vendor Line Items Generate a report of vendor activity (payments, credits, reversals)

Accounts Payable

Finance - SR BI super-user

Vendor List Generate a list of vendor master data. Enter one or more vendor numbers.

Accounts Payable

ECC: S_ALR_87012086BI: Finance - ER

ECC/BI super-user

Vendor Payment History- Appraisal of open items

Display the history of vendor payments. Includes turnaround of open commitments, and annual sales.

Accounts Payable

ECC: S_ALR_87012085BI: Finance - ER

ECC/BI super-user

Activity Types: Plan Data Display To display a list of Activity Types Finance ECC: KP27BI: Finance - ER - Controlling

ECC/BI super-user

Cost Centers: Master Data Report (Collective)

This report is to display expenditures that have been reclassified between different cost centers.

Finance ECC: KS13BI: Finance - ER - Controlling

ECC/BI super-user

Display Activity Types This report is to display Activity Types Finance KL13 ECC super-userDisplay changes to GL Accounts Displays a change history for a specific GL account Finance FB04 ECC super-userDisplay Document Display document Finance FB03 ECC end-userDisplay Line Cost Line Items for Cost Centers

This report is to display of actual expenses and revenues on cost center(s)

Finance KSB1 ECC end-user

Display Line Cost Line Items for Orders This report is to display of actual expenses and revenues on internal orders(s)

Finance KOB1 ECC end-user

Display Parked Document Display parked document Finance FBV3 ECC end-userDisplay reposting of CO Line Items This report is to display reclassified expenditures Finance ECC: KB63

BI: Finance - SR - ControllingECC/BI end-user

GL Account Balance Display The report displays the balance of the GL accounts, by period.

Finance FAGLB03 ECC end-user

2 of 5

Page 5: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

FINANCE SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERGL Account Line Item Display The report displays a list of the line items of the GL

accounts. This report could have long run-times depending on the criteria selected. If a complex selection criteria is required, consider using FAGLB03 and drilling down to the line items or using KSB1 (CO-Cost Centers), KOB1 (CO-Orders), FMRP_RFFMEP1AX (FM), or S_PLN_16000269 (Grants) depending on the type of information required.

Finance FAGLL03 ECC end-user

GL Accounts List Displays a list of all accounts in the chart of accounts Finance S_ALR_87012333 ECC end-userGL Balance GL Balance Finance S_ALR_87012277 ECC end-userGL Line Items List for Printing The report displays a list of the line items of the GL

accounts. This is, essentially, a BI version of the FAGLL03.

Finance Finance - SR BI end-user

Internal Orders: Master Data List To display a list of Internal Orders Finance ECC: KAK3BI: Finance - SR - Controlling

ECC/BI super-user

Purchase Orders By FUND (Summary) This report displays a list of Purchase Orders, by Fund, with the outstanding balances. Note: FM report FMRP_RFFMEP1AX, using value-type 51, will provide line item detail for all activity on a PO which will total the outstanding balance of the PO.

Finance Finance - RR BI super-user

SKF: Collective Display To display a list of Statistical Key Figures Finance ECC: KOK5BI: Finance - SR - Controlling

ECC/BI super-user

Trial Balance Displays the trial balance, by fund. Note: the Interim Financial Statements are also generated in this report. Care must be taken to select the "Trial Balance-SBBC" when running this report. The others are still in development and should not be used.

Finance Finance - ER BI super-user

180 Day Program - Food Service Stats Report

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

180 Day Program YTD Breakfast Averages

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

180 Day Program YTD Lunch Averages Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Breakfast & Lunch per Labor Hour Food Service report Food Service BI: Finance - SR - Controlling BI super-userBreakfast & Lunch per Labor Hour by Group

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Breakfast Participation Report (Monthly) Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Breakfast Reimbursement Rate Report (Monthly)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

3 of 5

Page 6: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

FINANCE SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERBreakfast Reimbursement Report (Monthly) Economically Needy

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Breakfast Reimbursement Report (Monthly) Regular Centers

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

CO-Analysis of 411S Accounts Food Service report Food Service BI: Finance - ER - Controlling BI super-userCommodity Average by School Food Service report Food Service BI: Finance - ER - Controlling BI super-userDaily Breakfast (Severely Needy) Reimbursement Report

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Daily Breakfast Reimbursement Report Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Daily Lunch Reimbursement Transaction Report

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Daily Snack Reimbursement, Revenue Expense Report

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Food Service Accounts Receivable Report

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

FS Financial Analysis by Area Food Service report Food Service BI: Finance - ER - Controlling BI super-userIncome per Labor Hour Food Service report Food Service BI: Finance - SR - Controlling BI super-userIncome per Labor Hour by Group Food Service report Food Service BI: Finance - SR - Controlling BI super-userIndirect Cost Analysis by Area Food Service report Food Service BI: Finance - ER - Controlling BI super-userIndirect Cost Analysis by Area (Schools only - BASE & SATELITE)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Lunch & A La Carte Meals Participation by Group

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Lunch & A La Carte per Labor Hour Food Service report Food Service BI: Finance - SR - Controlling BI super-userLunch Participation Report (Monthly) Food Service report Food Service BI: Finance - ER - Controlling BI super-userLunch per Labor Hour Food Service report Food Service BI: Finance - SR - Controlling BI super-userLunch per Labor Hour by Group Food Service report Food Service BI: Finance - SR - Controlling BI super-userLunch Reimbursement Rate Report (Monthly)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Meals per Labor Hour (Lunch + Breakfast + Snacks)

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Meals per Labor Hour (Lunch + Breakfast + Snacks) by Group

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

Monthly Breakfast Averages Food Service report Food Service BI: Finance - ER - Controlling BI super-userMonthly Lunch Averages Food Service report Food Service BI: Finance - ER - Controlling BI super-userPlate Food Report (Purchased & commodity)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Profit & Loss Report Food Service report Food Service BI: Finance - ER - Controlling BI super-userPurchased Food Average by School Food Service report Food Service BI: Finance - ER - Controlling BI super-user

4 of 5

Page 7: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

FINANCE SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERSchool Commodities Average by Base Sat.

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

School Purchased Food Average by Base Sat.

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Snack Expense Participation Report (Monthly)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Snack Reimbursement & Expenses Rate Report (Monthly)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Snack Reimbursement Participation Rate Report (Monthly)

Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Snack Reimbursement Report (Monthly) Food Service report Food Service BI: Finance - ER - Controlling BI super-user

Special Revenues and Expense by Month

Food Service report Food Service BI: Finance - SR - Controlling BI super-user

AP Detailed Invoice Aging Report (Project Systems)

AP statistics report used by Capital/Facilities department to track the moving and pmt turnaround for construction invoices.

Project Systems

Finance - SR BI super-user

Cash Position / Liquidity Forecast Report Cash Position / Liquidity Forecast Report Treasury ECC: FF7ABI: Finance - ER

ECC/BI super-user

Cops Reimbursement Report COPS Reimbursement Treasury Finance - ER BI super-userDisplay Cash Journal Display Cash Journal Treasury ECC: FBCJ

BI: Finance - SRECC/BI super-user

Display Electronic Bank Statement Display Electronic Bank Statement Treasury ECC: FF_6BI: Finance - ER

ECC/BI super-user

Interest Allocation Interest Allocation Treasury Finance - ER BI super-user

5 of 5

Page 8: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

LEARNING SOLUTIONS (LSO) SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERAdministrative Inservice Report Shows any individual's inservice record. Option to enter a

pernr.LSO ZHTE_INSERVICERECORD ECC both

Appraisal Report Summary report of all appraisals completed for a specific course

LSO Reporting function through LSO_EVAL_SEARCH

ECC both

Bookings per Course Number # of bookings per course under a course type/group.

LSO BI both

Capacity Levels Report for Course Events

Shows the capacity levels of each course under a course type, minimum, optimum and max numbers.

LSO ZHTE_CAPACITY ECC both

Comprehensive Inservice Report Shows inservice records for various selection areas such as individual, org units or personnel areas.

LSO BI both

Course Bookings w/emails Displays all the participants in a specific course along with their email addresses.

LSO BI both

Course Brochure Shows the course description, dates, locations, and objectives of the course type.

LSO LSO_RHXKBRO0 ECC both

Course Cancellations Course cancellations by course organizer and cancellation reason.

LSO BI both

Course Capacity Overview Shows the capacity levels of each course under a course type, minimum, optimum and max numbers.

LSO BI both

Course Dates Shows a list of the courses under a course type and their location and schedule.

LSO LSO_RHXKBRO1 ECC both

Course Demand - Not used Report displays the demand that exists for courses of a given type and may be used to determine demand for a planning year, or for individual quarters of a year; can also display details of whether the demand is covered or not by the number of courses scheduled.

LSO LSO_RHXKBED0 ECC both

Course Hierarchy - Not used This report displays the hierarchy of a course with course dates, delivery method, and participants.

LSO LSO_RHXCGRP0 ECC both

Course Prices Shows a list of the courses under a course type with location, delivery method, and internal and external prices.

LSO BI both

Course Schedule A list of the course schedule, days and times. LSO LSO_RHABLAUF_OLD ECC bothInservice Report (ESS) Shows an individual's inservice record. No option to enter

a pernr.LSO ZHTE_INSERVICERECORD - portal ECC end-user

Open Course Report (ZOBE) Shows all the courses which are not followed up but the end date has passed.

LSO BI both

Participant Bookings and Cancellations Shows and individual's history of bookings and cancellations and the corresponding courses.

LSO BI both

Participant List A list of the course participants with course dates, booking dates and follow-up information. This report can also generate an attendance list with signature lines.

LSO LSO_RHXTEILN ECC both

1 of 2

Page 9: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

LEARNING SOLUTIONS (LSO) SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERParticipant Registration History A list of the participant's training history containing all

courses attended or booked by a participant including dates, hours, cancellation date and reason, delivery method, location and follow-up information. NOTE: not to be interpreted as an inservice report, this only shows registrations.

LSO BI both

Participants for Rebooking - Not used This reports lists participants who did not receive a place on the course when it was firmly booked or canceled. These participants are on the waiting list of the course.

LSO LSO_RHXUMBU0 ECC both

Participants Qualifications A list of qualifications per booked participant.A report of participant's qualifications and proficiency.

LSO BI both

Participation and Cancellations Shows and individual's history of bookings and cancellations and the corresponding courses. Layout may contain cancellation date, reason, and course information.

LSO BI both

Participation Prerequisites Shows the prerequisites required for the course. LSO LSO_RHXKVOR0 ECC bothPrebookings per Participant Shows a list of courses the participant prebooked for and

the corresponding time periods along with the course location and type as well as prebooking date.

LSO LSO_RHXVORM1 ECC both

Prerequisites Matchup Shows each participant and whether they met the course prerequisites or not.

LSO LSO_RHXQANF0 ECC both

Specific Course Completion Report Shows all the individuals who have inservice records for a particular course, course type, course group.

LSO BI both

2 of 2

Page 10: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

ORGANIZATIONAL MANAGEMENT (OM)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERAccount Gaps and 1018 Standard Cost Report

Report used to show gaps in coding. Org Data ZHOM_GAPS ECC super-user

Food Service Location Totals Monthly Report

Report used by FSN containing the personnel numbers, employment date, bargaining unit date, position, position description and the organizational unit information of Food Service Managers and Workers.

Org Data BI both

Job Class Report This report provides an overview of all existing jobs. The list contains jobs, with information on Validity period, Object ID#, Exempt Status, Name.

Org Data BI both

Location Labels Produces labels for locations. Used for mail outs. Org Data ZHOM_ADDRESS ECC both

Location Totals and Roster A general report of employee count at an organizational unit.

Org Data BI super-user

Overstaffed Position Report Report to show overstaffed positions useful in determining those positions that have temporary overstaffing relationships. Report may be run b job class or position number.

Org Data ZHOM_OVRSTAFFED ECC both

Position Attributes Shows attributes of a position excluding cost information.

Org Data ZHOM_PA ECC super-user

Position Holder Information Shows past and present holders of a position through 12/31/9999. Always should be run prior to delimiting a position.

Org Data ZHOM_POSHOLDER ECC both

Staffing Report Report that an org unit runs to show their positions, the holders of positions, and the cost distribution line. Includes position percentage and the work schedule. Selection allows to run for unfilled, primary and/or substitutes/temporary.

Org Data ZHOM_STF ECC or BI both

Substitute and Temporary Custodian Report

Report of a locations substitute and temporary custodian/maintenance employees.

Org Data BI both

Vacant Positions Report used to view vacant positions. Selection can be specific to Title I schools, differentiated schools, etc.

Org Data BI super-user

1 of 1

Page 11: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PERSONNEL ADMINISTRATION (PA)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER

Basic Pay Wage Edit -Check Indirect Evaluation Indicator

Produces report to show employees without a indirect evaluation indicator on basic pay IT0008

Employee Data ZSALEDIT ECC super-user

Board Agenda Report & Board Agenda Download

The Staffing departments use to create the board agenda reports (i.e. resignations, supplements, new hires, etc.).

Employee Data ZHPA_BOARDAGENDAZPHA_BRDDWNLD

ECC super-user

Broward Certificate Printing Report

Used by Certification and Sub Central to produce certificates for substitute teachers and temporary hourly teachers.

Employee Data ZHTE_ZCER ECC super-user

Broward Teacher Union Download Data download given to the BTU of employees in the instructional bargaining unit.

Employee Data ZHPA_UNION ECC super-user

Certification and License Report Report showing instructional employees certificates and validity dates.

Employee Data BI both

Contact Information Report shows contact information (address and phone number) Report of employees and their emergency contact information.

Employee Data BI both

Contract Report Produces a report of teacher contracts; i.e, professional, annual, addendum

Employee Data ZHPA_CONTRACT ECC super-user

Corporate Functions Report showing employees corporate functions that are stored on IT 34. (i.e. Payroll Processor, Inservice Facilitator, TLC, etc.) Note: Corporate functions must be entered and maintained each location.

Employee Data BI both

Diversity Reporting Download Not currently active

Report showing ethnicity and sex breakdowns and pay scale, pay groups, actions, work schedule rule, employee group, employee group, employee sub group, org assignment.

Employee Data BI super-user

Education and Training This report creates a list describing the education and training of employees: education establishment, confer date, degrees obtained (high school, bachelors, doctorate, etc.); majors.

Employee Data BI both

EEO Ethnicity and Gender Statistics

Displays EEO category, breaks down the number of employees and ethnicity percentages.

Employee Data BI super-user

Employee Counts on a Specific Date

Count of permanent and nonpermanent employee and gender statistics.

Employee Data BI super-user

Employee history report Displays employees, entry date, annual salary, org unit, PA, EG, ESG, Job, Position, Pay Scale Type, pay Group, pay level, pay type, pay grade and pay level.

Employee Data BI super-user

1 of 4

Page 12: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PERSONNEL ADMINISTRATION (PA)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER

Employee List Displays a numerical list of employees assigned to an org unit that includes employment date and position.

Employee Data BI both

Employee Monitoring Produces employees' bargaining unit dates and task dates, such as, leave return and probationary dates. Also, shows paraprofessionals' highly qualified status.

Employee Data BI both

Employees Entered and Left Company

Summary report of employees who have been hired, rehired, retired, terminated, and resigned can run for a specific org unit or district wide.

Employee Data BI both

Employees with Different Action on Same Date

Produces a report of employees with different actions on the same date

Employee Data ZHPA_MULTIPLE_ACTION ECC super-user

Entitlements ReportNot currently active

Shows entitlements (i.e. advanced degrees, course work FNS, shift differential) the employee is receiving. Data is based on infotype 8. Does not include information from 14 (supplements).

Employee Data BI both

Experience Years Audit report used by HR department to validate teacher's, administrators and FNS years of experience in/outside district, and/or public/nonpublic.

Employee Data BI both

Fingerprint Report Report used by the Security Department to review employees fingerprint status and results.

Employee Data BI super-user

Flexible Employee Data Report displays employee data in a flexible manner. This report contains up to twenty (20) fields for displaying employee data. This means that you can choose to display personal or organizational data. (for ex. employment date, birthday, position, and org unit).

Employee Data S_AHR_61016362 BI/ECC both

Highly Qualified Report Report showing a schools teachers, their course assignments, and the highly qualified status for each course.

Employee Data BI both

HR - Calculate Contract Amount Personnel Records uses to verify employment and salary amount; HRIS uses to calculate contract amounts; Used to determine the contract amount to be printed on the instructional and administrator contracts.

Employee Data ZHPA_ZCALC ECC super-user

Incentive This report creates a list describing the advanced degree incentive an employee receives and their education/training for a specified time period.Data is based on infotype 8. Does not include information from 14 (supplements).

Employee Data BI both

2 of 4

Page 13: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PERSONNEL ADMINISTRATION (PA)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER

Inventory Report (in testing) Report of items that employees have been given. Data must be entered and maintained by the location on IT 40. Also, produces property pass and sends an email to the employee notifying that the items have been assigned to them.

Employee Data ZHPA_PA0040_REPORT ECC both

Job Entry Info Report Location enters in a job class (Job ID Number) and it will show all the positions with that job class. Shows some date attributes i.e. BUD.

Employee Data BI super-user

Leave Reports (Leaves Dept) Report that shows employees on leave, their status and return dates.

Employee Data BI super-user

Leave Reports for Workers Compensation

Report showing employees on workers comp and their status.

Employee Data ZHPR_WORKCOMP, ZHPR_WORKCOMP_PR ECC super-user

Missing Bargaining Units Audit report used by the staffing departments and HRIS to verify all employees have a bargaining unit date.

Employee Data BI super-user

Name Change Report used by the HR departments to review name changes.

Employee Data BI super-user

One Time Payment Shows one time payments (ex: workshop stipends, A+ Recognition, etc.) for one employee or an entire organizational unit.

Employee Data BI both

Out-of-Field Report Report showing locations out-of-field teachers. Employee Data BI bothPersonnel Actions Report Report for locations to use to track HR actions and

review the status of the actions. Also, indicates who has the item. (Former ZPAF report).

Employee Data ZHPA_ACTION_STAT ECC both

Re-Appointment Letters This outputs a flat file of reappointment info that is used to produce the reappointment letters for teachers and administrators.

Employee Data ZHPA_RE_LETTERS ECC super-user

Re-Appointment Status Report Summary of employees reappointment action. Employee Data ZHPA_RER ECC super-userResidence Status Report Produces a report of citizens, noncitizens and non-

resident aliens which includes expiration date if applicable based on information on IT0094

Employee Data BI super-user

Schools in Need of Improvement (SINI)

Report used to summarize a locations teachers and their HQ status, experience years… Instructional Staffing uses to meet the DOE reporting requirement.

Employee Data BI both

Substitute and Temporary Custodians

Produces a report to show substitute and temporary facility serviceperson, temporary custodian, and sub/temp maintenance.

Employee Data BI super-user

Substitute, Temporary, and Additional Positions of Personnel

Audit report displays employee's primary org. as well as who have an additional assignment (IT554), rate of pay, and validity period.

Employee Data BI both

3 of 4

Page 14: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PERSONNEL ADMINISTRATION (PA)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER

Supplement Shows supplements (ex: academic, athletic and nonspecific payments) for one employee or an entire organizational unit.

Employee Data ZPYR_SUPPLMT_RPRT_ACCNT_LOC ECC both

Union Report of Employee Changes

This report creates a list of personnel actions that have been carried out for employees for the selected time period.

Employee Data BI super-user

4 of 4

Page 15: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PROFESSIONAL DEVELOPMENT (PD)SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI END-USER/ SUPER-USER

Appraisal Criterion Report View informaion entered on a PGP or Apprial Professional Development

BI both

Appraisal Report-PGP Status Give a view of the PGP or Appraisal by template Professional Development

BI both

Appraisal Template Catalog view of Template Catalog Professional Development

SAPLHRHAP_C_UI_CATALOG ECC

Development Plan Report Various selections available to access reports based on data on the IDP

Professional Development

ZRHPD_DEV_PLAN_STATUS ECC super-user

Display Qualifications Display Qualification Catalog Professional Development

PPQD ECC

Expired Qualifications Shows people with expired qualification Professional Development

BI super-user

Find objects for a development plan Displays catalog of available development models Professional Development

PPDPSPFP ECC super-user

Find objects for development plan item Displays the employees who have selected a certain course

Professional Development

PPDPSPFS ECC super-user

Qualifications Overview Displays employees qualifications Professional Development

BI super-user

1 of 1

Page 16: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PAYROLL SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERCheck Completeness of Posting Displays a list of all personnel numbers whose payroll

results have not yet been posted. Also lists all employees who have been rejected from the posting.

Payroll PC00_M99_CIPC ECC super-user

Display Payroll Results Displays the Payroll Results H99_DISPLAY_PAYRESULT with the contents of all tables and field strings for any payroll cluster.

Payroll PC00_M10_CLSTR ECC SAP Support Access Only

Display Savings Bonds Purchases Displays Savings Bonds purchases as interpreted from payroll records at the end-of-period date. Payroll results reflect periodic payroll deductions accumulated as well as the bonds purchased. The bond owners are also displayed.

Payroll P0000_M10_SVB_PBS ECC super-user

Employees who are Medicare Providers Creates Medicaid Roster file: displays employees who are in positions where they provide Medicare services as defined by job classes. This program reads an input file of job classes and chooses all employees in positions with any job classes on the file in a particular quarter. Primary and 554 positions are checked as well as any specified wage types.

Payroll ZHPY_MEDICARE ECC super-user

Exemption Expiration Report Displays which employees' tax exemptions, entered in Infotype 0210 W-4 Withholding Info., are due to expire soon.

Payroll S_PH9_46000360 ECC super-user

Garnishment Statements (Garnishment Statistics)

Displays garnishment statistics, including number of employees and their garnishments as well as other details on the employees.

Payroll PC00_M10_CPL3U0 ECC super-user

Garnishment Statistics Displays garnishment statistics, including number of employees and their garnishments as well as other details on the employees.

Payroll P000_M10_GSTA ECC super-user

Garnishment Vendor Report(only available in BI)

Displays garnishment vendors and their contact information.

Payroll n/a BI super-user

Gross and Net Earnings Report (ZEARNINGS)

Displays gross and net earnings for employees within your organizational unit for a specified pay period.

Payroll Old: ZEARNINGSNew: ZHPY_PAY59

ECC both

Location Totals and Roster Provides counts of employees by location. Payroll ZLOCNCOUNTS ECC super-userMedicaid Quarterly Process Posted salary & fringe benefit dollars report. Reads in

the roster file (above) and retrieves the dollars posted to the Medicaid specified class for Fund 100. Run setup is for a single month at a time. Produces an output flat file.

Payroll ZHPY_MEDICAID ECC super-user

1 of 5

Page 17: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PAYROLL SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERMedicaid True-up True-up report for Medicaid dollars. This program

sums up all of the monthly ZPBFMEDICAID dollars into a single report. The fringe benefit percentages can be adjusted here if needed to produce a final 'true-up' report.

Payroll ZHPY_ZMEDITRUE ECC super-user

New Hire Report(New Hire Compliance Report)

Generates a list containing the following federally mandated information on newly hired employees: Employer name, address, and identification number (EIN), Employee name, address, and Social Security Number, as well as additional information, such as employee date of birth, date of hire, and employer state unemployment insurance number, depending on each state's requirement.

Payroll P000_M10_NHR ECC both

OC: List of Replacements/Reversals Reads and displays the contents of table T52OCL - Checks Replaced or Reversed.

Payroll PUOCLL ECC super-user

OC-Batch: Batch Table List Reads and displays the contents of the table T52OCG (Off-Cycle: Flags for Batch: Payroll, Subsequent Program) . The table T52OCG contains all data on the results of off-cycle payroll runs, payment replacements and reversals that you have carried.

Payroll PUOCLG ECC super-user

Off-Cycle Workbench USA The Off-Cycle Workbench is a special user interface in the SAP System for various off-cycle operations. Included is the ability to view individual employee's paychecks.

Payroll PUOC_10 ECC both

Overtime Report Displays overtime paid to District employees for a specified period.

Payroll ZHTM_OVERTIME_REP ECC both

Overtime Report (Month View) (only available in BI)

Displays overtime paid to District employees by month.

Payroll n/a BI super-user

Payroll Journal Generates the payroll journal using existing payroll results as a base. The payroll results are displayed using the in-period view; in other words, retroactive accounting runs are printed together with the results of the payroll run during which the retroactive run took place.

Payroll PC00_M10_CLJN ECC super-user

2 of 5

Page 18: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PAYROLL SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERPayroll Reconciliation Report Generates a report used to reconcile payroll results

from a specified time interval both with Tax Reporter results and, to a lesser extent, with the amounts posted to the Financials (FI) application component. The output of this report can be used to cross-check the accuracy of the results produced by these reporting programs.

Payroll PC00_M10_REC ECC super-user

Remuneration Statement Displays total earnings, pre-tax deductions, taxes, post-tax deductions, for individual employees identical in content to the paystub, minus the Leave Summary information.

Payroll PC00_M10_CEDT ECC both

Thirteen Week Salary Report (Risk Management)

Displays employee's earnings going back 13 weeks prior to a specific date entered (usually the date of an accident).

Payroll ZHPY_Z13WK ECC super-user

W-4 Withholding Allowance Report Generates a report of employees who have claimed more allowances than allowed by a tax authority. Employees are identified by comparing data on Infotype 0210 (W-4 Withholding Information records) to limits provided by the Tax Authorities.

Payroll S_PH9_46000361 ECC super-user

Wage Type Reporter Displays any or all wage types (supplements, attendance and one-time payments) for employees at the primary org unit, which have been paid during a specified period.

Payroll PC00_M99_CWTR ECC both

Wage Type Reporter (Month View)(only available in BI)

Displays any or all wage types (supplements, attendance and one-time payments) for employees at the primary org unit, which have been paid during a specified period, reported on a monthly basis.

Payroll n/a BI both

Wage Type Statement Displays lists of wage type distributions based on the payroll data for the employee(s) selected.

Payroll PC00_M99_CLGA00 ECC both

Wage Type Statement Displays lists of wage type distributions based on the payroll data for the employee(s) selected.

Payroll PC00_M99_CLGA09 ECC super-user

Wage Type Statement (Month View)(only available in BI)

Displays lists of wage type distributions by month based on the payroll data for the employee(s) selected..

Payroll n/a BI both

Worker Compensation Category(Risk Management)

Provides report with Workers Compensation Category, Job Class, Job Title, Gross Salary and Overtime Rate information (if applicable) for selected employees.

Payroll ZHPR_COMPENSATION ECC super-user

3 of 5

Page 19: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PAYROLL SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERAbsence List(Attendance/Absence Data: Calendar View)

Displays summary of absences/attendances for an employee for a specified period.

Time PT64 ECC both

Absence Overview Displays absences entered for employees within a specified time period.

Time Z_ABS ECC both

Ad Hoc Query A non-standard inquiry. An ad hoc query is created to obtain information as the need arises and displays information specific to that need.

Time PQAH ECC super-user

Attendance List Creates a list of all employees who are at work, absent with a reason, absent without a reason, or late at a specific time. The list shows which employees are absent at the time of the evaluation. Can also display employees who should be at work according to their personal work schedule, but are not at work.

Time PT62 ECC super-user

Attendance Overview Displays attendances entered for employees within a specified time period.

Time Z_ATT ECC both

Attendance/Absence Data: Calendar View

Displays attendances and absences for each employee. In addition, it can be used to output statistics and provide a legend for each employee.

Time S_AHR_61018659 ECC SAP Support Access Only

Cumulated Time Evaluation Results Creates a list of the day balances, cumulated balances (period balances), or time wage types that were determined by time evaluation.

Time PT_BAL00 ECC super-user

Deleted Absence Records/Retroactive Time Report (Retroactive Time Data Changes)

Displays absence and/or attendance data that was changed after payroll was processed.

Time ZHTM_TIMEDATA_CHNG ECC both

Display Absence Quota Information Displays absence quota information for individual employees or an entire Organizational Unit for a specified period.

Time PT_QTA10 ECC both

Display Cluster B2 Displays the current content of the Time (B2) cluster for each employee.

Time PT66 ECC SAP Support Access Only

Display Time Sheet Data Displays hours in “real time” that have been entered and saved to an employee’s record. This report displays data entered through CAT2 as well as data interfaced from COMPASS and KRONOS.

Time CADO ECC both

Employees Eligible for Sick Leave Buyback

Identifies employees who are eligible to participate in the annual Sick Leave Buy Back program.

Time ZHTM_ABSB ECC SAP Support Access Only

4 of 5

Page 20: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

PAYROLL SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERGraphical Attendance/Absence Overview Displays attendances and absences for each

employee. In addition, it can be used to output statistics and provide a legend for each employee.

Time PT65 ECC both

SAP Query: Maintain queries SAP Query is a program generator, with which SAP provides users access to data without requiring knowledge of ABAP for devising a report. The user must only know in which table the desired data can be located.

Time SQ01 ECC super-user

Show Work Schedules Displays the work schedules for employees for a specified period of time.

Time ZHTM_SCHED ECC both

Time Evaluation Evaluates employee time data. Time balances and wage types are formed in RPTIME00's rule processing.

Time PT60 ECC super-user

Time Evaluation Messages Display Creates a list of messages that were generated during time evaluation.

Time PT_ERL00 ECC super-user

Time Evaluation Messages Display Creates a list of messages that were generated during time evaluation.

Time S_PH9_46000588 ECC both

Time Management Info System Provides access to information on work schedules, attendances, absences, and time balances for one or multiple employees.

Time PT70 ECC SAP Support Access Only

Time Management Report (ZTIM) Displays hours worked for employees within your organizational unit. This report can be run by pay period or other specified periods of time.

Time ZTIM ECC both

Time Statement Displays an overview of the results determined by time evaluation. For example, an overview of time balances and time wage types for each employee.

Time PT61 ECC both

Tool Selection for Time Management(Personal Work Schedule)

Displays an overview for one or multiple employees for each day in any given period, which includes all essential planned specifications concerning the working time of an employee.

Time PT71 ECC SAP Support Access Only

5 of 5

Page 21: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

BENEFITS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERBenefit Election Analysis (in BI = Benefits Election Enrollment Analysis)

Displays percentage changes in plan participation and eligibility for plans between two given dates.

Benefits HRBEN0087 ECC super-user

Benefit Flex Data(only available in BI)

Displays various information from employee data. Report is able to display employee data along with Benefits data in one place; searchable by birthdate and age.

Benefits n/a BI super-user

Benefit Plan Census(only available in BI)

Displays a count of personnel enrolled in each plan for a given Bargaining Unit; can be selected from an available variant.

Benefits n/a BI super-user

Benefits Election Enrollment Analysis(in ECC = Benefit Election Analysis)

Displays changes in plan participation and eligibility for plans between two given dates.

Benefits HRBEN0087 BI super-user

Benefits Plan Overview Displays the employees who are participating in specified benefit plans on a given date or during a certain period of time.

Benefits HRBEN0009 ECC super-user

Calculation of Length of Service Calculates the employees' employment period. Benefits HRBEN00RETSRV ECC super-userChange in General Benefits Detects deviations from system-allocated default values in

an employee's General Benefits Information infotype (0171).

Benefits HRBEN0083 ECC super-user

Changes in Benefits Elections Displays the changes made to benefit plan infotype records on a given date or during a certain period in time. These changes include new enrollment, termination in enrollment, or changes in the employee elections for a plan.

Benefits HRBEN0077 ECC super-user

Changes in Eligibility Displays employees who are no longer eligible for the plans in which they are participating.

Benefits HRBEN0079 ECC super-user

Contribution Limit Check Detects employee contributions (stored on the plan infotype as an amount, percentage of salary, or as units) that are not within the limits on a key date.

Benefits HRBEN0088 ECC super-user

Discrimination Testing Report(FSA Discrimination Report)

Displays statistics (employee data) on employees participating in FSA plans.

Benefits ZHBE_FSA_DISC ECC super-user

Eligible Employees Displays the employees who are eligible for specified benefit plans on a given date.

Benefits HRBEN0071 ECCBI

super-user

Enrollment Report(only available in BI)

Displays the number of employees enrolled in each plan at any time.

Benefits n/a BI super-user

Enrollment Statistics Displays counts of employee enrollment made on each day for a specific date or date range.

Benefits HRBEN0089 ECCBI

super-user

FRS Saving Plan Report(FRS Monthly Report)

Displays FRS contribution dollars by participating employee on a monthly basis.

Benefits ZHBN_FRSTRANSAC ECC super-user

FSA Contributions Displays the employee contributions for specified FSA plans per pay period.

Benefits HRBEN0078 ECC super-user

1 of 2

Page 22: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

BENEFITS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERFSA Contributions(only available by month in BI;in ECC = FSA Contributions by pay period)

Displays the employee contributions for specified FSA plans by month.

Benefits HRBEN0078 BI super-user

Health Plan Costs(in BI = Plan Costs)

Displays the employee and employer cost for specified health plans.

Benefits HRBEN0073 ECC super-user

Insurance Interface Benefits ZHPY_INSURANCE ECC super-userInsurance Plan Costs (in BI = Plan Costs)

Displays the employee, employer, and provider costs for a specified insurance plan on a given date.

Benefits HRBEN0074 ECC super-user

IRS/SSA/CMS Data Match Electronic Media Questionaire (Medicare Match Report)

IRS/SSA/CMS Data Match Electronic Media Questionaire. Benefits ZHHR_MEDICARE_M ECC super-user

Leave Report(Sick & Vacation Balance Report)

Displays quota balances by employee. Benefits ZRHPA_LEAVE ECC super-user

Length of Service/Age In Years(only available in BI)

Displays a list of employees searched by birthdate, years of service, age and status.

Benefits n/a BI super-user

Participation Displays employees who are participating in specified benefit plans on a given date or during a certain period of time.

Benefits HRBEN0072 ECC super-user

Plan Costs(in ECC = Insurance Plan Costs HRBEN0074)

Displays the employee, employer, and provider costs for a specified insurance plan.

Benefits HRBEN0074 BI super-user

2 of 2

Page 23: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

OPERATIONS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERAnalysis of Order Values Analysis of Order Values-Interactive analysis with descriptors, net

order value, average per item, average per PO, and frequency; capability to also compare periods

Purchasing ME81 ECC/BI super-user

Compare Evaluations A tool to compare evaluations of vendors; search criteria; vendor, material, info record, material group.

Purchasing ME64 ECC/BI super-user

Delivery Due List Delivery Due List -Monitors delivery for warehouse and textbooks w/ addition of date range; displays shortage, material#, delivery date.

Purchasing ECC super-user

Display Material Documents by Mvt. Reason

Display Material Documents by Mvt. Reason-Search via material doc #, purchase doc #, displays mvt type, material qty and stock value.

Purchasing ECC/BI both

Display Inventory Count Use this procedure to view a past Inventory document. Display Inventory Count by Physical inv document number-report gives phys inv history, statistics (open, counted, recounted, deleted), Plant and storage location.

Purchasing ECC/BI both

Display Material Document Display Material Document-Report details from item mvt type, accounting documents and posting dates.

Purchasing ECC both

Display Planned Orders Display Planned (picked) Orders by MRP controller, material, provider, WBS (work breakdown structure)element.

Purchasing ECC super-user

Display Purchase Order Display Purchase Order-Detailed info of Purchase; Header allows you to access vendors address, texts, conditions and Org data, Purch group and status. The item overview displays requisition number, requisitioner, material data, with delivery schedule, delivery (shipping instructions, stock type, shelf life); Invoice info ( final invoice, tax code); Account assignment display allow you to see the func area, funds center and commit item info; Item text with material specs and additional texts; Conditions control (print price/Estimated Price).

Purchasing ME23N ECC both

Display Vendor Display Vendor Name address and telephone number, Contact and other communication.

Purchasing MK03 ECC both

Display Vendor With Tax Code Display Vendor With Tax Code and Tax Categories , along with the address, payment transactions, and contact persons.

Purchasing XK03 ECC/BI super-user

Display Vendor with Tax Code Display Vendor Name address and telephone number, Contact and other communication along with Tax Code - this Transaction Code is authorized for specific AP and some power users.

Purchasing ECC super-user

Display Warehouse Stocks of Material Display Warehouse Stocks of Material per storage location by plant. Special stock can be managed separately by using the special stock indicator.

Purchasing ECC/BI super-user

1 of 5

Page 24: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

OPERATIONS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USEREvaluations per Material / Mat. Group Ranking list of evaluations per Material / Mat. Group denotes list

of evaluations based on the material /mat group.Purchasing ME6B ECC/BI super-user

Expected Goods Receipts Displays expected deliveries with Purchase order numbers and delivery dates.

Purchasing ECC both

Info Records per Material Info Records per Material-material, vendor sub/range, mat group, plant : generates price calculations, last purch date, standard qty, net price, last PO #, qty ordered and info record. Restrictions: only plant specific; flagged for deletion, only with Purch org data.

Purchasing ME1M ECC/BI super-user

Info Records Per Material Group Info Records Per Material Group- mat group, plant, vendor sub/range : generates price calculations, last purch date, standard qty, net price, last PO #, qty ordered and info record. Restrictions: only plant specific; flagged for deletion, only with Purch org data.

Purchasing ME1W ECC/BI super-user

Info Records Per Vendor Info Records Per Vendor -vendor sub/range, mat group, plant : generates price calculations, last purch date, standard qty, net price, last PO #, qty ordered and info record. Restrictions: only plant specific; flagged for deletion, only with Purch org data.

Purchasing ME1L ECC/BI super-user

Inventory Turnover Allows you to check the Inventory turnover on material or range of material in a plant or warehouse; displays quantity on hand, period, and area analyzed.

Purchasing ECC/BI super-user

Material Document List Material Document List-Displays storage locations within plants, the corresponding material document number, posting date, quantity and unit of measure.

Purchasing ECC super-user

Materials List Materials List displays material with plant, valuation type, Material description, date of last change, material type, material group, base unit, purchasing group, ABC Indicator, MRP type, valuation class, price control, price, currency, price unit, and created by.

Purchasing ECC/BI both

Outline Agreements by Material Group Outline Agreements by Material Group-displays arrangement between a purchasing organization and a vendor for the supply of materials or provision of services over a certain period based on predefined terms and conditions via Material group.

Purchasing ME3C ECC/BI both

Outline Agreements per Material Outline Agreements per Material-Displays the arrangement between a purchasing organization and a vendor for the supply of materials or provision of services over a certain period based on predefined terms and conditions via material number.

Purchasing ME3M ECC/BI super-user

2 of 5

Page 25: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

OPERATIONS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USEROutline Agreements per Vendor Outline Agreements per Vendor-Displays arrangement between a

purchasing organization and a vendor for the supply of materials or provision of services over a certain period based on predefined terms and conditions via Vendor.

Purchasing ME3L ECC/BI both

Periodic report to indicate slow moving zero stock items

Periodic report to indicate slow moving zero stock items with option of Detail Display, ABC Analysis, and Classification. This is report also gives the user the option to display in double line or triple, and sort on a chosen field.

Purchasing ECC/BI super-user

Physical Inventory List Use this procedure to display information on inventoried items with a variety of filters. Perform this procedure to help analyze your inventory records. Prerequisites: previously completed or partially completed inventory.

Purchasing ECC super-user

PR and related RFQ, PO and contracts. Display of existing RFQ, PO and contracts related to purchase requisitions

PR and related RFQ, PO and contracts. Display of existing RFQ, PO and contracts related to purchase requisitions.

Purchasing ECC both

Price Comparison List Price Comparison List by comparing quotes from RFQ provided by the vendors .

Purchasing ECC both

Purch. Orders by Account Assignment Purch. Orders by Account Assignment presents WBS (work breakdown structure) element, vendor, supplying plant, scope of list can be generated by choosing a document date range.

Purchasing ME2K ECC/BI both

Purchase Order Price History Purchase Order Price History by vendor, material, material group; Options (displays all records/sorted by organization); Displays variance, net price, info record #, Purchase order # and material order date.

Purchasing ME1P ECC/BI super-user

Purchase Orders By FUND (Summary) Purchase Orders By FUND (Summary). Purchasing BI both

Purchase Orders by Material Purchase Orders by Material Purchasing ME2M ECC/BI bothPurchase Orders by Material Group Purchase Orders by Material Group via material group access PO

History/release documentation, purchase document category and type, vendor, material description, and account assignment/category.

Purchasing ME2C ECC/BI both

Purchase Orders by Vendor Purchase Orders by Vendor-Displays line item history, POH/release documentation, material short text, plant and storage location.

Purchasing ME2L ECC/BI both

Purchase Requisitions: List Display Purchase Requisitions: List Display of Requisitions for plant/ stor loc, specific requisition #, or a date range; Report includes short text and requisitioner.

Purchasing ME5A ECC/BI both

3 of 5

Page 26: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

OPERATIONS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERPurchasing Document per Document Number

Use this procedure to view all POs by storage loc or plant and determine what POs still have open invoices Summary report of all contracts with total amount, invoiced amount, dates.

Purchasing ME2N ECC both

Purchasing Documents Use this procedure to view all POs by storage loc or plant and determine what POs still have open invoices Summary report of all contracts with total amount, invoiced amount, dates.

Purchasing ME3N ECC both

Purchasing Documents per Supplying Plant

This report lists Purchasing Documents per Supplying Plant with Item, Purchasing Doc. Type, Purch. Doc. Category, Purch. Organization, Purchasing Group, PO history/release documentation, Document Date, Material, Short Text, Material Group, Deletion Indicator, Item Category, Acct Assignment Cat., Storage Location, Order Quantity, Order Unit, Quantity in SKU, Stockkeeping unit, Net price, Currency, Price Unit, Still to be delivered (qty), Still to be delivered (value), Still to be invoiced (qty), Still to be invoiced (val.), No. of Positions (Sum allowed), Control indicator, Purchasing Info Rec., Package number, Release group, Release Strategy, Release status, and Release indicator.

Purchasing ME2W ECC/BI both

Purchasing Reporting Purchasing Reporting (General Analysis)-Displays purchase order history and status of purchase orders.

Purchasing ME80FN ECC/BI both

Ranking Lists Ranking Lists generates a report of vendors that gives overall evaluation scores and average scores; search criteria: vendor, vendor class, scope of list.

Purchasing ME65 ECC/BI super-user

Requisition Approval Reminder Provides a list of requisitions to send out reminding of pending approvals. Displays Material #, req#, item, short text, delivery /release date, mat group, plant and storage location

Purchasing ME5F ECC super-user

Requisition Summary Report Requisition Summary Report Purchasing ME5A ECC/BI bothRequisitions by Account Assignment Requisitions by Account Assignment-List Display of Requisitions

for by entering acct assignment, plant/ stor loc, specific requisition #, or a date range; Report includes short text and requisitioner.

Purchasing ME5K ECC/BI both

RFQs by Collective Number RFQs by Collective Number Purchasing ME4S ECC/BI super-userRFQs by Material Group RFQs by Material Group-Provides Purchasing doc by material

group through vendor, plant, stor loc and delivery date.Purchasing ME4C ECC/BI super-user

RFQs by RFQ Number RFQs by RFQ Number-Provides Purchasing doc by RFQ#, vendor through plant, stor loc and delivery date.

Purchasing ME4N ECC/BI super-user

RFQs by Vendor Provides Purchasing doc by vendor through plant, stor loc and delivery date.

Purchasing ME4L ECC/BI super-user

4 of 5

Page 27: BUDGET SAP REPORTS - Broward County Public … Reports Matrix.pdfBUDGET SAP REPORTS REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BI ... monthly trial balance special ledger

OPERATIONS SAP REPORTS

REPORT NAME REPORT DESCRIPTION CATEGORY T-Code ECC AND/OR BIEND-USER/

SUPER-USERServices per Purchase Order Purchase Order with details driven by Material Group and Date

Ranges.Purchasing ME2S ECC/BI both

Stock / Requirement List Report to see items that are a certain percentage above their reorder point to possibly include them in purchase orders sent to vendors.

Purchasing ECC/BI super-user

Stock/Requirements List A list of stock on hand, requisitions processed or stock needed Report to see items that are a certain percentage above their reorder point to possibly include them in purchase orders sent to vendors.

Purchasing ECC/BI super-user

Summary report of all contracts with total amount, invoiced amount, dates

Use this procedure to view all POs by storage loc or plant and determine what POs still have open invoices Summary report of all contracts with total amount, invoiced amount, dates.

Purchasing ME2N, ME3N ECC super-user

Vendor Master reports for TIN, MWBE and certification

Vendor Master reports for TIN, MWBE and certification Displays Purchase order history corrections.

Purchasing BI super-user

Vendors not Evaluated Since Vendors not Evaluated Since-Displays the last time a vendor was evaluated; search criteria: vendor, Purch org,

Purchasing ME6D ECC/BI super-user

Vendors without Evaluation Vendors without Evaluation- Provides info of vendors they have not yet been evaluated with vendor name, number and address.

Purchasing ME6C ECC super-user

5 of 5