Critical Path and Low Float Network Activities Report
Short answer: A custom ALV report that filters network activities by the total float from the last scheduling run and lists critical (zero float), negative float and low float activities with responsible person, work center, earliest and latest dates and completion percentage. In the weekly project meeting the work that can delay the project shows up in one list.
- Estimated effort
- S · 3–4 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CN41N and CN47N show activity dates; even if the total float field is added, filtering by float across several projects, flagging negative float separately and grouping by responsible person are not possible. The project planning board shows the critical path graphically for one network. Planners therefore export the list every week and filter it in Excel.
Who uses it? Project managers, planning engineers, project offices and site managers.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PRPSWBS Element Master Data | WBS element and responsible person (driving table) | — | ECC + S/4 |
| PROJProject Definition | Project definition | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| AUFKOrder Master Data | Network header and linked WBS element | AUFK-PSPEL = PRPS-PSPNR | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Network routing number of operations | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVCOperation within an Order | Activity: number, text, work center | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVVQuantities, Dates and Values of Order Operations | Activity dates, total float, planned and actual work | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| CRHDWork Center Header | Work center code | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| JESTIndividual Object Status | Activity status (CNF, TECO) | JEST-OBJNR = AFVC-OBJNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | Yes | P-26-0014 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0014-02 |
| S_AUFNR | Network | Range / multiple | AFKO-AUFNR | No | 4000123 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | SAHA1 |
| S_VERNR | Responsible person no | Range / multiple | PRPS-VERNR | No | 12 |
| P_FLOAT | Maximum total float (days) | Single value | — | Yes | 5 |
| P_OPEN | Exclude completed activities | Checkbox | — | No | X |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | Responsible | PRPS-VERNA |
| 4 | Network | AFKO-AUFNR |
| 5 | Activity | AFVC-VORNR |
| 6 | Activity text | AFVC-LTXA1 |
| 7 | Work center | CRHD-ARBPL |
| 8 | Earliest start | AFVV-FSAVD |
| 9 | Earliest finish | AFVV-FSEDD |
| 10 | Latest finish | AFVV-SSEDD |
| 11 | Total float | AFVV-PUFFR |
| 12 | Actual start | AFVV-ISDD |
| 13 | Completion (%) | Calculated AFVV-ISMNW ÷ AFVV-ARBEI × 100 |
| 14 | Days to latest finish | Calculated AFVV-SSEDD − key date |
| 15 | Category | Calculated Float < 0 negative, = 0 critical, ≤ P_FLOAT low float |
Sample output
| Project | WBS element | Responsible | Network | Activity | Activity text | Work center | Earliest start | Earliest finish | Latest finish | Total float | Actual start | Completion (%) | Days to latest finish | Category |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0014 | P-26-0014-02-01 | A. Kaya | 4000123 | 0030 | Steel structure erection | SAHA1 | 11/18/2026 | 12/09/2026 | 12/09/2026 | 0 | 0 | 22 | Critical | |
| P-26-0014 | P-26-0014-02-03 | A. Kaya | 4000123 | 0050 | Panel wiring | ELEK1 | 11/24/2026 | 12/05/2026 | 12/08/2026 | 3 | 0 | 21 | Low float | |
| P-26-0021 | P-26-0021-01-02 | S. Arslan | 4000131 | 0020 | Soil survey | MUH01 | 11/02/2026 | 11/14/2026 | 11/12/2026 | -2 | 11/03/2026 | 60 | -5 | Negative float |
How does the report work?
- PROJ and PRPS are read by project, WBS element and responsible person (VERNR); networks linked to these WBS elements are found through AUFK (PSPEL) and AFKO.
- Activities are read from AFVC (AUFPL), and date and float fields from AFVV: earliest start and finish (FSAVD, FSEDD), latest start and finish (SSAVD, SSEDD), total float (PUFFR), actual start (ISDD).
- The activity status is read from JEST; if P_OPEN is set, finally confirmed (CNF), technically completed (TECO) or deleted activities are excluded.
- Activities with a total float equal to or below P_FLOAT remain; float 0 is classified as critical, negative as negative float and the rest as low float.
- Completion = AFVV-ISMNW ÷ AFVV-ARBEI × 100; days to latest finish = AFVV-SSEDD − key date. The work center comes from CRHD; the list is sorted by float and latest finish.
Performance notes
Float values come from the last scheduling run; running overall network scheduling (CN24N) as a nightly job before the report gives correct results. The read works through AUFPL, so it is fast even for hundreds of networks.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The network and activity open CJ20N on that activity.
- Export to Excel
- Runs as a background job
- Send the result by email Critical and negative float activities can be sent to each responsible person weekly.
Authorization objects
- C_AFKO_AWKNetwork authorization by plant and order type
- C_PRPS_VNRWBS element authorization by responsible person
Frequently asked questions
Why do the float values look out of date?
The float in AFVV is the result of the last scheduling run. If the network is not rescheduled after confirmations or date changes, the float stays old; overall scheduling at night before the report is therefore recommended.
Are relationships between networks taken into account?
Yes, if relationships between networks are scheduled together in overall scheduling (CN24N), the float reflects them. The report shows the value SAP calculated and does not recalculate it.
Does the report work on S/4HANA?
Yes. The network tables (AFKO, AFVC, AFVV) are the same in S/4HANA. In systems that use enterprise portfolio and project management, the same logic can be adapted to those structures.
Related reports
Network Activity Planned vs Actual Work Hours Report
A custom ALV report that compares planned work with confirmed actual work on network activities and lists the remaining hours, completion percentage, …
Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)
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 …
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.