Material Document and Stock Movement Analysis Report by Movement Type, Storage Location and User
Short answer: A custom ALV report that lists material documents with movement type, storage location, user and account assignment (cost center, order), matches reversed movements with their reversal documents to give the net quantity, shows the value and the reason for movement and flags back-dated postings. Warehouse, cost accounting and internal audit teams summarize stock movements in one list and find unusual postings quickly.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB51 lists material document items, but it does not match a reversed movement with its reversal document to show the net movement, does not flag the gap between posting date and entry date (back-dated postings) and gives no ready summary by movement type, user and day. MB5B gives opening and closing stock balances but does not analyze movements by user and account assignment. The custom report brings these checks together on one screen.
Who uses it? Warehouse supervisors, inventory control, cost accounting and internal audit teams.
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 |
|---|---|---|---|
| MKPFMaterial Document Header | Document header: posting and entry date, user (driving table) | — | ECC only |
| MSEGMaterial Document Item | Document items: movement type, quantity, value, account assignment, reversal reference | MSEG-MBLNR = MKPF-MBLNR AND MSEG-MJAHR = MKPF-MJAHR | ECC only |
| MATDOCMaterial Documents (S/4HANA) | In S/4HANA gives header and item fields in a single table | — | S/4HANA only |
| T156Movement Type | Movement type attributes and reversal movement type | T156-BWART = MSEG-BWART | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MSEG-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| T001LStorage Locations | Storage location name | T001L-WERKS = MSEG-WERKS AND T001L-LGORT = MSEG-LGORT | ECC + S/4 |
S/4HANA notes
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
- 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_BUDAT | Posting date | Range / multiple | MKPF-BUDAT | Yes | 01.11.2026 – 16.11.2026 |
| S_WERKS | Plant | Range / multiple | MSEG-WERKS | Yes | 1000 |
| S_LGORT | Storage location | Range / multiple | MSEG-LGORT | No | 0001 |
| S_BWART | Movement type | Range / multiple | MSEG-BWART | No | 201, 261, 551, 701 |
| S_MATNR | Material | Range / multiple | MSEG-MATNR | No | HM-1001 |
| S_USNAM | User | Range / multiple | MKPF-USNAM | No | DEPO01 |
| P_BACKD | Back-dated posting threshold (days) | Single value | — | No | 3 |
| P_NOREV | Hide reversed movement pairs | Checkbox | — | No | — |
| R_SUMM | Summary view (movement type, user, day) | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material document | MSEG-MBLNR |
| 2 | Item | MSEG-ZEILE |
| 3 | Posting date | MKPF-BUDAT |
| 4 | Entry date | MKPF-CPUDT |
| 5 | User | MKPF-USNAM |
| 6 | Movement type | MSEG-BWART |
| 7 | Material | MSEG-MATNR |
| 8 | Material description | MAKT-MAKTX |
| 9 | Storage location | MSEG-LGORT |
| 10 | Quantity (signed) | Calculated MSEG-MENGE; negative if SHKZG = H |
| 11 | Unit | MSEG-MEINS |
| 12 | Value | MSEG-DMBTR |
| 13 | Cost center | MSEG-KOSTL |
| 14 | Reason for movement | MSEG-GRUND |
| 15 | Reversal status | Calculated Reversed (with reversal document), reversal document or blank |
| 16 | Back-dated | Calculated CPUDT − BUDAT > threshold days |
Sample output
| Material document | Item | Posting date | Entry date | User | Movement type | Material | Material description | Storage location | Quantity (signed) | Unit | Value | Cost center | Reason for movement | Reversal status | Back-dated |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4900031177 | 1 | 11/12/2026 | 11/12/2026 | DEPO02 | 311 | SC-3300 | Sac levha 2 mm | 0003 | 350 | KG | 28,350 | No | |||
| 4900031190 | 1 | 10/31/2026 | 11/04/2026 | MALIYET1 | 201 | SP-0045 | Rulman 6204 | 0001 | -12 | ST | 1,860 | 4110 | Yes (4 days) | ||
| 4900031201 | 1 | 11/13/2026 | 11/13/2026 | DEPO01 | 551 | HM-1001 | Polipropilen granül | 0001 | -40 | KG | 3,480 | 0002 | Reversed (4900031215) | No | |
| 4900031215 | 1 | 11/13/2026 | 11/13/2026 | DEPO01 | 552 | HM-1001 | Polipropilen granül | 0001 | 40 | KG | 3,480 | Reversal document | No |
How does the report work?
- MKPF and MSEG are read by posting date, plant, storage location, movement type, material and user; in S/4HANA the same fields are read directly from MATDOC.
- Movement type attributes and text come from T156 and its text table, the material description from MAKT and the storage location name from T001L.
- Reversal matching: items with SMBLN, SJAHR and SMBLP filled are reversal documents; the reversed original item is found and both lines are flagged. The net quantity is the debit/credit-signed (SHKZG) quantity total of movements that were not reversed.
- The value comes from MSEG-DMBTR; the account assignment (cost center, order) and the reason for movement (GRUND) are shown on the same line.
- Back-dated posting: if the number of days between entry date (CPUDT) and posting date (BUDAT) exceeds the threshold parameter, the line is flagged; postings made to a previous period after closing become visible this way.
- The report opens with a detail and a summary view: the summary totals document count, quantity and value by movement type, user and day.
Performance notes
Start the selection with posting date and plant; the MKPF-BUDAT index and the MBLNR/MJAHR key of MSEG are used. For selection by material, check that an MATNR/WERKS index exists on MSEG. In S/4HANA MATDOC is a single table, so no join is needed and the summary view can be aggregated in the database.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the document number displays the material document in MIGO.
- Export to Excel
- Runs as a background job
Authorization objects
- M_MSEG_WMBMaterial document display authorization by plant
- M_MSEG_BWAAuthorization by movement type
- M_MSEG_LGOAuthorization by storage location
Frequently asked questions
How are reversed movements matched?
The reversal document item holds the number, year and item of the original document (SMBLN, SJAHR, SMBLP). The report uses this link to find the original item, flags both lines and can leave them out of the net calculation and the list.
Why do back-dated postings matter?
A stock movement posted to an earlier date after month-end closing changes the stock and cost figures of a closed period. Since postings above the threshold are flagged, the audit team can review them per user.
Does it work on S/4HANA?
Yes. In S/4HANA the report reads directly from MATDOC and aggregates the summary view in the database. If clean core is preferred, I_MaterialDocumentItem_2 can be used.
Related reports
Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location
A custom ALV report that reads all physical inventory documents of a period and shows, per material and storage location, the difference quantity, the …
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, …
Stock in Transit Between Plants Aging Report
A custom ALV report that lists quantities issued from the supplying plant with stock transport orders but not yet received in the receiving plant, …
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.