Create Decision Table and Text Rules
Create and activate the decision tables and text-based rules to create the decision logic.
Overview
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.
Prerequisites
Steps
Navigate to the Rules > Local Rules tab, then choose +.
Rules tab In the New Rule prompt, provide the following details:
Name Type DetermineEquipmentRulesDecision TableThen choose Create.
New Rule Window In the New Rule page, provide the following details and then choose Settings icon.
Label Description DetermineEquipmentRulesRule 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.
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
EquipmentInfoshould be of type Table to hold all the row values.Press CTRL + SPACE to load the autosuggestion list, and then choose Employee under Vocabulary section.
Autosuggestion list Choose the attribute
Country or Region of Companyfrom the Vocabulary section and then in the Label field enter Country or Region.
Attribute in autosuggestion list From the Fixed Operator dropdown list, select None.
Fixed operator Similarly, create the following condition expressions:
Condition Expressions Label Fixed Operator Employee.companyCompanyNoneEmployee.jobTitleJob TitleNoneEmployee.isFullTimeEmployeeFull time/Part timeNoneThe label is displayed in the decision table column header.
Choose
EquipmentInfoas 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.
In the
Country or Regioncolumn, press CTRL + SPACE. Under Comparison Operators, select is equal.
Comparison Operators Under Fixed Value section, select the value help icon to select the value.
Value help Select USA from the value help.
Value help1 In the
Companycolumn provide the following value using the autosuggestion list:='ACE_USA'
Company details 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 Select the first row, then choose Add Row > Insert After.
Company details 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
Use the breadcrumb navigation to navigate to Rules > Local Rules tab, and then choose +.
Create Text Rule In the New Rule window, enter the following values and then choose Create.
Name Type EquipmentApprovalRulesText Rule
New text rule In the New Rule page, enter the following details:
Label Description EquipmentApprovalRulesRules to determine if the approval is needed for equipment or notIn the Text Rule section, choose the Settings icon.
Text Rule details In the Text Rule Settings window, select
EquipmentApprovalas the Result and then choose Apply.
Text Rule Result 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 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
Resources
Discussion
Share feedback on this tutorial or join the conversation in SAP Community.