Skip to main content

Celonis Product Documentation

Pool Parameters
Create data pool parameters for shipping type mapping

For the calculation of transport emissions, it is necessary to assign the shipping types from the source systems to the transport modes required for the carbon engine.

  • Step 1: Check your Shipping types

    Run the following script in the data job “SAP O2C - Full Transformation”:

    select distinct
    VSART,
    BEZEI
    from O2C_VTTS
    where VSART is not null;

    Save the resulting table by making a screenshot or creating a copy.

    Example:

    image31.png

    The VSART column shows your shipping type codes while BEZEI provides a description for each code.

  • Step 2: Create data pool parameters for each transport modes

    In this step we create data pool parameters for each of the four transport modes by assigning the shipping type codes to the transport modes using the descriptions from the table above.

    Create data pool parameter “Shipping_Type_Road”:

    Example:

    image33.png

    Note

    Enter the shipping type codes for which the description can be assigned to the transport mode "Road" as values.

    Create data pool parameter “Shipping_Type_Air”:

    Example:

    image29.png

    Note

    Enter the shipping type codes as values for each description that can be assigned to the "Air" transport mode.

    Create data pool parameter “Shipping_Type_Sea”:

    Example:

    image35.png

    Note

    Enter the shipping type codes as values for each description that can be assigned to the "Sea" transport mode.

    Create data pool parameter “Shipping_Type_Rail”:

    Example:

    image46.png

    Note

    Enter the shipping type codes as values for each description that can be assigned to the "Rail" transport mode.

After this step, four new data job parameters will have been created.

image41.png