CO Report Custom development ALV report

Internal Order Budget Availability Report

Short answer: A custom ALV report that compares the annual or overall budget of internal orders with actual costs and open commitments, and shows the remaining budget, consumption rate and system status for each order on one row.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
7
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

KO03 shows the budget per order and KOB1 lists actual line items; neither shows budget, actual, commitment and remaining side by side for many orders. The standard budget comparison reports are based on Report Painter, do not offer a current-year remaining-budget column in one Excel-ready row and give no warning by consumption threshold.

Who uses it? Controllers, marketing and project budget owners, and teams that track investment and maintenance orders.

Closest standard alternatives

  • KOB1 Orders: Actual Line Items. Lists the order's actual line items; gives no budget or remaining amount.
  • KO03 Display Internal Order. Shows order master data and budget one at a time; no comparison across many orders.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataInternal order master: type, description, company code, object number (driving table)—ECC + S/4
BPJATotals Record for Annual Value (CO Object)Annual budget totals (value type 41)BPJA-OBJNR = AUFK-OBJNRECC + S/4
BPGETotals Record for Overall Value (CO Object)Overall budget (value type 41)BPGE-OBJNR = AUFK-OBJNRECC + S/4
COSPCO Object: Cost Totals for External PostingsPrimary actual costs and commitmentsCOSP-OBJNR = AUFK-OBJNRECC + S/4
COSSCO Object: Cost Totals for Internal PostingsSecondary actual costsCOSS-OBJNR = AUFK-OBJNRECC + S/4
JESTIndividual Object StatusSystem status (created, released, technically complete, closed)JEST-OBJNR = AUFK-OBJNRECC + S/4
TKA01Controlling AreasControlling area currencyTKA01-KOKRS = AUFK-KOKRSECC + S/4

S/4HANA notes

  • COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
  • COSS → ACDOCA: In S/4HANA COSS is a view, not a table; internal actual postings are read from ACDOCA.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KOKRSControlling areaSingle valueAUFK-KOKRSYes1000
S_AUFNRInternal orderRange / multipleAUFK-AUFNRNo400100–400199
S_AUARTOrder typeRange / multipleAUFK-AUARTNo0400
S_BUKRSCompany codeRange / multipleAUFK-BUKRSNo1000
P_GJAHRFiscal yearSingle valueBPJA-GJAHRYes2026
P_ANNUALAnnual budgetRadio button—NoX
P_OVERALOverall budgetRadio button—No—
P_WARNWarning threshold (%)Single value—No90
P_CLOSEDAlso show closed ordersCheckbox—No—

Output columns

#ColumnSource
1OrderAUFK-AUFNR
2DescriptionAUFK-KTEXT
3Order typeAUFK-AUART
4BudgetCalculated BPJA-WLJHR (annual) or BPGE-WLGES (overall), value type 41
5ActualCalculated COSP + COSS, value type 04
6CommitmentCalculated COSP, value types 21 and 22
7AssignedCalculated Actual + commitment
8Available budgetCalculated Budget − assigned
9Consumption (%)Calculated Assigned / budget × 100
10System statusCalculated Short text of the active system statuses in JEST
11LightCalculated Consumption < P_WARN green, P_WARN–100 yellow, > 100 red
12CurrencyTKA01-WAERS

Sample output

OrderDescriptionOrder typeBudgetActualCommitmentAssignedAvailable budgetConsumption (%)System statusLightCurrency
400120November trade fair0400650,000512,30088,000600,30049,70092RELYellowTRY
400133Digital advertising Q40400400,000410,2500410,250-10,250103RELRedTRY
400141Warehouse racking renewal04001,200,000265,000540,000805,000395,00067RELGreenTRY
400097Dealer meeting0400180,000176,4000176,4003,60098TECOYellowTRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. Internal orders (order category 01) matching the selection are read from AUFK; the system status is taken from JEST (inactive statuses excluded). Closed orders are skipped unless P_CLOSED is set.
  2. Budget: value type 41 records are summed in controlling area currency from BPJA for P_GJAHR in the annual view, or from BPGE in the overall view (WLJHR / WLGES); original budget, supplements and returns are all included.
  3. Actual: value type 04 in COSP and COSS; only P_GJAHR in the annual view, all years in the overall view.
  4. Commitment: value types 21 and 22 in COSP.
  5. Remaining = budget − actual − commitment; consumption % and the traffic light by the P_WARN threshold are calculated.

Performance notes

Select the orders from AUFK first, then read BPJA/BPGE and COSP/COSS once with the object number list. The JEST read is limited to active statuses.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order opens KO03 and the actual amount drills down to KOB1.
  • Export to Excel
  • Runs as a background job Can run weekly and send orders above the threshold to their owners.
  • Send the result by email

Authorization objects

  • K_ORDERInternal order display authorization by order type

Frequently asked questions

Does it give the same result as the availability control?

Because the report reads budget, actuals and commitments from the same value types, it usually gives the same remaining amount. If the availability control has cost element exemptions or tolerances, they are applied to the report the same way during installation.

Can the budget be split into original, supplement and return?

Yes. When budget records are split by business transaction (VORGA), original budget, supplements and returns can be shown in separate columns.

Does it work on S/4HANA?

Yes. BPJA and BPGE are still used on S/4HANA; COSP and COSS are read as compatibility views and actuals come from ACDOCA.

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: Internal Order Budget Availability Report