Open Posting Change Notices Aging Report
Short answer: A custom ALV report that lists posting change notices (stock category, batch or material changes) not yet converted to transfer orders by age, next to the stock waiting in the posting change interim storage. Stock that quality has already released but still shows as blocked in the warehouse is found at a glance.
- Estimated effort
- S · 2–3 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
LU04 shows open posting change notices as a worklist, but it does not give the number of days a notice has been waiting, the related material document and the stock left in the posting change interim storage (e.g. 922) together. Because usable stock stays in its old stock category in the warehouse, it cannot be picked, and the team usually notices only when an order gets stuck.
Who uses it? Warehouse supervisors, quality control teams and inventory controllers.
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 |
|---|---|---|---|
| LUBUPosting Change Notice | Posting change notice: movement type, source and target material/plant, quantity, status, material document (driving table) | — | ECC + S/4 |
| LQUAQuants | Quants waiting in posting change interim storage and their dates | LQUA-LGNUM = LUBU-LGNUM AND LQUA-MATNR = LUBU-MATN1 AND LQUA-WERKS = LUBU-WERK1 | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = LUBU-MATN1 AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| T333WM Movement Types | WM movement type settings: automatic transfer order and source/destination storage type | T333-LGNUM = LUBU-LGNUM AND T333-BWLVS = LUBU-BWLVS | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LUBU-LGNUM | Yes | 100 |
| S_BWLVS | WM movement type | Range / multiple | LUBU-BWLVS | No | 321 |
| S_MATNR | Material | Range / multiple | LUBU-MATN1 | No | FG-5003 |
| S_WERKS | Plant | Range / multiple | LUBU-WERK1 | No | 1000 |
| S_BDATU | Notice date | Range / multiple | LUBU-BDATU | No | 01.10.2026 – 17.11.2026 |
| P_IFTYP | Posting change interim storage type | Single value | LQUA-LGTYP | Yes | 922 |
| P_MINAGE | Minimum age (days) | Single value | — | No | 2 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Notice | LUBU-UBNUM |
| 2 | Movement type | LUBU-BWLVS |
| 3 | Material | LUBU-MATN1 |
| 4 | Description | MAKT-MAKTX |
| 5 | Plant | LUBU-WERK1 |
| 6 | Target material | LUBU-MATN2 |
| 7 | Notice qty | LUBU-MENGE |
| 8 | Open qty | Calculated LUBU-MENGE − LUBU-TAMEN |
| 9 | Unit | LUBU-MEINS |
| 10 | Qty in interim | Calculated Sum of LQUA-GESME in the interim storage type |
| 11 | Material doc. | LUBU-MBLNR |
| 12 | Notice date | LUBU-BDATU |
| 13 | Age (days) | Calculated Key date − LUBU-BDATU |
| 14 | Created by | LUBU-BNAME |
Sample output
| Notice | Movement type | Material | Description | Plant | Target material | Notice qty | Open qty | Unit | Qty in interim | Material doc. | Notice date | Age (days) | Created by |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000000731 | 321 | FG-5003 | Packed product C | 1000 | FG-5003 | 480 | 480 | PC | 480 | 4900023117 | 11/10/2026 | 7 | KK_OPER1 |
| 0000000736 | 323 | FG-5010 | Packed product K | 1000 | FG-5010 | 120 | 60 | PC | 60 | 4900023190 | 11/13/2026 | 4 | KK_OPER2 |
| 0000000740 | 309 | RM-2040 | Steel sheet 2 mm | 2000 | RM-2041 | 350 | 350 | KG | 350 | 4900023244 | 11/15/2026 | 2 | DEPO_SEF1 |
How does the report work?
- Notices with status open or partially processed are read from LUBU for the selected warehouse number and movement types.
- Open quantity = notice quantity (MENGE) − quantity already in transfer orders (TAMEN); lines with zero are skipped.
- For the posting change interim storage type (from the selection screen, default 922), quants of the same material and plant are read from LQUA; the quantity in interim storage and the oldest quant date (WDATU) are added.
- Age = key date − notice creation date (BDATU). If the target material (MATN2) differs from the source material, the line is flagged as a material change.
- The material description is added from MAKT and the result is shown in ALV in descending order of age.
Performance notes
LUBU is usually a small table; reading it by warehouse number and status is enough. Restrict LQUA to the posting change interim storage type only.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The notice number jumps to LU04 and the material document to MB03.
- Export to Excel
- Runs as a background job
- Send the result by email Notices still waiting after quality release can be sent to the warehouse team daily.
Authorization objects
- L_LGNUMDisplay authorization by warehouse number
- L_BWLVSAuthorization by WM movement type
Frequently asked questions
When is a posting change notice created?
When the stock category (for example from quality inspection to unrestricted), the batch or the material number changes in a storage location managed by WM, the MM posting opens a notice in WM. The quants keep their old status until the notice is processed with a transfer order.
Does the report process the notices automatically?
No, the report only reads. You can jump from a line to LU04 to create the transfer order; automatic processing should be handled as a separate background job.
Can interim storage types other than 922 be used?
Yes. The interim storage type is a selection-screen parameter, so a different value can be entered per warehouse number.
Related reports
Interim Storage Stuck and Negative Stock Report
A custom ALV report that lists quants in goods receipt, shipping, posting change and difference interim storage types that have been waiting longer …
Open Transfer Requirements Not Converted to Transfer Orders Aging Report
A custom ALV report that lists open or partially processed transfer requirements across all WM movement types by age, priority and the available stock …
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.