SAP ABAP Table /CRMBW/OLTP_EXT_ACT (Extract Structure for OLTP Activity Reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA (Application Component) CRM Analytics
     ⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI

Basic Data

Table Category	INTTAB	Structure
Structure	/CRMBW/OLTP_EXT_ACT	Table Relationship Diagram
Short Description	Extract Structure for OLTP Activity Reporting

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	.INCLUDE	☐				0	0	Extract Structure for OLTP Activities Internal Fields
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PRIVATE_FLAG	☐	CRMT_PRIVAT	CRM_BOOLEAN	CHAR	1	0	Indicator: Task is Private
6	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
7	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
8	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
9	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
10	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
11	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
12	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
13	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
14	FROMDATE	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
15	TODATE	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
16	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
17	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
18	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
19	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
20	ACT_TOT_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
21	ACT_TOT_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
22	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
23	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
24	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
25	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
26	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
27	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
28	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
29	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
30	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
31	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
32	.INCLUDE	☐				0	0	Reporting Coherent Catgory level GUID for interaction record
33	CATLVLGUID01_IR	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
34	CATLVLGUID02_IR	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
35	CATLVLGUID03_IR	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
36	CATLVLGUID04_IR	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
37	CATLVLGUID05_IR	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
38	CATLVLGUID06_IR	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
39	CATLVLGUID07_IR	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
40	CATLVLGUID08_IR	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
41	CATLVLGUID09_IR	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
42	CATLVLGUID10_IR	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
43	.INCLUDE	☐				0	0	EEW Include
44	EEW_R_ACT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
45	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
46	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
47	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
48	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
49	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
50	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
51	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
52	PREDGUID_BRELVONAE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
53	PREDOBJTYPE_BRELVONAE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
54	ACT_TOT_DURA_QU	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
55	ACT_TOT_UNIT_QU	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*

History

Last changed by/on	SAP	20130604
SAP Release Created in	520