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. Then to create a one-to-many relationship within the lookup, in the tree view panel, select
many
under the parent node and then click
Create
. For example, you create a country lookup reference entity related to the C_LU_COUNTRY lookup base object.
In the tree view, expand the parent node under which you want to create a child node.
For example, expand the LU Country node.
Under the expanded node, select
field
.
In the tree view, click
Create
.
From the New Field form in the node 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.
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.
Optionally, configure the Read only, Required, Type, URI, Searchable, and Filter properties for the field you created.
If you enable the Searchable property, additional search properties appear. For information about the search properties, see the chapter about search in the
Multidomain MDM Configuration Guide
.
Select
many
under the parent node, and then click
Create
.
In the node 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.