SAP ABAP Table CRMT_MKTTG_SMP_H (CRM Marketing: Target Group Header + Sample Header Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-SEG (Application Component) Segmentation
⤷ CRM_MKTTG_MGR (Package) CRM Marketing: Segment Builder Master Groups (4.0)
⤷ CRM-MKT-SEG (Application Component) Segmentation
⤷ CRM_MKTTG_MGR (Package) CRM Marketing: Segment Builder Master Groups (4.0)
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_MKTTG_SMP_H | Table Relationship Diagram |
Short Description | CRM Marketing: Target Group Header + Sample Header Structure |
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 | .INCLUDE | 0 | 0 | CRM Marketing: Target Group Header Data | |||||
2 | .INCLUDE | 0 | 0 | CRM Marketing: Key Fields for Target Group | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | GUID | CRMT_TARGETGRP_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Target Group | ||
5 | .INCLUDE | 0 | 0 | CRM Marketing: Target Group Relations (GUIDs) | |||||
6 | SET_H_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
7 | SET_GUID | CRMT_MKTTG_SET_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID Profile Set | ||
8 | PROF_GUID | CRMT_MKTTG_PF_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of a Profile | ||
9 | TG_ORG | CRMT_MKTTG_TG_ORG | CRM_MKTTG_TG_ORG | CHAR | 2 | 0 | CRM Marketing: Origin of a Target Group | ||
10 | TG_TYPE | CRMT_MKTTG_TG_TYPE | CRM_MKTTG_OBJECT_TYPE | CHAR | 6 | 0 | CRM Marketing: Usage ID | CRMC_MKTTG_TYP_H | |
11 | PLAN_COUNT | CRMT_MKTTG_PLAN | INT4 | 10 | 0 | CRM Marketing: Planned Size of a Segment | |||
12 | ACT_COUNT | CRMT_MKTTG_COUNT | INT4 | 10 | 0 | CRM Marketing: Number of Business Partners in a Segment | |||
13 | DEDUP_CODE | CRMT_MKTTG_DEDUP_CODE | CHAR6 | CHAR | 6 | 0 | CRM Marketing: Deduplication Method Key | ||
14 | PRIO | CRMT_MKTTG_SEG_PRIO | CRM_MKTTG_SEG_PRIO | INT4 | 10 | 0 | CRM Marketing: Priority of a Segment | ||
15 | SEARCHFIELD | CRMT_MKTTG_SEARCHFIELD | CRM_MKTTG_SEARCHFIELD | CHAR | 32 | 0 | CRM Marketing: Target Groups Search Term | ||
16 | DELETE_FLAG | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
17 | ITEM_TABLE | CRMT_MKTTG_TG_I_TAB_NAME | DBOBJ_NAME | CHAR | 16 | 0 | CRM Marketing: Table Containing Header Items | ||
18 | .INCLUDE | 0 | 0 | CRM Marketing: Time point and User Creation and Last Change | |||||
19 | ORIG_LG | CRMT_MKTTG_ORIG_LG | SYLANGU | LANG | 1 | 0 | CRM Marketing: Original Language of a Marketing Object | ||
20 | CREATED_AT | CRMT_MKT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Creation Date | ||
21 | CREATED_BY | CRMT_MKT_CREATED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Created By User | ||
22 | CHANGED_AT | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
23 | CHANGED_BY | CRMT_MKT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Last Changed By | ||
24 | TG_SEL | CRMT_MKTTG_TG_SELECTION | CRM_BOOLEAN | CHAR | 1 | 0 | Variable for Scheduled Target Group Selection | ||
25 | UU_COUNT | CRMT_MKTTG_UU_COUNT | INT4 | 10 | 0 | CRM Marketing: No. of Unknown Users in a Segment | |||
26 | BW_SYNC | CRMT_MKTTG_BW_SYNC | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator for Target Group Synchronization with BW | ||
27 | OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CRM_MKTPF_OBJ_TYPE | CHAR | 2 | 0 | CRM Marketing: Object Type for a Marketing Profile | ||
28 | COUNT_RELATION | CRMT_MKTTG_COUNT_RELATIONSHIP | INT4 | 10 | 0 | CRM Marketing: Number of Relationships | |||
29 | ID | CRMT_MKTTG_TG_ID | CRMT_MKTTG_TG_ID | CHAR | 10 | 0 | Unique Identifiers for Target Groups and Product Segments | ||
30 | MODELING_TYPE | CRMT_MKTTG_MODELING_TYPE | CRM_MKTTG_MODELING_TYPE | CHAR | 1 | 0 | CRM Marketing: Modeling Type | ||
31 | .INCLUDE | 0 | 0 | new fields on profile/tg with TPM related fields | |||||
32 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
33 | TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | SYSUUID | RAW | 16 | 0 | Territory Path GUID | ||
34 | NODE_GUID | BU_NODE_GUID | SYSUUID | RAW | 16 | 0 | GUID of Hierarchy Node | ||
35 | VALID_FROM | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
36 | VALID_TO | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
37 | LAST_BUILD | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
38 | .INCLUDE | 0 | 0 | Additional Information on Target Groups | |||||
39 | TG_GUID | CRMT_TARGETGRP_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Target Group | ||
40 | RNUMB | CRMT_RNUMB | CRMT_RNUM | CHAR | 3 | 0 | CRM Marketing: Rule Number for Processing Target Groups | ||
41 | SSIZE | CRMT_MKTTG_TG_SSIZE | CRMT_MKTTG_TG_SSIZE | CHAR | 10 | 0 | Sample Size | ||
42 | ACTUAL_SIZE | CRMT_MKTTG_TG_ASIZE | CRMT_MKTTG_TG_SSIZE | CHAR | 10 | 0 | Actual Size of a Target Group | ||
43 | PARENT_GUID | CRMT_TARGETGRP_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Target Group | ||
44 | JOBNAME | BTCJOB | CHAR32 | CHAR | 32 | 0 | Background job name | ||
45 | JOBCOUNT | BTCJOBCNT | CHAR8 | CHAR | 8 | 0 | Job ID | ||
46 | SMP_OPT | CRMT_MKTTG_SMP_OPT | CRM_MKTTG_SMP_OPT | CHAR | 3 | 0 | CRM Marketing: Sample Optimization |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_MKTTG_SMP_H | CLIENT | T000 | MANDT | |||
2 | CRMT_MKTTG_SMP_H | TG_TYPE | CRMC_MKTTG_TYP_H | TYPE_ID |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |