timallen
Well Known Member
If you want a list of all OneWorld tables and their descriptions, you can get it from the F9869 table (Object Librarian Master Table). This query will get the tables in Oracle:
select SIOBNM, SIMD from OBJ7333.F9860 where SIFUNO = 'TBLE' order by SIOBNM;
This table also has names and descriptions of the following (use these SIFUNO codes in place of TBLE):
APPL - Applications
BL - Business Function Librarys
BSFN - Business Functions
BSVW - Business Views
DSTR - Data Structures
GT - Generic Text
TBLE - Tables
UBE - Batch programs
I hope that is helpful.
select SIOBNM, SIMD from OBJ7333.F9860 where SIFUNO = 'TBLE' order by SIOBNM;
This table also has names and descriptions of the following (use these SIFUNO codes in place of TBLE):
APPL - Applications
BL - Business Function Librarys
BSFN - Business Functions
BSVW - Business Views
DSTR - Data Structures
GT - Generic Text
TBLE - Tables
UBE - Batch programs
I hope that is helpful.