SAP ABAP View SMOTGBPV (Relationship View: Target Group - Business Partner)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-SEG-TGR (Application Component) Target Groups
     CRM_MKTTG (Package) CRM Marketing: General FMs for TG Selection (Enhanced)
Basic Data
View Type D Database View 
Database View SMOTGBPV  
Short Description Relationship View: Target Group - Business Partner    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 CRMD_MKTTG_TG_I  
3 CRMD_MKTTG_TG_H  
4 CRMC_MKTTG_TYP_H  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT000 CLIENT JL EQ 0 0
2 CRMD_MKTTG_TG_I CLIENT JR EQ AND 0 0
3 BUT000 CLIENT JL EQ 0 0
4 CRMD_MKTTG_TG_H CLIENT JR EQ AND 0 0
5 BUT000 CLIENT JL EQ 0 0
6 CRMC_MKTTG_TYP_H CLIENT JR EQ AND 0 0
7 CRMD_MKTTG_TG_I BP_GUID JL EQ 0 0
8 BUT000 PARTNER_GUID JR EQ AND 0 0
9 CRMD_MKTTG_TG_H TG_TYPE JL EQ 0 0
10 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_TG_I CLIENT   MANDT Client
2 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 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
5 TG_TYPE CRMD_MKTTG_TG_H TG_TYPE   CRMT_MKTTG_TG_TYPE CRM Marketing: Usage ID
6 SEGM_CAT CRMC_MKTTG_TYP_H SEGM_CAT   CRMT_MKTTG_SEGM_CAT CRM Marketing: Usage Category
7 GUID_I CRMD_MKTTG_TG_I GUID   CRMT_BPITEMS_GUID Item List Business Partner GUID
8 GUID_H CRMD_MKTTG_TG_H GUID   CRMT_TARGETGRP_GUID CRM Marketing: GUID of Target Group
                 
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