Prerequisites for the object-centric GR/IR Reconciliation app
BBefore you set up the object-centric GR/IR Reconciliation app, you’ll need to enable and configure the Procurement process, load the object-centric data model with your data, and validate the Procurement perspective. The app uses the Procurement perspective for SAP ECC as a basis.
You’ll also need to extend existing objects, set up an additional custom object type, and create a custom Procurement perspective with the additional object. You’ll use the custom perspective with the app in place of the supplied perspective_celonis_Procurement perspective. The object-centric GR/IR Reconciliation app uses a combination of purchasing data and general ledger data. While most of the required tables are part of the OCPM extraction package for SAP, others must be manually added, as detailed in Required tables and columns.
When you select Request access for the app on the Celonis Marketplace, we’ll provide a step-by-step guide for you to extend objects, set up the custom object type and the custom perspective. Alternatively, raise a support ticket to request it - Support tells you how.
For the steps to connect a source system to the OCPM Data Pool and create objects and events from your data, see Quickstart: Extract and transform your data into objects and events.
For instructions to work with perspectives, see Using objects and events for process mining.
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.
Table | Columns |
|---|---|
ADR6 | CLIENT, ADDRNUMBER, PERSNUMBER, DATE_FROM, CONSNUMBER, SMTP_ADDR |
BKPF | MANDT, BUKRS, BELNR, GJAHR, AWKEY, AWTYP, BLART, BLDAT, BUDAT, CPUDT, CPUTM, TCODE, USNAM, WAERS, XBLNR |
BSEG | MANDT, BUKRS, BELNR, GJAHR, BUZEI, AUGBL, AUGDT, DMBTR, EBELN, EBELP, HKONT, KOSTL, KTOSL, MEINS, MENGE, PRCTR, SGTXT, SHKZG, WRBTR, XREF3, ZUONR |
EKPO | MANDT, EBELN, EBELP, AEDAT, AFNAM, BSTYP, ELIKZ, EREKZ, LOEKZ, MATNR, MEINS, MENGE, WERKS |
EKKO | MANDT, EBELN, AEDAT, BSART, BSTYP, BUKRS, EKGRP, EKORG, ERNAM, LIFNR |
LFA1 | MANDT, LIFNR, NAME1, VBUND |
SKAT | MANDT, SPRAS, KTOPL, SAKNR, TXT50 |
T001 | MANDT, BUKRS, BUTXT, KTOPL, WAERS |
T001W | MANDT, WERKS, NAME1 |
T003T | MANDT, SPRAS, BLART, LTEXT |
T024 | MANDT, EKGRP, EKNAM, 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 |
USR02 | MANDT, BNAME, USTYP |
USR21 | MANDT, BNAME, PERSNUMBER, ADDRNUMBER |