SAP ABAP Table /CRMBW/OLTP_EXT_CONT_TRACK_VDM (Extract Structure for OLTP Contact Tracking (VDM-based))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-OR (Application Component) Interactive Reporting
     ⤷ /CRMBW/OP_REPORTING_VDM (Package) Operational (Interactive) Reporting (HANA VDM based)

Basic Data

Table Category	INTTAB	Structure
Structure	/CRMBW/OLTP_EXT_CONT_TRACK_VDM	Table Relationship Diagram
Short Description	Extract Structure for OLTP Contact Tracking (VDM-based)

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	CAMPAIGN_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
2	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
3	CAMP_ELEM_GUID	☐	CGPL_TASK_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Tasks
4	CAMP_ELEM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
5	MKT_RESPONSIBLE	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
6	MKT_MKT_ORG	☐	CRM_OR_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
7	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
8	BP_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	BP_FULL_NAME	☐	/CRMBW/OLTP_VDM_BP_FULL_NAME	CHAR255	CHAR	255	0	Full Name of a Business Partner
10	CON_TRACK_STATUS	☐	CRMT_IM_STATUS	CRM_IM_STATUS	CHAR	1	0	CRM Marketing: Technical Status for an Outbound
11	COMM_CHANNEL	☐	CRM_MKTPL_COM_CHANNEL	CRM_MKTPL_COM_CHANNEL	NUMC	2	0	CRM Marketing Planning - Communication Method
12	TARGET_GRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
13	TARGET_GRP_ID	☐	CRMT_MKTTG_TG_ID	CRMT_MKTTG_TG_ID	CHAR	10	0	Unique Identifiers for Target Groups and Product Segments
14	MAILFORM_ID	☐	CRMT_IM_MAIL_FORM	TDSFNAME	CHAR	30	0	Form for letter	*
15	CREATED_ON	☐	DATS	DATS	DATS	8	0	Field of type DATS
16	CREATED_ON_Y	☐	RSCALYEAR	GJAHR	NUMC	4	0	Calendar year
17	CREATED_ON_Q	☐	RSCALQUART	RSCALQUART	NUMC	5	0	Calendar year / quarter
18	CREATED_ON_M	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
19	CREATED_ON_W	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
20	CREATED_ON_D	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
21	NO_SUCCESS_O_CON	☐	/CRMBW/OLTP_VDM_NO_SUCC_O_CONT	INT4	INT4	10	0	Number of Successful Outbound Contacts
22	NO_FAILED_O_CON	☐	/CRMBW/OLTP_VDM_NO_FAIL_O_CONT	INT4	INT4	10	0	Number of Failed Outbound Contacts
23	NO_PLANNED_O_CON	☐	/CRMBW/OLTP_VDM_NO_PLAN_O_CONT	INT4	INT4	10	0	Number of Planned Outbound Contacts
24	NO_LINK_ACCESSES	☐	CRMT_IM_NUMBER_ACCESS	INT2	INT2	5	0	Number of Times a Link is Accessed
25	SEL_GUID	☐	/CRMBW/OLTP_VDM_SEL_GUID_CHAR		CHAR	32	0	Selection GUID as char

History

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