# 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 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.

- 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/project-stock-left-on-technically-completed-or-closed-wbs-elements-report/


## 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.

### Closest standard alternatives

- MB52: Lists project stock by WBS element; has no WBS status or status date.
- MMBE: Shows the project stock of one material; cannot find closed projects collectively.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MSPR | Project stock: material, plant, storage location, WBS, unrestricted and blocked quantity (driving table) | Read | - | ECC + S/4 |
| PRPS | WBS element: external number, description, object number | Read | PRPS-PSPNR = MSPR-PSPNR | ECC + S/4 |
| PROJ | Project definition | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| JEST | WBS system status (TECO, CLSD) | Read | JEST-OBJNR = PRPS-OBJNR | ECC + S/4 |
| JCDS | Date the status was set | Read | JCDS-OBJNR = PRPS-OBJNR AND JCDS-STAT = JEST-STAT | ECC + S/4 |
| QBEW | Valuated project stock: quantity and value | Read | QBEW-MATNR = MSPR-MATNR AND QBEW-BWKEY = MSPR-WERKS AND QBEW-PSPNR = MSPR-PSPNR | ECC + S/4 |
| MBEW | Material price for non-valuated project stock | Read | MBEW-MATNR = MSPR-MATNR AND MBEW-BWKEY = MSPR-WERKS | ECC + S/4 |
| MSEG | Last project stock movement | Read | MSEG-MATNR = MSPR-MATNR AND MSEG-WERKS = MSPR-WERKS AND MSEG-MAT_PSPNR = MSPR-PSPNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MSPR-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARA | Base unit of measure | Read | MARA-MATNR = MSPR-MATNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | No |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_WERKS | Plant | Range / multiple | MSPR-WERKS | Yes |
| S_MATNR | Material | Range / multiple | MSPR-MATNR | No |
| P_TECO | Technically completed (TECO) WBS elements | Checkbox | - | No |
| P_CLSD | Closed (CLSD) WBS elements | Checkbox | - | No |
| P_MINVAL | Minimum stock value to show | Single value | - | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| WBS description | PRPS-POST1 |
| WBS status | Calculated: Active TECO or CLSD status in JEST |
| Status date | JCDS-UDATE |
| Plant | MSPR-WERKS |
| Storage location | MSPR-LGORT |
| Material | MSPR-MATNR |
| Description | MAKT-MAKTX |
| Unrestricted qty | MSPR-PRLAB |
| Blocked qty | MSPR-PRSPE |
| Unit | MARA-MEINS |
| Stock value | Calculated: QBEW-SALK3 ÷ QBEW-LBKUM × qty (MBEW price × qty if non-valuated) |
| Last movement | Calculated: Latest MSEG-BUDAT_MKPF (SOBKZ = Q, same WBS) |
| Days since status | Calculated: Key date − JCDS-UDATE |
| Suggestion | Calculated: Review/scrap if blocked, 415 Q if another project needs it, otherwise 411 Q |

## How does the report work?

1. Special stock Q records are read from MSPR; those with unrestricted (PRLAB), quality (PRINS) or blocked (PRSPE) quantity above zero remain.
2. 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.
3. Value: for valuated project stock QBEW-SALK3 ÷ QBEW-LBKUM × quantity; for non-valuated project stock the MBEW price (STPRS or VERPR ÷ PEINH) is used.
4. 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.
5. 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.

## Authorization objects

- C_PROJ_KOK: Project display authorization by controlling area
- M_MSEG_WWA: Goods 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-project-stock-on-completed-wbs
