PS Report Custom development ALV report

Network Activity Planned vs Actual Work Hours Report

Short answer: A custom ALV report that compares planned work with confirmed actual work on network activities and lists the remaining hours, completion percentage, last confirmation date and overrun status by work center and WBS element. It shows the hour budget of engineering and site teams across projects in one list.

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

Why is the standard not enough?

CN48 lists confirmations one by one; the CN47N activity overview can show planned and actual work but does not give the overrun percentage, remaining hours, last confirmation date or work center totals across projects out of the box. Teams build the weekly hours tracking by merging two lists in Excel.

Who uses it? Project managers, resource planners and engineering team leads.

Closest standard alternatives

  • CN48 Overview: Confirmations. Lists confirmations one by one; gives no planned, actual and remaining comparison per activity.
  • CN47N Overview: Activities/Elements. Can show activities with planned and actual work; overrun percentage, last confirmation date and work center totals are not ready-made.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataNetwork header: number, category and plant—ECC + S/4
AFKOOrder Header Data for PP OrdersNetwork routing number (AUFPL)AFKO-AUFNR = AUFK-AUFNRECC + S/4
AFVCOperation within an OrderActivity: number, text, work center and WBS assignment (driving table)AFVC-AUFPL = AFKO-AUFPLECC + S/4
AFVVQuantities, Dates and Values of Order OperationsPlanned and actual work, unit and planned datesAFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZLECC + S/4
AFRUOrder ConfirmationsConfirmations: last confirmation date and final confirmation flagAFRU-AUFPL = AFVC-AUFPL AND AFRU-APLZL = AFVC-APLZLECC + S/4
CRHDWork Center HeaderWork center codeCRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A'ECC + S/4
PRPSWBS Element Master DataWBS elementPRPS-PSPNR = AFVC-PROJNECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0012-*
S_AUFNRNetworkRange / multipleAUFK-AUFNRNo4000123
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoMUH-ELK
S_WERKSPlantRange / multipleAUFK-WERKSYes1000
S_FSEDDPlanned finish dateRange / multipleAFVV-FSEDDNo01.10.2026 – 31.12.2026
P_OVEROverruns onlyCheckbox—No—
P_OPENExclude finally confirmedCheckbox—NoX

Output columns

#ColumnSource
1WBS elementPRPS-POSID
2NetworkAUFK-AUFNR
3ActivityAFVC-VORNR
4Activity textAFVC-LTXA1
5Work centerCRHD-ARBPL
6Planned workAFVV-ARBEI
7Actual workAFVV-ISMNW
8RemainingCalculated AFVV-ARBEI − AFVV-ISMNW
9UnitAFVV-ARBEH
10Completion (%)Calculated AFVV-ISMNW ÷ AFVV-ARBEI × 100
11Planned startAFVV-FSAVD
12Planned finishAFVV-FSEDD
13Last confirmationAFRU-BUDAT
14StatusCalculated Overrun (actual > plan), late (FSEDD passed, no final confirmation) or on plan

Sample output

WBS elementNetworkActivityActivity textWork centerPlanned workActual workRemainingUnitCompletion (%)Planned startPlanned finishLast confirmationStatus
P-26-0012-0140001230010Electrical designMUH-ELK320352-32H11002/03/202605/29/202606/18/2026Overrun
P-26-0012-0140001230020Mechanical designMUH-MEK48041070H85.4002/03/202606/12/202611/13/2026Late
P-26-0012-0340001310010Site setupSAHA-01600240360H4011/12/202601/15/202711/14/2026On plan
P-26-0015-0140001400030Structural calculation checkMUH-INS16015010H93.8003/02/202604/30/202605/04/2026On plan
A view built with fictional sample data; not real system data.

How does the report work?

  1. Network headers are read from AUFK/AFKO (order category network) by WBS or network criteria; network activities come from AFVC and the WBS assignment from AFVC-PROJN.
  2. Planned work (ARBEI), actual work (ISMNW), unit (ARBEH) and planned dates (FSAVD, FSEDD) are read from AFVV.
  3. From AFRU, the latest posting date (BUDAT) of confirmations that are not cancelled (STOKZ blank) and the final confirmation flag (AUERU) are taken.
  4. Remaining hours = ARBEI − ISMNW; completion = ISMNW ÷ ARBEI × 100. Overrun: actual work exceeds plan, or the planned finish has passed without a final confirmation.
  5. The work center is added from CRHD (ARBID = OBJID); the ALV shows subtotals by work center and WBS element.

Performance notes

Read AFVC and AFVV for the network list through the AUFPL key; in AFRU only the latest confirmation date is needed, so take MAX(BUDAT) with GROUP BY. For multi-project portfolios run the report as a weekly background job.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the activity opens CN23 (display network); clicking the last confirmation opens CN28.
  • Export to Excel
  • Runs as a background job
  • Send the result by email

Authorization objects

  • C_AFKO_AWKNetwork authorization by plant and order type
  • C_AFRU_AWKConfirmation display authorization by plant and order type

Frequently asked questions

Are hours entered with CATS included?

Yes. After transfer, CATS records create network confirmations (AFRU) and update AFVV-ISMNW. CATS records that have not been transferred yet are not included.

Can costs be compared instead of hours?

The base version focuses on work hours. If planned and actual cost per activity are needed, cost totals (COSS) can be added through the activity object number; this increases the effort range.

Does this report work on S/4HANA?

Yes. AFKO, AFVC, AFVV and AFRU keep the same structure for classic networks in S/4HANA.

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

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: Network Activity Planned vs Actual Work Hours Report