SAP ABAP View CRMV_MKTTG_SET (CRM-Marketing: Profile Set Search view)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
     ⤷ CRM_MKTTG_SET (Package) CRM Marketing: Profile Set of Target Grp. Select. (enhanced)

Basic Data

View Type	D	Database View
Database View	CRMV_MKTTG_SET
Short Description	CRM-Marketing: Profile Set Search view
Root table	CRMD_MKTTG_SET_H	CRM Marketing: Profile Set

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTTG_SET_H	CRMD_MKTTG_SET_H
2	CRMD_MKTTG_SET_T
3	CRMC_MKTTG_TYP_H

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_MKTTG_SET_H	CLIENT	JL	EQ				0	0
2	CRMD_MKTTG_SET_T	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTTG_SET_H	GUID	JL	EQ				0	0
4	CRMD_MKTTG_SET_T	GUID	JR	EQ			AND	0	0
5	CRMD_MKTTG_SET_H	SET_TYPE	JL	EQ				0	0
6	CRMC_MKTTG_TYP_H	TYPE_ID	JR	EQ			AND	0	0
7	CRMD_MKTTG_SET_H	CLIENT	JL	EQ				0	0
8	CRMC_MKTTG_TYP_H	CLIENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_MKTTG_SET_H	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_MKTTG_SET_H	GUID		☐	CRMT_MKTTG_SET_GUID	☐	CRM Marketing: GUID Profile Set
3	CLIENT_TXT	CRMD_MKTTG_SET_T	CLIENT		☐	MANDT	☐	Client
4	GUID_TXT	CRMD_MKTTG_SET_T	GUID		☐	CRMT_MKTTG_SET_GUID	☐	CRM Marketing: GUID Profile Set
5	LANGU	CRMD_MKTTG_SET_T	LANGU		☐	CRMT_MKTTG_SET_LANGU	☐	CRM Marketing: Profile Set Language
6	DESCR	CRMD_MKTTG_SET_T	DESCR		☐	CRMT_MKTTG_SET_DESCR	☐	CRM Marketing: Description of Profile Set
7	CLIENT_TYP	CRMC_MKTTG_TYP_H	CLIENT		☐	MANDT	☐	Client
8	TYPE_ID	CRMC_MKTTG_TYP_H	TYPE_ID		☐	CRMT_MKTTG_TG_TYPE	☐	CRM Marketing: Usage ID
9	SEG_TYPE	CRMD_MKTTG_SET_H	SET_TYPE		☐	CRMT_MKTTG_SET_TYPE	☐	CRM Marketing: Usage of Profile Set
10	CREATED_ON	CRMD_MKTTG_SET_H	CREATED_AT		☐	CRMT_MKT_CREATED_AT	☐	Marketing Object: Creation Date
11	CREATED_BY	CRMD_MKTTG_SET_H	CREATED_BY		☐	CRMT_MKT_CREATED_BY	☐	Marketing Object: Created By User
12	CHANGED_ON	CRMD_MKTTG_SET_H	CHANGED_AT		☐	CRMT_MKT_CHANGED_AT	☐	Marketing Object: Date of Last Change
13	CHANGED_BY	CRMD_MKTTG_SET_H	CHANGED_BY		☐	CRMT_MKT_CHANGED_BY	☐	Marketing Object: Last Changed By
14	CATEGORY	CRMC_MKTTG_TYP_H	SEGM_CAT		☐	CRMT_MKTTG_SEGM_CAT	☐	CRM Marketing: Usage Category
15	PARENT_GUID	CRMD_MKTTG_SET_H	PARENT_GUID		☐	CRMT_MKTTG_SET_PAR_GUID	☐	CRM Marketing: GUID of Profile Set (Parent)
16	MGR_GUID	CRMD_MKTTG_SET_H	MGR_GUID		☐	CRMT_MKTTG_SEG_CHAR32_GUID	☐	CRM Marketing: GUID of a Marketing Segment (CHAR32)
17	ACT_COUNT	CRMD_MKTTG_SET_H	ACT_COUNT		☐	CRMT_MKTTG_COUNT	☐	CRM Marketing: Number of Business Partners in a Segment
18	PLAN_COUNT	CRMD_MKTTG_SET_H	PLAN_COUNT		☐	CRMT_MKTTG_PLAN	☐	CRM Marketing: Planned Size of a Segment
19	MLC_RULE	CRMD_MKTTG_SET_H	MLC_RULE		☐	CRMT_MKTTG_MLC_RULE	☐	Size Reduction Rule
20	DEDUP_CODE	CRMD_MKTTG_SET_H	DEDUP_CODE		☐	CRMT_MKTTG_DEDUP_CODE	☐	CRM Marketing: Deduplication Method Key
21	DEDUP_CODE_CONS	CRMD_MKTTG_SET_H	DEDUP_CODE_CONS		☐	CRMT_MKTTG_DEDUP_CODE	☐	CRM Marketing: Deduplication Method Key
22	PRIO	CRMD_MKTTG_SET_H	PRIO		☐	CRMT_MKTTG_SEG_PRIO	☐	CRM Marketing: Priority of a Segment
23	DELETE_FLAG	CRMD_MKTTG_SET_H	DELETE_FLAG		☐	CRMT_BOOLEAN	☐	Logical Variable
24	JOB_PLANNED	CRMD_MKTTG_SET_H	JOB_PLANNED		☐	CRMT_BOOLEAN	☐	Logical Variable
25	OBJ_TYPE	CRMD_MKTTG_SET_H	OBJ_TYPE		☐	CRMT_MKTTG_PF_OBJ_TYPE	☐	CRM Marketing: Object Type for a Marketing Profile
26	CONTACT	CRMD_MKTTG_SET_H	CONTACT		☐	CRMT_MKTTG_CONTACT	☐	Include Members of Segments
27	RELATED	CRMD_MKTTG_SET_H	RELATED		☐	CRMT_MKTTG_RELATED	☐	Include Segment Relationships
28	ORIG_LG	CRMD_MKTTG_SET_H	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
29	DESCR_UC	CRMD_MKTTG_SET_T	DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
30	ID	CRMD_MKTTG_SET_H	ID		☐	CRMT_MKTTG_SET_ID	☐	ID for Profile Set in Segment Builder

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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