To configure a dependent lookup, create a new reference entity in the tree view panel and then associate the root node with a lookup base object. To create a one-to-many relationship within the lookup, in the tree view panel, select
One to Many
under the parent node and then click
Create
. For example, you can create a country lookup reference entity related to the C_LU_COUNTRY lookup base object.
Click
Business Entity
Modeling
, and then select
Reference Entities
.
Select the reference entity.
In the tree view panel, select
Fields
, and then click
Create
.
From the New Field form in the properties panel, select the base object column to associate with the field from the
Column
list.
For example, select
Country_Code
from the
Column
list.
The base object column is created in the MDM Hub before you add a field to a node.
Enter a field name and a field display name.
For example, enter
Country Code
for the field name and field display name.
Optionally, configure the Read Only, Required, URI, Type, Display Format, Filter, and Searchable properties for the field you created.
If you enable the Searchable property, additional search properties appear. For information about the search properties, see the
Multidomain MDM Configuration Guide
.
Click
Apply
.
The field you created appears in the tree view panel.
Create another field. In this example, select
Country_Name_Disp
from the
Column
list.
Enter a field name and a field display name. In this example, enter
Country Name Disp
for the field name and field label name.
Select
One to Many
under the parent node, and then click
Create
.
In the properties panel, select the base object that contains the lookup child node data.
For example, select the lookup base object C_LU_State.
Select the constraint reference that defines the MDM Hub relationship between the base object of the parent node and the base object of the child node.
For example, select the constraint C_LU_STATE(COUNTRY_CODE).C_LU_COUNTRY(COUNTRY_CODE).
The constraints are created in the MDM Hub before you configure the business entity structure.
Optionally, enter a node name, a node label name, and a node description.
For example, enter LU State for the node name and node label name.
Click
Apply
.
The changes are saved but are not published to the MDM Hub.