App Technical Recap
Data Integration
1, Standard Order-to-Cash (O2C) process connector + shipping and emission specific add-ons
Extraction add-ons
VTTK
VTTP
VTTS
VTSP
T173W
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, Python scripts to run the emission calculation via the carbon engine
Reach out to the Celonis sustainability team (sustainability@celonis.com) for requesting the python scripts which are needed to execute the carbon engine. With this request you will also receive a project specific API key.
Studio App
The Studio App, on Marketplace as ‘Shipping Emissions Reduction’.Which contains:
Views
Shipping Emissions Cockpit (target group: analytical users, team leads)
Open Shipment Processing (target group: operational users)
KM
Skills