Skip to main content

Celonis Product Documentation

Prerequisites for the case-centric Baseline Date Optimizer app

Before you set up the case-centric version of the Baseline Date Optimizer app, you’ll need to complete these prerequisite steps:

  1. Install and configure a Data Connection between Celonis and your source system.

    If you’ve already set up a Data Connection to this source system, you can reuse it. If not, you'll need to install the Celonis components in your source system, set up the extractor server, and configure a Data Connection in the Celonis platform.

  2. Install and configure the newest version of the Process Connector that the Baseline Date Optimizer app works with.

    This is the one shown on the app’s Celonis Marketplace listing page as the required connector. The Data Model “SAP ECC - Analytical (FI Open + Cleared)” that you’ll use with the app comes with the Process Connector. The easiest way to get the connector is through the Process Connector library. If you’ve already set up this Process Connector for a different app, you can reuse it.

  3. Load the Data Model “SAP ECC - Analytical (FI Open + Cleared)” with your data.

    Required tables and columns lists the tables and columns you’ll need from SAP ECC.

    Important

    The BSEG table, which contains credit memos and invoice items, must have fewer than 30 million rows for the Baseline Date Optimizer app’s augmentation functionality to work. If you need to pre-process your data to meet this requirement, ask your Celonis point of contact to help you choose a suitable strategy.

When the Data Connection and Process Connector are in place and you’ve loaded the Data Model, follow the steps in Installing the case-centric Baseline Date Optimizer app.

If you need to get help with any of the app’s prerequisites or setup steps, Support tells you how.

Required tables and columns

Here’s the reference list of the SAP ECC tables and columns that the Baseline Date Optimizer app needs data from:

Table

Columns

LFA1

KTOKK, LAND1, LIFNR, MANDT, NAME1, VBUND

LFB1

MANDT, LIFNR, BUKRS, ZTERM

BSEG

AUGDT, BELNR, BSCHL, BUKRS, BUZEI, GJAHR, MANDT, SKFBT, WRBTR, WSKTO, ZBD1P, ZBD1T, ZBD2P, ZBD2T, ZBD3T, ZDART_MD, ZFAEL_MD, ZFBDT, ZLSCH, ZLSPR, ZPRZ1_MD, ZPRZ2_MD, ZTAG1_MD, ZTAG2_MD, ZTAG3_MD, ZTERM

BKPF

AWTYP, BELNR, BLART, BLART_TEXT, BLDAT, BUDAT, CPUDT, MANDT, REINDAT, TCODE, WAERS, XBLNR

RBKP

BELNR

EKPO

EBELN, EBELP, KNTTP, MANDT

EKBE

BWART, CPUDT, SHKZG, VGABE

Also include any potential alternative timestamps from the EKBE table relating to goods receipt, such as the BLDAT column, the document date of the delivery note, or BUDAT, the financial posting date of the document.