SAP ABAP Table CRMT_BW_DS_ACTIVITY_SICH (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_SICH	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	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
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_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	Attributes for Activity
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	COMPLETION	☐	CRMT_COMPLETION	CRM_COMPLETION	NUMC	3	0	Completion Rate in Percent
32	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class
33	STATUS_SYSTEM	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
34	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
35	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
36	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
37	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
38	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
39	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
40	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
41	.INCLUDE	☐				0	0	Partner for Activities
42	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER_32	BU_PARTNER	CHAR	10	0	Activity Partner: GUID	*
43	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
44	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
45	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
46	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
47	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
48	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
49	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
50	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
51	.INCLUDE	☐				0	0	DATES Data for BW DataSources
52	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
53	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
54	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
55	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
56	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
57	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
58	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
59	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
60	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
61	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
62	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
63	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
64	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
65	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
66	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
67	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
68	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
69	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
70	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
71	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
72	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
73	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
74	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
75	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
76	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
77	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
78	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
79	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
80	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
81	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
82	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
83	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
84	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
85	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
86	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
87	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
88	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
89	.INCLUDE	☐				0	0	Sales Organization Data Part 1
90	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
91	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
92	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
93	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
94	HOSTING_ORG	☐	CRMT_HOSTING_ORG	HROBJEC_14	CHAR	14	0	Hosting Org. Unit
95	.INCLUDE	☐				0	0	organizational Data Sales Part 2
96	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
97	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
98	.INCLUDE	☐				0	0	Organizational Data (Service)
99	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
100	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
101	.INCLUDE	☐				0	0	Purchasing Organizational Data
102	PURCH_ORG	☐	CRMT_PURCH_ORG	HROBJEC_14	CHAR	14	0	Purchasing Organization
103	PURCH_GROUP	☐	CRMT_PURCH_GROUP	HROBJEC_14	CHAR	14	0	Purchasing Group
104	PURCH_ORG_RESP	☐	CRMT_PURCH_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Purchasing)
105	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
106	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
107	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
108	FTF_DURATION	☐	CRMT_FTF_DURATION	CRM_REPORT_DURATION_IN_MIN	FLTP	16	16	Face To Face Duration
109	GUID_OPPORTUNITY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
110	MKT_ELEMENT	☐			CHAR	24	0
111	COUNTER	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)

Foreign Keys

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

History

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