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

- 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/network-activity-planned-vs-actual-work-hours-report/


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

### Closest standard alternatives

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

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AUFK | Network header: number, category and plant | Read | - | ECC + S/4 |
| AFKO | Network routing number (AUFPL) | Read | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVC | Activity: number, text, work center and WBS assignment (driving table) | Read | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVV | Planned and actual work, unit and planned dates | Read | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| AFRU | Confirmations: last confirmation date and final confirmation flag | Read | AFRU-AUFPL = AFVC-AUFPL AND AFRU-APLZL = AFVC-APLZL | ECC + S/4 |
| CRHD | Work center code | Read | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| PRPS | WBS element | Read | PRPS-PSPNR = AFVC-PROJN | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_AUFNR | Network | Range / multiple | AUFK-AUFNR | No |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes |
| S_FSEDD | Planned finish date | Range / multiple | AFVV-FSEDD | No |
| P_OVER | Overruns only | Checkbox | - | No |
| P_OPEN | Exclude finally confirmed | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| WBS element | PRPS-POSID |
| Network | AUFK-AUFNR |
| Activity | AFVC-VORNR |
| Activity text | AFVC-LTXA1 |
| Work center | CRHD-ARBPL |
| Planned work | AFVV-ARBEI |
| Actual work | AFVV-ISMNW |
| Remaining | Calculated: AFVV-ARBEI − AFVV-ISMNW |
| Unit | AFVV-ARBEH |
| Completion (%) | Calculated: AFVV-ISMNW ÷ AFVV-ARBEI × 100 |
| Planned start | AFVV-FSAVD |
| Planned finish | AFVV-FSEDD |
| Last confirmation | AFRU-BUDAT |
| Status | Calculated: Overrun (actual > plan), late (FSEDD passed, no final confirmation) or on plan |

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

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-network-activity-planned-vs-actual-hours
