Skip to Content

Create Decision Table and Text Rules

Beginner
15 min.
SAP Workflow Management, business rules capability, Beginner, Tutorial, Cloud, SAP Business Technology Platform, SAP BTP, Cloud Foundry environment
Create and activate the decision tables and text-based rules to create the decision logic.
You will learn
  • How to create decision table rules
  • How to create text rules
VandanaVasudevanVandana VasudevanSeptember 29, 2021
Created by
VandanaVasudevan
September 19, 2019
Contributors
VandanaVasudevan

A decision table rule is the collection of rule expressions in tabular format. The rule expressions are sequentially executed, and the matching rows are returned.

A text rule is a decision logic in a simple if-then-else format. A text rule evaluates a single rule expression and returns the result that matches the condition.

In this tutorial, we will create the decision logic required to assign equipment for the new hire, both as a text rule as well as a decision table.

  • Step 1

    1. Navigate to the Rules > Local Rules tab, then choose +.

      Rules tab

    2. In the New Rule prompt, provide the following details:

      Name Type
      DetermineEquipmentRules Decision Table

      Then choose Create.

      New Rule Window

    3. In the New Rule page, provide the following details and then choose Settings icon.

      Label Description
      DetermineEquipmentRules Rule to determine equipment for the new hire based on the country and job title of the new hire.
      New Rule Page

      The decision table settings window opens.

    4. In the decision table settings window, select the Hit Policy as First Match. With Hit Policy as First Match, the decision table returns the first row that matches the condition.

      Hit Policy

      In this tutorial, we are using the First Match hit policy. If you select All Match hit policy, all the rows of the decision table that matches the condition are returned. In this case, the result data object EquipmentInfo should be of type Table to hold all the row values.

    5. Press CTRL + SPACE to load the autosuggestion list, and then choose Employee under Vocabulary section.

      Autosuggestion list

    6. Choose the attribute Country or Region of Company from the Vocabulary section and then in the Label field enter Country or Region.

      Attribute in autosuggestion list

    7. From the Fixed Operator dropdown list, select None.

      Fixed operator

    8. Similarly, create the following condition expressions:

      Condition Expressions Label Fixed Operator
      Employee.company Company None
      Employee.jobTitle Job Title None
      Employee.isFullTimeEmployee Full time/Part time None

      The label is displayed in the decision table column header.

      Choose EquipmentInfo as the Result data object from the dropdown list and then choose Apply.

      DT settings

      A decision table gets created with the condition columns and result columns.

    9. In the Country or Region column, press CTRL + SPACE. Under Comparison Operators, select is equal.

      Comparison Operators

    10. Under Fixed Value section, select the value help icon to select the value.

      Value help

      Select USA from the value help.

      Value help1

    11. In the Company column provide the following value using the autosuggestion list:

      ='ACE_USA'

      Company details

    12. In the subsequent cells, provide the following values:

      Job Title Full Time/Part Time Product ID Equipment Type Price Product Description Currency
      MATCHES '.*' = true OR Employee.IsFullTimeEmployee = false 'A106743' 'Audio and Video' 35.96 'Lovely Sound 5.1' EUR
      Company details

    13. Select the first row, then choose Add Row > Insert After.

      Company details

    14. Enter the following values in the condition and result columns of the new row:

      Country or Region Company Job Title Full Time/Part Time Product ID Equipment Type Price Product Description Currency
      = 'USA' MATCHES '.*' MATCHES '.*' = true OR Employee.IsFullTimeEmployee = false 'C106875' 'Notebook' 956.00 'Notebook Basic 15' 'EUR'

      Then, choose Activate.

      Company details
  • Step 2

    1. Use the breadcrumb navigation to navigate to Rules > Local Rules tab, and then choose +.

      Create Text Rule

    2. In the New Rule window, enter the following values and then choose Create.

      Name Type
      EquipmentApprovalRules Text Rule
      New text rule

    3. In the New Rule page, enter the following details:

      Label Description
      EquipmentApprovalRules Rules to determine if the approval is needed for equipment or not

      In the Text Rule section, choose the Settings icon.

      Text Rule details

    4. In the Text Rule Settings window, select EquipmentApproval as the Result and then choose Apply.

      Text Rule Result

    5. In the If section, press CTRL+**SPACE** and then provide condition expression using the autosuggestion list:

      Equipment.TotalAmount > 800

      Text Rule if condition

      In the Then section, enter true. Then, choose Add Else to an Else section.

      Else condition

    6. In this Else section, enter 'false'.

      Activate text rule

      Then, choose Activate.

      Activate text rule

      Navigate to the Rules > Local Rules tab to view the list of rules as shown:

      Some alternative text

    Which of the following entities holds the decision logic of the project?

Back to Top
Back to top