SAP ABAP View CRMV_MKTTG_PF (CRM-Marketing: Search View Profiles)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
     ⤷ CRM_MKTTG_PF (Package) CRM Marketing: Target Group Selection Profiles (Enhanced)

Basic Data

View Type	D	Database View
Database View	CRMV_MKTTG_PF
Short Description	CRM-Marketing: Search View Profiles
Root table	CRMD_MKTTG_PF_H	CRM Marketing: Profile

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTTG_PF_H	CRMD_MKTTG_PF_H
2	CRMD_MKTTG_PF_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_PF_H	CLIENT	JL	EQ				0	0
2	CRMD_MKTTG_PF_T	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTTG_PF_H	CLIENT	JL	EQ				0	0
4	CRMC_MKTTG_TYP_H	CLIENT	JR	EQ			AND	0	0
5	CRMD_MKTTG_PF_H	GUID	JL	EQ				0	0
6	CRMD_MKTTG_PF_T	GUID	JR	EQ			AND	0	0
7	CRMD_MKTTG_PF_H	PF_TYPE	JL	EQ				0	0
8	CRMC_MKTTG_TYP_H	TYPE_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_MKTTG_PF_H	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_MKTTG_PF_H	GUID		☐	CRMT_MKTTG_PF_GUID	☐	CRM Marketing: GUID of a Profile
3	PF_T_CLIENT	CRMD_MKTTG_PF_T	CLIENT		☐	MANDT	☐	Client
4	PF_T_GUID	CRMD_MKTTG_PF_T	GUID		☐	CRMT_MKTTG_PF_GUID	☐	CRM Marketing: GUID of a Profile
5	LANGU	CRMD_MKTTG_PF_T	LANGU		☐	CRMT_MKTTG_PF_LANGU	☐	CRM Marketing: Profile Language
6	TYP_CLIENT	CRMC_MKTTG_TYP_H	CLIENT		☐	MANDT	☐	Client
7	SEG_TYPE	CRMC_MKTTG_TYP_H	TYPE_ID		☐	CRMT_MKTTG_TG_TYPE	☐	CRM Marketing: Usage ID
8	ACT_COUNT	CRMD_MKTTG_PF_H	ACT_COUNT		☐	CRMT_MKTTG_COUNT	☐	CRM Marketing: Number of Business Partners in a Segment
9	PLAN_COUNT	CRMD_MKTTG_PF_H	PLAN_COUNT		☐	CRMT_MKTTG_PLAN	☐	CRM Marketing: Planned Size of a Segment
10	MLC_RULE	CRMD_MKTTG_PF_H	MLC_RULE		☐	CRMT_MKTTG_MLC_RULE	☐	Size Reduction Rule
11	DEDUP_CODE	CRMD_MKTTG_PF_H	DEDUP_CODE		☐	CRMT_MKTTG_DEDUP_CODE	☐	CRM Marketing: Deduplication Method Key
12	PRIO	CRMD_MKTTG_PF_H	PRIO		☐	CRMT_MKTTG_SEG_PRIO	☐	CRM Marketing: Priority of a Segment
13	ORIG_LG	CRMD_MKTTG_PF_H	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
14	CREATED_ON	CRMD_MKTTG_PF_H	CREATED_AT		☐	CRMT_MKT_CREATED_AT	☐	Marketing Object: Creation Date
15	CREATED_BY	CRMD_MKTTG_PF_H	CREATED_BY		☐	CRMT_MKT_CREATED_BY	☐	Marketing Object: Created By User
16	CHANGED_ON	CRMD_MKTTG_PF_H	CHANGED_AT		☐	CRMT_MKT_CHANGED_AT	☐	Marketing Object: Date of Last Change
17	CHANGED_BY	CRMD_MKTTG_PF_H	CHANGED_BY		☐	CRMT_MKT_CHANGED_BY	☐	Marketing Object: Last Changed By
18	DESCR	CRMD_MKTTG_PF_T	DESCR		☐	CRMT_MKTTG_PF_DESCR	☐	CRM Marketing: Profile Description
19	DESCR_AUTO	CRMD_MKTTG_PF_T	DESCR_AUTO		☐	CRMT_MKTTG_PF_DESCR	☐	CRM Marketing: Profile Description
20	DESCR_UC	CRMD_MKTTG_PF_T	DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
21	CATEGORY	CRMC_MKTTG_TYP_H	SEGM_CAT		☐	CRMT_MKTTG_SEGM_CAT	☐	CRM Marketing: Usage Category
22	SET_GUID	CRMD_MKTTG_PF_H	SET_GUID		☐	CRMT_MKTTG_SET_GUID	☐	CRM Marketing: GUID Profile Set
23	DELETE_FLAG	CRMD_MKTTG_PF_H	DELETE_FLAG		☐	CRMT_BOOLEAN	☐	Logical Variable
24	OBJ_TYPE	CRMD_MKTTG_PF_H	OBJ_TYPE		☐	CRMT_MKTTG_PF_OBJ_TYPE	☐	CRM Marketing: Object Type for a Marketing Profile
25	ID	CRMD_MKTTG_PF_H	ID		☐	CRMT_MKTTG_PF_ID	☐	ID for Profiles in Segment Builder
26	END_NODE	CRMD_MKTTG_PF_H	END_NODE		☐	CRMT_BOOLEAN	☐	Logical Variable
27	MODELING_TYPE	CRMD_MKTTG_PF_H	MODELING_TYPE		☐	CRMT_MKTTG_MODELING_TYPE	☐	CRM Marketing: Modeling Type

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