PS Report Custom development ALV report

Technically Completed WBS Elements with Unsettled Balance Report

Short answer: 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.

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

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.

Who uses it? Project controllers, cost accounting and period-end closing teams.

Closest standard alternatives

  • CJ8G Actual Settlement: Projects/Networks (Collective). Runs collective settlement; does not list closed WBS elements with a balance in advance.
  • CJ88 Settle Projects and Networks. Settles one project and gives the log of that run.

Tables used

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

TableRoleJoinSystem
PRPSWBS Element Master DataWBS element, object number, company code and responsible person (driving table)—ECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
JESTIndividual Object StatusActive system status (TECO, CLSD)JEST-OBJNR = PRPS-OBJNRECC + S/4
JCDSChange Documents for System/User StatusesDate the status was setJCDS-OBJNR = JEST-OBJNR AND JCDS-STAT = JEST-STAT AND JCDS-CHGNR = JEST-CHGNRECC + S/4
TJ02TSystem Status TextsSystem status textTJ02T-ISTAT = JEST-STAT AND TJ02T-SPRAS = SY-LANGUECC + S/4
COSPCO Object: Cost Totals for External PostingsActual cost and settlement totals (balance)COSP-OBJNR = PRPS-OBJNRECC + S/4
COBRBSettlement Rule Distribution RulesSettlement rule: receiver category, receiver and percentageCOBRB-OBJNR = PRPS-OBJNRECC + S/4
TKA01Controlling AreasControlling area currencyTKA01-KOKRS = PRPS-PKOKRECC + S/4

S/4HANA notes

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

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PBUKRCompany codeRange / multiplePRPS-PBUKRYes1000
S_PSPIDProject definitionRange / multiplePROJ-PSPIDNoP-25-*
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-25-0031-*
P_GJAHRFiscal yearSingle valueCOSP-GJAHRYes2026
P_PERIOUp to periodSingle value—Yes10
R_TECOTechnically completed (TECO)Radio button—NoX
R_CLSDClosed (CLSD)Radio button—No—
P_MINMinimum balance amountSingle value—No1

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4Company codePRPS-PBUKR
5ResponsiblePRPS-VERNA
6StatusTJ02T-TXT04
7Status dateJCDS-UDATE
8BalanceCalculated Σ COSP-WKG001…WKG016 (WRTTP = 04, settlement included) up to the selected period
9CurrencyTKA01-WAERS
10Receiver categoryCOBRB-KONTY
11ReceiverCalculated COBRB-KOSTL, COBRB-ANLN1, COBRB-HKONT or COBRB-PS_PSP_PNR depending on the receiver category
12PercentageCOBRB-PROZS
13ActionCalculated "Rule missing" without a rule, otherwise "settlement not run"

Sample output

ProjectWBS elementDescriptionCompany codeResponsibleStatusStatus dateBalanceCurrencyReceiver categoryReceiverPercentageAction
P-25-0031P-25-0031-01Line modernization1000M. DemirTECO09/30/2026184,500TRYAUC40000125100Settlement not run
P-25-0031P-25-0031-03Commissioning1000E. KayaTECO10/15/202637,250TRY0Rule missing
P-25-0040P-25-0040-02Laboratory renewal1000S. ArslanTECO08/22/20269,800TRYKSTCC4100100Settlement not run
A view built with fictional sample data; not real system data.

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.

Performance notes

Read JEST by status and object number prefix (PR), and take the COSP totals only for the object numbers found with GROUP BY OBJNR. The report should run as a step of the period-end closing schedule, before settlement.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the WBS element opens CJ20N; clicking the balance opens CJI3.
  • Export to Excel
  • Runs as a background job Can run in the period-end closing schedule before settlement.

Authorization objects

  • C_PROJ_KOKProject display authorization by controlling area
  • C_PRPS_PRCWBS 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.

Packages that include this solution

PS Package Custom

Project Closing Control Pack

A five-component pack for closing projects without leaving open items behind: a technical completion readiness check, reconciliation of project …

5 components · v1.0

Related reports

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: Technically Completed WBS Elements with Unsettled Balance Report