- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 01:02 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 05:08 AM
Hi @nandup ,
Business units are parts of your organization that are in charge of certain operations, such as Finance, HR, IT.
Business units usually comprise departments and are associated with a company. By default, the Hierarchy of Segments includes a segment for business units, departments, and vendors, which are companies with the Vendor option selected.
While creating a Business unit, there is a "Business Unit Head" which references to sys_user table.
Also, in the user record, we can find Department, where in turn you can find the business unit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 06:15 PM
Hi @nandup
There is no direct relation between sys_user table and business_unit table except the Business Unit Head in business unit table which references sys_user.
If you ever want to check this kind of relationships you can try schema map. Navigate to Tables (sys_db_object) module and look for the table in your question and open that record. In the record opened, under related links click on Show schema map.
Once the schema map page is loaded, enable the check boxes Referenced Tables and Referencing tables and wait for the loading to be completed. It will show you relation between the table and other tables where it is referenced.
And also you can search in the dictionary table where field table is Reference and references the table name of your interest.
Please mark my answer helpful and accept as a solution if it helped 👍✅
Anvesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 04:48 AM
Hi @nandup
unfortunately it is not clear what your question is about. Please provide more details.
The only thing I can tell you is that there is a field "Department" on the sys_user table. And a department has a reference to a "Business Unit". So the OOTB relation between a user and a business unit goes over the department.
Maik

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 05:08 AM
Hi @nandup ,
Business units are parts of your organization that are in charge of certain operations, such as Finance, HR, IT.
Business units usually comprise departments and are associated with a company. By default, the Hierarchy of Segments includes a segment for business units, departments, and vendors, which are companies with the Vendor option selected.
While creating a Business unit, there is a "Business Unit Head" which references to sys_user table.
Also, in the user record, we can find Department, where in turn you can find the business unit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 06:15 PM
Hi @nandup
There is no direct relation between sys_user table and business_unit table except the Business Unit Head in business unit table which references sys_user.
If you ever want to check this kind of relationships you can try schema map. Navigate to Tables (sys_db_object) module and look for the table in your question and open that record. In the record opened, under related links click on Show schema map.
Once the schema map page is loaded, enable the check boxes Referenced Tables and Referencing tables and wait for the loading to be completed. It will show you relation between the table and other tables where it is referenced.
And also you can search in the dictionary table where field table is Reference and references the table name of your interest.
Please mark my answer helpful and accept as a solution if it helped 👍✅
Anvesh