CO Report Custom development ALV report

Orders Without Settlement Rule or With Unsettled Balance Report

Short answer: 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 after the period-end settlement. It surfaces costs left behind on orders at the month-end close.

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

Why is the standard not enough?

KO88 only gives an error log for the orders included in the run; orders without a rule stay as messages in the log and there is no consolidated check list after the close. KO03 shows the settlement rule per order. Costs left on orders at month end are therefore usually noticed later, when reports do not reconcile.

Who uses it? Controllers, CO teams running the month-end close and production cost owners.

Closest standard alternatives

  • KO88 Actual Settlement: Order. Settles orders and reports errors in a log; offers no consolidated check list after the close.
  • KO03 Display Internal Order. Shows the settlement rule per order.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataOrder master: category, type, description, object number (driving table)—ECC + S/4
COBRASettlement Rule for Order SettlementSettlement rule header and settlement profileCOBRA-OBJNR = AUFK-OBJNRECC + S/4
COBRBSettlement Rule Distribution RulesDistribution rules: receiver type, receiver, percentage, validityCOBRB-OBJNR = AUFK-OBJNRECC + S/4
COSPCO Object: Cost Totals for External PostingsPrimary actual costs and settlement creditsCOSP-OBJNR = AUFK-OBJNRECC + S/4
COSSCO Object: Cost Totals for Internal PostingsSecondary actual costs and settlement creditsCOSS-OBJNR = AUFK-OBJNRECC + S/4
JESTIndividual Object StatusSystem status (REL, TECO, DLV, CLSD)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_AUFNROrderRange / multipleAUFK-AUFNRNo—
S_AUTYPOrder categoryRange / multipleAUFK-AUTYPNo01, 10
S_AUARTOrder typeRange / multipleAUFK-AUARTNo0400
P_GJAHRFiscal yearSingle valueCOSS-GJAHRYes2026
P_PERIOPeriodSingle value—Yes10
P_NORULEOnly orders without a ruleRadio button—No—
P_ALLOrders without a rule and with a balanceRadio button—NoX
P_TOLAMTBalance toleranceSingle value—No1

Output columns

#ColumnSource
1OrderAUFK-AUFNR
2DescriptionAUFK-KTEXT
3CategoryAUFK-AUTYP
4Order typeAUFK-AUART
5Created onAUFK-ERDAT
6System statusCalculated Short text of the active system statuses in JEST
7Rule existsCalculated A COBRB line valid in the period with a percentage total > 0
8ReceiverCalculated COBRB-KONTY and the receiver object (KOSTL, AUFNR, HKONT, ANLN1…)
9Period debitCalculated Non-settlement debits in P_PERIO, COSP + COSS value type 04
10BalanceCalculated COSP + COSS value type 04 total from the start of the year to P_PERIO (settlement included)
11IssueCalculated No rule, period not settled, or balance after settlement
12CurrencyTKA01-WAERS

Sample output

OrderDescriptionCategoryOrder typeCreated onSystem statusRule existsReceiverPeriod debitBalanceIssueCurrency
400152Office relocation costs01040009/08/2026RELNo84,60084,600No rule, costs postedTRY
400118Dealer training programme01040003/14/2026TECOYesCost center 430018,50018,500Period not settledTRY
1000081Plastic crate 40 L10PP0110/02/2026DLVYesMaterial 300045012,840Balance after settlementTRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. Orders matching the selection (internal orders, production orders and other categories) are read from AUFK; the active system status comes from JEST and closed orders are skipped.
  2. Settlement rule: the COBRA header and the COBRB distribution rules are read; if there is no rule valid in the selected period, or the percentages add up to zero, the status is “No rule”.
  3. Balance: value type 04 amounts in COSP and COSS, settlement credits included, are summed from the start of the fiscal year up to P_PERIO. If the absolute balance exceeds P_TOLAMT, the status is “Balance after settlement”.
  4. The period debit is the non-settlement debit posted in the selected period; it highlights orders that receive costs without a rule.
  5. For production orders, a balance in status delivered (DLV) or technically complete (TECO) is flagged separately as an unsettled variance or work in process.

Performance notes

First find the objects with a balance from the COSP/COSS totals, then read COBRA/COBRB and JEST only for those orders. This order of reads shortens the runtime noticeably for large numbers of orders.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order opens KO03, or KKBC_ORD for production orders.
  • Export to Excel
  • Runs as a background job Can run in the close calendar right after the settlement jobs.
  • Send the result by email

Authorization objects

  • K_ORDERInternal order display authorization by order type
  • C_AFKO_AWKProduction order authorization by plant and order type

Frequently asked questions

Are statistical orders listed too?

No. Statistical orders are not settled, so they are excluded by default; they can be made visible with a separate selection if needed.

Is a balance on a production order always an error?

No. On orders that are not fully delivered, the balance is work in process and is normal. The report flags separately the balance left on delivered or technically complete orders; this is usually an unsettled variance.

Does it work on S/4HANA?

Yes. COBRA, COBRB and JEST are used the same way; COSP and COSS are read as compatibility views and actuals come from ACDOCA.

Packages that include this solution

FI Package Custom

Month-End Close Control Pack

A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …

5 components · v1.0

Related reports

CO Report Custom ALV report

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 …

AUFK · BPJA · BPGE · COSP

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: Orders Without Settlement Rule or With Unsettled Balance Report