MM Report Custom development ALV report

Stock in Transit Between Plants Aging Report

Short answer: A custom ALV report that lists quantities issued from the supplying plant with stock transport orders but not yet received in the receiving plant, with goods issue document, issue date, days in transit, age bucket and value. Optionally it also shows quantities left in two-step plant-to-plant transfers (303 issued, 305 receipt pending).

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
7
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

MB5T lists stock in transit by order, but does not calculate how many days the goods issue has been in transit or an age bucket, and does not show two-step 303/305 transfers in the same list. MMBE only gives the total stock in transit. At month end, MB5T and MB51 output is matched by hand to find transfers that never arrived or were received in the wrong plant.

Who uses it? Warehouse and logistics teams, inventory controllers and cost accountants doing month-end closing, plant planners.

Closest standard alternatives

  • MB5T Stock in Transit (Cross-Company). Lists stock in transit by order; has no days in transit, age bucket or 303/305 transfers.
  • MMBE Stock Overview. Shows the total stock in transit for a material and plant; gives no document or date detail.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderStock transport order header: supplying plant and document type (driving table)—ECC + S/4
EKPOPurchasing Document ItemTransport item: receiving plant, material, unitEKPO-EBELN = EKKO-EBELNECC + S/4
EKBEPurchasing Document HistoryGoods issues and receipts for the transport orderEKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELPECC + S/4
MSEGMaterial Document ItemTwo-step 303/305 transfer movementsMSEG-MATNR = EKPO-MATNR AND MSEG-UMWRK = EKPO-WERKSECC + S/4
MARCPlant Data for MaterialStock in transit and in transfer totals by plantMARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKSECC + S/4
MBEWMaterial ValuationValuation price of the receiving plantMBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKSECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = EKPO-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

S/4HANA notes

  • MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
  • 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_WERKSReceiving plantRange / multipleEKPO-WERKSYes1200
S_RESWKSupplying plantRange / multipleEKKO-RESWKNo1100
S_MATNRMaterialRange / multipleEKPO-MATNRNoRM-2040
S_BSARTTransport order document typeRange / multipleEKKO-BSARTNoUB
P_KEYDTKey date for ageSingle valueSY-DATUMYes17.11.2026
P_MINAGEMinimum days in transitSingle value—No7
P_303Include two-step 303/305 transfersCheckbox—NoX

Output columns

#ColumnSource
1Receiving plantEKPO-WERKS
2Supplying plantEKKO-RESWK
3Transport orderEKPO-EBELN
4ItemEKPO-EBELP
5MaterialEKPO-MATNR
6DescriptionMAKT-MAKTX
7Goods issue documentEKBE-BELNR
8Issue dateEKBE-BUDAT
9Issued qtyCalculated Σ EKBE-MENGE (VGABE = 6, reversals negative)
10Received qtyCalculated Σ EKBE-MENGE (VGABE = 1, reversals negative)
11Qty in transitCalculated Issued qty − received qty
12UnitEKPO-MEINS
13Value in transitCalculated Qty in transit × receiving plant MBEW price ÷ MBEW-PEINH
14CurrencyEKBE-HSWAE
15Days in transitCalculated Key date − EKBE-BUDAT of the oldest open issue
16Age bucketCalculated 0–7, 8–30, 31–90, 90+ days

Sample output

Receiving plantSupplying plantTransport orderItemMaterialDescriptionGoods issue documentIssue dateIssued qtyReceived qtyQty in transitUnitValue in transitCurrencyDays in transitAge bucket
12001100450001320500010RM-2040Galvanised sheet 1.5 mm490008112011/10/20265000500KG30,600TRY70–7
12001100450001318800020PK-1180Corrugated box 40x60490008094710/21/20262,0001,500500PC925TRY278–30
13001100450001301100010CH-0315Epoxy resin490007953208/14/20261200120KG1,032TRY9590+
A view built with fictional sample data; not real system data.

How does the report work?

  1. Stock transport orders with a supplying plant (EKKO-RESWK) and non-deleted EKPO items are read by receiving plant, supplying plant, material and document type.
  2. Goods issues for the transport order (VGABE = 6) and goods receipts (VGABE = 1) are summed per item from EKBE; reversals (SHKZG) are deducted. Quantity in transit = issued − received.
  3. The quantity in transit is assigned in date order (FIFO) to the oldest goods issue not yet closed by receipts; age = key date − EKBE-BUDAT of that issue.
  4. If P_303 is set, 303 movements with a receiving plant (UMWRK) are read from MSEG and compared with 305 receipts for the same material and plant; the remaining quantity is added with its own line type.
  5. Value = quantity in transit × the receiving plant’s MBEW price (STPRS or VERPR ÷ PEINH). The total in transit is compared with MARC-TRAME and MARC-UMLMC; lines are flagged if they differ. Lines are put into the 0–7, 8–30, 31–90 and 90+ day buckets.

Performance notes

The number of open transport orders is usually small; reading EKBE for the order list is enough. The 303 option reads MSEG for a date range; on S/4HANA this read is fast through MATDOC, on ECC a suitable index on MSEG-BUDAT_MKPF and plant is recommended.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The transport order opens ME23N and the goods issue document opens MIGO display.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Lines older than 90 days can be sent to the warehouse owners of both plants before month end.

Authorization objects

  • M_MSEG_WWAGoods movement authorization by plant
  • M_BEST_WRKPurchase order display authorization by plant

Frequently asked questions

Are transport orders shipped with a delivery (VL10B) included?

Yes. The goods issue of the delivery (641 or 643) is written to the transport order history as VGABE 6; the report reads it the same way whether the issue was posted with a delivery or directly.

Does the report correct the stock in transit?

No, the report only reads. For material that has not arrived, a goods receipt in the receiving plant or a reversal in the supplying plant is needed; the order can be opened directly from the report.

Does the report work on S/4HANA?

Yes. EKKO, EKPO and EKBE stay the same. On S/4HANA the stock fields in MSEG and MARC are read through compatibility views; the report works with them without changes.

Related reports

MM Report Custom ALV report

Stock Aging Report

A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …

MARD · MARA · MAKT · MBEW

WM Report Custom ALV report

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 …

T320 · MARD · LQUA · LTAP

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: Stock in Transit Between Plants Aging Report