Customer Consignment Stock Reconciliation Report (Fill-Up, Issue, Pick-Up, Return)
Short answer: 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.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Sales teams that sell on consignment, logistics, inventory control and accounting.
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 |
|---|---|---|---|
| MSKUSpecial Stocks with Customer | Customer consignment stock (special stock W): unrestricted, quality inspection and restricted quantity (driving table) | — | ECC + S/4 |
| MSEGMaterial Document Item | Consignment movement items in ECC: movement type, quantity, debit/credit | 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 |
| MKPFMaterial Document Header | Material document posting date in ECC | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MATDOCMaterial Documents (S/4HANA) | Material document item and posting date in one table in S/4HANA | MATDOC-KUNNR = MSKU-KUNNR AND MATDOC-MATNR = MSKU-MATNR AND MATDOC-WERKS = MSKU-WERKS | S/4HANA only |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = MSKU-KUNNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MSKU-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARAGeneral Material Data | Base unit of measure | MARA-MATNR = MSKU-MATNR | ECC + S/4 |
| MBEWMaterial Valuation | Standard or moving average price for the stock value | MBEW-MATNR = MSKU-MATNR AND MBEW-BWKEY = MSKU-WERKS | ECC + S/4 |
S/4HANA notes
- MSKU → MATDOC: In S/4HANA MSKU is read through the compatibility view NSDM_V_MSKU, which derives the quantities from MATDOC. Reading code keeps working, but nothing should write to the table directly.
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MSKU-WERKS | Yes | 1000 |
| S_KUNNR | Customer | Range / multiple | MSKU-KUNNR | No | 200100 |
| S_MATNR | Material | Range / multiple | MSKU-MATNR | No | FG-1001 |
| S_CHARG | Batch | Range / multiple | MSKU-CHARG | No | B2026-091 |
| S_BUDAT | Reconciliation period (posting date) | Range / multiple | MKPF-BUDAT | Yes | 01.10.2026 – 17.11.2026 |
| P_SLOW | Days without issue threshold | Single value | — | No | 60 |
| P_ZERO | Hide lines with zero closing stock | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Customer | MSKU-KUNNR |
| 2 | Customer name | KNA1-NAME1 |
| 3 | Material | MSKU-MATNR |
| 4 | Description | MAKT-MAKTX |
| 5 | Plant | MSKU-WERKS |
| 6 | Batch | MSKU-CHARG |
| 7 | Opening stock | Calculated Closing − fill-ups + pick-ups + issues − returns |
| 8 | Fill-ups (631) | Calculated Signed Σ MSEG-MENGE of 631 movements in the period |
| 9 | Pick-ups (632) | Calculated Signed Σ MSEG-MENGE of 632 movements in the period |
| 10 | Issues (633) | Calculated Signed Σ MSEG-MENGE of 633 movements in the period |
| 11 | Returns (634) | Calculated Signed Σ MSEG-MENGE of 634 movements in the period |
| 12 | Closing stock | Calculated MSKU-KULAB + MSKU-KUINS + MSKU-KUEIN (movements after the period taken back) |
| 13 | Unit | MARA-MEINS |
| 14 | Stock value | Calculated Closing stock × MBEW-STPRS or MBEW-VERPR ÷ MBEW-PEINH |
| 15 | Last issue date | Calculated MKPF-BUDAT of the latest 633 movement |
| 16 | Days without issue | Calculated Today − last issue date |
Sample output
| Customer | Customer name | Material | Description | Plant | Batch | Opening stock | Fill-ups (631) | Pick-ups (632) | Issues (633) | Returns (634) | Closing stock | Unit | Stock value | Last issue date | Days without issue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 200100 | Marmara Gıda | FG-1001 | Jam jar 380 g | 1000 | 400 | 600 | 0 | 550 | 20 | 470 | CS | 14,100 | 11/12/2026 | 5 | |
| 200245 | Karadeniz Market Zinciri | FG-1120 | Tomato paste 830 g | 1000 | B2026-091 | 250 | 0 | 0 | 30 | 0 | 220 | CS | 9,680 | 09/02/2026 | 76 |
| 200610 | Ege Kuruyemiş Dağıtım | FG-4010 | Hazelnut kernels 500 g | 2000 | B2026-114 | 120 | 0 | 120 | 0 | 0 | 0 | CS | 0 | 06/20/2026 | 150 |
How does the report work?
- The customer consignment stock with special stock indicator W is read from MSKU: current stock = KULAB + KUINS + KUEIN (unrestricted, in quality inspection, restricted).
- 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.
- Movements are split by type: 631 fill-up, 632 pick-up, 633 issue (customer consumption), 634 return. Reversals are deducted from their own type.
- Opening stock = closing stock − fill-ups + pick-ups + issues − returns. A negative opening stock is flagged as a data inconsistency.
- Value = closing stock × MBEW price (STPRS for price control S, VERPR for V) ÷ PEINH.
- 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.
Performance notes
In ECC, read MSEG with a JOIN, narrowed by plant, special stock indicator and movement type, and MKPF by posting date. In S/4HANA, MATDOC is a single table with the posting date on the same row. With many customers, run the report in the background at month end.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a movement column opens the material documents in an MB51-like list; clicking a document opens it in MIGO display mode.
- Export to Excel
- Runs as a background job
- Send the result by email At month end each account manager can receive the reconciliation list of their own customers.
Authorization objects
- M_MSEG_WWAMaterial document display authorization by plant
- M_MSEG_BWAAuthorization 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.
Related reports
Sales Order – Delivery – Invoice Status Report
A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …
Picked but Not Goods-Issued Deliveries Report
A custom ALV report that lists deliveries whose picking is complete but whose goods issue has not been posted, with the number of days they have been …
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.