SAP ABAP View CRMV_MKTTG_SAF (CRM-Marketing: Attribute Filter Search view)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
     ⤷ CRM_MKTTG_DS (Package) CRM Marketing: Data Source of TargetGroupSelection (Extend.)

Basic Data

View Type	D	Database View
Database View	CRMV_MKTTG_SAF
Short Description	CRM-Marketing: Attribute Filter Search view
Root table	CRMD_MKTTG_SAL	CRM Marketing: Selection Attribute List

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTTG_SAL	CRMD_MKTTG_SAL
2	CRMD_MKTTG_SAL_T	CRMD_MKTTG_SAL_T
3	CRMD_MKTTG_SALDS
4	CRMD_MKTTG_SA
5	CRMD_MKTTG_SA_T
6	CRMD_MKTTG_SAF
7	CRMD_MKTTG_SAF_T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
2	CRMD_MKTTG_SAL_T	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
4	CRMD_MKTTG_SALDS	CLIENT	JR	EQ			AND	0	0
5	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
6	CRMD_MKTTG_SA	CLIENT	JR	EQ			AND	0	0
7	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
8	CRMD_MKTTG_SA_T	CLIENT	JR	EQ			AND	0	0
9	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
10	CRMD_MKTTG_SAF	CLIENT	JR	EQ			AND	0	0
11	CRMD_MKTTG_SAL	CLIENT	JL	EQ				0	0
12	CRMD_MKTTG_SAF_T	CLIENT	JR	EQ			AND	0	0
13	CRMD_MKTTG_SAL	GUID	JL	EQ				0	0
14	CRMD_MKTTG_SAL_T	GUID	JR	EQ			AND	0	0
15	CRMD_MKTTG_SAL	GUID	JL	EQ				0	0
16	CRMD_MKTTG_SALDS	SAL_GUID	JR	EQ			AND	0	0
17	CRMD_MKTTG_SALDS	GUID	JL	EQ				0	0
18	CRMD_MKTTG_SA	SALDS_GUID	JR	EQ			AND	0	0
19	CRMD_MKTTG_SA	GUID	JL	EQ				0	0
20	CRMD_MKTTG_SA_T	GUID	JR	EQ			AND	0	0
21	CRMD_MKTTG_SA	GUID	JL	EQ				0	0
22	CRMD_MKTTG_SAF	SA_GUID	JR	EQ			AND	0	0
23	CRMD_MKTTG_SAF	GUID	JL	EQ				0	0
24	CRMD_MKTTG_SAF_T	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	SAL_T_CLIENT	CRMD_MKTTG_SAL_T	CLIENT		☐	MANDT	☐	Client
2	SAL_T_GUID	CRMD_MKTTG_SAL_T	GUID		☐	CRMT_MKTTG_SAL_GUID	☐	CRM Marketing: GUID for an Attribute List
3	SAL_T_LANGU	CRMD_MKTTG_SAL_T	LANGU		☐	CRMT_MKTTG_SAL_LG	☐	CRM Marketing: Language of an Attribute List
4	SALDS_CLIENT	CRMD_MKTTG_SALDS	CLIENT		☐	MANDT	☐	Client
5	SALDS_GUID	CRMD_MKTTG_SALDS	GUID		☐	CRMT_MKTTG_SALDS_GUID	☐	CRM: GUID for a Selection Attribute/Data Source Assignment
6	SA_CLIENT	CRMD_MKTTG_SA	CLIENT		☐	MANDT	☐	Client
7	SA_GUID	CRMD_MKTTG_SA	GUID		☐	CRMT_MKTTG_SA_GUID	☐	CRM Marketing: GUID of Selection Attribute
8	SA_T_CLIENT	CRMD_MKTTG_SA_T	CLIENT		☐	MANDT	☐	Client
9	SA_T_GUID	CRMD_MKTTG_SA_T	GUID		☐	CRMT_MKTTG_SA_GUID	☐	CRM Marketing: GUID of Selection Attribute
10	SA_T_LANGU	CRMD_MKTTG_SA_T	LANGU		☐	CRMT_MKTTG_SA_LG	☐	CRM Marketing: Language of Selection Attribute
11	CLIENT	CRMD_MKTTG_SAF	CLIENT		☐	MANDT	☐	Client
12	GUID	CRMD_MKTTG_SAF	GUID		☐	CRMT_MKTTG_SAF_GUID	☐	CRM Marketing: GUID of a Selection Attribute Filter
13	SAF_T_CLIENT	CRMD_MKTTG_SAF_T	CLIENT		☐	MANDT	☐	Client
14	SAF_T_GUID	CRMD_MKTTG_SAF_T	GUID		☐	CRMT_MKTTG_SAF_GUID	☐	CRM Marketing: GUID of a Selection Attribute Filter
15	SAF_T_LANGU	CRMD_MKTTG_SAF_T	LANGU		☐	CRMT_MKTTG_SAF_LG	☐	CRM Marketing: Language for a Selection Attribute Filter
16	SAL_DESCR	CRMD_MKTTG_SAL_T	DESCR		☐	CRMT_MKTTG_SAL_DESCR	☐	CRM Marketing: Description for an Attribute List
17	SAL_DESCR_UC	CRMD_MKTTG_SAL_T	DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
18	SA_DESCR	CRMD_MKTTG_SA_T	DESCR		☐	CRMT_MKTTG_SA_DESCR	☐	CRM Marketing: Description of Selection Attribute
19	SA_DESCR_UC	CRMD_MKTTG_SA_T	DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
20	DESCR	CRMD_MKTTG_SAF_T	DESCR		☐	CRMT_MKTTG_SAF_DESCR	☐	CRM Marketing: Description of a Selection Attribute Filter
21	DESCR_UC	CRMD_MKTTG_SAF_T	DESCR_UC		☐	CRMT_MKTTG_DESCR_UC	☐	CRM Marketing: Description of Segment in Capitals
22	SAF_USER	CRMD_MKTTG_SAF	SAF_USER		☐	CRMT_MKTTG_PERS_USER	☐	CRM Marketing: User for a Personalization Parameter
23	SAL_CLIENT	CRMD_MKTTG_SAL	CLIENT		☐	MANDT	☐	Client
24	SAL_GUID	CRMD_MKTTG_SAL	GUID		☐	CRMT_MKTTG_SAL_GUID	☐	CRM Marketing: GUID for an Attribute List
25	SAL_ORIG_LG	CRMD_MKTTG_SAL	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
26	SA_ORIG_LG	CRMD_MKTTG_SA	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
27	ORIG_LG	CRMD_MKTTG_SAF	ORIG_LG		☐	CRMT_MKTTG_ORIG_LG	☐	CRM Marketing: Original Language of a Marketing Object
28	OBJ_TYPE	CRMD_MKTTG_SAL	OBJ_TYPE		☐	CRMT_MKTTG_PF_OBJ_TYPE	☐	CRM Marketing: Object Type for a Marketing Profile
29	STATIC_FLAG	CRMD_MKTTG_SAF	STATIC_FLAG		☐	CRMT_MKTTG_SAF_STATIC	☐	define a filter as static
30	TYPE_ID	CRMD_MKTTG_SAL	TYPE_ID		☐	CRMT_MKTTG_TG_TYPE	☐	CRM Marketing: Usage ID

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