SAP ABAP Table /CRMBW/OLTP_EXT_CAMPAIGN (Extract Structure for OLTP Campaign 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_CAMPAIGN	Table Relationship Diagram
Short Description	Extract Structure for OLTP Campaign 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	MKT_OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	MKT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
4	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
5	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
6	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
7	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
8	MKT_EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
9	MKT_CAMP_TYPE	☐	CRMT_OR_MKTPL_CAMPTYPE	CRM_OR_MKTPL_CAMPTYPE	CHAR	4	0	Reporting - Campaign Type
10	MKT_RESPONSIBLE	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
11	MKT_MKT_ORG	☐	CRM_OR_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
12	MKT_PLANSTART	☐	CGPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
13	MKT_PLANFINISH	☐	CGPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
14	MKT_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
15	MKT_APPROVED	☐	CRMT_OR_STAT_APPROVED	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status Approved
16	MKT_LOCKED	☐	CRMT_OR_STAT_LOCKED	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status Locked
17	MKT_IN_PROCESS	☐	CRMT_OR_STAT_IN_PROCESS	CRM_BOOLEAN	CHAR	1	0	Reporting - Campaign Status In Process
18	MKT_NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
19	MKT_CREATED_AT	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
20	MKT_NUM_OF_OPPS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
21	MKT_NUM_OF_LEADS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
22	MKT_NUM_OF_INBS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
23	MKT_NUM_OF_OUTBS	☐	CRMT_OR_OBJ_NUM		INT4	10	0	Reporting - Number of Objects Attached to a Campaign
24	.INCLUDE	☐				0	0

History

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