Core idea: Container Visibility = planning accuracy + early detection of delay risk.
ABAP report collects bill-of-lading and container numbers from Shipment/Delivery tables.
Each B/L number is sent to the ShipsGo REST API; live status, ETA and vessel name are returned.
CL_BCS builds the HTML email and delivers it automatically to all distribution list recipients.
Tech stack: SAP S/4HANA · ABAP REPORT · CL_BCS HTML Mail · ShipsGo Tracking API · Base64 inline logo
8 statuses returned by the API:
Automated report | 05.03.2026 | XOSEN
8
TOTAL B/L
05.03.2026
REPORT DATE
Status Summary
| Status | Count | Distribution |
|---|---|---|
| SAILING | 2 | |
| ARRIVED | 2 | |
| LOADED | 1 | |
| BOOKED | 1 | |
| INPROGRESS | 1 | |
| DISCHARGED | 1 | |
| NEW | 0 | |
| UNTRACKED | 0 | |
| TOTAL | 8 |
Shipment Details
| B/L No | Carrier | Status | Origin | Departure | Destination | Arrival | ETA | Vessel | Cont. | Shipper |
|---|---|---|---|---|---|---|---|---|---|---|
| 026F559886 | WAN HAI LINES | SAILING | XIAMEN | 08.01.2026 | IZMIT (GEBZE) | 20.02.2026 | 20.02.2026 | WAN HAI 623 | 2 | COMPRESORES REDIN S.A.L. |
| MEDUW3088269 | MSC | SAILING | KOBE | 27.01.2026 | IZMIT (GEBZE) | 26.03.2026 | 26.03.2026 | MSC HAMBURG | 1 | LLC DALGAKIRAN COMPRESOR |
| COSU6482901740 | COSCO | ARRIVED | SHANGHAI | 14.02.2026 | MERSIN | 12.03.2026 | 12.03.2026 | COSCO GLORY | 3 | SIDAL COMPANY |
| HLCUIST260215 | HAPAG-LLOYD | ARRIVED | BUSAN (PUSAN) | 05.02.2026 | IZMIR (ALSANCAK) | 28.02.2026 | 28.02.2026 | TORONTO EXPRESS | 1 | TEKNO YATIRIM A.S. |
| EGLV140602830 | EVERGREEN | LOADED | GUANGZHOU | 18.02.2026 | ISTANBUL | 05.04.2026 | 05.04.2026 | EVER GIVEN | 2 | BRISA BRIDGESTONE SABANCI |
| MAEU4591037260 | MAERSK | BOOKED | NINGBO | 25.03.2026 | GEBZE (DERINCE) | 12.05.2026 | 12.05.2026 | MAERSK EDINBURGH | 4 | KORDSA TEKNIK TEKSTIL |
| YMLJIST260380 | YANG MING | INPROGRESS | TIANJIN | 10.03.2026 | BANDIRMA | 22.04.2026 | 22.04.2026 | YM UNIFORMITY | 1 | ASELSAN A.S. |
| MEDUK2690221 | MSC | DISCHARGED | BUSAN (PUSAN) | 16.01.2024 | IZMIT (GEBZE) | 17.03.2024 | 17.03.2024 | MSC CLARA | 1 | SIDAL COMPANY |