WBS Technical Completion (TECO) Readiness Check Report for Open Items
Short answer: A custom ALV report that shows, on one row per WBS element that is a candidate for technical completion (TECO), whether there are open purchase orders, open requisitions, open reservations, unbilled billing plan dates and a balance still to settle. Project teams see what has to be cleared before closing, and post-closing surprises decrease.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 12
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
When the TECO status is set in CJ20N, warnings about open items appear only at that moment and element by element; there is no advance checklist for many WBS elements. CN43N lists WBS elements with their status but does not check open orders, reservations, billing plans or balances. The custom report collects all blockers in one list and separates the elements that are "ready to close".
Who uses it? Project managers, project control (PMO) teams and project accounting.
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 |
|---|---|---|---|
| PRPSWBS Element Master Data | WBS element: description, responsible person, object number (driving table) | — | ECC + S/4 |
| PROJProject Definition | Project definition | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| JESTIndividual Object Status | System statuses: REL, TECO, CLSD | JEST-OBJNR = PRPS-OBJNR | ECC + S/4 |
| EKKNAccount Assignment in Purchasing Document | Order items with account assignment to the WBS element | EKKN-PS_PSP_PNR = PRPS-PSPNR | ECC + S/4 |
| EKPOPurchasing Document Item | Order item: value, deletion and delivery completed flags | EKPO-EBELN = EKKN-EBELN AND EKPO-EBELP = EKKN-EBELP | ECC + S/4 |
| EBKNPurchase Requisition Account Assignment | Requisitions with account assignment to the WBS element | EBKN-PS_PSP_PNR = PRPS-PSPNR | ECC + S/4 |
| EBANPurchase Requisition | Requisition item: quantity and ordered quantity | EBAN-BANFN = EBKN-BANFN AND EBAN-BNFPO = EBKN-BNFPO | ECC + S/4 |
| RESBReservation/Dependent Requirements | Open reservations linked to the WBS element | RESB-PSPEL = PRPS-PSPNR | ECC + S/4 |
| VBAPSales Document Item | Sales order item assigned to the WBS element | VBAP-PS_PSP_PNR = PRPS-PSPNR | ECC + S/4 |
| FPLABilling Plan | Billing plan of the order | FPLA-VBELN = VBAP-VBELN | ECC + S/4 |
| FPLTBilling Plan Dates | Billing plan dates: value and billing status | FPLT-FPLNR = FPLA-FPLNR | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Actual balance still to settle | COSP-OBJNR = PRPS-OBJNR | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project | Range / multiple | PROJ-PSPID | Yes | P-26015 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26015* |
| S_VERNR | Responsible person number | Range / multiple | PRPS-VERNR | No | 12 |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | Yes | 1000 |
| P_BALTOL | Balance tolerance | Single value | — | No | 100 |
| P_ONLYBL | Only WBS elements with blockers | Checkbox | — | No | — |
| P_INCTEC | Also check elements already in TECO | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | Description | PRPS-POST1 |
| 4 | Responsible | PRPS-VERNA |
| 5 | System status | Calculated Text of the active statuses in JEST (e.g. REL, TECO) |
| 6 | Open PO items | Calculated Number of items with EKPO-LOEKZ and EKPO-ELIKZ blank |
| 7 | Open PO value | Calculated Σ EKPO-NETWR (open items) |
| 8 | Open requisition items | Calculated Number of items with EBAN-BSMNG < EBAN-MENGE and LOEKZ blank |
| 9 | Open reservations | Calculated Number of items with RESB-KZEAR and XLOEK blank and BDMNG > ENMNG |
| 10 | Unbilled billing plan value | Calculated Σ FPLT-FAKWR (FKSAF ≠ C) |
| 11 | Balance to settle | Calculated Σ COSP actual (WRTTP 04), all periods |
| 12 | Currency | COSP-TWAER |
| 13 | Readiness | Calculated Ready if all checks are clean, otherwise Blocked |
| 14 | Blocking reasons | Calculated List of the checks that are not zero |
Sample output
| Project | WBS element | Description | Responsible | System status | Open PO items | Open PO value | Open requisition items | Open reservations | Unbilled billing plan value | Balance to settle | Currency | Readiness | Blocking reasons |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26008 | P-26008-01 | Design | Proje Lideri A | REL | 0 | 0 | 0 | 0 | 0 | 0 | TRY | Ready | |
| P-26008 | P-26008-02 | Fabrication | Proje Lideri B | REL | 2 | 84,500 | 0 | 3 | 0 | 412,300 | TRY | Blocked | Open PO, open reservation, balance |
| P-26008 | P-26008-03 | Commissioning | Proje Lideri C | REL | 0 | 0 | 1 | 0 | 250,000 | 0 | TRY | Blocked | Open requisition, unbilled billing plan |
| P-26011 | P-26011-01 | Site works | Proje Lideri D | REL | 0 | 0 | 0 | 0 | 0 | 45 | TRY | Ready | Balance within tolerance |
How does the report work?
- PROJ and PRPS are read by project, WBS element, responsible person and company code. Active statuses come from JEST; elements that are released (REL) but not yet TECO or CLSD remain.
- Open orders: number and value of the EKPO items linked via EKKN-PS_PSP_PNR that are not deleted and not delivery-completed (ELIKZ blank).
- Open requisitions: EBAN items linked via EBKN that are not deleted and whose ordered quantity is below the requisition quantity.
- Open reservations: items linked via RESB-PSPEL without the final issue flag (KZEAR) or deletion flag and with BDMNG > ENMNG.
- Unbilled billing plan: value of the FPLA/FPLT dates of the sales order linked to the WBS element whose billing status is not complete (FKSAF ≠ C).
- Balance: total actual cost and revenue in COSP (WRTTP 04); above the tolerance, settlement is considered necessary. If all checks are clean the row is “ready”, otherwise the blocking reasons are listed.
Performance notes
First determine the candidate WBS elements via JEST, then read EKKN, EBKN, RESB and COSP once each with this WBS list via FOR ALL ENTRIES. If RESB has no secondary index on PSPEL, restrict the read by plant and date range.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The open PO count opens ME2J, the reservation count the CN52N component list and the balance CJI3 for that WBS element.
- Export to Excel
- Runs as a background job
- Send the result by email In the month-end closing week, blocked WBS elements can be sent to the responsible person.
Authorization objects
- C_PROJ_KOKProject display authorization by controlling area
- C_PRPS_KOKWBS element authorization by controlling area
- M_BEST_WRKOrder display authorization by plant
Frequently asked questions
Can WBS elements shown as ready be closed from the report?
The report only reads. Ready elements can be selected and passed to the mass status change program, so TECO is given only to elements without blockers.
Why is the balance checked against a tolerance?
Small balances of a few units can remain due to exchange differences or rounding. A balance below the tolerance does not block closing but is shown as a note on the row.
Do the same checks apply in S/4HANA?
Yes. Status management (JEST), purchasing account assignments and reservations are the same in S/4HANA. For the balance, the COSP compatibility view or ACDOCA is read; MATDOC-based stock views can also be used for reservations in S/4HANA.
Packages that include this solution
Project Closing Control Pack
A five-component pack for closing projects without leaving open items behind: a technical completion readiness check, reconciliation of project …
Related reports
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, …
Project Stock Left on Technically Completed or Closed WBS Elements Report
A custom ALV report that lists project stock (special stock Q) still sitting on technically completed (TECO) or closed (CLSD) WBS elements with …
Mass TECO and Close (CLSD) Status Change Program for WBS Elements
A custom background program that runs selected WBS elements, or those listed in a file, through checks for open commitments, non-zero balance and open …
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.