# Profit Center Plan vs Actual Revenue and Cost Report

> A custom ALV report that compares plan and actual amounts by profit center and account for the period and year to date, and gives the variance as amount and percentage. It comes as one list with the profit center owner and group.

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/profit-center-plan-vs-actual-report/


## Why is the standard not enough?

Classic profit center reports are defined in Report Painter; changing the layout and seeing account text, owner and variance percentage in one ALV needs a new form. KE5Z lists actual line items but does not compare them with plan. FAGLB03 shows the balance of one account. The monthly business unit report needs one Excel-ready, filterable plan/actual list.

### Closest standard alternatives

- KE5Z: Lists profit center actual line items; does not compare with plan.
- FAGLB03: Shows account balances by period; gives no cross-profit-center list or plan variance.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| FAGLFLEXT | Plan and actual period totals by profit center and account (driving table) | Read | - | ECC + S/4 |
| CEPC | Profit center owner and standard hierarchy group | Read | CEPC-PRCTR = FAGLFLEXT-PRCTR AND CEPC-KOKRS = FAGLFLEXT-KOKRS AND CEPC-DATBI >= yıl sonu | ECC + S/4 |
| CEPCT | Profit center text | Read | CEPCT-PRCTR = CEPC-PRCTR AND CEPCT-KOKRS = CEPC-KOKRS AND CEPCT-DATBI = CEPC-DATBI AND CEPCT-SPRAS = SY-LANGU | ECC + S/4 |
| SKAT | Account text | Read | SKAT-KTOPL = T001-KTOPL AND SKAT-SAKNR = FAGLFLEXT-RACCT AND SKAT-SPRAS = SY-LANGU | ECC + S/4 |
| T001 | Chart of accounts and currency | Read | T001-BUKRS = FAGLFLEXT-RBUKRS | ECC + S/4 |
| I_ActualPlanJournalEntryItem | Actual and plan items in one view on S/4HANA | Read | CompanyCode = FAGLFLEXT-RBUKRS AND ProfitCenter = FAGLFLEXT-PRCTR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_RLDNR | Ledger | Single value | FAGLFLEXT-RLDNR | Yes |
| S_RBUKRS | Company code | Range / multiple | FAGLFLEXT-RBUKRS | Yes |
| P_RYEAR | Fiscal year | Single value | FAGLFLEXT-RYEAR | Yes |
| P_PERIO | Report period | Single value | - | Yes |
| P_RVERS | Plan version | Single value | FAGLFLEXT-RVERS | Yes |
| S_PRCTR | Profit center | Range / multiple | FAGLFLEXT-PRCTR | No |
| P_KHINR | Profit center group | Single value | CEPC-KHINR | No |
| S_RACCT | Account | Range / multiple | FAGLFLEXT-RACCT | No |

## Output columns

| Column | Source |
|---|---|
| Profit center | FAGLFLEXT-PRCTR |
| Profit center text | CEPCT-KTEXT |
| Person responsible | CEPC-VERAK |
| Account | FAGLFLEXT-RACCT |
| Account text | SKAT-TXT50 |
| Line type | Calculated: Revenue or cost by account range |
| Plan (period) | Calculated: HSLnn for RRCTY = 1, RVERS = P_RVERS |
| Actual (period) | Calculated: HSLnn for RRCTY = 0 |
| Variance (period) | Calculated: Actual − plan (sign flipped for revenue) |
| Plan (year to date) | Calculated: Sum of plan HSL01…HSLnn |
| Actual (year to date) | Calculated: Sum of actual HSL01…HSLnn |
| Variance (year to date) | Calculated: Actual YTD − plan YTD |
| Variance % | Calculated: YTD variance / |plan YTD| × 100 |
| Currency | T001-WAERS |

## How does the report work?

1. Totals are read from FAGLFLEXT by ledger, company code, fiscal year and profit center: record type RRCTY = 0 for actual, RRCTY = 1 with RVERS = P_RVERS for plan.
2. The period amount comes from the matching HSLnn field; the cumulative amount is HSLVT (balance carried forward, for balance sheet accounts) plus HSL01…HSLnn.
3. The profit center text is added from CEPCT, and the owner and group (KHINR) from CEPC by validity date; when P_KHINR is given, only profit centers in that group are taken.
4. The account text is read from SKAT (T001-KTOPL); the line type is classed as revenue or cost by account range.
5. Variance = actual − plan; variance % = variance / |plan| × 100. On revenue lines the sign is flipped so a favourable variance is always positive.

## Authorization objects

- K_PCA: Authorization by profit center responsibility area
- K_PCAR_REP: Authorization to run profit center reports
- F_FAGL_LDR: Authorization for the general ledger

## Frequently asked questions

### Does it work on a system that uses classic profit center accounting (GLPCT)?

Yes, it is built with a selectable source table. With the new G/L FAGLFLEXT is read; with classic profit center accounting GLPCT.

### Where does plan data come from?

Plan is the amount posted in G/L planning with the selected version (RRCTY = 1). If the plan is in another version, it is changed on the selection screen.

### Are revenue and cost variances shown in the same direction?

The sign is flipped on revenue lines, so a favourable variance is positive and an unfavourable one negative on every row.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-profit-center-plan-actual
