WM Report Custom development ALV report

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

  • LU04 Selection of Posting Change Notices. Shows open posting change notices as a worklist; no age and no stock in interim storage.
  • LS24 Display Quants for Material. Shows the quants of a material; does not say which quant belongs to a waiting notice.

Tables used

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

TableRoleJoinSystem
LUBUPosting Change NoticePosting change notice: movement type, source and target material/plant, quantity, status, material document (driving table)—ECC + S/4
LQUAQuantsQuants waiting in posting change interim storage and their datesLQUA-LGNUM = LUBU-LGNUM AND LQUA-MATNR = LUBU-MATN1 AND LQUA-WERKS = LUBU-WERK1ECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = LUBU-MATN1 AND MAKT-SPRAS = SY-LANGUECC + S/4
T333WM Movement TypesWM movement type settings: automatic transfer order and source/destination storage typeT333-LGNUM = LUBU-LGNUM AND T333-BWLVS = LUBU-BWLVSECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLUBU-LGNUMYes100
S_BWLVSWM movement typeRange / multipleLUBU-BWLVSNo321
S_MATNRMaterialRange / multipleLUBU-MATN1NoFG-5003
S_WERKSPlantRange / multipleLUBU-WERK1No1000
S_BDATUNotice dateRange / multipleLUBU-BDATUNo01.10.2026 – 17.11.2026
P_IFTYPPosting change interim storage typeSingle valueLQUA-LGTYPYes922
P_MINAGEMinimum age (days)Single value—No2

Output columns

#ColumnSource
1NoticeLUBU-UBNUM
2Movement typeLUBU-BWLVS
3MaterialLUBU-MATN1
4DescriptionMAKT-MAKTX
5PlantLUBU-WERK1
6Target materialLUBU-MATN2
7Notice qtyLUBU-MENGE
8Open qtyCalculated LUBU-MENGE − LUBU-TAMEN
9UnitLUBU-MEINS
10Qty in interimCalculated Sum of LQUA-GESME in the interim storage type
11Material doc.LUBU-MBLNR
12Notice dateLUBU-BDATU
13Age (days)Calculated Key date − LUBU-BDATU
14Created byLUBU-BNAME

Sample output

NoticeMovement typeMaterialDescriptionPlantTarget materialNotice qtyOpen qtyUnitQty in interimMaterial doc.Notice dateAge (days)Created by
0000000731321FG-5003Packed product C1000FG-5003480480PC480490002311711/10/20267KK_OPER1
0000000736323FG-5010Packed product K1000FG-501012060PC60490002319011/13/20264KK_OPER2
0000000740309RM-2040Steel sheet 2 mm2000RM-2041350350KG350490002324411/15/20262DEPO_SEF1
A view built with fictional sample data; not real system data.

How does the report work?

  1. Notices with status open or partially processed are read from LUBU for the selected warehouse number and movement types.
  2. Open quantity = notice quantity (MENGE) − quantity already in transfer orders (TAMEN); lines with zero are skipped.
  3. 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.
  4. 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.
  5. 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

WM Report Custom ALV report

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 …

LQUA · LTBP · LTBK · LTAP

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: Open Posting Change Notices Aging Report