SAP ABAP Table CRMS_MKTPL_IB_QUERY_PGM (Structure for IBOM MDF Program query attributes)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_QUERY_PGM	Table Relationship Diagram
Short Description	Structure for IBOM MDF Program query attributes

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	EXTERNAL_ID	☐	CRM_MKTPL_MDFPROGRAMID	CGPL_EXTID	CHAR	24	0	MDF Program ID
2	PARENT_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
3	TEXT1	☐	CRM_MKTPL_IB_PGM_TEXT	CHAR40	CHAR	40	0	MDF Program Description
4	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
5	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
6	RESPONSIBLE_NO	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
7	RESP_NAME_FIRST	☐	CRM_MKTPL_IB_RESP_NAME_FIRST	BU_NAME	CHAR	40	0	Person Responsible: First Name
8	RESP_NAME_LAST	☐	CRM_MKTPL_IB_RESP_NAME_LAST	BU_NAME	CHAR	40	0	Person Responsible: Last Name
9	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
10	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
11	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
13	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
14	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
15	MY_ORGS	☐	CRM_MKTPL_IB_BELONGING_TO	TEXT50	CHAR	50	0	Belonging To
16	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
17	ENROLLMENT_STARTDATE	☐	CRM_MKTPL_ENR_STARTDATE	DATUM	DATS	8	0	Enrollment Start Date
18	ENROLLMENT_ENDDATE	☐	CRM_MKTPL_ENR_ENDDATE	DATUM	DATS	8	0	Enrollment End Date
19	PRODUCT_CATEGORY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
20	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
21	STATUS_KEY	☐	CRM_MKTPL_IB_STATUS_KEY	CRM_MKTPL_IB_STATUS_KEY	CHAR	23	0	Key for Status Node (iBom MKTPL)
22	STATUS_TEXT	☐	CRM_MKTPL_IB_STATUS_TEXT	TEXT40	CHAR	40	0	Status of Scope Item (Concatenated)
23	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
24	START_DATE_FIELD_1	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
25	END_DATE_FIELD_1	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
26	START_DATE_FIELD_2	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
27	END_DATE_FIELD_2	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
28	START_DATE_FIELD_3	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
29	END_DATE_FIELD_3	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
30	START_DATE_FIELD_4	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
31	END_DATE_FIELD_4	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
32	START_DATE_FIELD_5	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
33	END_DATE_FIELD_5	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
34	MDF_CAMPAIGNID	☐	CRM_MKTPL_MDFCAMPAIGNID	CGPL_EXTID	CHAR	24	0	MDF Special Program ID
35	PARTNER_ID	☐	CMST_PARTICIPATINGPARTNER_ID	BU_PARTNER	CHAR	10	0	Participating Partner ID	*
36	FUNDSPLAN_ID	☐	CRM_FMBPO_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
37	PARTY_INVOLVED	☐	CMST_TRACKPARTNER_ID	BU_PARTNER	CHAR	10	0	Channel partner ID	*
38	.INCLUDE	☐				0	0
39	.INCLUDE	☐				0	0
40	.INCLUDE	☐				0	0
41	ADD_DT_RANGE_06_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
42	ADD_DT_RANGE_06_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
43	ENROLLED	☐	CRM_MKTPL_ENR_ENROLLED	CRM_MKTPL_ENR_ENROLLED	CHAR	1	0	Enrolled
44	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
45	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
46	ENROLLED_PARTNER	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
47	ADD_DT_RANGE_01_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
48	ADD_DT_RANGE_01_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
49	ADD_DT_RANGE_02_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
50	ADD_DT_RANGE_02_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
51	ADD_DT_RANGE_03_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
52	ADD_DT_RANGE_03_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
53	ADD_DT_RANGE_04_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
54	ADD_DT_RANGE_04_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
55	ADD_DT_RANGE_05_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
56	ADD_DT_RANGE_05_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
57	ADD_DT_RANGE_07_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
58	ADD_DT_RANGE_07_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
59	ADD_DT_RANGE_08_STARTDATE	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
60	ADD_DT_RANGE_08_ENDDATE	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
61	.INCLUDE	☐				0	0	Extension Include - MDF Program
62	MKTPL_QUERY_PGM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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