Question

select query to find entities in the cloud database

  • 15 March 2024
  • 4 replies
  • 58 views
S
Rank
Badge +1
  • shva
  • Do Gooder (Customer)
  • 2 replies

Hi All,

I would like to get SELECT query to find ENTITIES from the cloud database. It should be a base view from the Aurena cloud. Since i want it to create List of Values(LOV), there view alone can be used.

I have tried with DICTIONARY_SYS_VIEW .But it did not work.

Is there any way to find a solution ?

Thanks in advance.

 

 

 

 

4 replies

ashen_malaka_ranasinghe
Rank
Userlevel 3
Badge +10

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';

 

Find me on LinkedIn as Ashen Malaka: https://www.linkedin.com/in/ashen-malaka-ranasinghe/
S
Rank
Badge +1

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

S
Rank
Badge +1

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. 

2 Attachments
ashen_malaka_ranasinghe
Rank
Userlevel 3
Badge +10

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.

Find me on LinkedIn as Ashen Malaka: https://www.linkedin.com/in/ashen-malaka-ranasinghe/

Reply


Terms & ConditionsCookie settings