SAP ABAP View CRMV_MKTTG_TG (CRM-Marketing: Target Group Search view)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
     ⤷ CRM_MKTTG_TG (Package) CRM Marketing: Targ. Grps. of Targ. Gr. Select. (Extended)

Basic Data

View Type	D	Database View
Database View	CRMV_MKTTG_TG
Short Description	CRM-Marketing: Target Group Search view
Root table	CRMD_MKTTG_TG_H	CRM Marketing: Target Group Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTTG_TG_H	CRMD_MKTTG_TG_H
2	CRMD_MKTTG_TG_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_TG_H	CLIENT	JL	EQ				0	0
2	CRMD_MKTTG_TG_T	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTTG_TG_H	GUID	JL	EQ				0	0
4	CRMD_MKTTG_TG_T	GUID	JR	EQ			AND	0	0
5	CRMD_MKTTG_TG_H	TG_TYPE	JL	EQ				0	0
6	CRMC_MKTTG_TYP_H	TYPE_ID	JR	EQ			AND	0	0
7	CRMD_MKTTG_TG_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_TG_H	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_MKTTG_TG_H	GUID		☐	CRMT_TARGETGRP_GUID	☐	CRM Marketing: GUID of Target Group
3	TG_T_CLIENT	CRMD_MKTTG_TG_T	CLIENT		☐	MANDT	☐	Client
4	TG_T_GUID	CRMD_MKTTG_TG_T	GUID		☐	CRMT_TARGETGRP_GUID	☐	CRM Marketing: GUID of Target Group
5	LANGU	CRMD_MKTTG_TG_T	TG_LG		☐	CRMT_MKTTG_TG_SPRAS	☐	CRM Marketing. Language Key for Target Group Description
6	TYPE_CLIENT	CRMC_MKTTG_TYP_H	CLIENT		☐	MANDT	☐	Client
7	TYPE_ID	CRMC_MKTTG_TYP_H	TYPE_ID		☐	CRMT_MKTTG_TG_TYPE	☐	CRM Marketing: Usage ID
8	SET_H_GUID	CRMD_MKTTG_TG_H	SET_H_GUID		☐	CRMT_MKTTG_SET_GUID	☐	CRM Marketing: GUID Profile Set
9	SET_GUID	CRMD_MKTTG_TG_H	SET_GUID		☐	CRMT_MKTTG_SET_GUID	☐	CRM Marketing: GUID Profile Set
10	PROF_GUID	CRMD_MKTTG_TG_H	PROF_GUID		☐	CRMT_MKTTG_PF_GUID	☐	CRM Marketing: GUID of a Profile
11	TG_ORG	CRMD_MKTTG_TG_H	TG_ORG		☐	CRMT_MKTTG_TG_ORG	☐	CRM Marketing: Origin of a Target Group
12	SEG_TYPE	CRMD_MKTTG_TG_H	TG_TYPE		☐	CRMT_MKTTG_TG_TYPE	☐	CRM Marketing: Usage ID
13	PLAN_COUNT	CRMD_MKTTG_TG_H	PLAN_COUNT		☐	CRMT_MKTTG_PLAN	☐	CRM Marketing: Planned Size of a Segment
14	ACT_COUNT	CRMD_MKTTG_TG_H	ACT_COUNT		☐	CRMT_MKTTG_COUNT	☐	CRM Marketing: Number of Business Partners in a Segment
15	DEDUP_CODE	CRMD_MKTTG_TG_H	DEDUP_CODE		☐	CRMT_MKTTG_DEDUP_CODE	☐	CRM Marketing: Deduplication Method Key
16	PRIO	CRMD_MKTTG_TG_H	PRIO		☐	CRMT_MKTTG_SEG_PRIO	☐	CRM Marketing: Priority of a Segment
17	SEARCHFIELD	CRMD_MKTTG_TG_H	SEARCHFIELD		☐	CRMT_MKTTG_SEARCHFIELD	☐	CRM Marketing: Target Groups Search Term
18	DELETE_FLAG	CRMD_MKTTG_TG_H	DELETE_FLAG		☐	CRMT_BOOLEAN	☐	Logical Variable
19	ITEM_TABLE	CRMD_MKTTG_TG_H	ITEM_TABLE		☐	CRMT_MKTTG_TG_I_TAB_NAME	☐	CRM Marketing: Table Containing Header Items
20	ORIG_LG	CRMD_MKTTG_TG_H	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
21	CREATED_ON	CRMD_MKTTG_TG_H	CREATED_AT		☐	CRMT_MKT_CREATED_AT	☐	Marketing Object: Creation Date
22	CREATED_BY	CRMD_MKTTG_TG_H	CREATED_BY		☐	CRMT_MKT_CREATED_BY	☐	Marketing Object: Created By User
23	CHANGED_ON	CRMD_MKTTG_TG_H	CHANGED_AT		☐	CRMT_MKT_CHANGED_AT	☐	Marketing Object: Date of Last Change
24	CHANGED_BY	CRMD_MKTTG_TG_H	CHANGED_BY		☐	CRMT_MKT_CHANGED_BY	☐	Marketing Object: Last Changed By
25	TG_SEL	CRMD_MKTTG_TG_H	TG_SEL		☐	CRMT_MKTTG_TG_SELECTION	☐	Variable for Scheduled Target Group Selection
26	UU_COUNT	CRMD_MKTTG_TG_H	UU_COUNT		☐	CRMT_MKTTG_UU_COUNT	☐	CRM Marketing: No. of Unknown Users in a Segment
27	BW_SYNC	CRMD_MKTTG_TG_H	BW_SYNC		☐	CRMT_MKTTG_BW_SYNC	☐	Indicator for Target Group Synchronization with BW
28	DESCR	CRMD_MKTTG_TG_T	TG_DESCR		☐	CRMT_MKTTG_TG_DESCR	☐	CRM Marketing: Description of a Target Group
29	DESCR_UC	CRMD_MKTTG_TG_T	TG_DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
30	CATEGORY	CRMC_MKTTG_TYP_H	SEGM_CAT		☐	CRMT_MKTTG_SEGM_CAT	☐	CRM Marketing: Usage Category
31	OBJ_TYPE	CRMD_MKTTG_TG_H	OBJ_TYPE		☐	CRMT_MKTTG_PF_OBJ_TYPE	☐	CRM Marketing: Object Type for a Marketing Profile
32	TERR_PATH_GUID	CRMD_MKTTG_TG_H	TERR_PATH_GUID		☐	CRMT_TERRITORY_PATH_GUID	☐	Territory Path GUID
33	NODE_GUID	CRMD_MKTTG_TG_H	NODE_GUID		☐	BU_NODE_GUID	☐	GUID of Hierarchy Node
34	VALID_FROM	CRMD_MKTTG_TG_H	VALID_FROM		☐	CGPL_PLANSTART	☐	Planned start date
35	VALID_TO	CRMD_MKTTG_TG_H	VALID_TO		☐	CGPL_PLANSTART	☐	Planned start date
36	RESPONSIBLE	CRMD_MKTTG_TG_H	RESPONSIBLE		☐	BU_PARTNER_GUID	☐	Business Partner GUID
37	ID	CRMD_MKTTG_TG_H	ID		☐	CRMT_MKTTG_TG_ID	☐	Unique Identifiers for Target Groups and Product Segments
38	MODELING_TYPE	CRMD_MKTTG_TG_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