SAP ABAP Table CRMD_MKTTG_TG_H (CRM Marketing: Target Group Header Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
⤷ CRM_MKTTG_TG (Package) CRM Marketing: Targ. Grps. of Targ. Gr. Select. (Extended)
⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
⤷ CRM_MKTTG_TG (Package) CRM Marketing: Targ. Grps. of Targ. Gr. Select. (Extended)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CRMD_MKTTG_TG_H | Table Relationship Diagram |
Short Description | CRM Marketing: Target Group Header Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | CRM Marketing: Key Fields for Target Group | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | GUID | CRMT_TARGETGRP_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Target Group | ||
4 | .INCLUDE | 0 | 0 | CRM Marketing: Target Group Relations (GUIDs) | |||||
5 | SET_H_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
6 | SET_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
7 | PROF_GUID | CRMT_MKTTG_PF_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of a Profile | ||
8 | TG_ORG | CRMT_MKTTG_TG_ORG | CRM_MKTTG_TG_ORG | CHAR | 2 | 0 | CRM Marketing: Origin of a Target Group | ||
9 | TG_TYPE | CRMT_MKTTG_TG_TYPE | CRM_MKTTG_OBJECT_TYPE | CHAR | 6 | 0 | CRM Marketing: Usage ID | CRMC_MKTTG_TYP_H | |
10 | PLAN_COUNT | CRMT_MKTTG_PLAN | INT4 | 10 | 0 | CRM Marketing: Planned Size of a Segment | |||
11 | ACT_COUNT | CRMT_MKTTG_COUNT | INT4 | 10 | 0 | CRM Marketing: Number of Business Partners in a Segment | |||
12 | DEDUP_CODE | CRMT_MKTTG_DEDUP_CODE | CHAR6 | CHAR | 6 | 0 | CRM Marketing: Deduplication Method Key | ||
13 | PRIO | CRMT_MKTTG_SEG_PRIO | CRM_MKTTG_SEG_PRIO | INT4 | 10 | 0 | CRM Marketing: Priority of a Segment | ||
14 | SEARCHFIELD | CRMT_MKTTG_SEARCHFIELD | CRM_MKTTG_SEARCHFIELD | CHAR | 32 | 0 | CRM Marketing: Target Groups Search Term | ||
15 | DELETE_FLAG | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
16 | ITEM_TABLE | CRMT_MKTTG_TG_I_TAB_NAME | DBOBJ_NAME | CHAR | 16 | 0 | CRM Marketing: Table Containing Header Items | ||
17 | .INCLUDE | 0 | 0 | CRM Marketing: Time point and User Creation and Last Change | |||||
18 | ORIG_LG | CRMT_MKTTG_ORIG_LG | SYLANGU | LANG | 1 | 0 | CRM Marketing: Original Language of a Marketing Object | ||
19 | CREATED_AT | CRMT_MKT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Creation Date | ||
20 | CREATED_BY | CRMT_MKT_CREATED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Created By User | ||
21 | CHANGED_AT | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
22 | CHANGED_BY | CRMT_MKT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Last Changed By | ||
23 | TG_SEL | CRMT_MKTTG_TG_SELECTION | CRM_BOOLEAN | CHAR | 1 | 0 | Variable for Scheduled Target Group Selection | ||
24 | UU_COUNT | CRMT_MKTTG_UU_COUNT | INT4 | 10 | 0 | CRM Marketing: No. of Unknown Users in a Segment | |||
25 | BW_SYNC | CRMT_MKTTG_BW_SYNC | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator for Target Group Synchronization with BW | ||
26 | OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CRM_MKTPF_OBJ_TYPE | CHAR | 2 | 0 | CRM Marketing: Object Type for a Marketing Profile | ||
27 | COUNT_RELATION | CRMT_MKTTG_COUNT_RELATIONSHIP | INT4 | 10 | 0 | CRM Marketing: Number of Relationships | |||
28 | ID | CRMT_MKTTG_TG_ID | CRMT_MKTTG_TG_ID | CHAR | 10 | 0 | Unique Identifiers for Target Groups and Product Segments | ||
29 | MODELING_TYPE | CRMT_MKTTG_MODELING_TYPE | CRM_MKTTG_MODELING_TYPE | CHAR | 1 | 0 | CRM Marketing: Modeling Type | ||
30 | .INCLUDE | 0 | 0 | new fields on profile/tg with TPM related fields | |||||
31 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
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 | LAST_BUILD | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMD_MKTTG_TG_H | CLIENT | T000 | MANDT | |||
2 | CRMD_MKTTG_TG_H | TG_TYPE | CRMC_MKTTG_TYP_H | TYPE_ID |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 30A |