---
parser: v2
auto_validation: true
time: 15
tags: [ tutorial>beginner, topic>cloud, products>sap-business-technology-platform, products>sap-btp--cloud-foundry-environment]
primary_tag: products>business-rules
author_name: Vandana Vasudevan
author_profile: https://github.com/VandanaVasudevan
slug: cp-cf-businessrules06-dt-textrule
canonical_url: https://developers.sap.com/tutorials/cp-cf-businessrules06-dt-textrule
---

# Create Decision Table and Text Rules
<!-- description --> 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

  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.

---

### Create decision table rules


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

    ![Rules tab](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_1.png)

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

    |  Name   | Type
    |  :------------- | :-------------
    | **`DetermineEquipmentRules`** | **`Decision Table`**

    Then choose **Create**.

    ![New Rule Window](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_2.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_3.png)

    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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_4.png)

    > 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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_5.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_6.png)

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

    ![Fixed operator](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_7.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_8.png)

    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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_9.png)

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

    ![Value help](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_10.png)

    Select **USA** from the value help.

    ![Value help1](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_11.png)

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

    `='ACE_USA'`

    ![Company details](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_12.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_13.png)

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

    ![Company details](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_14.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_dt_15.png)


### Create text rules


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

    ![Create Text Rule](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule1.png)

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

    |  Name     | Type
    |  :------------- | :-------------
    | **`EquipmentApprovalRules`** | **`Text Rule`**

    ![New text rule](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule2.png)

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](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule3.png)

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

    ![Text Rule Result](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule4.png)

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

    `Equipment.TotalAmount > 800`

    ![Text Rule if condition](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule5.png)

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

     ![Else condition](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule6.png)

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

    ![Activate text rule](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule7.png)

    Then, choose **Activate**.

    ![Activate text rule](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_text_rule8.png)

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

    ![Some alternative text](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/cp-cf-businessrules06-dt-textrule/create_rules.png)