kiran g
Well Known Member
Hi,
I am looking for information about views created by JDE OneWorld. While browsing tables in OneWorld database, I found that Table F98711 stores information about tables and their columns and Tables F98712 and F98713 stores information about tables and indexes created on them.
I am looking for similar information about Views (e.g. columns of view).I didn't find any table which can give me the information about View and list of tables on which view is created.
I don't want to use cross reference for getting this information. I want to retrieve this information from database tables only. So please tell me which table I should refer to get more information on OneWorld Views.
Thanks in advance,
Kiran
I am looking for information about views created by JDE OneWorld. While browsing tables in OneWorld database, I found that Table F98711 stores information about tables and their columns and Tables F98712 and F98713 stores information about tables and indexes created on them.
I am looking for similar information about Views (e.g. columns of view).I didn't find any table which can give me the information about View and list of tables on which view is created.
I don't want to use cross reference for getting this information. I want to retrieve this information from database tables only. So please tell me which table I should refer to get more information on OneWorld Views.
Thanks in advance,
Kiran