You’ve learned how to customize field values with mathematical formulas. Next, you’ll learn how to use a logical formula to customize field values.
Note
Logical formulas support logical operators and brackets: (, <, >, !, ==, &&, ||, )
You can also include the Date and Time API in the logical formula.
The previous video showed only one lookup field. However, you can define more than one lookup field for a specific object. For example, when a sales person creates a new sales order for an item and wants to know if this item was already promoted to this customer, you will:
- Add a UDF to the master Data – Activities category "Item_Promoted".
- Add another UDF to the master Data – Activities category "Promoted".
The sales person can create an activity for each call with the customer and use these fields to update that this specific item was promoted. 
- Add a UDF to the Marketing Documents – Rows "Promoted".
- Add a UDV to the "Promoted" UDF.
This will inform the sales person who is creating the sales order if the item was already promoted.
In addition, you can define more than one lookup object. For example, if the user needs to check whether the shipping type in a sales order row is identical to the shipping type of the Item master data, and to the shipping type of the Business Partner. If all of the shipping types are not identical, you want to turn on a checkbox "Ship Different". This will alert the user who is filling the order.
- Add a UDF to Marketing Documents – Rows "Ship Different".
- Add a UDV to this UDF.
This will inform the user if there is a difference in the shipping type. 