SAP ABAP View CRMV_MKTTGGRP_US (CRM Marketing: Usage Category/Description/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 CRMV_MKTTGGRP_US  
Short Description CRM Marketing: Usage Category/Description/Business Partner    
Root table CRMD_MKTTGGRP_US   CRM Marketing: Usage Category for Target Group 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMD_MKTTGGRP_US CRMD_MKTTGGRP_US
2 CRMD_MKTTGGRP_T  
3 CRMD_MKTTGBP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRMD_MKTTGGRP_US CLIENT JL EQ 0 0
2 CRMD_MKTTGGRP_T CLIENT JR EQ AND 0 0
3 CRMD_MKTTGGRP_US TARGETGRP_GUID JL EQ 0 0
4 CRMD_MKTTGGRP_T TARGETGRP_GUID JR EQ AND 0 0
5 CRMD_MKTTGGRP_US TARGETGRP_GUID JL EQ 0 0
6 CRMD_MKTTGBP TARGETGRP_GUID JR EQ AND 0 0
7 CRMD_MKTTGGRP_T TARGETGRP_GUID JL EQ 0 0
8 CRMD_MKTTGBP TARGETGRP_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMD_MKTTGGRP_US CLIENT   MANDT Client
2 TARGETGRP_GUID CRMD_MKTTGGRP_US TARGETGRP_GUID   CRMT_TARGETGRP_GUID CRM Marketing: GUID of Target Group
3 TARGETGRP_USAGE CRMD_MKTTGGRP_US TARGETGRP_USAGE   CRMT_TARGETGRP_USAGE CRM Marketing: Usage Category for Target Group
4 TARGETGRP_USID CRMD_MKTTGGRP_US TARGETGRP_USID   CRMT_TARGETGRP_USID CRM Marketing: Target Group - Usage Object for Usage Cat.
5 USAGE_VALID_TO CRMD_MKTTGGRP_US USAGE_VALID_TO   CRMT_USAGE_VALID_TO CRM Marketing: Target Groups - Usage Category Valid To
6 TG_BP_GUID CRMD_MKTTGBP TG_BP_GUID   CRMT_TG_BP_GUID CRM Marketing: Target Group Business Partner GUID
7 TG_BP_VALID_TO CRMD_MKTTGBP TG_BP_VALID_TO   CRMT_TG_BP_VALID_TO CRM Marketing: Target Group Business Partner Valid To
8 TARGETGRP_DESCR CRMD_MKTTGGRP_T TARGETGRP_DESCR   CRMT_TARGETGRP_DESCR CRM Marketing: Description for Target Group
9 TARGETGRP_LG CRMD_MKTTGGRP_T TARGETGRP_LG   CRMT_TARGETGRP_LG CRM Marketing. Target Group Language
                 
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  20100421 
SAP Release Created in 12A