select query to find entities in the cloud database

Hi @shva,

By executing the following SQL query in the database, you can view all the active logical units of components.

SELECT * FROM dictionary_sys_lu_active;

To view the components, you can use the following SQL query.

SELECT * FROM module_tab;

For an example, if you need to get all the active logical units of the module - FNDBAS, you can use a SQL query like below.

SELECT * FROM dictionary_sys_lu_active WHERE MODULE = 'FNDBAS';

Thank you so much for your quick response. It works.

Hi @ashen_malaka_ranasinghe,

I can not find this view name “dictionary_sys_lu_active” from  the View List name  while we are creating the  custom field when Data type is Reference and Reference format is Restricted.

Kindly find the attachments to get more in details.

Thanks. 

Seems like this view is not exposed to the client.