This is one of 4556 IT projects that we have successfully completed with our customers.

How can we support you?

SAP BW on HANA: Connection and integration TMS

Project duration: 9 months

Brief description

The customer is using a transport management system based on MSSQL. The system is connected to SAP BW via SDI and integrated into the existing reporting. Where possible, access is virtual, where necessary separate modeling and persistence in BW. PTA is involved in the preliminary analysis and conception, as well as in the implementation of BW data flows and queries.


Except for the TMS-specific data such as dates and status of dispatch, the master and transaction data comes from the sources SAP Retail (material and vendor master, purchase orders and deliveries, etc.) and Sap EWM (handling units/containers, transport units, carriers, etc.). In BW, the data may need to be harmonized in terms of content and format.

Subject description

In Phase I of the project, the land and sea freight processes are mapped. In the case of sea freight, the orders are distributed or grouped into containers and shipments and ultimately combined into transports. The flow through the individual steps such as customs clearance, shipping, etc. is planned and controlled. In the case of land freight, the system activity focuses on the areas of scheduling and freight space planning for deliveries from the distribution center to the individual specialist centers.


Project periodProjektzeitraum01.04.2023 - 31.12.2023

Have we sparked your interest?

Marcus Rödiger

Retail sector manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.