SAP ABAP Table CRMT_REPORT_LOC_ACT (Output Fields: Activity for CRM_Transaction)

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_REPORT_LOC_ACT	Table Relationship Diagram
Short Description	Output Fields: Activity for CRM_Transaction

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	EXTERN_ACT_ID	☐	CRMT_EXTERNAL_ACTIVITY_ID	CRM_EXTERNAL_ACTIVITY_ID	CHAR	20	0	External Business Transaction Number
2	PRIVATE_FLAG	☐	CRMT_PRIVAT	CRM_BOOLEAN	CHAR	1	0	Indicator: Task is Private
3	COMPLETION	☐	CRMT_COMPLETION	CRM_COMPLETION	NUMC	3	0	Completion Rate in Percent
4	ADDRESS_ID	☐	CRMT_ADDRESS	AD_ADDRNUM	CHAR	10	0	Location where Activity takes place	*
5	ACT_LOCATION	☐	CRMT_ACTIVITY_LCTN	CRM_ACTIVITY_LOCATION	CHAR	100	0	Location
6	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class
7	CALENDAR	☐	CRMT_CALENDAR	CRM_BOOLEAN	CHAR	1	0	Include Activity in Calendar
8	CATEGORY_TXT	☐	CRMT_REPORT_CATEGORY_TXT	DDTEXT	CHAR	60	0	Texts for Category
9	PRIORITY_TXT	☐	CRMT_REPORT_PRIORITY_TXT	DDTEXT	CHAR	60	0	Text Description for Priority
10	OBJECTIVE_TXT	☐	CRMT_REPORT_OBJECTIVE_TXT	DDTEXT	CHAR	60	0	Text Description for Goal of an Activity
11	DIRECTION_TXT	☐	CRMT_REPORT_DIRECTION_TXT	DDTEXT	CHAR	60	0	Text Description for Direction
12	IO_ICON	☐	CRMT_IO_ICON	ICON	CHAR	4	0	Icon for Interaction Object/Contact	*
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	ACT_TOT_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
16	ACT_TOT_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
17	KATALOGART_ACT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
18	CODEGRUPPE_ACT	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
19	CODE_ACT	☐	QCODE	QCODE	CHAR	4	0	Code	*
20	SUBJECT_PROF_ACT	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*
21	KATALOGART_ACT_ST	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
22	CODEGRUPPE_ACT_ST	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
23	CODE_ACT_ST	☐	QCODE	QCODE	CHAR	4	0	Code	*
24	SUBJECT_PROF_ACT_ST	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*
25	SUB_CATGUID_ACT	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
26	.INCLUDE	☐				0	0	All Keys (<> Texts) in the Output List
27	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
28	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
29	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
30	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
31	TASK	☐	CRMT_TASK	CRM_BOOLEAN	CHAR	1	0	Indicator: Activity is a Task
32	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
33	.INCLUDE	☐				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
34	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
35	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
36	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_REPORT_LOC_ACT	PARTNER_FCT	CRMC_PARTNER_FCT	PARTNER_FCT

History

Last changed by/on	SAP	20130604
SAP Release Created in	20C