WM Report Custom development ALV report

Cycle Count Due Bins and Count Progress Report

Short answer: A custom ALV report that shows the storage bins whose count is due or overdue based on the last count date and the material's cycle counting indicator, the status of open inventory documents and the difference between counted and book quantity. Inventory owners track the annual counting target per storage section.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
6
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

LX26 creates inventory documents for cycle counting, LX25 summarizes count progress per storage type and LI20 clears differences. None of them compares the days since the last count per bin with the interval of the cycle counting indicator, or gives the uncounted bins as a percentage per storage section.

Who uses it? Inventory owners, warehouse managers and internal audit teams.

Closest standard alternatives

  • LX26 Inventory in WM via Cycle Counting. Creates cycle counting documents; gives neither days left per bin nor progress percentage per storage section.
  • LX25 Inventory Status. Summarizes count progress per storage type; does not list uncounted bins with material and difference details.

Tables used

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

TableRoleJoinSystem
LAGPStorage BinsStorage bin: last count date, inventory method, active inventory document (driving table)—ECC + S/4
LQUAQuantsQuants in the bin: material and plantLQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLAECC + S/4
MARCPlant Data for MaterialCycle counting indicator (ABC)MARC-MATNR = LQUA-MATNR AND MARC-WERKS = LQUA-WERKSECC + S/4
LINKWM Inventory Document HeaderInventory document header and statusLINK-LGNUM = LAGP-LGNUM AND LINK-IVNUM = LAGP-IVNUMECC + S/4
LINVInventory Data per QuantBook and counted quantity per quantLINV-LGNUM = LINK-LGNUM AND LINV-IVNUM = LINK-IVNUM AND LINV-LGPLA = LAGP-LGPLAECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLAGP-LGNUMYes100
S_LGTYPStorage typeRange / multipleLAGP-LGTYPNo001
S_LGBERStorage sectionRange / multipleLAGP-LGBERNo001
S_MATNRMaterialRange / multipleLQUA-MATNRNoFG-5003
S_ABCINCycle counting indicatorRange / multipleMARC-ABCINNoA
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_INTVLDefault count interval (days)Single value—No365
P_DUEDue or overdue bins onlyCheckbox—NoX

Output columns

#ColumnSource
1Storage typeLAGP-LGTYP
2Storage binLAGP-LGPLA
3SectionLAGP-LGBER
4MaterialLQUA-MATNR
5DescriptionMAKT-MAKTX
6CC indicatorMARC-ABCIN
7Last countLAGP-IDATU
8Days since countCalculated Key date − LAGP-IDATU
9Days leftCalculated LAGP-IDATU + count interval − key date
10Active inv. doc.LAGP-IVNUM
11Doc. statusLINK-ISTAT
12Book qtyLINV-GESME
13Counted qtyLINV-MENGA
14DifferenceCalculated LINV-MENGA − LINV-GESME
15StatusCalculated Overdue, due soon, difference pending or current

Sample output

Storage typeStorage binSectionMaterialDescriptionCC indicatorLast countDays since countDays leftActive inv. doc.Doc. statusBook qtyCounted qtyDifferenceStatus
00101-05-03001FG-5003Packed product CA08/04/2026105-15000Overdue
00101-06-01002FG-6200Detergent 5 kgB06/10/202616020000Due soon
00202-11-01001FG-5011Instant soup packA07/20/2026120-300000000318Z240236-4Difference pending
A view built with fictional sample data; not real system data.

How does the report work?

  1. LAGP is read for the selected storage types; the last count date (IDATU), inventory method (KZINV) and active inventory document (IVNUM) are taken.
  2. Quants in the bin are read from LQUA; the material’s cycle counting indicator per plant is added from MARC-ABCIN.
  3. The counting interval (days) of the indicator is read from the cycle counting settings; without a setting, the default interval from the selection screen is used. Days left = last count date + interval − key date.
  4. If an active inventory document exists, the document status is read from LINK, and book quantity (GESME) and counted quantity (MENGA) from LINV; difference = MENGA − GESME.
  5. Status: “Overdue” if days left < 0, “Due soon” if ≤ 30, “Difference pending” if the document is counted but not cleared. The percentage of counted bins per storage section is shown as a subtotal.

Performance notes

Restrict LAGP and LQUA by warehouse number and storage type. Read MARC once for the list of materials and plants. LINK/LINV should only be read for bins with IVNUM filled.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the inventory document opens LI03N.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number and storage type

Frequently asked questions

Where does the count interval come from?

In cycle counting, the number of counts per year is defined per indicator (A, B, C…) and plant. The report derives the interval in days from this setting; without it, the default interval on the selection screen is used.

Are empty bins included in the report?

In storage types with continuous inventory or zero stock check, empty bins must also be counted. An option to include empty bins can be added; the material column is then empty.

Can past count evidence be obtained for audits?

Cleared inventory documents remain in LINK and LINV. An extra view showing which bin was counted on which date during the year can be built from the same tables.

Packages that include this solution

WM Package Custom

Physical Inventory Count and Difference Pack

A four-component pack that runs a count campaign from start to finish: storage bins due for counting, bulk entry of count results from handheld …

4 components · v1.0

WM Package Custom

Warehouse Operations Control Pack

A five-report pack that shows daily warehouse health per warehouse number: unconfirmed transfer orders, stock stuck in interim storage and negative …

5 components · v1.0

Related reports

WM Report Custom ALV report

WM vs IM Stock Comparison Report

A custom ALV report that compares inventory management stock per storage location (MARD) with the total of warehouse management quants (LQUA) by …

T320 · MARD · LQUA · LTAP

WM Report Custom ALV report

Storage Bin Utilization and Empty Bin Report

A custom ALV report that shows, per storage type and storage section, the weight and capacity utilization percentage of every bin, the empty bins and …

LAGP · LQUA · T303 · T302

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: Cycle Count Due Bins and Count Progress Report