CO Report Custom development ALV report

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

  • KE5Z Profit Center: Actual Line Items. Lists profit center actual line items; does not compare with plan.
  • FAGLB03 Display Balances (New General Ledger). Shows account balances by period; gives no cross-profit-center list or plan variance.

Tables used

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

TableRoleJoinSystem
FAGLFLEXTNew General Ledger: TotalsPlan and actual period totals by profit center and account (driving table)—ECC + S/4
CEPCProfit Center Master DataProfit center owner and standard hierarchy groupCEPC-PRCTR = FAGLFLEXT-PRCTR AND CEPC-KOKRS = FAGLFLEXT-KOKRS AND CEPC-DATBI >= yıl sonuECC + S/4
CEPCTProfit Center TextsProfit center textCEPCT-PRCTR = CEPC-PRCTR AND CEPCT-KOKRS = CEPC-KOKRS AND CEPCT-DATBI = CEPC-DATBI AND CEPCT-SPRAS = SY-LANGUECC + S/4
SKATG/L Account DescriptionsAccount textSKAT-KTOPL = T001-KTOPL AND SKAT-SAKNR = FAGLFLEXT-RACCT AND SKAT-SPRAS = SY-LANGUECC + S/4
T001Company CodesChart of accounts and currencyT001-BUKRS = FAGLFLEXT-RBUKRSECC + S/4
I_ActualPlanJournalEntryItemActual Plan for Journal Entry ItemActual and plan items in one view on S/4HANACompanyCode = FAGLFLEXT-RBUKRS AND ProfitCenter = FAGLFLEXT-PRCTRS/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

ParameterDescriptionTypeReference fieldRequiredExample
P_RLDNRLedgerSingle valueFAGLFLEXT-RLDNRYes0L
S_RBUKRSCompany codeRange / multipleFAGLFLEXT-RBUKRSYes1000
P_RYEARFiscal yearSingle valueFAGLFLEXT-RYEARYes2026
P_PERIOReport periodSingle value—Yes10
P_RVERSPlan versionSingle valueFAGLFLEXT-RVERSYes001
S_PRCTRProfit centerRange / multipleFAGLFLEXT-PRCTRNoPC100
P_KHINRProfit center groupSingle valueCEPC-KHINRNoPCG_SATIS
S_RACCTAccountRange / multipleFAGLFLEXT-RACCTNo6000000000 – 7999999999

Output columns

#ColumnSource
1Profit centerFAGLFLEXT-PRCTR
2Profit center textCEPCT-KTEXT
3Person responsibleCEPC-VERAK
4AccountFAGLFLEXT-RACCT
5Account textSKAT-TXT50
6Line typeCalculated Revenue or cost by account range
7Plan (period)Calculated HSLnn for RRCTY = 1, RVERS = P_RVERS
8Actual (period)Calculated HSLnn for RRCTY = 0
9Variance (period)Calculated Actual − plan (sign flipped for revenue)
10Plan (year to date)Calculated Sum of plan HSL01…HSLnn
11Actual (year to date)Calculated Sum of actual HSL01…HSLnn
12Variance (year to date)Calculated Actual YTD − plan YTD
13Variance %Calculated YTD variance / |plan YTD| × 100
14CurrencyT001-WAERS

Sample output

Profit centerProfit center textPerson responsibleAccountAccount textLine typePlan (period)Actual (period)Variance (period)Plan (year to date)Actual (year to date)Variance (year to date)Variance %Currency
PC100Domestic salesM. Aksoy6000000000Domestic sales revenueRevenue4,200,0004,512,000312,00040,000,00041,850,0001,850,0004.60TRY
PC100Domestic salesM. Aksoy7600000000Marketing expensesCost380,000441,500-61,5003,600,0003,925,000-325,000-9TRY
PC200ExportS. Yıldız6010000000Export sales revenueRevenue2,900,0002,610,000-290,00027,500,00026,180,000-1,320,000-4.80TRY
PC200ExportS. Yıldız7600000000Marketing expensesCost210,000198,40011,6002,050,0001,987,00063,0003.10TRY
A view built with fictional sample data; not real system data.

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.

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

CO Report Custom ALV report

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 …

COSP · COSS · CSKS · CSKT

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: Profit Center Plan vs Actual Revenue and Cost Report