# Critical Path and Low Float Network Activities Report

> 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.

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: S (3–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/critical-path-and-low-float-network-activities-report/


## 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.

### Closest standard alternatives

- CN41N: Shows the project structure and dates; has no filtering or classification by float across projects.
- CN47N: Gives the activity list; negative float and days to latest finish are not calculated.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PRPS | WBS element and responsible person (driving table) | Read | - | ECC + S/4 |
| PROJ | Project definition | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| AUFK | Network header and linked WBS element | Read | AUFK-PSPEL = PRPS-PSPNR | ECC + S/4 |
| AFKO | Network routing number of operations | Read | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVC | Activity: number, text, work center | Read | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVV | Activity dates, total float, planned and actual work | Read | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| CRHD | Work center code | Read | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| JEST | Activity status (CNF, TECO) | Read | JEST-OBJNR = AFVC-OBJNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | Yes |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_AUFNR | Network | Range / multiple | AFKO-AUFNR | No |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_VERNR | Responsible person no | Range / multiple | PRPS-VERNR | No |
| P_FLOAT | Maximum total float (days) | Single value | - | Yes |
| P_OPEN | Exclude completed activities | Checkbox | - | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| Responsible | PRPS-VERNA |
| Network | AFKO-AUFNR |
| Activity | AFVC-VORNR |
| Activity text | AFVC-LTXA1 |
| Work center | CRHD-ARBPL |
| Earliest start | AFVV-FSAVD |
| Earliest finish | AFVV-FSEDD |
| Latest finish | AFVV-SSEDD |
| Total float | AFVV-PUFFR |
| Actual start | AFVV-ISDD |
| Completion (%) | Calculated: AFVV-ISMNW ÷ AFVV-ARBEI × 100 |
| Days to latest finish | Calculated: AFVV-SSEDD − key date |
| Category | Calculated: Float < 0 negative, = 0 critical, ≤ P_FLOAT low float |

## How does the report work?

1. 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.
2. 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).
3. The activity status is read from JEST; if P_OPEN is set, finally confirmed (CNF), technically completed (TECO) or deleted activities are excluded.
4. 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.
5. 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.

## Authorization objects

- C_AFKO_AWK: Network authorization by plant and order type
- C_PRPS_VNR: WBS 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-network-activities-low-float
