SAP ABAP Table CRMT_DHR_ACTIV (Structure for activity buffer table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_DHR_ACTIV	Table Relationship Diagram
Short Description	Structure for activity buffer table

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
2	.INCLUDE	☐				0	0	Extract Structure for OLTP Activities Internal Fields
3	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	PRIVATE_FLAG	☐	CRMT_PRIVAT	CRM_BOOLEAN	CHAR	1	0	Indicator: Task is Private
5	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
6	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
7	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
8	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
9	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
10	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
11	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
12	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
13	FROMDATE	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
14	TODATE	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
15	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
16	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
17	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
18	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
19	ACT_TOT_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
20	ACT_TOT_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
21	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
22	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
23	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
24	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
25	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
26	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
27	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
28	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
29	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
30	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
31	.INCLUDE	☐				0	0	Reporting Coherent Catgory level GUID for interaction record
32	CATLVLGUID01_IR	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
33	CATLVLGUID02_IR	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
34	CATLVLGUID03_IR	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
35	CATLVLGUID04_IR	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
36	CATLVLGUID05_IR	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
37	CATLVLGUID06_IR	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
38	CATLVLGUID07_IR	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
39	CATLVLGUID08_IR	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
40	CATLVLGUID09_IR	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
41	CATLVLGUID10_IR	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
42	.INCLUDE	☐				0	0	EEW Include
43	EEW_R_ACT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20130604
SAP Release Created in