PS Report Custom development ALV report

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

  • CN41N Project Structure Overview. Shows the project structure and dates; has no filtering or classification by float across projects.
  • CN47N Overview: Activities/Elements. Gives the activity list; negative float and days to latest finish are not calculated.

Tables used

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

TableRoleJoinSystem
PRPSWBS Element Master DataWBS element and responsible person (driving table)—ECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
AUFKOrder Master DataNetwork header and linked WBS elementAUFK-PSPEL = PRPS-PSPNRECC + S/4
AFKOOrder Header Data for PP OrdersNetwork routing number of operationsAFKO-AUFNR = AUFK-AUFNRECC + S/4
AFVCOperation within an OrderActivity: number, text, work centerAFVC-AUFPL = AFKO-AUFPLECC + S/4
AFVVQuantities, Dates and Values of Order OperationsActivity dates, total float, planned and actual workAFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZLECC + S/4
CRHDWork Center HeaderWork center codeCRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A'ECC + S/4
JESTIndividual Object StatusActivity status (CNF, TECO)JEST-OBJNR = AFVC-OBJNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProject definitionRange / multiplePROJ-PSPIDYesP-26-0014
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0014-02
S_AUFNRNetworkRange / multipleAFKO-AUFNRNo4000123
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoSAHA1
S_VERNRResponsible person noRange / multiplePRPS-VERNRNo12
P_FLOATMaximum total float (days)Single value—Yes5
P_OPENExclude completed activitiesCheckbox—NoX
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3ResponsiblePRPS-VERNA
4NetworkAFKO-AUFNR
5ActivityAFVC-VORNR
6Activity textAFVC-LTXA1
7Work centerCRHD-ARBPL
8Earliest startAFVV-FSAVD
9Earliest finishAFVV-FSEDD
10Latest finishAFVV-SSEDD
11Total floatAFVV-PUFFR
12Actual startAFVV-ISDD
13Completion (%)Calculated AFVV-ISMNW ÷ AFVV-ARBEI × 100
14Days to latest finishCalculated AFVV-SSEDD − key date
15CategoryCalculated Float < 0 negative, = 0 critical, ≤ P_FLOAT low float

Sample output

ProjectWBS elementResponsibleNetworkActivityActivity textWork centerEarliest startEarliest finishLatest finishTotal floatActual startCompletion (%)Days to latest finishCategory
P-26-0014P-26-0014-02-01A. Kaya40001230030Steel structure erectionSAHA111/18/202612/09/202612/09/20260022Critical
P-26-0014P-26-0014-02-03A. Kaya40001230050Panel wiringELEK111/24/202612/05/202612/08/20263021Low float
P-26-0021P-26-0021-01-02S. Arslan40001310020Soil surveyMUH0111/02/202611/14/202611/12/2026-211/03/202660-5Negative float
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 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.

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

PS Report Custom ALV report

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, …

AUFK · AFKO · AFVC · AFVV

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: Critical Path and Low Float Network Activities Report