Skip to main content

Celonis Product Documentation

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..