SAP ABAP Table CRMS_MKTPL_OL_ATTRIBUTES_EXT (MKTPL OL: Marketing Project External Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_OBJECT_LAYER (Package) Marketing Planner Object Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_OL_ATTRIBUTES_EXT	Table Relationship Diagram
Short Description	MKTPL OL: Marketing Project External 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	.INCLUDE	☐				0	0	CRM Marketing Planning - External Format of Attributes
2	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
3	CHANNELTX	☐	CRM_MKTPL_CHANNELTX	TEXT40	CHAR	40	0	Description of Communication Medium
4	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
5	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
6	ADRESS_NAME	☐	CRMT_IM_E_ADDRESS	SO_STRI241	CHAR	241	0	Marketing: E-mail Address
7	ADRESS_TEXT	☐	CRMT_IM_E_TEXT	CHAR40	CHAR	40	0	Text for E-Mail Address
8	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
9	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
10	ACTUALSTARTDATE	☐	CRM_MKTPL_ACTUALSTARTDATE	DATUM	DATS	8	0	Actual Start Date
11	ACTUALFINISHDATE	☐	CRM_MKTPL_ACTUALFINISHDATE	DATUM	DATS	8	0	Actual Finish (Date)
12	PLANSTARTTIME	☐	CRM_MKTPL_PLANSTARTTIME	TIME	TIMS	6	0	Planned Start (Time)
13	PLANFINISHTIME	☐	CRM_MKTPL_PLANFINISHTIME	TIME	TIMS	6	0	Planned Finish (Time)
14	ACTUALSTARTTIME	☐	CRM_MKTPL_ACTUALSTARTTIME	TIME	TIMS	6	0	Actual Start (Time)
15	ACTUALFINISHTIME	☐	CRM_MKTPL_ACTUALFINISHTIME	TIME	TIMS	6	0	Actual Finish (time)
16	CONSTRAINTDATE	☐	CRM_MKTPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
17	CONSTRAINTTIME	☐	CRM_MKTPL_CONSTRAINTTIME	TIME	TIMS	6	0	Constraint Date (Time)
18	SCRIPT_TREEID	☐	CRMT_TREEID	CRM_TREEID	NUMC	8	0	Name of Interaction Center (IC) WinClient Script
19	SEND_PARTNER_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
20	TACTICSTX	☐	CRM_MKTPL_TACTICSTX	TEXT40	CHAR	40	0	Tactic Description
21	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
22	CAMP_PRIOTX	☐	CRM_MKTPL_CAMPPRIOTX	TEXT40	CHAR	40	0	Description of Priority
23	CONSTRAINT_TYPETX	☐	CGPL_CONSTRAINTTX	TEXT40	CHAR	40	0	Description of Type of Scheduling Constraint
24	PLANSTART_IO	☐	CRM_MKTPL_PLANSTART_IO	TZTF_IO_FIELD	CHAR	26	0	Planned Start Date
25	PLANFINISH_IO	☐	CRM_MKTPL_PLANFINISH_IO	TZTF_IO_FIELD	CHAR	26	0	Planned End Date
26	ACTUALSTART_IO	☐	CRM_MKTPL_ACTUALSTART_IO	TZTF_IO_FIELD	CHAR	26	0	Actual Start Date
27	ACTUALFINISH_IO	☐	CRM_MKTPL_ACTUALFINISH_IO	TZTF_IO_FIELD	CHAR	26	0	Actual Finish Date
28	CONSTRAINT_IO	☐	CRM_MKTPL_CONSTRAINT_IO	TZTF_IO_FIELD	CHAR	26	0	Constraint Date
29	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
30	ACTION_PROFILE_TEXT	☐	PPFDCNTXTT	TEXT60	CHAR	60	0	PPF: Description of Action Profile
31	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
32	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
33	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
34	PSP_CREATION	☐	CRMT_MKTPL_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Replicated in ERP
35	MKT_ORG_DESC	☐	CRM_MKTPL_MORG_DESC	CRM_MKTPL_MORG_DESC	CHAR	40	0	Marketing Organization Description
36	EXCL_IND_DESC	☐	CRM_MKTPL_EXCL_IND_DESC	CRM_BOOLEAN	CHAR	1	0	Marketing Planner: Exclusive Indicator for Mult. Promotions
37	ACTIVE	☐	CRMT_MKTPL_ACTIVE	XFELD	CHAR	1	0	Active Marketing Project
38	HAS_PROCESSMODEL	☐	CRMT_MKTPL_HAS_PROCESSMODEL		CHAR	1	0	Campaign Has Process Model
39	PROD_PL_BASIS_TEXT	☐	CRM_MKTSS_PL_BASIS_TEXT	CRM_MKTSS_PL_BASIS_TEXT	CHAR	40	0	Description of Product Planning Basis
40	PLANGROUP_DESC	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
41	AUTH_GROUP_TEXT	☐	CRM_MKTPL_AUTH_GROUPTX	TEXT40	CHAR	40	0	Description of Authorization Group
42	HIERARCHY_SORT	☐	CRM_MKTPL_HIERARCHY_SORT_SEQ		NUMC	3	0	Hierarchy Sort Sequence
43	HV_ACTIVE	☐	CRM_MKTPL_HV_ACTIVE	CRM_MKTPL_HV_ACTIVE	CHAR	1	0	High-Volume Execution
44	.INCLUDE	☐				0	0	CRM MarketingPlanning- External Format of TPM/TPT Attribute
45	CUSTOMER_ID	☐	CRM_MKTPL_CUSTOMER_ID	CHAR20	CHAR	20	0	Planning Account ID
46	CUSTOMER_DESC	☐	CRM_MKTPL_PLANCUST_DESC		CHAR	50	0	Planning Account Description
47	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
48	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
49	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
50	BPAT_TYPE_TEXT	☐	CRM_MKTPL_DEF_BPAT_TYPETX	CRM_MKTPL_DEF_BPAT_TYPETX	CHAR	25	0	Type of Buying Pattern (Text)
51	CUSTOMER_TYPE	☐	CRM_MKTPL_PLCUST_TYPE	CRM_MKTPL_PLCUST_TYPE	CHAR	2	0	Type of Account (BP, Hierarchy Node, Target Group)
52	TARGETGRP_DESC	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
53	TGRP_OWNER_DESC	☐	BU_NODE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of a Hierarchy Node
54	REF_TYPE_TEXT	☐	CRM_MKTPL_REF_TYPE_TEXT	TEXT40	CHAR	40	0	Usage Type Description
55	SALES_ORG_RESP_DESC	☐	CRMT_SALES_ORG_RESP_DESC	CRMT_SALES_ORG_RESP_DESC	CHAR	40	0	Description for Responsible Organizational Unit
56	DEAL_ID	☐	CRM_MKTPL_DEALID	CGPL_EXTID	CHAR	24	0	Deal
57	STSMA_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
58	.INCLUDE	☐				0	0	CRM MarketingPlanning - External Form. of INI/INT Attributes
59	DESCRIPTION_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner

History

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