App Data Structure
In order to accurately quantify shipping emissions, it is necessary to have access to comprehensive shipment data. This overview shows the structure of the data used in the app
Notice
If some of tables are not available or not maintained, this should not be an blocker to implementing the app. There are numerous alternatives to populate the data fields that are crucial to the emissions calculation. Experience has shown that in most cases, distance-based emissions calculations based on the data available are orders of magnitude better than other approaches, such as measuring emissions based on transportation spending. The lessons learned from implementing and using the app can also be used to improve accuracy in the future.
For an extended data guide explaining the standard data objects and fields, and alternative strategies for dealing with poor data availability or quality, please contact the Celonis sustainability team.
Data components
1, Standard Order-to-Cash (O2C) process connector + shipping and emission specific add-ons
Extraction add-ons
VTTK
VTTP
VTTS
VTSP
T173T
T001W
Transformations add-ons
Create Table: O2C_VTTP
Create Table: O2C_VTTK
Create Table: O2C_VTSP
Create Table: O2C_VTTS
Create Table: Shipment Network (Signal Link)
Create Table: Carbon Engine Emissions Data
Create Datamodel Views
Data Model add-ons
SHIPMENT_NETWORK
Main table which combines shipment, delivery and order item data
Uses signal link to generate a graph which can be displayed in the network explorer component to view shipments visually with arcs between locations
UNIQUE_SHIPPING_STAGES
Includes all unique shipping stages (unique combination of departure location - arrival location - transport mode - shipping type) which are used as input for calculating the emissions
UNIQUE_SHIPPING_ROUTES
Includes all unique shipping routes (unique combination of departure location - arrival location - shipping type)
The information are used for the shipping type simulation use case
TRANSPORT_EMISSIONS_DATA / TRANSPORT_SECTIONS_EMISSIONS_DATA / TRANSPORT_EMISSION_FACTORS
Stores the result from the carbon engine
Different level of detail
Includes emissions (per kg) of each unique shipping stage
TRANSPORT_EMISSIONS_DATA_ROUTE / TRANSPORT_SECTIONS_EMISSIONS_DATA_ROUTE / TRANSPORT_EMISSION_FACTORS_ROUTE
Emissions used in the shipping type simulation use case
SHIPPING_TYPE_METADATA
Configuration table used for specifying the attributes of different shipping types (e.g. map to transport modes; define max. Vehicle weight for utilization use case; specify details)
VTTK / VTTP / VTTS
Shipment tables
Shipment Header
Shipment Items
Shipment Stages
SHIPPING_LIKP / SHIPPING_LIPS
Delivery tables
2, Distance-based and GLEC-certified emission data via the carbon engine (powered by Climatiq)
Reach out to the Celonis sustainability team (sustainability@celonis.com) for requesting the API key which are needed to execute the carbon engine..