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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| AUFKOrder Master Data | Network header: number, category and plant | — | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Network routing number (AUFPL) | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVCOperation within an Order | Activity: number, text, work center and WBS assignment (driving table) | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVVQuantities, Dates and Values of Order Operations | Planned and actual work, unit and planned dates | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| AFRUOrder Confirmations | Confirmations: last confirmation date and final confirmation flag | AFRU-AUFPL = AFVC-AUFPL AND AFRU-APLZL = AFVC-APLZL | ECC + S/4 |
| CRHDWork Center Header | Work center code | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element | PRPS-PSPNR = AFVC-PROJN | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0012-* |
| S_AUFNR | Network | Range / multiple | AUFK-AUFNR | No | 4000123 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | MUH-ELK |
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes | 1000 |
| S_FSEDD | Planned finish date | Range / multiple | AFVV-FSEDD | No | 01.10.2026 – 31.12.2026 |
| P_OVER | Overruns only | Checkbox | — | No | — |
| P_OPEN | Exclude finally confirmed | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | WBS element | PRPS-POSID |
| 2 | Network | AUFK-AUFNR |
| 3 | Activity | AFVC-VORNR |
| 4 | Activity text | AFVC-LTXA1 |
| 5 | Work center | CRHD-ARBPL |
| 6 | Planned work | AFVV-ARBEI |
| 7 | Actual work | AFVV-ISMNW |
| 8 | Remaining | Calculated AFVV-ARBEI − AFVV-ISMNW |
| 9 | Unit | AFVV-ARBEH |
| 10 | Completion (%) | Calculated AFVV-ISMNW ÷ AFVV-ARBEI × 100 |
| 11 | Planned start | AFVV-FSAVD |
| 12 | Planned finish | AFVV-FSEDD |
| 13 | Last confirmation | AFRU-BUDAT |
| 14 | Status | Calculated Overrun (actual > plan), late (FSEDD passed, no final confirmation) or on plan |
Sample output
| WBS element | Network | Activity | Activity text | Work center | Planned work | Actual work | Remaining | Unit | Completion (%) | Planned start | Planned finish | Last confirmation | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0012-01 | 4000123 | 0010 | Electrical design | MUH-ELK | 320 | 352 | -32 | H | 110 | 02/03/2026 | 05/29/2026 | 06/18/2026 | Overrun |
| P-26-0012-01 | 4000123 | 0020 | Mechanical design | MUH-MEK | 480 | 410 | 70 | H | 85.40 | 02/03/2026 | 06/12/2026 | 11/13/2026 | Late |
| P-26-0012-03 | 4000131 | 0010 | Site setup | SAHA-01 | 600 | 240 | 360 | H | 40 | 11/12/2026 | 01/15/2027 | 11/14/2026 | On plan |
| P-26-0015-01 | 4000140 | 0030 | Structural calculation check | MUH-INS | 160 | 150 | 10 | H | 93.80 | 03/02/2026 | 04/30/2026 | 05/04/2026 | On plan |
How does the report work?
- 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.
- Planned work (ARBEI), actual work (ISMNW), unit (ARBEH) and planned dates (FSAVD, FSEDD) are read from AFVV.
- From AFRU, the latest posting date (BUDAT) of confirmations that are not cancelled (STOKZ blank) and the final confirmation flag (AUERU) are taken.
- Remaining hours = ARBEI − ISMNW; completion = ISMNW ÷ ARBEI × 100. Overrun: actual work exceeds plan, or the planned finish has passed without a final confirmation.
- 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
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, …
Related reports
Network Activity Confirmation Upload from Weekly Timesheets Program
A custom interface program that posts personnel, network, activity, date and hours rows from an external time tracking tool or an Excel timesheet as …
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.