SAP ABAP Table CRMT_MKTTG_PF_IL (CRM Marketing: Profile IL Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
     ⤷ CRM_MKTTG_SEG_IL (Package) CRM Marketing: Segment Builder (Interaction Layer)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTTG_PF_IL	Table Relationship Diagram
Short Description	CRM Marketing: Profile IL Structure

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	☐	CRMT_MKTTG_SEG_CHAR32_GUID	SMO_GUID	CHAR	32	0	CRM Marketing: GUID of a Marketing Segment (CHAR32)
2	SET_GUID	☐	CRMT_MKTTG_SEG_CHAR32_GUID	SMO_GUID	CHAR	32	0	CRM Marketing: GUID of a Marketing Segment (CHAR32)
3	DESCRIPTION	☐	CRMT_MKTTG_SEG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description for a Marketing Segment
4	MGR_DESCRIPTION	☐	CRMT_MKTTG_MGR_DESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of Segmentation Basis
5	SET_DESCRIPTION	☐	CRMT_MKTTG_SET_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of Profile Set
6	ATT_TG_DESCR	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
7	POS	☐	CRMT_MKTTG_SEG_POS		INT4	10	0	CRM Marketing: Sort Sequence for a Marketing Segment
8	ICON	☐	CRMT_MKTTG_SEG_ICON	ICON	CHAR	4	0	CRM Marketing: Icon for a Marketing Segment	*
9	STATUSICON	☐	CRMT_MKTTG_SEG_ICON	ICON	CHAR	4	0	CRM Marketing: Icon for a Marketing Segment	*
10	PLAN_QUANTITY	☐	CRMT_MKTTG_PLAN		INT4	10	0	CRM Marketing: Planned Size of a Segment
11	MLC_RULE	☐	CRMT_MKTTG_MLC_RULE	CRMT_RNUM	CHAR	3	0	Size Reduction Rule
12	ACT_QUANTITY	☐	CRMT_MKTTG_COUNT		INT4	10	0	CRM Marketing: Number of Business Partners in a Segment
13	DEDUP_CODE	☐	CRMT_MKTTG_DEDUP_CODE	CHAR6	CHAR	6	0	CRM Marketing: Deduplication Method Key
14	PRIO	☐	CRMT_MKTTG_SEG_PRIO	CRM_MKTTG_SEG_PRIO	INT4	10	0	CRM Marketing: Priority of a Segment
15	TG_GUID	☐	CRMT_MKTTG_SEG_CHAR32_GUID	SMO_GUID	CHAR	32	0	CRM Marketing: GUID of a Marketing Segment (CHAR32)
16	TG_ACTIVE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
17	TYPE	☐	CRMT_MKTTG_TG_TYPE	CRM_MKTTG_OBJECT_TYPE	CHAR	6	0	CRM Marketing: Usage ID
18	CREATED_AT	☐	CRMT_MKT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Creation Date
19	CREATED_BY	☐	CRMT_MKT_CREATED_BY	UNAME	CHAR	12	0	Marketing Object: Created By User
20	CHANGED_AT	☐	CRMT_MKT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Date of Last Change
21	CHANGED_BY	☐	CRMT_MKT_CHANGED_BY	UNAME	CHAR	12	0	Marketing Object: Last Changed By
22	OBJ_TYPE	☐	CRMT_MKTTG_PF_OBJ_TYPE	CRM_MKTPF_OBJ_TYPE	CHAR	2	0	CRM Marketing: Object Type for a Marketing Profile
23	.INCLUDE	☐				0	0	new fields on profile/tg with TPM related fields
24	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
25	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
26	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
27	VALID_FROM	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
28	VALID_TO	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
29	LAST_BUILD	☐	CRMT_MKT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Date of Last Change

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A