SAP ABAP Table CRMV_MKTTG_TGPFS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMV_MKTTG_TGPFS   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 GUID CRMT_TARGETGRP_GUID SYSUUID RAW 16   0   CRM Marketing: GUID of Target Group  
3 TG_T_CLIENT MANDT MANDT CLNT 3   0   Client T000
4 TG_T_GUID CRMT_TARGETGRP_GUID SYSUUID RAW 16   0   CRM Marketing: GUID of Target Group  
5 LANGU CRMT_MKTTG_TG_SPRAS SPRAS LANG 1   0   CRM Marketing. Language Key for Target Group Description  
6 TYPE_CLIENT MANDT MANDT CLNT 3   0   Client T000
7 TYPE_ID CRMT_MKTTG_TG_TYPE CRM_MKTTG_OBJECT_TYPE CHAR 6   0   CRM Marketing: Usage ID  
8 SET_H_GUID CRMT_MKTTG_SET_GUID SYSUUID RAW 16   0   CRM Marketing: GUID Profile Set  
9 SET_GUID CRMT_MKTTG_SET_GUID SYSUUID RAW 16   0   CRM Marketing: GUID Profile Set  
10 PROF_GUID CRMT_MKTTG_PF_GUID SYSUUID RAW 16   0   CRM Marketing: GUID of a Profile  
11 TG_ORG CRMT_MKTTG_TG_ORG CRM_MKTTG_TG_ORG CHAR 2   0   CRM Marketing: Origin of a Target Group  
12 SEG_TYPE CRMT_MKTTG_TG_TYPE CRM_MKTTG_OBJECT_TYPE CHAR 6   0   CRM Marketing: Usage ID CRMC_MKTTG_TYP_H
13 PLAN_COUNT CRMT_MKTTG_PLAN   INT4 10   0   CRM Marketing: Planned Size of a Segment  
14 ACT_COUNT CRMT_MKTTG_COUNT   INT4 10   0   CRM Marketing: Number of Business Partners in a Segment  
15 DEDUP_CODE CRMT_MKTTG_DEDUP_CODE CHAR6 CHAR 6   0   CRM Marketing: Deduplication Method Key  
16 PRIO CRMT_MKTTG_SEG_PRIO CRM_MKTTG_SEG_PRIO INT4 10   0   CRM Marketing: Priority of a Segment  
17 SEARCHFIELD CRMT_MKTTG_SEARCHFIELD CRM_MKTTG_SEARCHFIELD CHAR 32   0   CRM Marketing: Target Groups Search Term  
18 DELETE_FLAG CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
19 ITEM_TABLE CRMT_MKTTG_TG_I_TAB_NAME DBOBJ_NAME CHAR 16   0   CRM Marketing: Table Containing Header Items  
20 ORIG_LG CRMT_MKTTG_ORIG_LG SYLANGU LANG 1   0   CRM Marketing: Original Language of a Marketing Object  
21 CREATED_ON CRMT_MKT_CREATED_AT BCOS_TSTMP DEC 15   0   Marketing Object: Creation Date  
22 CREATED_BY CRMT_MKT_CREATED_BY UNAME CHAR 12   0   Marketing Object: Created By User  
23 CHANGED_ON CRMT_MKT_CHANGED_AT BCOS_TSTMP DEC 15   0   Marketing Object: Date of Last Change  
24 CHANGED_BY CRMT_MKT_CHANGED_BY UNAME CHAR 12   0   Marketing Object: Last Changed By  
25 TG_SEL CRMT_MKTTG_TG_SELECTION CRM_BOOLEAN CHAR 1   0   Variable for Scheduled Target Group Selection  
26 UU_COUNT CRMT_MKTTG_UU_COUNT   INT4 10   0   CRM Marketing: No. of Unknown Users in a Segment  
27 BW_SYNC CRMT_MKTTG_BW_SYNC CRM_BOOLEAN CHAR 1   0   Indicator for Target Group Synchronization with BW  
28 DESCR CRMT_MKTTG_TG_DESCR CRM_MARKETING_DESC CHAR 72   0   CRM Marketing: Description of a Target Group  
29 DESCR_UC CRMT_MKTTG_DESCR_UC CRM_MARKETING_DESC_UC CHAR 72   0   CRM Marketing: Description of Segment in Capitals  
30 CATEGORY CRMT_MKTTG_SEGM_CAT CRM_MKTTG_SEGM_CAT CHAR 2   0   CRM Marketing: Usage Category  
31 OBJ_TYPE CRMT_MKTTG_PF_OBJ_TYPE CRM_MKTPF_OBJ_TYPE CHAR 2   0   CRM Marketing: Object Type for a Marketing Profile  
32 TERR_PATH_GUID CRMT_TERRITORY_PATH_GUID SYSUUID RAW 16   0   Territory Path GUID  
33 NODE_GUID BU_NODE_GUID SYSUUID RAW 16   0   GUID of Hierarchy Node  
34 VALID_FROM CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
35 VALID_TO CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
36 RESPONSIBLE BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
37 PF_GUID CRMT_MKTTG_PF_GUID SYSUUID RAW 16   0   CRM Marketing: GUID of a Profile  
38 SAF_GUID CRMT_MKTTG_SAF_GUID SYSUUID RAW 16   0   CRM Marketing: GUID of a Selection Attribute Filter  
39 PF_S_CLIENT MANDT MANDT CLNT 3   0   Client  
40 PF_S_GUID CRMT_MKTTG_PF_S_GUID SYSUUID RAW 16   0   CRM Marketing: GUID for a Target Group Selection Criterion  
41 ID CRMT_MKTTG_TG_ID CRMT_MKTTG_TG_ID CHAR 10   0   Unique Identifiers for Target Groups and Product Segments  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMV_MKTTG_TGPFS CLIENT T000 MANDT    
2 CRMV_MKTTG_TGPFS SEG_TYPE CRMC_MKTTG_TYP_H TYPE_ID    
3 CRMV_MKTTG_TGPFS TG_T_CLIENT T000 MANDT    
4 CRMV_MKTTG_TGPFS TYPE_CLIENT T000 MANDT    
History
Last changed by/on SAP  20130604 
SAP Release Created in