SAP Table CRMD_ACTIVITY_H stores Activitydata

  

In this post, I will try and describe everything you need to know about the SAP crmd_activity_h table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_ACTIVITY_H what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_ACTIVITY_H....Right lets get started!


SAP CRMD_ACTIVITY_H dictionary attributes

Object Name: CRMD_ACTIVITY_H
Dictionary Type: Transparent table
Description: Activity


CRMD_ACTIVITY_H field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
CATEGORYCRMT_ACTIVITY_CATEGORYCHAR3(0) CRMC_ACT_CATEGORActivity Category (Communication Type)CRM_ACTIVITY_CATEGORYCRM
PRIORITYCRMT_PRIORITYNUMC1(0) SCPRIOActivity PrioritySC_PRIOCRM
OBJECTIVECRMT_OBJECTIVECHAR3(0) CRMC_ACT_OBJGoal of an ActivityCRM_OBJECTIVECRM
DIRECTIONCRMT_DIRECTIONCHAR1(0) Direction of an ActivityCRM_DIRECTIONCRM
EXTERN_ACT_IDCRMT_EXTERNAL_ACTIVITY_IDCHAR20(0) External Business Transaction NumberCRM_EXTERNAL_ACTIVITY_IDCRM
ADDRESS_IDCRMT_ADDRESSCHAR10(0) *Location where Activity takes placeAD_ADDRNUMCRM
PRIVATE_FLAGCRMT_PRIVATCHAR1(0) Indicator: Task is PrivateCRM_BOOLEANCRM
COMPLETIONCRMT_COMPLETIONNUMC3(0) Completion Rate in PercentCRM_COMPLETIONCRM_ACT_COMPLETIONCOMPLETIONCRM
ACT_LOCATIONCRMT_ACTIVITY_LCTNCHAR100(0) LocationCRM_ACTIVITY_LOCATIONCRM
CALENDARCRMT_CALENDARCHAR1(0) Include Activity in CalendarCRM_BOOLEANCRM
TASKCRMT_TASKCHAR1(0) Indicator: Activity is a TaskCRM_BOOLEANCRM
CLASSCRMT_ACTIVITY_CLASSCHAR1(0) Activity ClassCRM_ACTIVITY_CLASSCRM


View list of all tables