# Internal Order Budget Availability Report

> 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.

- 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/internal-order-budget-availability-report/


## 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.

### Closest standard alternatives

- KOB1: Lists the order's actual line items; gives no budget or remaining amount.
- KO03: Shows order master data and budget one at a time; no comparison across many orders.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AUFK | Internal order master: type, description, company code, object number (driving table) | Read | - | ECC + S/4 |
| BPJA | Annual budget totals (value type 41) | Read | BPJA-OBJNR = AUFK-OBJNR | ECC + S/4 |
| BPGE | Overall budget (value type 41) | Read | BPGE-OBJNR = AUFK-OBJNR | ECC + S/4 |
| COSP | Primary actual costs and commitments | Read | COSP-OBJNR = AUFK-OBJNR | ECC + S/4 |
| COSS | Secondary actual costs | Read | COSS-OBJNR = AUFK-OBJNR | ECC + S/4 |
| JEST | System status (created, released, technically complete, closed) | Read | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| TKA01 | Controlling area currency | Read | TKA01-KOKRS = AUFK-KOKRS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | AUFK-KOKRS | Yes |
| S_AUFNR | Internal order | Range / multiple | AUFK-AUFNR | No |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No |
| S_BUKRS | Company code | Range / multiple | AUFK-BUKRS | No |
| P_GJAHR | Fiscal year | Single value | BPJA-GJAHR | Yes |
| P_ANNUAL | Annual budget | Radio button | - | No |
| P_OVERAL | Overall budget | Radio button | - | No |
| P_WARN | Warning threshold (%) | Single value | - | No |
| P_CLOSED | Also show closed orders | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Order | AUFK-AUFNR |
| Description | AUFK-KTEXT |
| Order type | AUFK-AUART |
| Budget | Calculated: BPJA-WLJHR (annual) or BPGE-WLGES (overall), value type 41 |
| Actual | Calculated: COSP + COSS, value type 04 |
| Commitment | Calculated: COSP, value types 21 and 22 |
| Assigned | Calculated: Actual + commitment |
| Available budget | Calculated: Budget − assigned |
| Consumption (%) | Calculated: Assigned / budget × 100 |
| System status | Calculated: Short text of the active system statuses in JEST |
| Light | Calculated: Consumption < P_WARN green, P_WARN–100 yellow, > 100 red |
| Currency | TKA01-WAERS |

## 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.

## Authorization objects

- K_ORDER: Internal 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-internal-order-budget-availability
