SAP ABAP View V_SMOTGGRP (View for Target Group synchronization in BW)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-MKT-BW (Application Component) Data Extraction for BW
     ⤷ CRM_MKT_BW (Package) BW Extractors for Marketing

Basic Data

View Type	D	Database View
Database View	V_SMOTGGRP
Short Description	View for Target Group synchronization in BW
Root table	CRMD_MKTTG_TG_I	CRM Marketing: Target Group Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTTG_TG_I	CRMD_MKTTG_TG_I
2	BUT000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_MKTTG_TG_I	CLIENT	JL	EQ				0	0
2	BUT000	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTTG_TG_I	BP_GUID	JL	EQ				0	0
4	BUT000	PARTNER_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_MKTTG_TG_I	CLIENT		☐	MANDT	☐	Client
2	TG_GUID	CRMD_MKTTG_TG_I	TG_GUID		☐	CRMT_TARGETGRP_GUID	☐	CRM Marketing: GUID of Target Group
3	BP_GUID	CRMD_MKTTG_TG_I	BP_GUID		☐	CRMT_TG_BP_GUID	☐	CRM Marketing: Target Group Business Partner GUID
4	BP_ORG	CRMD_MKTTG_TG_I	BP_ORG		☐	CRMT_MKTTG_BP_ORG	☐	CRM Marketing: Origin Indicator for a Business Partner
5	BP_DEL	CRMD_MKTTG_TG_I	BP_DEL		☐	CRMT_MKTBP_ITEMS_DEL	☐	CRM Marketing: Delete Indicator for a Business Partner
6	BP_NUMBER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number

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	20140117
SAP Release Created in	400