Skip to main content

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.

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