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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EKKOPurchasing Document Header | Stock transport order header: supplying plant and document type (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Transport item: receiving plant, material, unit | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKBEPurchasing Document History | Goods issues and receipts for the transport order | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |
| MSEGMaterial Document Item | Two-step 303/305 transfer movements | MSEG-MATNR = EKPO-MATNR AND MSEG-UMWRK = EKPO-WERKS | ECC + S/4 |
| MARCPlant Data for Material | Stock in transit and in transfer totals by plant | MARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKS | ECC + S/4 |
| MBEWMaterial Valuation | Valuation price of the receiving plant | MBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKS | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = EKPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Receiving plant | Range / multiple | EKPO-WERKS | Yes | 1200 |
| S_RESWK | Supplying plant | Range / multiple | EKKO-RESWK | No | 1100 |
| S_MATNR | Material | Range / multiple | EKPO-MATNR | No | RM-2040 |
| S_BSART | Transport order document type | Range / multiple | EKKO-BSART | No | UB |
| P_KEYDT | Key date for age | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_MINAGE | Minimum days in transit | Single value | — | No | 7 |
| P_303 | Include two-step 303/305 transfers | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Receiving plant | EKPO-WERKS |
| 2 | Supplying plant | EKKO-RESWK |
| 3 | Transport order | EKPO-EBELN |
| 4 | Item | EKPO-EBELP |
| 5 | Material | EKPO-MATNR |
| 6 | Description | MAKT-MAKTX |
| 7 | Goods issue document | EKBE-BELNR |
| 8 | Issue date | EKBE-BUDAT |
| 9 | Issued qty | Calculated Σ EKBE-MENGE (VGABE = 6, reversals negative) |
| 10 | Received qty | Calculated Σ EKBE-MENGE (VGABE = 1, reversals negative) |
| 11 | Qty in transit | Calculated Issued qty − received qty |
| 12 | Unit | EKPO-MEINS |
| 13 | Value in transit | Calculated Qty in transit × receiving plant MBEW price ÷ MBEW-PEINH |
| 14 | Currency | EKBE-HSWAE |
| 15 | Days in transit | Calculated Key date − EKBE-BUDAT of the oldest open issue |
| 16 | Age bucket | Calculated 0–7, 8–30, 31–90, 90+ days |
Sample output
| Receiving plant | Supplying plant | Transport order | Item | Material | Description | Goods issue document | Issue date | Issued qty | Received qty | Qty in transit | Unit | Value in transit | Currency | Days in transit | Age bucket |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1200 | 1100 | 4500013205 | 00010 | RM-2040 | Galvanised sheet 1.5 mm | 4900081120 | 11/10/2026 | 500 | 0 | 500 | KG | 30,600 | TRY | 7 | 0–7 |
| 1200 | 1100 | 4500013188 | 00020 | PK-1180 | Corrugated box 40x60 | 4900080947 | 10/21/2026 | 2,000 | 1,500 | 500 | PC | 925 | TRY | 27 | 8–30 |
| 1300 | 1100 | 4500013011 | 00010 | CH-0315 | Epoxy resin | 4900079532 | 08/14/2026 | 120 | 0 | 120 | KG | 1,032 | TRY | 95 | 90+ |
How does the report work?
- 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.
- 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.
- 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.
- 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.
- 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
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, …
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 …
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.