Information about Views

kiran g

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
 
Kiran,

The business view definitions are stored in F98720 and in spec files on clients and servers. However you will need to make use of the spec API's to bring the information out of the binary field in this table.
 
Back
Top