Project Stock Left on Technically Completed or Closed WBS Elements Report
Short answer: A custom ALV report that lists project stock (special stock Q) still sitting on technically completed (TECO) or closed (CLSD) WBS elements with material, storage location, quantity, value, last movement date and days since the status was set. It gives a suggestion for every line: move to own stock, transfer to another project or scrap.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB52 and MMBE show project stock by WBS element but do not know the WBS status (TECO, CLSD) or the status date; CN41N shows the status but not the stock. Material forgotten on closed projects therefore stays in project stock for years, and with valuated project stock its value stays tied to the closed project.
Who uses it? Project controllers, warehouse and inventory control teams, project offices responsible for project close-out.
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 |
|---|---|---|---|
| MSPRProject Stock | Project stock: material, plant, storage location, WBS, unrestricted and blocked quantity (driving table) | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element: external number, description, object number | PRPS-PSPNR = MSPR-PSPNR | ECC + S/4 |
| PROJProject Definition | Project definition | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| JESTIndividual Object Status | WBS system status (TECO, CLSD) | JEST-OBJNR = PRPS-OBJNR | ECC + S/4 |
| JCDSChange Documents for System/User Statuses | Date the status was set | JCDS-OBJNR = PRPS-OBJNR AND JCDS-STAT = JEST-STAT | ECC + S/4 |
| QBEWProject Stock Valuation | Valuated project stock: quantity and value | QBEW-MATNR = MSPR-MATNR AND QBEW-BWKEY = MSPR-WERKS AND QBEW-PSPNR = MSPR-PSPNR | ECC + S/4 |
| MBEWMaterial Valuation | Material price for non-valuated project stock | MBEW-MATNR = MSPR-MATNR AND MBEW-BWKEY = MSPR-WERKS | ECC + S/4 |
| MSEGMaterial Document Item | Last project stock movement | MSEG-MATNR = MSPR-MATNR AND MSEG-WERKS = MSPR-WERKS AND MSEG-MAT_PSPNR = MSPR-PSPNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MSPR-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARAGeneral Material Data | Base unit of measure | MARA-MATNR = MSPR-MATNR | ECC + S/4 |
S/4HANA notes
- MSPR → MATDOC: In S/4HANA stock quantities are derived from MATDOC; reads on MSPR are served through the compatibility view NSDM_V_MSPR.
- QBEW: In S/4HANA QBEW is read through the compatibility view MBVQBEW. Reading code keeps working, but nothing should write to the table directly.
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | No | P-25-0088 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-25-0088-03 |
| S_WERKS | Plant | Range / multiple | MSPR-WERKS | Yes | 1100 |
| S_MATNR | Material | Range / multiple | MSPR-MATNR | No | RM-2040 |
| P_TECO | Technically completed (TECO) WBS elements | Checkbox | — | No | X |
| P_CLSD | Closed (CLSD) WBS elements | Checkbox | — | No | X |
| P_MINVAL | Minimum stock value to show | Single value | — | No | 100 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | WBS description | PRPS-POST1 |
| 4 | WBS status | Calculated Active TECO or CLSD status in JEST |
| 5 | Status date | JCDS-UDATE |
| 6 | Plant | MSPR-WERKS |
| 7 | Storage location | MSPR-LGORT |
| 8 | Material | MSPR-MATNR |
| 9 | Description | MAKT-MAKTX |
| 10 | Unrestricted qty | MSPR-PRLAB |
| 11 | Blocked qty | MSPR-PRSPE |
| 12 | Unit | MARA-MEINS |
| 13 | Stock value | Calculated QBEW-SALK3 ÷ QBEW-LBKUM × qty (MBEW price × qty if non-valuated) |
| 14 | Last movement | Calculated Latest MSEG-BUDAT_MKPF (SOBKZ = Q, same WBS) |
| 15 | Days since status | Calculated Key date − JCDS-UDATE |
| 16 | Suggestion | Calculated Review/scrap if blocked, 415 Q if another project needs it, otherwise 411 Q |
Sample output
| Project | WBS element | WBS description | WBS status | Status date | Plant | Storage location | Material | Description | Unrestricted qty | Blocked qty | Unit | Stock value | Last movement | Days since status | Suggestion |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-25-0088 | P-25-0088-03 | Installation and commissioning | TECO | 06/30/2026 | 1100 | 1000 | RM-2040 | Galvanised sheet 1.5 mm | 420 | 0 | KG | 25,704 | 05/12/2026 | 140 | Transfer to another project (415 Q) |
| P-25-0102 | P-25-0102-01 | Electrical infrastructure | CLSD | 03/31/2026 | 1100 | 1000 | EL-7720 | Cable NYY 4x16 | 1,800 | 0 | M | 64,800 | 02/18/2026 | 231 | Move to own stock (411 Q) |
| P-26-0003 | P-26-0003-02 | Mechanical installation | TECO | 10/15/2026 | 1200 | 2000 | PK-1180 | Corrugated box 40x60 | 0 | 250 | PC | 463 | 10/02/2026 | 33 | Review blocked stock or scrap it |
How does the report work?
- Special stock Q records are read from MSPR; those with unrestricted (PRLAB), quality (PRINS) or blocked (PRSPE) quantity above zero remain.
- The WBS element is read from PRPS with MSPR-PSPNR and the project from PROJ. Active TECO (I0045) and CLSD (I0046) statuses are read from JEST and the date the status was set (UDATE) from JCDS; WBS elements without one of the selected statuses are excluded.
- Value: for valuated project stock QBEW-SALK3 ÷ QBEW-LBKUM × quantity; for non-valuated project stock the MBEW price (STPRS or VERPR ÷ PEINH) is used.
- The last movement date is the latest MSEG-BUDAT_MKPF for the same material, plant and WBS element (MAT_PSPNR, SOBKZ = Q). Days since status = key date − JCDS-UDATE.
- Suggestion rule: blocked quantity leads to review or scrapping, an open project needing the same material leads to transfer to another project (415 Q), all others to moving into own stock (411 Q). Lines below the minimum value can be hidden.
Performance notes
MSPR is usually a small table; MSPR is read first and the WBS list is derived from it. The last movement read in MSEG is done only for the listed material and WBS pairs.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The WBS element opens CJ20N, the material opens MMBE and the last movement opens MB51.
- Export to Excel
- Runs as a background job
- Send the result by email Each project manager can receive the stock list of their own closed projects monthly.
Authorization objects
- C_PROJ_KOKProject display authorization by controlling area
- M_MSEG_WWAGoods movement authorization by plant (for transfers started from the report)
Frequently asked questions
Does the report post the stock transfer itself?
The default version only reads and gives a suggestion. Optionally it can be extended to post the 411 Q or 415 Q transfer for selected lines from the report with BAPI_GOODSMVT_CREATE.
What is the difference between valuated and non-valuated project stock?
With valuated project stock the value is kept in QBEW per WBS element and a transfer creates an accounting entry. With non-valuated stock the cost was already posted to the project at goods receipt; the report then shows a value with the MBEW price for information only.
Does the report work on S/4HANA?
Yes. MSPR and QBEW are read as compatibility views in S/4HANA and the MSEG read works through MATDOC; the PS status tables do not change.
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
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
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, …
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.