MyPortal Substitution Report

 View Options:              Print
Procedure Updated: 
02/26/26

Use this report to view whether leave approvers have planned or unplanned substitutions in place.

Tips: 

Agencies are required to audit MyPortal substitution relationships and end substitution relationships when they are no longer needed, such as when a leave approver substitute has separated or moved to a different agency. Run this report to identify substitutes, then follow the Substitute Admin Transaction procedures to create, delimit, or delete MyPortal Substitution relationships as needed. Refer to the MyPortal Substitution Guide for more detailed information on auditing MyPortal substitution relationships, including when to end substitute relationships and what specific things to look for in your report results.

There are several authorized roles for this report. However, only the personnel administration processor will be able to view substitute relationships that are still in place after the substitute has moved to a different agency.

The following statewide variants are available for the MyPortal Substitution Report:

  • SWV-NOSUB
  • SWV-PLANNED
  • SWV-UPLAN

Refer to the Statewide Variant List for more information.

  1. Enter transaction code ZHR_ESS_SUBSREPORT in the command field and click the Enter button.

    Command field with transaction code ZHR_ESS_SUBSREPORT.

  2. Complete the Period section.

    The following field will default:

    • Key Date (As-of-Date)

    Period section with Key Date (As-Of-Date) field displayed.

    Tips: 

    The Period section will determine the time period of the employees and data that will display in the results.

    Key date defaults to Today but can be changed to a different date.

  3. Complete the Selection section.

    The following fields are optional:

    • Business Area
    • Personnel Area
    • Pers Num (Leave Approver)
    • Emp Status (Leave Approver)
    • Pers Num (Substitute)
    • Emp Status (Substitute)

    Selection section displayed.

    Tips: 

    The Selection section will assist in getting only the information needed. A selection is not required for each field.

    Leaving the Employment Status field blank will bring Withdrawn (0) employees into your reports results. This may be useful when determining if withdrawn employees have active substitutes. Restrict your report results to active (3) and/or inactive (1) employees if you are monitoring employees who are active/inactive only.

  4. Complete the Output Format section.

    The following Layout Variants are optional:

    • SWV-NOSUB
    • SWV-PLANNED
    • SWV-UPLAN

    Output Format section with Layout Variant field displayed.

    Tips: 

    The Output format section determines the format of the report results.

    A Layout Variant name is not required. Leaving this field blank will result in a default layout for this report.

  5. Click the Execute button.

    Screenshot of report results. Click to expand image.

    Sample report results. Click to expand image.

    Screenshot of report results. Click to expand image.

    Sample report results. Click to expand image.

    Tips: 

    Columns included in the report results depend on your default layout for this report. The report layout can be changed, saved or a previously saved layout can be selected.

    If the profile does not show ‘All Task Group,’ the substitute was set up incorrectly and will not process. The agency should follow the Substitute Admin Transaction procedures to delimit and create a new substitution with the correct profile. 

    To Export this report, click on the Excel button within the report results. This will open a Read Only Excel file within your SAP screen. Click on the Save button within the file. You will receive a warning stating the file is Read Only. Click Ok to return to the SAP screen and then click File > Save As.

The following table maps each field to the infotype:

Report Field Infotype Name Infotype Number
Business Area Code Organizational Assignment 0001
Business Area Organizational Assignment 0001
Personnel Area Code Organizational Assignment 0001
Personnel Area Organizational Assignment 0001
Personnel Number (Leave Approver) Derived value from table N/A
Name (Leave Approver) Organizational Assignment 0001
Employment Status (Leave Approver) Actions 0000
Personnel Area (Planned Substitute) Organizational Assignment 0001
Personnel Number (Planned Substitute) Derived value from table N/A
Name (Planned Substitute) Organizational Assignment 0001
Employment Status (Planned Substitute) Organizational Assignment 0001
Start Date (Planned Substitution) Derived value from table N/A
End Date (Planned Substitution) Derived value from table N/A
Personnel Area (Unplanned Substitute) Organizational Assignment 0001
Personnel Number (Unplanned Substitute) Organizational Assignment 0001
Name (Unplanned Substitute) Organizational Assignment 0001
Employment Status (Unplanned Substitute) Organizational Assignment 0001
Active (Unplanned Substitution) Derived value from table N/A
Profile Derived value from table N/A
Personnel Number (Leave Approver) Derived value from table N/A
Name (Leave Approver) Organizational Assignment 0001

Example Scenario

Below is an example of running the MyPortal Substitution Report. It is not a comprehensive list of every scenario.

Example – View a substitution for a transferred employee

In this scenario, my manager has requested that I conduct an audit of MyPortal substitutions to ensure there are no issues. As a personnel administrator, I will now run the MyPortal Substitution Report.

On the report selection screen:

  • Period:
    • Key Date (As-Of-Date) = Today (12/15/2025)
  • Selection:
    • Personnel area = 1790

Report selection screen. Click to expand.

Report selection screen. Click to expand.

  • Execute the report.

Sample report results. Click to expand.

Sample report results. Click to expand.

  • The report results show there is an active substitution for an employee who has transferred to another agency (2250). I can now end date the substitution so that the requests will no longer be sent to an incorrect substitute.