SAP ABAP Table CRMS_MKTPL_IB_QUERY_RESULT_SPG (Sturucture for IBOM MDFCampaign search result object)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_MDF_SPG (Package) IBOM Package for MDF Campaigns

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_QUERY_RESULT_SPG	Table Relationship Diagram
Short Description	Sturucture for IBOM MDFCampaign search result object

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	GUID	☐	CRM_MKTPL_IB_SPG_GUID		RAW	16	0	MDF Special Program
2	EXTERNAL_ID	☐	CRM_MKTPL_MDFCAMPAIGNID	CGPL_EXTID	CHAR	24	0	MDF Special Program ID
3	TEXT1	☐	CRM_MKTPL_IB_SPG_TEXT	CHAR40	CHAR	40	0	MDF Special Program Description
4	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
5	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
6	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
7	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
8	PARENT_EXT_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
9	STATUS_TEXT	☐	CRM_MKTPL_IB_STATUS_TEXT	TEXT40	CHAR	40	0	Status of Scope Item (Concatenated)
10	ENROLLMENT_STARTDATE	☐	CRM_MKTPL_ENR_STARTDATE	DATUM	DATS	8	0	Enrollment Start Date
11	ENROLLMENT_ENDDATE	☐	CRM_MKTPL_ENR_ENDDATE	DATUM	DATS	8	0	Enrollment End Date
12	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
13	RESPONSIBLE_NO	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
14	RESP_NAME_FIRST	☐	CRM_MKTPL_IB_RESP_NAME_FIRST	BU_NAME	CHAR	40	0	Person Responsible: First Name
15	RESP_NAME_LAST	☐	CRM_MKTPL_IB_RESP_NAME_LAST	BU_NAME	CHAR	40	0	Person Responsible: Last Name
16	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
17	PROGRAM_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
18	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
19	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
20	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
22	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
23	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
24	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
25	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
26	PLANSTARTTIME	☐	CRM_MKTPL_PLANSTARTTIME	TIME	TIMS	6	0	Planned Start (Time)
27	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
28	PLANFINISHTIME	☐	CRM_MKTPL_PLANFINISHTIME	TIME	TIMS	6	0	Planned Finish (Time)
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0
32	PARENT_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
33	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
34	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
35	ACTION_PROFILE	☐	CRM_MKTPL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	ID of Action Profile	*
36	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
37	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
38	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
39	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
40	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
41	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
42	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
43	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
44	ACTION_PROFILE_TEXT	☐	PPFDCNTXTT	TEXT60	CHAR	60	0	PPF: Description of Action Profile
45	STSMA_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
46	REF_TYPE_TEXT	☐	CRM_MKTPL_REF_TYPE_TEXT	TEXT40	CHAR	40	0	Usage Type Description
47	ADD_DT_RANGE_06_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
48	ADD_DT_RANGE_06_ENDDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
49	USE_FIX_TZ_UTC	☐	CRM_MKTPL_USE_FIX_TIMEZONE	CRM_BOOLEAN	CHAR	1	0	MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv.
50	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
51	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
52	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
53	.INCLUDE	☐				0	0	Extensive inculde for MDF special program search result
54	MKTPL_RESULT_SPG	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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