# Cycle Count Due Bins and Count Progress Report

> 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.

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/cycle-count-due-bins-and-progress-report/


## 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.

### Closest standard alternatives

- LX26: Creates cycle counting documents; gives neither days left per bin nor progress percentage per storage section.
- LX25: Summarizes count progress per storage type; does not list uncounted bins with material and difference details.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LAGP | Storage bin: last count date, inventory method, active inventory document (driving table) | Read | - | ECC + S/4 |
| LQUA | Quants in the bin: material and plant | Read | LQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLA | ECC + S/4 |
| MARC | Cycle counting indicator (ABC) | Read | MARC-MATNR = LQUA-MATNR AND MARC-WERKS = LQUA-WERKS | ECC + S/4 |
| LINK | Inventory document header and status | Read | LINK-LGNUM = LAGP-LGNUM AND LINK-IVNUM = LAGP-IVNUM | ECC + S/4 |
| LINV | Book and counted quantity per quant | Read | LINV-LGNUM = LINK-LGNUM AND LINV-IVNUM = LINK-IVNUM AND LINV-LGPLA = LAGP-LGPLA | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LAGP-LGNUM | Yes |
| S_LGTYP | Storage type | Range / multiple | LAGP-LGTYP | No |
| S_LGBER | Storage section | Range / multiple | LAGP-LGBER | No |
| S_MATNR | Material | Range / multiple | LQUA-MATNR | No |
| S_ABCIN | Cycle counting indicator | Range / multiple | MARC-ABCIN | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_INTVL | Default count interval (days) | Single value | - | No |
| P_DUE | Due or overdue bins only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Storage type | LAGP-LGTYP |
| Storage bin | LAGP-LGPLA |
| Section | LAGP-LGBER |
| Material | LQUA-MATNR |
| Description | MAKT-MAKTX |
| CC indicator | MARC-ABCIN |
| Last count | LAGP-IDATU |
| Days since count | Calculated: Key date − LAGP-IDATU |
| Days left | Calculated: LAGP-IDATU + count interval − key date |
| Active inv. doc. | LAGP-IVNUM |
| Doc. status | LINK-ISTAT |
| Book qty | LINV-GESME |
| Counted qty | LINV-MENGA |
| Difference | Calculated: LINV-MENGA − LINV-GESME |
| Status | Calculated: Overdue, due soon, difference pending or current |

## 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.

## Authorization objects

- L_LGNUM: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-cycle-count-due-bins
