SAP ABAP Table CRMT_MKTTG_TG_H_MSA (CRM Marketing: Copy CRMD_MKTTG_GT_H and Current Number of BP)
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 | INTTAB | Structure |
Structure | CRMT_MKTTG_TG_H_MSA | Table Relationship Diagram |
Short Description | CRM Marketing: Copy CRMD_MKTTG_GT_H and Current Number of BP |
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 | XFIELD | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
2 | TASK | SMOG_TASK | SMOG_TASK | INT1 | 3 | 0 | Task flag for segment structures | ||
3 | STATUS | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
4 | BP_NO_ACTUAL | INTEGER4 | INT4 | 10 | 0 | Integer 4 | |||
5 | .INCLUDE | 0 | 0 | CRM Marketing: Header Structure for Target Group | |||||
6 | .INCLUDE | 0 | 0 | CRM Marketing: Target Group Header Data | |||||
7 | .INCLUDE | 0 | 0 | CRM Marketing: Key Fields for Target Group | |||||
8 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
9 | GUID | CRMT_TARGETGRP_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Target Group | ||
10 | .INCLUDE | 0 | 0 | CRM Marketing: Target Group Relations (GUIDs) | |||||
11 | SET_H_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
12 | SET_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
13 | PROF_GUID | CRMT_MKTTG_PF_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of a Profile | ||
14 | TG_ORG | CRMT_MKTTG_TG_ORG | CRM_MKTTG_TG_ORG | CHAR | 2 | 0 | CRM Marketing: Origin of a Target Group | ||
15 | TG_TYPE | CRMT_MKTTG_TG_TYPE | CRM_MKTTG_OBJECT_TYPE | CHAR | 6 | 0 | CRM Marketing: Usage ID | CRMC_MKTTG_TYP_H | |
16 | PLAN_COUNT | CRMT_MKTTG_PLAN | INT4 | 10 | 0 | CRM Marketing: Planned Size of a Segment | |||
17 | ACT_COUNT | CRMT_MKTTG_COUNT | INT4 | 10 | 0 | CRM Marketing: Number of Business Partners in a Segment | |||
18 | DEDUP_CODE | CRMT_MKTTG_DEDUP_CODE | CHAR6 | CHAR | 6 | 0 | CRM Marketing: Deduplication Method Key | ||
19 | PRIO | CRMT_MKTTG_SEG_PRIO | CRM_MKTTG_SEG_PRIO | INT4 | 10 | 0 | CRM Marketing: Priority of a Segment | ||
20 | SEARCHFIELD | CRMT_MKTTG_SEARCHFIELD | CRM_MKTTG_SEARCHFIELD | CHAR | 32 | 0 | CRM Marketing: Target Groups Search Term | ||
21 | DELETE_FLAG | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
22 | ITEM_TABLE | CRMT_MKTTG_TG_I_TAB_NAME | DBOBJ_NAME | CHAR | 16 | 0 | CRM Marketing: Table Containing Header Items | ||
23 | .INCLUDE | 0 | 0 | CRM Marketing: Time point and User Creation and Last Change | |||||
24 | ORIG_LG | CRMT_MKTTG_ORIG_LG | SYLANGU | LANG | 1 | 0 | CRM Marketing: Original Language of a Marketing Object | ||
25 | CREATED_AT | CRMT_MKT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Creation Date | ||
26 | CREATED_BY | CRMT_MKT_CREATED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Created By User | ||
27 | CHANGED_AT | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
28 | CHANGED_BY | CRMT_MKT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Last Changed By | ||
29 | TG_SEL | CRMT_MKTTG_TG_SELECTION | CRM_BOOLEAN | CHAR | 1 | 0 | Variable for Scheduled Target Group Selection | ||
30 | UU_COUNT | CRMT_MKTTG_UU_COUNT | INT4 | 10 | 0 | CRM Marketing: No. of Unknown Users in a Segment | |||
31 | BW_SYNC | CRMT_MKTTG_BW_SYNC | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator for Target Group Synchronization with BW | ||
32 | OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CRM_MKTPF_OBJ_TYPE | CHAR | 2 | 0 | CRM Marketing: Object Type for a Marketing Profile | ||
33 | COUNT_RELATION | CRMT_MKTTG_COUNT_RELATIONSHIP | INT4 | 10 | 0 | CRM Marketing: Number of Relationships | |||
34 | ID | CRMT_MKTTG_TG_ID | CRMT_MKTTG_TG_ID | CHAR | 10 | 0 | Unique Identifiers for Target Groups and Product Segments | ||
35 | MODELING_TYPE | CRMT_MKTTG_MODELING_TYPE | CRM_MKTTG_MODELING_TYPE | CHAR | 1 | 0 | CRM Marketing: Modeling Type | ||
36 | .INCLUDE | 0 | 0 | new fields on profile/tg with TPM related fields | |||||
37 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
38 | TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | SYSUUID | RAW | 16 | 0 | Territory Path GUID | ||
39 | NODE_GUID | BU_NODE_GUID | SYSUUID | RAW | 16 | 0 | GUID of Hierarchy Node | ||
40 | VALID_FROM | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
41 | VALID_TO | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
42 | LAST_BUILD | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
43 | TG_CAT | CRMT_MKTTG_SEGM_CAT | CRM_MKTTG_SEGM_CAT | CHAR | 2 | 0 | CRM Marketing: Usage Category | ||
44 | TG_STATUS | CRMT_MKTTG_STATUS_ID_TEXT_TAB | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_MKTTG_TG_H_MSA | CLIENT | T000 | MANDT | |||
2 | CRMT_MKTTG_TG_H_MSA | TG_TYPE | CRMC_MKTTG_TYP_H | TYPE_ID |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 30A |