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:

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

Was this helpful?

Would you like to provide feedback? Just click here to suggest edits.