SAP ABAP Table /CRMBW/OLTP_EXT_ACT_APP (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_APP	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	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	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
19	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
20	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
21	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
22	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
23	REPORT_AREA	☐	CRMT_OR_INFOTYPE		CHAR	30	0	Report Area
24	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
25	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
26	PREDGUID_BRELVONAE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
27	PREDOBJTYPE_BRELVONAE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
28	PRE_CAMPAIGN	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
29	ACT_TOT_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
30	ACT_TOT_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
31	ACT_TOT_DURA_QU	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
32	ACT_TOT_UNIT_QU	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
33	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
34	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
35	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
36	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
37	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
38	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
39	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
40	.INCLUDE	☐				0	0	Reporting Coherent Catgory level GUID for interaction record
41	CATLVLGUID01_IR	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
42	CATLVLGUID02_IR	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
43	CATLVLGUID03_IR	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
44	CATLVLGUID04_IR	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
45	CATLVLGUID05_IR	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
46	CATLVLGUID06_IR	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
47	CATLVLGUID07_IR	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
48	CATLVLGUID08_IR	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
49	CATLVLGUID09_IR	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
50	CATLVLGUID10_IR	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
51	TODATE_W	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
52	TODATE_M	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
53	TODATE_Q	☐	RSCALQUART	RSCALQUART	NUMC	5	0	Calendar year / quarter
54	TODATE_Y	☐	RSCALYEAR	GJAHR	NUMC	4	0	Calendar year

History

Last changed by/on	SAP	20141013
SAP Release Created in	700