Prerequisites for the case-centric GR/IR Reconciliation app
Before you set up the GR/IR Reconciliation app, you’ll need to complete these prerequisite steps:
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.
Install and configure the dedicated SAP Connector for the GR/IR Reconciliation app. The Process Connector for the app is not available in the Celonis Marketplace. Raise a support ticket to request it - Support tells you how.
Note
The GR/IR Reconciliation app uses a combination of purchasing data and general ledger data.
If you’re already using our Process Connector for Accounts Payable or for Purchase to Pay, the purchasing data needed by the GR/IR Reconciliation app will already be extracted and available through that data connection, and if so you can reuse it from there. If you aren’t using those connectors, the Process Connector for the GR/IR Reconciliation app will extract and transform the purchasing data.
The general ledger data is not covered by any standard Process Connector, so you’ll need to extract and transform it using the Process Connector for the GR/IR Reconciliation app.
Load the Data Model “SAP ECC - GR/IR Reconciliation” with your data. Required tables and columns lists the tables and columns you’ll need from SAP ECC.
When the Data Model is in place and loaded, follow the steps in Installing the case-centric GR/IR Reconciliation 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 SAP tables and columns that the GR/IR Reconciliation app needs data from.
Important
With SAP ECC, the cluster table BSEG is required for the app to function, as general ledger items must be directly linked to the purchase order line. As the BSEG table is typically large and slow to extract, an alternative approach is to partially extract it with only core columns, for only open items, and less frequently. If you do this, you’ll need to extract columns from the transparent BSIS and BSAS tables as well. The Process Connector for the GR/IR Reconciliation app includes upsert transformation logic to combine those columns with the partial extract from the BSEG table to complete your data.
Table | Columns |
|---|---|
ADR6 | CLIENT, ADDRNUMBER, PERSNUMBER, DATE_FROM, CONSNUMBER, SMTP_ADDR |
BKPF | MANDT, BUKRS, BELNR, GJAHR, AWKEY, AWTYP, BLART, BLDAT, BUDAT, CPUDT, USNAM, WAERS, XBLNR |
BSEG (when fully extracting BSEG) | MANDT, BUKRS, BELNR, GJAHR, BUZEI, AUGBL, AUGDT, DMBTR, EBELN, EBELP, HKONT, KTOSL, MEINS, MENGE, SHKZG, WRBTR, XREF3, ZUONR |
BSEG (when partially extracting BSEG) | MANDT, BUKRS, BELNR, GJAHR, BUZEI, EBELN, EBELP, KTOSL, MEINS, MENGE |
BSIS (only when partially extracting BSEG) | MANDT, BUKRS, HKONT, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI, DMBTR, SHKZG, WRBTR, XREF3 |
BSAS (only when partially extracting BSEG) | MANDT, BUKRS, HKONT, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI, DMBTR, SHKZG, WRBTR, XREF3 |
EKPO | MANDT, EBELN, EBELP, AEDAT, AFNAM, ELIKZ, EREKZ, LOEKZ, MATNR, MEINS, MENGE, WERKS |
EKKO | MANDT, EBELN, AEDAT, BSART, BUKRS, EKGRP, EKORG, ERNAM, LIFNR |
LFA1 | MANDT, LIFNR, NAME1, VBUND |
SKAT | MANDT, SPRAS, KTOPL, SAKNR, TXT50 |
T001 | MANDT, BUKRS, KTOPL, WAERS |
T024 | MANDT, EKGRP, SMTP_ADDR |
T161T | MANDT, SPRAS, BSART, BSTYP, BATXT |
TCURF | MANDT, KURST, FCURR, TCURR, GDATU, FFACT, TFACT, ABWCT, ABWGA |
TCURR | MANDT, KURST, FCURR, TCURR, GDATU, UKURS, FFACT, TFACT |
TCURX | CURRKEY, CURRDEC |
USR21 | MANDT, BNAME, PERSNUMBER, ADDRNUMBER |