Skip to main content

Celonis Product Documentation

Variables

Below is a list and description of the most important variables:

Variables for Table Alias

VAR_TABLE_Cases

_CEL_AP_CASES

The case table in the operational data model (RBKP + BSEG). If this value is changed, the embedded view in the “Vendor Block” view needs to be replaced as it contains an hardcoded Java Script filter. The snippet below shows an example of the BSEG used as case table:

layout: 
   rows:
      - id: row_1afd722c-eaf9-4981-a562-34ec8473da04
        growHeight: false
        columns:
           - id: column_2c810e46-5b33-4e17-81ba-fa6235f6eb03
             componentId: view-replacement
             size: "1"
             type: ""
             order: 100
        height: ""
        order: 250
components:
   - id: view-replacement
     type: view
     settings:
        key: central-vendor-view
        shareFilters: false
        shareVariables: false
        shareAll: false
        shareSelections: true
     filters:
        - pql: FILTER "BSEG"."LIFNR" = '${record.VENDOR_ID}'

VAR_TABLE_PurchaseOrder

EKKO

Purchase document header

VAR_TABLE_PurchaseOrderItem

EKPO

Purchase document item

VAR_TABLE_IncomingInvoiceItem

RSEG

Incoming invoice header

VAR_TABLE_Activity

_CEL_AP_ACTIVITIES

The activity table

VAR_TABLE_VendorMasterGeneral

LFA1

The vendor master data table across company codes

VAR_TABLE_VendorMasterCompanyCode

LFB1

The vendor master data table per company code

Variables for Thresholds

The threshold variables are configured as runtime variables and can be updated directly in the Settings view.

VAR_THRESHOLD_CriticalCashDiscount

1000

Parameter used in Cash Discount Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_HighCashDiscount

500

Parameter used in Cash Discount Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_MinimumCashDiscount

100

Parameter used in Cash Discount Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_CriticalProcessingTime

5

Parameter used in Cash Discount and On-Time Payment Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_RegularProcessingTime

10

Parameter used in Cash Discount and On-Time Payment Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_CashDiscountPaymentBuffer

3

Days after the Cash Discount Due date the discount is still realized (SAP setting)

VAR_THRESHOLD_HighInvoiceAmount

10000

Parameter used in On-Time Payment Prioritization (see Invoice Prioritization)

VAR_THRESHOLD_CriticalOverdueThreshold

14

Number of days when the priority of an overdue invoice is becoming at least high

Variables for Currency Conversion

VAR_CURR_CONVERSION_EligibleCashDiscount

Parked: RBKP.RMWWR

Posted: BSEG.WRBTR

The amount on an invoice that is eligible for realizing the discount

VAR_CURR_CONVERSION_DirectCashDiscount

WSKTO

Discount field in case of direct cash discount (discount terms are zero and cash discount is entered directly)

VAR_CURR_CONVERSION_AccountingDocumentLineValue

Parked: RBKP.RMWWR

Posted: BSEG.WRBTR

Invoice line value