SAP ABAP Table CRMD_MKTTG_SA (CRM Marketing: Selection Attribute)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
⤷ CRM_MKTTG_DS (Package) CRM Marketing: Data Source of TargetGroupSelection (Extend.)
⤷ CRM-MKT-SEG-TGR (Application Component) Target Groups
⤷ CRM_MKTTG_DS (Package) CRM Marketing: Data Source of TargetGroupSelection (Extend.)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CRMD_MKTTG_SA | Table Relationship Diagram |
Short Description | CRM Marketing: Selection Attribute |
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: Selection Attribute Key | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRMT_MKTTG_SA_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Selection Attribute | ||
4 | .INCLUDE | 0 | 0 | CRM Marketing: Selection Attribute Data Part | |||||
5 | SALDS_GUID | CRMT_MKTTG_SALDS_GUID | SYSUUID | RAW | 16 | 0 | CRM: GUID for a Selection Attribute/Data Source Assignment | ||
6 | SA_POSITION | CRMT_MKTTG_SA_POSITION | INT4 | 10 | 0 | CRM Marketing: Sorting of Selection Attribute | |||
7 | FIELDNAME | CRMT_MKTTG_SA_FIELDNAME | CHAR72 | CHAR | 72 | 0 | CRM Marketing: Technical Field Name of Selection Attribute | ||
8 | ACTIVE | CRMT_MKTTG_SA_ACTIVE | CRM_BOOLEAN | CHAR | 1 | 0 | CRM Marketing: Selection Attribute is Active | ||
9 | SA_TYPE | CRMT_MKTTG_SA_TYPE | CRM_MKTTG_SA_TYPE | CHAR | 3 | 0 | CRM Marketing: Type of Attribute | CRMC_MKTTG_SA_TP | |
10 | MULTIPLE_VA | CRMT_MKTTG_SA_VA | CRM_BOOLEAN | CHAR | 1 | 0 | CRM Marketing: Valuation of an Attribute | ||
11 | IQQNAME | IQQNAME | IQNAME | CHAR | 30 | 0 | InfoSet Query: Query Name | ||
12 | IQQNAME_SMP | IQQNAME | IQNAME | CHAR | 30 | 0 | InfoSet Query: Query Name | ||
13 | UPDATE_CYCLE | CRMT_MKTTG_UPDATE_CYCLE | NUMC3 | NUMC | 3 | 0 | CRM-MKT: Update Interval | ||
14 | OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CRM_MKTPF_OBJ_TYPE | CHAR | 2 | 0 | CRM Marketing: Object Type for a Marketing Profile | ||
15 | TREX_LAST_UPDT | CRMT_MKTTG_LAST_UPDATE | BCOS_TSTMP | DEC | 15 | 0 | CRM-MKTTG: Time of Last Update | ||
16 | TREX_RELEVANT | CRMT_MKTTG_SA_TREX_REL | CHAR | 1 | 0 | CRM Mkt: Flag to enable Fast Find for Sel Attribute via TREX | |||
17 | DTA_SRC_ID | CRM_MKTHV_SEG_DTA_SRC_ID | CRM_MKTHV_SEG_DTA_SRC_ID | CHAR | 10 | 0 | CRM_MKTHV_SEG_DTA: Delta Source Object ID | ||
18 | TREX_GUID | CRMT_MKTTG_TREX_GUID | SYSUUID | RAW | 16 | 0 | trex guid for attributes | ||
19 | FDS_ATTR_GUID | CRMT_MKTTG_SA_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Selection Attribute | ||
20 | AGGREGATION_TYPE | CRMT_MKTTG_SA_AGG_TYPE | CRM_MKTTG_SA_AGG_TYPE | NUMC | 2 | 0 | Define Aggregation Type | ||
21 | BWA_DEFAULT_HIER | CRMT_MKTTG_BWA_HIER | CRM_MKTTG_BWA_HIER | CHAR | 110 | 0 | External representation of BW Hierarchy (concatenated value) | ||
22 | BWA_DEF_HIE_GUID | CRMT_MKTTG_BWA_HIER_GUID | SYSUUID_25 | CHAR | 25 | 0 | Internal BW Hierarchy ID | ||
23 | TRANSPORT_ID | CRMT_MKTTG_TRANSPORT_ID | CRM_MKTTG_TRANSPORT_ID | CHAR | 20 | 0 | CRM Marketing: Transport Key for Data Sources | ||
24 | .INCLUDE | 0 | 0 | CRM Marketing: Time point and User Creation and Last Change | |||||
25 | ORIG_LG | CRMT_MKTTG_ORIG_LG | SYLANGU | LANG | 1 | 0 | CRM Marketing: Original Language of a Marketing Object | ||
26 | CREATED_AT | CRMT_MKT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Creation Date | ||
27 | CREATED_BY | CRMT_MKT_CREATED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Created By User | ||
28 | CHANGED_AT | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Marketing Object: Date of Last Change | ||
29 | CHANGED_BY | CRMT_MKT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Marketing Object: Last Changed By |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMD_MKTTG_SA | SA_TYPE | CRMC_MKTTG_SA_TP | SA_TYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 30A |