SD Report Custom development ALV report

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

  • MMBE Stock Overview. Shows the customer consignment stock as of now; no period movements and no opening stock.
  • MB51 Material Document List. Lists consignment movements one by one; no totals by movement type and no stock reconciliation.

Tables used

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

TableRoleJoinSystem
MSKUSpecial Stocks with CustomerCustomer consignment stock (special stock W): unrestricted, quality inspection and restricted quantity (driving table)—ECC + S/4
MSEGMaterial Document ItemConsignment movement items in ECC: movement type, quantity, debit/creditMSEG-KUNNR = MSKU-KUNNR AND MSEG-MATNR = MSKU-MATNR AND MSEG-WERKS = MSKU-WERKS AND MSEG-CHARG = MSKU-CHARG AND MSEG-SOBKZ = MSKU-SOBKZECC only
MKPFMaterial Document HeaderMaterial document posting date in ECCMKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHRECC only
MATDOCMaterial Documents (S/4HANA)Material document item and posting date in one table in S/4HANAMATDOC-KUNNR = MSKU-KUNNR AND MATDOC-MATNR = MSKU-MATNR AND MATDOC-WERKS = MSKU-WERKSS/4HANA only
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = MSKU-KUNNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MSKU-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MARAGeneral Material DataBase unit of measureMARA-MATNR = MSKU-MATNRECC + S/4
MBEWMaterial ValuationStandard or moving average price for the stock valueMBEW-MATNR = MSKU-MATNR AND MBEW-BWKEY = MSKU-WERKSECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleMSKU-WERKSYes1000
S_KUNNRCustomerRange / multipleMSKU-KUNNRNo200100
S_MATNRMaterialRange / multipleMSKU-MATNRNoFG-1001
S_CHARGBatchRange / multipleMSKU-CHARGNoB2026-091
S_BUDATReconciliation period (posting date)Range / multipleMKPF-BUDATYes01.10.2026 – 17.11.2026
P_SLOWDays without issue thresholdSingle value—No60
P_ZEROHide lines with zero closing stockCheckbox—No—

Output columns

#ColumnSource
1CustomerMSKU-KUNNR
2Customer nameKNA1-NAME1
3MaterialMSKU-MATNR
4DescriptionMAKT-MAKTX
5PlantMSKU-WERKS
6BatchMSKU-CHARG
7Opening stockCalculated Closing − fill-ups + pick-ups + issues − returns
8Fill-ups (631)Calculated Signed Σ MSEG-MENGE of 631 movements in the period
9Pick-ups (632)Calculated Signed Σ MSEG-MENGE of 632 movements in the period
10Issues (633)Calculated Signed Σ MSEG-MENGE of 633 movements in the period
11Returns (634)Calculated Signed Σ MSEG-MENGE of 634 movements in the period
12Closing stockCalculated MSKU-KULAB + MSKU-KUINS + MSKU-KUEIN (movements after the period taken back)
13UnitMARA-MEINS
14Stock valueCalculated Closing stock × MBEW-STPRS or MBEW-VERPR ÷ MBEW-PEINH
15Last issue dateCalculated MKPF-BUDAT of the latest 633 movement
16Days without issueCalculated Today − last issue date

Sample output

CustomerCustomer nameMaterialDescriptionPlantBatchOpening stockFill-ups (631)Pick-ups (632)Issues (633)Returns (634)Closing stockUnitStock valueLast issue dateDays without issue
200100Marmara GıdaFG-1001Jam jar 380 g1000400600055020470CS14,10011/12/20265
200245Karadeniz Market ZinciriFG-1120Tomato paste 830 g1000B2026-09125000300220CS9,68009/02/202676
200610Ege Kuruyemiş DağıtımFG-4010Hazelnut kernels 500 g2000B2026-1141200120000CS006/20/2026150
A view built with fictional sample data; not real system data.

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.

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

SD Report Custom ALV report

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 …

VBAK · VBAP · VBFA · LIKP

SD Report Custom ALV report

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 …

LIKP · VBUK · LIPS · KNA1

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: Customer Consignment Stock Reconciliation Report (Fill-Up, Issue, Pick-Up, Return)