In what table are cases and case activities stored?

Tasks and Appointments for all objects (including Cases) are stored in the Activities table ZMM_ACTY_ACTIVITIES. You find specific cases and appointments using the following:

A specific case task be found by:

• SELECT * FROM ZMM_ACTY_ACTIVITIES WHERE ACTIVITY_FUNCTION_CODE = 'TASK' AND CASE_ID = <CASE_ID>;

A Case appointment can be found by:

• SELECT * FROM ZMM_ACTY_ACTIVITIES WHERE ACTIVITY_FUNCTION_CODE = ' APPOINTMENT' AND CASE_ID = <CASE_ID>;