Export Logistics Data Report.
A SAP SD shipment-based export data report that connects delivery and shipment data with destination country, ports, product type, net weight, transport mode and freight responsibility — a focused logistics intelligence screen for Osman Akça export operations.
Five reports, one order-to-export chain.
ZSD_041Sales & FOB Report — order, FOB, USD.ZSD_042Delivery & E-Doc Report — delivery, batch, e-documents.ZSD_043Invoice & Export Report — billing, CIF/FOB. Authorized.ZSD_044Export Logistics Report — shipment, ports, weight, freight.ZSD_045Price-Restricted Invoice — invoice & e-docs, no pricing.From delivery lists to export logistics intelligence.
The Export Logistics Data Report was developed to enable logistics and operational analysis of Osman Akça export deliveries from a single screen. The report works with sales organization, delivery type and actual goods issue date criteria, presenting export deliveries with shipment number, delivery date, delivered quantity, unit, sold product type, net weight (KG), destination country, destination city, arrival port, transport mode, vehicle type, departure port, cooling info and freight payment responsibility.
With this development, export operations are tracked not just at delivery document level, but with shipment and route context. Delivery records are linked with shipment documents, showing which export delivery went out with which shipment number, to which country, to which arrival port and via which transport mode.
The report classifies product type from material type automatically — home textiles vs. fabric by the metre — making export data operationally readable in business language. Incoterms-based freight responsibility determination (buyer vs. sender) adds logistics decision support to every row.
Why it was built.
Export logistics data was scattered across transactions.
The operations team needed to see: which delivery went out with which shipment? What's the goods issue date? What product type? How many KG? Which country and city? Which arrival port? Which departure port? Sea or road? What vehicle type? Cooling required? Who pays the freight? Standard SAP delivery lists don't provide this shipment-and-route context in one place.
A focused export logistics control screen.
The report consolidates LIKP/LIPS delivery data with VTTK/VTTP shipment data, customer, material, country, region, port and transport information into a single ALV. Product type is auto- classified from material type. Net KG comes from check/log data. Incoterms-based freight responsibility is calculated per row. Shipment number hotspot links to VT03N for direct navigation.
What the report does.
Export delivery tracking, shipment routing, product classification, weight aggregation and Incoterms-based freight logic.
Delivery–shipment consolidation
LIKP/LIPS delivery data linked with VTTK/VTTP shipment documents — showing which export delivery went out with which transport number.
Destination country & city
Destination country code, country name, region/city from customer and shipment master data — showing exactly where each export delivery is headed.
Arrival & departure ports
Arrival port and departure port derived from shipment master data — key logistics routing information for export operations planning.
Transport mode & vehicle
Transport mode (sea, road) and vehicle type descriptions from shipment data — operational context for logistics coordination.
Product type classification
Material type auto-classified into business categories — EV TEKSTİLİ (home textiles) or METRE MALI (fabric by the metre) — so users see business language, not MTART codes.
Net weight (KG)
Net KG information aggregated from ZSD_015_T_CEKLOG check/log data — giving the weight-based export volume alongside unit-based delivery quantities.
Freight responsibility
Incoterms-based freight payment determination — EXW/FOB/FCA → ALICI (buyer), others → GÖNDERİCİ (sender). Automatic logistics decision support per row.
VT03N navigation
Shipment number hotspot linking directly to VT03N — instant access to the full shipment document for detailed transport verification.
Selection screen, ALV output.
Selection screen — entry filters
SAP GUI
ALV output — export logistics data
SAP GUI
How the data comes together.
Built a SAP SD export logistics report that connects delivery and shipment data with destination, port, product type, net weight, transport mode and freight responsibility information.
— Project summaryWhat I built.
From delivery–shipment linking through product classification, weight aggregation, port derivation and Incoterms freight logic.
- Custom SAP SD export report — developed the full report for shipment-based export logistics tracking.
- Focused selection screen — sales organization, delivery type, goods movement date and layout variant filters.
- Delivery–shipment linking — LIKP/LIPS combined with VTTK/VTTP for transport number, carrier, vehicle and route data.
- Delivery aggregation — quantities aggregated by delivery type, goods issue date, shipment number and destination.
- Product type classification — material type auto-classified into EV TEKSTİLİ or METRE MALI business categories.
- Net KG integration — weight data aggregated from ZSD_015_T_CEKLOG packaging/check log records.
- Port & route derivation — arrival port, departure port, transport mode and vehicle type from shipment master data.
- Freight responsibility logic — Incoterms-based determination: EXW/FOB/FCA → buyer, others → sender.
- VT03N hotspot navigation — shipment number links directly to shipment document display.
- ALV output optimization — layout variants, fixed key columns and highlighted business-relevant fields.
The impact.
Export deliveries became trackable with shipment number context. Destination country, city, port and departure port information was consolidated into one report. Delivery quantity and net KG shown together for operational volume analysis. Product type displayed in business categories instead of material type codes. Incoterms-based freight payment responsibility auto-interpreted per row. Shipment number navigation to VT03N provides instant document access. A clean, focused logistics control screen for daily export operations.
See the full Osman Akça suite.
This export logistics report is the fourth piece of the Osman Akça SD reporting suite — covering sales orders, deliveries, invoices, e-documents, export documentation and shipment logistics.