Skip to main content

Celonis Product Documentation

Data Model
Create a new Data Model or adapt an existing Data Model

After extracting all the necessary data and adapting it to the requirements, it must now be added to the O2C data model. This can be done using an existing DM or in a separate DM.

Visual of the relevant part of the DM:

image50.png

Table

Description

Sections

SHIPMENT_NETWORK

  • Link table between Sales Order, Delivery and Shipment tables

  • Table structure enables use of Signal Link technology and Network Explorer

Add SHIPMENT_NETWORK table to data model

UNIQUE_SHIPPING_STAGES

  • Derived from VTTS

  • Includes all unique shipment stages (unique in terms of the combination of departure address - arrival address - transport mode)

  • Used for the calculation of emissions

  • Data from this table is input for the carbon engine

Add UNIQUE_SHIPPING_STAGES table to data model

TRANSPORT_EMISSIONS_DATA

  • Includes emissions (results from carbon engine) of unique shipping stage

Add TRANSPORT_EMISSIONS_DATA table to data model

TRANSPORT_SECTIONS_EMISSIONS_DATA

  • Leg emissions (results from carbon engine)

Add TRANSPORT_SECTIONS_EMISSIONS_DATA table to data model

TRANSPORT_EMISSION_FACTORS

  • Includes detailed information about the calculated emissions (results from carbon engine)

Add TRANSPORT_EMISSION_FACTORS table to data model

UNIQUE_SHIPPING_ROUTES

  • Derived from UNIQUE_SHIPPING_STAGES

  • Includes all unique shipment stages (unique in terms of the combination of departure address - arrival address)

  • Used for transport mode simulation use case

Add UNIQUE_SHIPPING_ROUTES table to data model

TRANSPORT_EMISSIONS_DATA_ROUTE

  • Same table as previous, but joined to UNIQUE_SHIPPING_STAGES with different foreign key

  • Used for transport mode simulation use case

Add the TRANSPORT_EMISSIONS_DATA_ROUTE table to the data model

TRANSPORT_SECTIONS_EMISSIONS_DATA_ROUTES

  • Same table as previous, but joined to UNIQUE_SHIPPING_STAGES with different foreign key

  • Used for transport mode simulation use case

Add the TRANSPORT_SECTIONS_EMISSIONS_DATA_ROUTE table to the data model

TRANSPORT_EMISSION_FACTORS_ROUTE

  • Same table as previous, but joined to UNIQUE_SHIPPING_STAGES with different foreign key

  • Used for transport mode simulation use case

Add the TRANSPORT_EMISSION_FACTORS_ROUTE table to the data model

VTTK

SAP - Shipment Header Table

Add the VTTS table to data model

VTTP

SAP - Shipment Item Table

Add the VTTP table to the data model

VTTS

SAP - Shipment Stage Table

Add the VTTK table to the data model

SHIPPING_LIKP

SAP - Delivery Header Table

Add the SHIPPING_LIPS table to the data model

SHIPPING_LIPS

SAP - Delivery Items Table

Add SHIPPING_LIKP table to data model