SAP ABAP Table CRMT_BW_DS_ACTIVITY (DataSource for Activities)

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_BW_DS_ACTIVITY	Table Relationship Diagram
Short Description	DataSource for Activities

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	EXTERN_ACT_ID	☐	CRMT_EXTERNAL_ACTIVITY_ID	CRM_EXTERNAL_ACTIVITY_ID	CHAR	20	0	External Business Transaction Number
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	NUMBER_OF_H	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
16	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
17	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
18	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
19	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
20	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
21	COMPLETION	☐	CRMT_COMPLETION	CRM_COMPLETION	NUMC	3	0	Completion Rate in Percent
22	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class
23	STATUS_SYSTEM	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
24	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
25	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
26	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
27	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER_32	BU_PARTNER	CHAR	10	0	Activity Partner: GUID	*
28	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
29	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
30	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
31	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
32	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
33	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
34	CC_CATEGORY_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
35	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
36	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
37	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
38	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
39	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
40	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
41	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
42	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
43	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
44	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
45	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
46	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
47	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
48	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
49	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
50	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
51	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
52	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
53	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
54	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
55	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
56	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
57	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
58	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
59	SERVICE_TGRP_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
60	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
61	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
62	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
63	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
64	CAL_ACT_TIME	☐	CRMT_ACTIVITY_TIME	UZEIT	TIMS	6	0	Activity Time
65	FTF_DURATION	☐	CRMT_FTF_DURATION	CRM_REPORT_DURATION_IN_MIN	FLTP	16	16	Face To Face Duration
66	DURATION	☐	CRMT_ACT_DURATION	CRM_REPORT_DURATION_IN_MIN	FLTP	16	16	Duration of an Activity
67	GUID_OPPORTUNITY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
68	COUNTER	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
69	USSTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
70	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
71	ACT_ONLY	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
72	CALDAY_TO	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
73	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
74	PRIVATE_FLAG	☐	CRMT_PRIVAT	CRM_BOOLEAN	CHAR	1	0	Indicator: Task is Private
75	BWSTONEACTI	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
76	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
77	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
78	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
79	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
80	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
81	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
82	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
83	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
84	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
85	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
86	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
87	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
88	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
89	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
90	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
91	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
92	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
93	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
94	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
95	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
96	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
97	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
98	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
99	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
100	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
101	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
102	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
103	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
104	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
105	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
106	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
107	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
108	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
109	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
110	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
111	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
112	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
113	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
114	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
115	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
116	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
117	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
118	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
119	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
120	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
121	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
122	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
123	.INCLUDE	☐				0	0	USER STATUS GROUPS Data for BW Datasources
124	BWSTONEUSS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
125	.INCLUDE	☐				0	0	Territory Data for BW Data Sources (Partner Attribute)
126	PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
127	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
128	.INCLUDE	☐				0	0	Object References for BW DataSources
129	REF_IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
130	REF_IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
131	REF_CONF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
132	REF_CONF_PROD_GU	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
133	REF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
134	REF_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
135	REF_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
136	REF_BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
137	REF_BUAG_GUID	☐	CRMT_BUAG_GUID_C	SYSUUID_C	CHAR	32	0	GUID of Business Agreement in Character Format
138	REF_NO_ITEMS	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
139	.INCLUDE	☐				0	0	CUOBJ for BW DataSources
140	CUOBJ	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
141	.INCLUDE	☐				0	0	PARTNER (Locator) Various Partner Functions
142	INSTALL_AT	☐	CRMT_INSTALL_AT_PART	BU_PARTNER	CHAR	10	0	Installed At	*
143	INSTALL_AT_LIST	☐	CRMT_INSTALL_AT_LIST	CHAR80	CHAR	80	0	Installed At - Name
144	RESPONS_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
145	END_CUSTOMER	☐	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
146	RESP_AT_PART	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_DS_ACTIVITY	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

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