PS Report Custom development ALV report

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

  • CJ20N Project Builder. Open-item warnings appear element by element and only when TECO is set; no advance bulk checklist.
  • CN43N Overview: WBS Elements. Lists WBS elements with their status; no check of open orders, reservations, billing plans or balances.

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: description, responsible person, object number (driving table)—ECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
JESTIndividual Object StatusSystem statuses: REL, TECO, CLSDJEST-OBJNR = PRPS-OBJNRECC + S/4
EKKNAccount Assignment in Purchasing DocumentOrder items with account assignment to the WBS elementEKKN-PS_PSP_PNR = PRPS-PSPNRECC + S/4
EKPOPurchasing Document ItemOrder item: value, deletion and delivery completed flagsEKPO-EBELN = EKKN-EBELN AND EKPO-EBELP = EKKN-EBELPECC + S/4
EBKNPurchase Requisition Account AssignmentRequisitions with account assignment to the WBS elementEBKN-PS_PSP_PNR = PRPS-PSPNRECC + S/4
EBANPurchase RequisitionRequisition item: quantity and ordered quantityEBAN-BANFN = EBKN-BANFN AND EBAN-BNFPO = EBKN-BNFPOECC + S/4
RESBReservation/Dependent RequirementsOpen reservations linked to the WBS elementRESB-PSPEL = PRPS-PSPNRECC + S/4
VBAPSales Document ItemSales order item assigned to the WBS elementVBAP-PS_PSP_PNR = PRPS-PSPNRECC + S/4
FPLABilling PlanBilling plan of the orderFPLA-VBELN = VBAP-VBELNECC + S/4
FPLTBilling Plan DatesBilling plan dates: value and billing statusFPLT-FPLNR = FPLA-FPLNRECC + S/4
COSPCO Object: Cost Totals for External PostingsActual balance still to settleCOSP-OBJNR = PRPS-OBJNRECC + 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_PSPIDProjectRange / multiplePROJ-PSPIDYesP-26015
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26015*
S_VERNRResponsible person numberRange / multiplePRPS-VERNRNo12
S_PBUKRCompany codeRange / multiplePRPS-PBUKRYes1000
P_BALTOLBalance toleranceSingle value—No100
P_ONLYBLOnly WBS elements with blockersCheckbox—No—
P_INCTECAlso check elements already in TECOCheckbox—No—

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4ResponsiblePRPS-VERNA
5System statusCalculated Text of the active statuses in JEST (e.g. REL, TECO)
6Open PO itemsCalculated Number of items with EKPO-LOEKZ and EKPO-ELIKZ blank
7Open PO valueCalculated Σ EKPO-NETWR (open items)
8Open requisition itemsCalculated Number of items with EBAN-BSMNG < EBAN-MENGE and LOEKZ blank
9Open reservationsCalculated Number of items with RESB-KZEAR and XLOEK blank and BDMNG > ENMNG
10Unbilled billing plan valueCalculated Σ FPLT-FAKWR (FKSAF ≠ C)
11Balance to settleCalculated Σ COSP actual (WRTTP 04), all periods
12CurrencyCOSP-TWAER
13ReadinessCalculated Ready if all checks are clean, otherwise Blocked
14Blocking reasonsCalculated List of the checks that are not zero

Sample output

ProjectWBS elementDescriptionResponsibleSystem statusOpen PO itemsOpen PO valueOpen requisition itemsOpen reservationsUnbilled billing plan valueBalance to settleCurrencyReadinessBlocking reasons
P-26008P-26008-01DesignProje Lideri AREL000000TRYReady
P-26008P-26008-02FabricationProje Lideri BREL284,500030412,300TRYBlockedOpen PO, open reservation, balance
P-26008P-26008-03CommissioningProje Lideri CREL0010250,0000TRYBlockedOpen requisition, unbilled billing plan
P-26011P-26011-01Site worksProje Lideri DREL0000045TRYReadyBalance within tolerance
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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).
  3. Open requisitions: EBAN items linked via EBKN that are not deleted and whose ordered quantity is below the requisition quantity.
  4. Open reservations: items linked via RESB-PSPEL without the final issue flag (KZEAR) or deletion flag and with BDMNG > ENMNG.
  5. 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).
  6. 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

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: WBS Technical Completion (TECO) Readiness Check Report for Open Items