override the Business Unit field reference in cmdb_ci_business_app table using Dictionary Override

[mihirgupta]

Hi, I need some help with a configuration in ServiceNow.

In the cmdb_ci_business_app table, the Business Unit field (inherited from the base table cmdb_ci) currently references the Business Unit (cmn_business_unit) table.

As per the new business requirement, for the Business Application table only, the Business Unit field should instead reference the Department (cmn_department) table.

Since this field is inherited from the base table, I understand this change can be achieved through a Dictionary Override on the business_unit field.

Could you please guide me on how to override the reference so that it points to the Department table instead of Business Unit?

In the Dictionary Override form for a reference field,
you don’t see a “Reference” field (like you do in the main dictionary entry).

Instead, you only see “Reference qualifier” and related options —
because “reference” (the table that field points to) is not one of the directly editable override fields by default in the UI.

[Brad Bowman · Accepted solution]

You cannot alter the table that an inherited reference field references for just one table.  For this requirement I would suggest creating a new field on the Business Application table that references the Department table, then displaying this new field on the form in place of the out of box one.