PS Report Custom development ALV report

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

  • MB52 List of Warehouse Stocks on Hand. Lists project stock by WBS element; has no WBS status or status date.
  • MMBE Stock Overview. Shows the project stock of one material; cannot find closed projects collectively.

Tables used

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

TableRoleJoinSystem
MSPRProject StockProject stock: material, plant, storage location, WBS, unrestricted and blocked quantity (driving table)—ECC + S/4
PRPSWBS Element Master DataWBS element: external number, description, object numberPRPS-PSPNR = MSPR-PSPNRECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
JESTIndividual Object StatusWBS system status (TECO, CLSD)JEST-OBJNR = PRPS-OBJNRECC + S/4
JCDSChange Documents for System/User StatusesDate the status was setJCDS-OBJNR = PRPS-OBJNR AND JCDS-STAT = JEST-STATECC + S/4
QBEWProject Stock ValuationValuated project stock: quantity and valueQBEW-MATNR = MSPR-MATNR AND QBEW-BWKEY = MSPR-WERKS AND QBEW-PSPNR = MSPR-PSPNRECC + S/4
MBEWMaterial ValuationMaterial price for non-valuated project stockMBEW-MATNR = MSPR-MATNR AND MBEW-BWKEY = MSPR-WERKSECC + S/4
MSEGMaterial Document ItemLast project stock movementMSEG-MATNR = MSPR-MATNR AND MSEG-WERKS = MSPR-WERKS AND MSEG-MAT_PSPNR = MSPR-PSPNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MSPR-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MARAGeneral Material DataBase unit of measureMARA-MATNR = MSPR-MATNRECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProject definitionRange / multiplePROJ-PSPIDNoP-25-0088
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-25-0088-03
S_WERKSPlantRange / multipleMSPR-WERKSYes1100
S_MATNRMaterialRange / multipleMSPR-MATNRNoRM-2040
P_TECOTechnically completed (TECO) WBS elementsCheckbox—NoX
P_CLSDClosed (CLSD) WBS elementsCheckbox—NoX
P_MINVALMinimum stock value to showSingle value—No100
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3WBS descriptionPRPS-POST1
4WBS statusCalculated Active TECO or CLSD status in JEST
5Status dateJCDS-UDATE
6PlantMSPR-WERKS
7Storage locationMSPR-LGORT
8MaterialMSPR-MATNR
9DescriptionMAKT-MAKTX
10Unrestricted qtyMSPR-PRLAB
11Blocked qtyMSPR-PRSPE
12UnitMARA-MEINS
13Stock valueCalculated QBEW-SALK3 ÷ QBEW-LBKUM × qty (MBEW price × qty if non-valuated)
14Last movementCalculated Latest MSEG-BUDAT_MKPF (SOBKZ = Q, same WBS)
15Days since statusCalculated Key date − JCDS-UDATE
16SuggestionCalculated Review/scrap if blocked, 415 Q if another project needs it, otherwise 411 Q

Sample output

ProjectWBS elementWBS descriptionWBS statusStatus datePlantStorage locationMaterialDescriptionUnrestricted qtyBlocked qtyUnitStock valueLast movementDays since statusSuggestion
P-25-0088P-25-0088-03Installation and commissioningTECO06/30/202611001000RM-2040Galvanised sheet 1.5 mm4200KG25,70405/12/2026140Transfer to another project (415 Q)
P-25-0102P-25-0102-01Electrical infrastructureCLSD03/31/202611001000EL-7720Cable NYY 4x161,8000M64,80002/18/2026231Move to own stock (411 Q)
P-26-0003P-26-0003-02Mechanical installationTECO10/15/202612002000PK-1180Corrugated box 40x600250PC46310/02/202633Review blocked stock or scrap it
A view built with fictional sample data; not real system data.

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.

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

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

MM Report Custom ALV report

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, …

MARD · MARA · MAKT · MBEW

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: Project Stock Left on Technically Completed or Closed WBS Elements Report