What is the base table for Activities?

The base table for activities is ZMM_ACTIVITIES. This table stores the core details of activities, such as tasks and appointments, linked to various entities, including contacts.

The relationship between a contact and its related activities is managed using ZMM_ACT_CONTACTS. This table links contacts with their related activities. The key fields typically include:
  • CONTACT_ID: Links to the contact record in the ZCA_CONTACTS table.
  • ACTIVITY_ID: Links to the specific activity in the ZMM_ACTIVITY table.

For more information see Tables and Views for Sales and Fusion Service.