Skip to main content

Celonis Product Documentation

Value Discovery App Configuration (if required)

In order for the Value Discovery (VD) App to work, modifications have to be made to the Data Model, as well as changes to some of the runtime variables.

Modifications to the Data Model

The Value Discovery App needs a new table added in the Data Model using the following steps:

  1. Go to the Data Integration section of Celonis and select the Data Pool that you are using for the Starter Kit.

  2. Click Data Jobs and then click on New Data Job with the option to add it as a Global (no data connection). We recommend naming it "Create Inefficiency Table".

  3. Click on New Transformation. We recommend naming it "Create Inefficiency Table" and without any task template.

  4. Paste the code provided below.

  5. Select all code and click the Execute button.

  6. Go to the Data Model that you are using for the Starter Kit. Add the INEFFICIENCIES table via the Add Tables button and then click Finish.

  7. Reload the Data Model.

DROP TABLE IF EXISTS INEFFICIENCIES;
CREATE TABLE INEFFICIENCIES (
  INEFFICIENCY_NAME VARCHAR(100),  
  TIME_TO_VALUE VARCHAR(100),  
  BUSINESS_OBJECTIVE VARCHAR(100))
;

INSERT INTO INEFFICIENCIES
  (INEFFICIENCY_NAME,TIME_TO_VALUE,BUSINESS_OBJECTIVE)
  SELECT 'Duplicate Invoices','A - Low','Spend' UNION
  SELECT 'Lost Cash Discount','A - Low','Spend' UNION
  SELECT 'Early Payments','B - Medium','Working Capital' UNION
  SELECT 'Late Payments','A - Low','Labor Productivity' UNION
  SELECT 'Manual Invoice Posting','C - High','Labor Productivity' UNION
  SELECT 'Short Payment Terms','B - Medium','Working Capital' UNION
  SELECT 'Manual Payment Block Changes','B - Medium','Labor Productivity' UNION
  SELECT 'Manual Invoice Clearing','C - High','Labor Productivity' UNION
  SELECT 'Manual Payment Term Changes','B - Medium','Labor Productivity' UNION
  SELECT 'Invoices w/ Retrospective POs','A - Low','Spend' UNION
  SELECT 'Invoices without Purchase Order','A - Low','Spend' UNION
  SELECT 'Manual Baseline Date Changes','B - Medium','Labor Productivity' UNION
  SELECT 'Baseline Date Decreases','B - Medium','Working Capital' UNION
  SELECT 'Payment Term Decreases','B - Medium','Working Capital' UNION
  SELECT 'Unfavorable Payment Terms','B - Medium','Working Capital' UNION
  SELECT 'Multiple Payment Terms per Vendor','B - Medium','Working Capital'

Updating the Runtime Variables

Next, configure the runtime variables in the table below to your specifications.

Variable ID

Variable Description

Default Value

userTypesAutomated

Include all user types that are considered Automated

'B', 'S'

PostingActivity

Posting Activity

'Enter in SAP'

setPaymentBlockActivity

Payment Block Activity Field

'Set Payment Block'

BaselineDateField

Baseline Date Field

'ZFBDT'

PaymentTermField

Payment Term Field

'ZTERM','ZBD1T','ZBD2T','ZBD3T','ZBD1P','ZBD2P'

InvoiceClearingActivity

Invoice Clearing Activity

'Clear Invoice', 'Clear Invoice with Payment Run'

ReferenceTransactionField

Field to identify a reference transaction

‘RMRP’

PaymentBlockActivity

Payment Block Activity

'ZLSPR'

Important

For the app to work properly, click the Publish button in the upper-right corner to publish the app.