PS Report Custom development ALV report

Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)

Short answer: A custom ALV report that compares the basic start and finish dates of each WBS element with the forecast and actual dates, calculates the slip in days and counts milestones that are past due but not reached. It gives one list for the weekly project meeting.

Estimated effort
S · 3–4 working days
System
ECC and S/4HANA
Tables
4
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

CN41N and CN43N show dates per object but do not calculate the slip in days between the basic finish and the forecast or actual finish, and cannot filter by slip. CN53N lists milestones separately and does not combine them with the WBS line. PMO teams calculate the slippage table in Excel every week.

Who uses it? Project managers, project scheduling and PMO teams.

Closest standard alternatives

  • CN41N Project Structure Overview. Shows the project structure with dates; does not calculate the slip in days or filter by slip.
  • CN53N Overview: Milestones. Lists milestones; does not show them on the same line as the WBS date slip.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
PROJProject DefinitionProject definition—ECC + S/4
PRPSWBS Element Master DataWBS element: description, level and responsible person (driving table)PRPS-PSPHI = PROJ-PSPNRECC + S/4
PRTEScheduling Data for WBS ElementWBS dates: basic, forecast and actualPRTE-POSNR = PRPS-PSPNRECC + S/4
MLSTMilestoneMilestones: planned and actual dateMLST-PSPNR = PRPS-PSPNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProject definitionRange / multiplePROJ-PSPIDYesP-26-0012
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0012-*
S_VERNRResponsible personRange / multiplePRPS-VERNRNo12
S_PENDEBasic finish dateRange / multiplePRTE-PENDENo01.10.2026 – 31.12.2026
P_LEVELMaximum levelSingle valuePRPS-STUFENo3
P_MINSLMinimum slip (days)Single value—No5
P_MLSTCheck milestonesCheckbox—NoX
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4ResponsiblePRPS-VERNA
5Basic startPRTE-PSTRT
6Basic finishPRTE-PENDE
7Forecast startPRTE-PSTRM
8Forecast finishPRTE-PETRM
9Actual startPRTE-ISTRT
10Actual finishPRTE-IENDE
11Start slip (days)Calculated (ISTRT, else PSTRM) − PSTRT
12Finish slip (days)Calculated (IENDE, else PETRM) − PENDE; if neither exists and PENDE has passed, key date − PENDE
13Overdue milestonesCalculated Number of milestones with MLST-TEDAT < key date and empty MLST-LST_ACTDT
14StatusCalculated Green: slip ≤ 0; yellow: slip ≤ threshold; red: slip > threshold or overdue milestones exist

Sample output

ProjectWBS elementDescriptionResponsibleBasic startBasic finishForecast startForecast finishActual startActual finishStart slip (days)Finish slip (days)Overdue milestonesStatus
P-26-0012P-26-0012-01Engineering and designS. Arslan02/01/202605/31/202602/03/202606/20/20262200Yellow
P-26-0012P-26-0012-02Equipment procurementM. Demir04/01/202610/31/202604/15/202612/15/202604/15/202614452Red
P-26-0012P-26-0012-03Site installationE. Kaya11/01/202602/28/202711/10/202603/05/202711/12/20261150Yellow
P-26-0015P-26-0015-01Warehouse extension worksM. Demir03/01/202609/30/202603/01/202609/26/20260-40Green
A view built with fictional sample data; not real system data.

How does the report work?

  1. PROJ and PRPS are read by project, WBS, responsible person and maximum level.
  2. Dates are taken from PRTE: basic start / finish (PSTRT, PENDE), forecast start / finish (PSTRM, PETRM), actual start / finish (ISTRT, IENDE).
  3. Start slip = (actual start, else forecast start) − basic start. Finish slip = (actual finish, else forecast finish) − basic finish. If neither exists and the basic finish has passed, slip = key date − basic finish.
  4. Milestones assigned to the WBS element are read from MLST; those with a planned date (TEDAT) before the key date and an empty actual date (LST_ACTDT) count as overdue.
  5. The minimum slip filter is applied; the status light is set from the finish slip and the number of overdue milestones.

Performance notes

PRTE and MLST are small tables proportional to the number of WBS elements, so the report runs fast online. For forecast dates to be meaningful, the project team must update them regularly; otherwise the report shows the delay from the basic date to today.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the WBS element opens CJ20N.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Red lines can be sent weekly to the responsible persons.

Authorization objects

  • C_PROJ_KOKProject display authorization by controlling area
  • C_PRPS_VNRWBS element authorization by responsible person

Frequently asked questions

Can network activity dates be included as well?

Yes. If activity level is needed, the same slip calculation is applied to the planned and actual dates in AFVV; this extends the effort range.

Can it compare against a project version (baseline)?

The base version uses the WBS basic dates as the reference. If a frozen baseline exists as a project version (CN72), the comparison can be extended to use the version data.

Does this report work on S/4HANA?

Yes. PRPS, PRTE and MLST are used in classic Project System on S/4HANA as well. On systems using enterprise projects, the scope is assessed separately.

Packages that include this solution

PS Package Custom

Project Budget and Schedule Controlling Pack

A pack that combines five reports for the project review meeting with one project definition and WBS selection: budget vs actual vs commitment, …

5 components · v1.0

Related reports

PS Report Custom ALV report

Billing Milestones Reached but Not Invoiced Report

A custom ALV report that lists completed project milestones, those with an actual date, whose billing plan date in the sales order is still not …

MLST · PRPS · FPLT · FPLA

Let us build this report for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)