# Technically Completed WBS Elements with Unsettled Balance Report

> A custom ALV report that lists technically completed (TECO) or closed WBS elements that still carry a cost balance, with status date, balance, settlement rule and receiver. At period-end closing it shows unsettled projects or projects with a missing rule in advance.

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/technically-completed-wbs-unsettled-balance-report/


## Why is the standard not enough?

CJ8G and CJ88 run settlement and only give the error log of that run. No standard report lists in advance the technically completed or closed WBS elements whose balance is not zero, whose settlement rule is missing or whose receiver is not suitable. Closing teams do this check by combining status lists and cost reports.

### Closest standard alternatives

- CJ8G: Runs collective settlement; does not list closed WBS elements with a balance in advance.
- CJ88: Settles one project and gives the log of that run.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PRPS | WBS element, object number, company code and responsible person (driving table) | Read | - | ECC + S/4 |
| PROJ | Project definition | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| JEST | Active system status (TECO, CLSD) | Read | JEST-OBJNR = PRPS-OBJNR | ECC + S/4 |
| JCDS | Date the status was set | Read | JCDS-OBJNR = JEST-OBJNR AND JCDS-STAT = JEST-STAT AND JCDS-CHGNR = JEST-CHGNR | ECC + S/4 |
| TJ02T | System status text | Read | TJ02T-ISTAT = JEST-STAT AND TJ02T-SPRAS = SY-LANGU | ECC + S/4 |
| COSP | Actual cost and settlement totals (balance) | Read | COSP-OBJNR = PRPS-OBJNR | ECC + S/4 |
| COBRB | Settlement rule: receiver category, receiver and percentage | Read | COBRB-OBJNR = PRPS-OBJNR | ECC + S/4 |
| TKA01 | Controlling area currency | Read | TKA01-KOKRS = PRPS-PKOKR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | Yes |
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | No |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| P_GJAHR | Fiscal year | Single value | COSP-GJAHR | Yes |
| P_PERIO | Up to period | Single value | - | Yes |
| R_TECO | Technically completed (TECO) | Radio button | - | No |
| R_CLSD | Closed (CLSD) | Radio button | - | No |
| P_MIN | Minimum balance amount | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| Description | PRPS-POST1 |
| Company code | PRPS-PBUKR |
| Responsible | PRPS-VERNA |
| Status | TJ02T-TXT04 |
| Status date | JCDS-UDATE |
| Balance | Calculated: Σ COSP-WKG001…WKG016 (WRTTP = 04, settlement included) up to the selected period |
| Currency | TKA01-WAERS |
| Receiver category | COBRB-KONTY |
| Receiver | Calculated: COBRB-KOSTL, COBRB-ANLN1, COBRB-HKONT or COBRB-PS_PSP_PNR depending on the receiver category |
| Percentage | COBRB-PROZS |
| Action | Calculated: "Rule missing" without a rule, otherwise "settlement not run" |

## How does the report work?

1. PRPS is read by project, WBS and company code. Elements whose active (INACT blank) system status in JEST is TECO (I0045) or CLSD (I0046) remain; the date the status was set comes from JCDS-UDATE and the text from TJ02T.
2. Balance = sum of WKG001…WKG016 of the actual values (WRTTP = 04) in COSP up to the selected fiscal year and period; settlement postings (BEKNZ = A) are included. Balances below the threshold are skipped.
3. The settlement rule is read from COBRB: receiver category (KONTY), receiver (KOSTL, ANLN1, HKONT or PS_PSP_PNR) and percentage (PROZS).
4. Action: "rule missing" if there is no rule, otherwise "settlement not run".
5. The currency comes from the controlling area (TKA01); the ALV shows subtotals by company code and project.

## Authorization objects

- C_PROJ_KOK: Project display authorization by controlling area
- C_PRPS_PRC: WBS element authorization by profit center

## Frequently asked questions

### Does the report run settlement itself?

No. The report only lists. Settlement is run with CJ8G or CJ88; the report is used to fix missing rules before that run.

### How does it work for capital projects (AUC)?

Rules with an AUC or fixed asset receiver are shown as well. The split between full settlement (FUL) and periodic settlement (PER) is visible in the rule lines.

### Does this report work on S/4HANA?

Yes. In S/4HANA COSP is read from ACDOCA as a compatibility view, and the report keeps using the same fields. JEST, JCDS and COBRB keep the same structure.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-closed-wbs-unsettled-balance
