# Stock in Transit Between Plants Aging Report

> 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).

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/stock-in-transit-between-plants-aging-report/


## 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.

### Closest standard alternatives

- MB5T: Lists stock in transit by order; has no days in transit, age bucket or 303/305 transfers.
- MMBE: Shows the total stock in transit for a material and plant; gives no document or date detail.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EKKO | Stock transport order header: supplying plant and document type (driving table) | Read | - | ECC + S/4 |
| EKPO | Transport item: receiving plant, material, unit | Read | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKBE | Goods issues and receipts for the transport order | Read | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |
| MSEG | Two-step 303/305 transfer movements | Read | MSEG-MATNR = EKPO-MATNR AND MSEG-UMWRK = EKPO-WERKS | ECC + S/4 |
| MARC | Stock in transit and in transfer totals by plant | Read | MARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKS | ECC + S/4 |
| MBEW | Valuation price of the receiving plant | Read | MBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKS | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = EKPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Receiving plant | Range / multiple | EKPO-WERKS | Yes |
| S_RESWK | Supplying plant | Range / multiple | EKKO-RESWK | No |
| S_MATNR | Material | Range / multiple | EKPO-MATNR | No |
| S_BSART | Transport order document type | Range / multiple | EKKO-BSART | No |
| P_KEYDT | Key date for age | Single value | SY-DATUM | Yes |
| P_MINAGE | Minimum days in transit | Single value | - | No |
| P_303 | Include two-step 303/305 transfers | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Receiving plant | EKPO-WERKS |
| Supplying plant | EKKO-RESWK |
| Transport order | EKPO-EBELN |
| Item | EKPO-EBELP |
| Material | EKPO-MATNR |
| Description | MAKT-MAKTX |
| Goods issue document | EKBE-BELNR |
| Issue date | EKBE-BUDAT |
| Issued qty | Calculated: Σ EKBE-MENGE (VGABE = 6, reversals negative) |
| Received qty | Calculated: Σ EKBE-MENGE (VGABE = 1, reversals negative) |
| Qty in transit | Calculated: Issued qty − received qty |
| Unit | EKPO-MEINS |
| Value in transit | Calculated: Qty in transit × receiving plant MBEW price ÷ MBEW-PEINH |
| Currency | EKBE-HSWAE |
| Days in transit | Calculated: Key date − EKBE-BUDAT of the oldest open issue |
| Age bucket | Calculated: 0–7, 8–30, 31–90, 90+ days |

## 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.

## Authorization objects

- M_MSEG_WWA: Goods movement authorization by plant
- M_BEST_WRK: Purchase 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-stock-in-transit-aging
