Hi all:

I'm trying to get a report to know all the users, their rolls and access to sessions. Long story short, I need to get the DEM information in reports. Somebody knows where all this information stored? I've checked tgbrg850, 855, 857 and 860 but the tables are empty :confused:

Please note that dem data can be store in another company, check the tgbrg000 table.

We generate these two reports

1. Employee and roles
====================
tgbrg820 - Emp by roles by proj model
tgbrg810 - roles (join by role)
tgbrg840 - emp by proj model (join by user)

2. Detail emp by session - above tables plus
================================
tgbrg340 - role by BP B Model
tgbrg350 - role by activity by BP
tgbrg450 - activity authorization by role
tgbrg500 - busines processes
tgbrg520 - BP Activities
tgbrg830

Data is stored in the functional company. The 2nd one is tricky as there exists hierarchy in the data.
Hope you find this useful.

Thanks, it was very useful, I wasn't getting the complete set of tables for my report :D