SAP ABAP Table /CRMBW/OLTP_EXT_CAMPAIGN_VDM (Extract Structure for OLTP Campaign Reporting (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_CAMPAIGN_VDM	Table Relationship Diagram
Short Description	Extract Structure for OLTP Campaign Reporting (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	MKT_EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
2	MKT_CAMP_TYPE	☐	CRMT_OR_MKTPL_CAMPTYPE	CRM_OR_MKTPL_CAMPTYPE	CHAR	4	0	Reporting - Campaign Type
3	MKT_RESPONSIBLE	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
4	MKT_MKT_ORG	☐	CRM_OR_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
5	MKT_PLANSTART	☐	CGPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
6	MKT_PLANFINISH	☐	CGPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
7	MKT_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
8	MKT_APPROVED	☐	CRMT_OR_STAT_APPROVED	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status Approved
9	MKT_LOCKED	☐	CRMT_OR_STAT_LOCKED	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status Locked
10	MKT_IN_PROCESS	☐	CRMT_OR_STAT_IN_PROCESS	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status In Process
11	MKT_CREATED_AT	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
12	MKT_NUM_OF_OPPS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
13	MKT_NUM_OF_LEADS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
14	MKT_NUM_OF_INBS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
15	MKT_NUM_OF_OUTBS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
16	MKT_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
17	MKT_OPP_EXPREV_D	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
18	MKT_OPP_PROBABI	☐	CRMT_PROBABILITY_NO_F4	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success
19	MKT_CREATED_AT_Q	☐	RSCALQUART	RSCALQUART	NUMC	5	0	Calendar year / quarter
20	MKT_CREATED_AT_M	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
21	MKT_CREATED_AT_W	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
22	MKT_CREATED_AT_D	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
23	SEL_GUID	☐	/CRMBW/OLTP_VDM_SEL_GUID_CHAR		CHAR	32	0	Selection GUID as char
24	.INCLUDE	☐				0	0

History

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