# Customer Consignment Stock Reconciliation Report (Fill-Up, Issue, Pick-Up, Return)

> A custom ALV report that shows, per customer and material, the opening consignment stock at the customer, the fill-ups, pick-ups, issues and returns of the period, the closing stock, its value and the days since the last issue. Sales and logistics teams reconcile with the customer from one list and see consignment stock that has not been consumed for a long time.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/customer-consignment-stock-reconciliation-report/


## Why is the standard not enough?

MMBE shows the customer consignment stock only as of now; MB51 lists movements one by one. Neither gives the opening stock, the totals of fill-ups, pick-ups, issues and returns by movement type and the closing stock on the same line. The month-end count reconciliation with the customer is therefore prepared in Excel. The custom report splits the movements by movement type, derives the opening stock backwards and flags slow-moving stock.

### Closest standard alternatives

- MMBE: Shows the customer consignment stock as of now; no period movements and no opening stock.
- MB51: Lists consignment movements one by one; no totals by movement type and no stock reconciliation.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MSKU | Customer consignment stock (special stock W): unrestricted, quality inspection and restricted quantity (driving table) | Read | - | ECC + S/4 |
| MSEG | Consignment movement items in ECC: movement type, quantity, debit/credit | Read | MSEG-KUNNR = MSKU-KUNNR AND MSEG-MATNR = MSKU-MATNR AND MSEG-WERKS = MSKU-WERKS AND MSEG-CHARG = MSKU-CHARG AND MSEG-SOBKZ = MSKU-SOBKZ | ECC only |
| MKPF | Material document posting date in ECC | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MATDOC | Material document item and posting date in one table in S/4HANA | Read | MATDOC-KUNNR = MSKU-KUNNR AND MATDOC-MATNR = MSKU-MATNR AND MATDOC-WERKS = MSKU-WERKS | S/4HANA only |
| KNA1 | Customer name | Read | KNA1-KUNNR = MSKU-KUNNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MSKU-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARA | Base unit of measure | Read | MARA-MATNR = MSKU-MATNR | ECC + S/4 |
| MBEW | Standard or moving average price for the stock value | Read | MBEW-MATNR = MSKU-MATNR AND MBEW-BWKEY = MSKU-WERKS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MSKU-WERKS | Yes |
| S_KUNNR | Customer | Range / multiple | MSKU-KUNNR | No |
| S_MATNR | Material | Range / multiple | MSKU-MATNR | No |
| S_CHARG | Batch | Range / multiple | MSKU-CHARG | No |
| S_BUDAT | Reconciliation period (posting date) | Range / multiple | MKPF-BUDAT | Yes |
| P_SLOW | Days without issue threshold | Single value | - | No |
| P_ZERO | Hide lines with zero closing stock | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Customer | MSKU-KUNNR |
| Customer name | KNA1-NAME1 |
| Material | MSKU-MATNR |
| Description | MAKT-MAKTX |
| Plant | MSKU-WERKS |
| Batch | MSKU-CHARG |
| Opening stock | Calculated: Closing − fill-ups + pick-ups + issues − returns |
| Fill-ups (631) | Calculated: Signed Σ MSEG-MENGE of 631 movements in the period |
| Pick-ups (632) | Calculated: Signed Σ MSEG-MENGE of 632 movements in the period |
| Issues (633) | Calculated: Signed Σ MSEG-MENGE of 633 movements in the period |
| Returns (634) | Calculated: Signed Σ MSEG-MENGE of 634 movements in the period |
| Closing stock | Calculated: MSKU-KULAB + MSKU-KUINS + MSKU-KUEIN (movements after the period taken back) |
| Unit | MARA-MEINS |
| Stock value | Calculated: Closing stock × MBEW-STPRS or MBEW-VERPR ÷ MBEW-PEINH |
| Last issue date | Calculated: MKPF-BUDAT of the latest 633 movement |
| Days without issue | Calculated: Today − last issue date |

## How does the report work?

1. The customer consignment stock with special stock indicator W is read from MSKU: current stock = KULAB + KUINS + KUEIN (unrestricted, in quality inspection, restricted).
2. The consignment movements of the period are read from MKPF and MSEG in ECC and from MATDOC in S/4HANA (MSEG-SOBKZ = W, BWART 631–634); the quantity is signed by the debit/credit indicator (SHKZG). If the period ends before today, later movements are also read and taken back from the current stock.
3. Movements are split by type: 631 fill-up, 632 pick-up, 633 issue (customer consumption), 634 return. Reversals are deducted from their own type.
4. Opening stock = closing stock − fill-ups + pick-ups + issues − returns. A negative opening stock is flagged as a data inconsistency.
5. Value = closing stock × MBEW price (STPRS for price control S, VERPR for V) ÷ PEINH.
6. The last issue date is the posting date of the latest 633 movement, also looking beyond the period; if the days since then exceed the threshold, the line is marked as slow-moving.

## Authorization objects

- M_MSEG_WWA: Material document display authorization by plant
- M_MSEG_BWA: Authorization by movement type

## Frequently asked questions

### Which movement types are used?

The standard consignment processes: 631 consignment fill-up, 632 consignment pick-up, 633 consignment issue (customer consumption and billing), 634 consignment return. If copies of these types are used in the system, a movement type range is added to the selection screen.

### Can a past month be reconciled?

Yes. MSKU holds only the current stock; the report takes back the movements from the period end until today to find the stock on that date, and then derives the opening stock from the period movements.

### Does the report work on S/4HANA?

Yes. In S/4HANA the movements are read from MATDOC; MSKU and MBEW can still be queried. For a clean core approach, the I_MaterialDocumentItem_2 CDS view can be used.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-customer-consignment-stock-reconciliation
