Does anyone know which table in the database would give me the data that associates sessions (T$CSES) with a business process (T$PROC). I thought that it would be in the TTGBRG500 but that table does not have the T$CSES field and only the T$PRGM (Program_Code) field which is not the same.


Help Please!

Hi,

Pls check in table tgbrg520. There u can find the relevent sessions associated with a business process.

Rgds

Navin Tenani

That table does note have the T$CSES field

ttgbrg520001
T$PROC
T$PROV
T$PONO
T$EXTC
T$DESC
T$ACTP
T$COTP
T$PRGM
T$ARGU
T$NBPR
T$AODO
T$CATG
T$CUTI
T$WKIN
T$XPOS
T$YPOS
T$WIDT
T$HGHT
T$TXTC
T$EUSR
T$EEXT
T$ETIM
T$EAUT
T$REFCNTD
T$REFCNTU

T$PRGM would be the field.

There are however standard print sessions available in DEM.
You have "business processes" tgbrg5400m000, which can print the activities and the linked sessions.
You have "project model" tgbrg4400m000, which prints in the context of the project model, which is the implementation context.

You have session tgbrg4450m000, which gives an overview per employee which sessions within which business processes he is authorized.

Navin Tenani and awever are right!

The table is tgbrg520, but for a session you have to put in actp=3. Then you have to completed prgm with the code of your session.

In this table you can associate sessions, activities, other programs applications, process, and control activities with a process

Regards

Birgit