Skip to main content

Celonis Product Documentation

Data Transformations Overview for AR Cash App

The following section will detail some of the reasoning behind different transformations in the AR connector and what should be considered when implementing. The transformations should be run in the order of the prefix and the following order. Please refer to the Data Pool Overview for more details on each job.

The transformations in jobs D1 - AR Cash Application Global Tables & Views, D1 - AR Cash Application Full Load Job and D2 - AR Cash Application Delta Job.

  1. Create View - All CashApp Base Tables : Create a view to store the Tolerance values in the SAP source system. It also creates a view to store the payment and payment details. We will fetch the Tolerance from the T043G/T043GT table.

  2. Create Table: Payment Line : Create a table called AR_PAYMENT_LINE where we will store Invoice clearing lines for customer invoice(s).

  3. Create Table - Tolerance (full): Creates a Tolerance table with a generic name to store the data from the T043G and T043GT tables created from Step 1 and Step 2 transformation.

  4. Insert Records - Tolerance (full): Inserts data into the Tolerance table from the T043G and T043GT tables created during Step 1 and Step 2 transformation.

  5. Create Table : AR_FEBEP: Creates a AR_FEBEP table with a generic name to store the data from the FEBEP tables created from Step 1 and Step 2 transformation.

  6. Create Table : AR_FEBKO: Creates a AR_FEBKO table with a generic name to store the data from the FEBKO tables created from Step 1 and Step 2 transformation.

  7. Add Transaction Activity - Cash on Account [Posting] Editor: Captures Cash on Account activity based on the TRANSACTION.POSTING_KEY and TRANSACTION.DOCUMENT_TYPE field.

  8. Add Transaction Activity - Reversals: Captures payment Reversal activity based on the TRANSACTION.POSTING_KEY and TRANSACTION.XREVERSAL field.

  9. Add Transaction Activity - Cash on Account [Clearing]: Captures Cash on Account Clearing activity based on the TRANSACTION.POSTING_KEY and TRANSACTION.DOCUMENT_TYPE field.

  10. Add Transaction Activity - Clear Credit Memo : Captures Cash on Account Clearing activity based on the TRANSACTION.POSTING_KEY.

  11. Add Transaction Activity - Cash Receipts: Captures Cash Receipt activity based from the FEBEP and FEBKO table.

  12. Create Table - Payment: Creates a PAYMENT table with a generic name to store the data from the TRANSACTION tables created from Step 1 and Step 2 transformation.

  13. Insert Records - Payment: Inserts data into the PAYMENT table from the TRANSACTIONS / BSEG tables created during Step 1 and Step 2 transformation.

  14. Create Table - Payment Batch: Creates a PAYMENT BATCH table with a generic name to store the data payment groups.

  15. Insert Records - Payment Batch: Inserts data into the PAYMENT BATCH table from the PAYMENT tables created during Step 1 and Step 2 transformation.