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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| AUFKOrder Master Data | Internal 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-OBJNR | ECC + S/4 |
| BPGETotals Record for Overall Value (CO Object) | Overall budget (value type 41) | BPGE-OBJNR = AUFK-OBJNR | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Primary actual costs and commitments | COSP-OBJNR = AUFK-OBJNR | ECC + S/4 |
| COSSCO Object: Cost Totals for Internal Postings | Secondary actual costs | COSS-OBJNR = AUFK-OBJNR | ECC + S/4 |
| JESTIndividual Object Status | System status (created, released, technically complete, closed) | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| TKA01Controlling Areas | Controlling area currency | TKA01-KOKRS = AUFK-KOKRS | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | AUFK-KOKRS | Yes | 1000 |
| S_AUFNR | Internal order | Range / multiple | AUFK-AUFNR | No | 400100–400199 |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | 0400 |
| S_BUKRS | Company code | Range / multiple | AUFK-BUKRS | No | 1000 |
| P_GJAHR | Fiscal year | Single value | BPJA-GJAHR | Yes | 2026 |
| P_ANNUAL | Annual budget | Radio button | — | No | X |
| P_OVERAL | Overall budget | Radio button | — | No | — |
| P_WARN | Warning threshold (%) | Single value | — | No | 90 |
| P_CLOSED | Also show closed orders | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Order | AUFK-AUFNR |
| 2 | Description | AUFK-KTEXT |
| 3 | Order type | AUFK-AUART |
| 4 | Budget | Calculated BPJA-WLJHR (annual) or BPGE-WLGES (overall), value type 41 |
| 5 | Actual | Calculated COSP + COSS, value type 04 |
| 6 | Commitment | Calculated COSP, value types 21 and 22 |
| 7 | Assigned | Calculated Actual + commitment |
| 8 | Available budget | Calculated Budget − assigned |
| 9 | Consumption (%) | Calculated Assigned / budget × 100 |
| 10 | System status | Calculated Short text of the active system statuses in JEST |
| 11 | Light | Calculated Consumption < P_WARN green, P_WARN–100 yellow, > 100 red |
| 12 | Currency | TKA01-WAERS |
Sample output
| Order | Description | Order type | Budget | Actual | Commitment | Assigned | Available budget | Consumption (%) | System status | Light | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 400120 | November trade fair | 0400 | 650,000 | 512,300 | 88,000 | 600,300 | 49,700 | 92 | REL | Yellow | TRY |
| 400133 | Digital advertising Q4 | 0400 | 400,000 | 410,250 | 0 | 410,250 | -10,250 | 103 | REL | Red | TRY |
| 400141 | Warehouse racking renewal | 0400 | 1,200,000 | 265,000 | 540,000 | 805,000 | 395,000 | 67 | REL | Green | TRY |
| 400097 | Dealer meeting | 0400 | 180,000 | 176,400 | 0 | 176,400 | 3,600 | 98 | TECO | Yellow | TRY |
How does the report work?
- 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.
- 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.
- Actual: value type 04 in COSP and COSS; only P_GJAHR in the annual view, all years in the overall view.
- Commitment: value types 21 and 22 in COSP.
- 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
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 …
Mass Internal Order Creation from Excel with Settlement Rule
A custom program that creates internal orders in bulk from file rows, with order type, company code, responsible cost center and profit center, and …
Orders Without Settlement Rule or With Unsettled Balance Report
A custom ALV report that lists orders that received costs but have no settlement rule, and internal and production orders that still carry a balance …
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.