HOWTO: List OneWorld tables/objects and descriptions

timallen

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.
 
Hi Tim,
Thanks for your hint; we post them, usually, on the Tips and Traps forum :)
Warm regards,
 
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.
Please correct it to F9860
 
Back
Top