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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| LAGPStorage Bins | Storage bin: last count date, inventory method, active inventory document (driving table) | — | ECC + S/4 |
| LQUAQuants | Quants in the bin: material and plant | LQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLA | ECC + S/4 |
| MARCPlant Data for Material | Cycle counting indicator (ABC) | MARC-MATNR = LQUA-MATNR AND MARC-WERKS = LQUA-WERKS | ECC + S/4 |
| LINKWM Inventory Document Header | Inventory document header and status | LINK-LGNUM = LAGP-LGNUM AND LINK-IVNUM = LAGP-IVNUM | ECC + S/4 |
| LINVInventory Data per Quant | Book and counted quantity per quant | LINV-LGNUM = LINK-LGNUM AND LINV-IVNUM = LINK-IVNUM AND LINV-LGPLA = LAGP-LGPLA | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LAGP-LGNUM | Yes | 100 |
| S_LGTYP | Storage type | Range / multiple | LAGP-LGTYP | No | 001 |
| S_LGBER | Storage section | Range / multiple | LAGP-LGBER | No | 001 |
| S_MATNR | Material | Range / multiple | LQUA-MATNR | No | FG-5003 |
| S_ABCIN | Cycle counting indicator | Range / multiple | MARC-ABCIN | No | A |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_INTVL | Default count interval (days) | Single value | — | No | 365 |
| P_DUE | Due or overdue bins only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage type | LAGP-LGTYP |
| 2 | Storage bin | LAGP-LGPLA |
| 3 | Section | LAGP-LGBER |
| 4 | Material | LQUA-MATNR |
| 5 | Description | MAKT-MAKTX |
| 6 | CC indicator | MARC-ABCIN |
| 7 | Last count | LAGP-IDATU |
| 8 | Days since count | Calculated Key date − LAGP-IDATU |
| 9 | Days left | Calculated LAGP-IDATU + count interval − key date |
| 10 | Active inv. doc. | LAGP-IVNUM |
| 11 | Doc. status | LINK-ISTAT |
| 12 | Book qty | LINV-GESME |
| 13 | Counted qty | LINV-MENGA |
| 14 | Difference | Calculated LINV-MENGA − LINV-GESME |
| 15 | Status | Calculated Overdue, due soon, difference pending or current |
Sample output
| Storage type | Storage bin | Section | Material | Description | CC indicator | Last count | Days since count | Days left | Active inv. doc. | Doc. status | Book qty | Counted qty | Difference | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 001 | 01-05-03 | 001 | FG-5003 | Packed product C | A | 08/04/2026 | 105 | -15 | 0 | 0 | 0 | Overdue | ||
| 001 | 01-06-01 | 002 | FG-6200 | Detergent 5 kg | B | 06/10/2026 | 160 | 20 | 0 | 0 | 0 | Due soon | ||
| 002 | 02-11-01 | 001 | FG-5011 | Instant soup pack | A | 07/20/2026 | 120 | -30 | 0000000318 | Z | 240 | 236 | -4 | Difference pending |
How does the report work?
- LAGP is read for the selected storage types; the last count date (IDATU), inventory method (KZINV) and active inventory document (IVNUM) are taken.
- Quants in the bin are read from LQUA; the material’s cycle counting indicator per plant is added from MARC-ABCIN.
- 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.
- 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.
- 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
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 …
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 …
Related reports
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 …
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 …
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.