Profit Center Plan vs Actual Revenue and Cost Report
Short answer: 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.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Controllers, business unit managers and finance teams preparing the monthly performance report.
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 |
|---|---|---|---|
| FAGLFLEXTNew General Ledger: Totals | Plan and actual period totals by profit center and account (driving table) | — | ECC + S/4 |
| CEPCProfit Center Master Data | Profit center owner and standard hierarchy group | CEPC-PRCTR = FAGLFLEXT-PRCTR AND CEPC-KOKRS = FAGLFLEXT-KOKRS AND CEPC-DATBI >= yıl sonu | ECC + S/4 |
| CEPCTProfit Center Texts | Profit center text | CEPCT-PRCTR = CEPC-PRCTR AND CEPCT-KOKRS = CEPC-KOKRS AND CEPCT-DATBI = CEPC-DATBI AND CEPCT-SPRAS = SY-LANGU | ECC + S/4 |
| SKATG/L Account Descriptions | Account text | SKAT-KTOPL = T001-KTOPL AND SKAT-SAKNR = FAGLFLEXT-RACCT AND SKAT-SPRAS = SY-LANGU | ECC + S/4 |
| T001Company Codes | Chart of accounts and currency | T001-BUKRS = FAGLFLEXT-RBUKRS | ECC + S/4 |
| I_ActualPlanJournalEntryItemActual Plan for Journal Entry Item | Actual and plan items in one view on S/4HANA | CompanyCode = FAGLFLEXT-RBUKRS AND ProfitCenter = FAGLFLEXT-PRCTR | S/4HANA only |
S/4HANA notes
- FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_RLDNR | Ledger | Single value | FAGLFLEXT-RLDNR | Yes | 0L |
| S_RBUKRS | Company code | Range / multiple | FAGLFLEXT-RBUKRS | Yes | 1000 |
| P_RYEAR | Fiscal year | Single value | FAGLFLEXT-RYEAR | Yes | 2026 |
| P_PERIO | Report period | Single value | — | Yes | 10 |
| P_RVERS | Plan version | Single value | FAGLFLEXT-RVERS | Yes | 001 |
| S_PRCTR | Profit center | Range / multiple | FAGLFLEXT-PRCTR | No | PC100 |
| P_KHINR | Profit center group | Single value | CEPC-KHINR | No | PCG_SATIS |
| S_RACCT | Account | Range / multiple | FAGLFLEXT-RACCT | No | 6000000000 – 7999999999 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Profit center | FAGLFLEXT-PRCTR |
| 2 | Profit center text | CEPCT-KTEXT |
| 3 | Person responsible | CEPC-VERAK |
| 4 | Account | FAGLFLEXT-RACCT |
| 5 | Account text | SKAT-TXT50 |
| 6 | Line type | Calculated Revenue or cost by account range |
| 7 | Plan (period) | Calculated HSLnn for RRCTY = 1, RVERS = P_RVERS |
| 8 | Actual (period) | Calculated HSLnn for RRCTY = 0 |
| 9 | Variance (period) | Calculated Actual − plan (sign flipped for revenue) |
| 10 | Plan (year to date) | Calculated Sum of plan HSL01…HSLnn |
| 11 | Actual (year to date) | Calculated Sum of actual HSL01…HSLnn |
| 12 | Variance (year to date) | Calculated Actual YTD − plan YTD |
| 13 | Variance % | Calculated YTD variance / |plan YTD| × 100 |
| 14 | Currency | T001-WAERS |
Sample output
| Profit center | Profit center text | Person responsible | Account | Account text | Line type | Plan (period) | Actual (period) | Variance (period) | Plan (year to date) | Actual (year to date) | Variance (year to date) | Variance % | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PC100 | Domestic sales | M. Aksoy | 6000000000 | Domestic sales revenue | Revenue | 4,200,000 | 4,512,000 | 312,000 | 40,000,000 | 41,850,000 | 1,850,000 | 4.60 | TRY |
| PC100 | Domestic sales | M. Aksoy | 7600000000 | Marketing expenses | Cost | 380,000 | 441,500 | -61,500 | 3,600,000 | 3,925,000 | -325,000 | -9 | TRY |
| PC200 | Export | S. Yıldız | 6010000000 | Export sales revenue | Revenue | 2,900,000 | 2,610,000 | -290,000 | 27,500,000 | 26,180,000 | -1,320,000 | -4.80 | TRY |
| PC200 | Export | S. Yıldız | 7600000000 | Marketing expenses | Cost | 210,000 | 198,400 | 11,600 | 2,050,000 | 1,987,000 | 63,000 | 3.10 | TRY |
How does the report work?
- 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.
- The period amount comes from the matching HSLnn field; the cumulative amount is HSLVT (balance carried forward, for balance sheet accounts) plus HSL01…HSLnn.
- 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.
- The account text is read from SKAT (T001-KTOPL); the line type is classed as revenue or cost by account range.
- Variance = actual − plan; variance % = variance / |plan| × 100. On revenue lines the sign is flipped so a favourable variance is always positive.
Performance notes
Restrict FAGLFLEXT by ledger, company code and year; add the profit center and account ranges to the WHERE clause. On S/4HANA aggregate actual and plan in one query on I_ActualPlanJournalEntryItem instead of the totals table.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking an actual amount opens the KE5Z line items for that profit center and account.
- Export to Excel
- Runs as a background job
- Send the result by email Can be sent to business unit managers after the month-end close.
Authorization objects
- K_PCAAuthorization by profit center responsibility area
- K_PCAR_REPAuthorization to run profit center reports
- F_FAGL_LDRAuthorization 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.
Related reports
Cost Center Line Items with Vendor, Purchase Order and Employee Report
A custom ALV report that shows cost center actual line items on one row with the purchase order, vendor name, employee name and source document. The …
Cost Center Plan vs Actual with Commitments Report
A custom ALV report that shows plan, actual and open purchasing commitments per cost center and cost element on one row, and calculates the remaining …
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.