Skip to main content

Celonis Product Documentation

Using Imported Tables in the Inventory Management ‘Local’ Jobs

Although this is not currently in use in the standard configuration of the IM connector, it is actually possible to import tables from other data pools and ‘push’ them to the local pool of the IM connector.

Follow the steps below to set up the push of local tables.

If you are already extracting and using some of the IM specific tables in the other data pools that you work with, for example MSEG or RESB, it is not required to re-extract them in the local job of the IM connector. You could instead do the following:

  1. Disable the table from the local extraction by navigating to the local data job and opening the extraction. Tables can be deactivated by clicking the three dots:

    IM_Connector_Push_Tables_2.png
  2. If not already available, navigate to the IM global job and create a new global job named “0.0 Import and Push tables [ Optional ]” and then create a new transformation:

    IM_Connector_Push_Tables_3.png
  3. Inside of the transformation, the objective is to create a table in the local job based on the table from the source data pool. It is important that you update the data connection parameter in the FROM statement, to the parameter of your system.

    DROP TABLE IF EXISTS <%=DATASOURCE:SAP_ECC%>.MSEG; -- Target Local job you want to push to
     
    CREATE TABLE
    <%=DATASOURCE:SAP_ECC%>.MSEG AS ( -- Target Local job you want to push to
       SELECT
           *
       FROM <%=DATASOURCE:SAP_ECC_-_ORDER_TO_CASH_ORDER_TO_CASH_-_SAP_ECC%>.MSEG -- source table in source pool
    );
  4. Incorporate the new global job into your data job scheduling, such that these import and push transformations are executed prior to the Local IM data job “execute material management tasks.” This ensures that the MSEG table (from this example) is updated in the local job prior to the local transformations that depend on it are run.