SAP ABAP Table CRMS_MKTPL_IB_QUERY_RESULT_CPT (Query Result Attributes of Node Campaign Element)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_CPG (Package) CRM Marketing: iBom for Campaign
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_CPG (Package) CRM Marketing: iBom for Campaign
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPL_IB_QUERY_RESULT_CPT | Table Relationship Diagram |
Short Description | Query Result Attributes of Node Campaign Element |
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 | Include for Basic Data | |||||
2 | GUID | CRM_MKTPL_IB_CPG_GUID | RAW | 16 | 0 | Campaign | |||
3 | EXTERNAL_ID | CRM_MKTPL_CAMPAIGNID | CGPL_EXTID | CHAR | 24 | 0 | Campaign | ||
4 | CAMP_TYPE | CRM_MKTPL_CAMPTYPE | CRM_MKTPL_CAMPTYPE | CHAR | 4 | 0 | Type | * | |
5 | OBJECTIVE | CRM_MKTPL_OBJECTIVE | CRM_MKTPL_OBJECTIVE | CHAR | 4 | 0 | Objective | ||
6 | TACTICS | CRM_MKTPL_TACTICS | CRM_MKTPL_TACTICS | CHAR | 4 | 0 | Tactic | ||
7 | PRIORITY | CRM_MKTPL_IB_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority String Element (iBom MKTPL) | ||
8 | SHORTCUT | CRMT_MKTPL_CAMPAIGN_SHORTCUT | CHAR4 | CHAR | 4 | 0 | Campaign Code | ||
9 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
10 | TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | SYSUUID | RAW | 16 | 0 | Territory Path GUID | ||
11 | TERR_PATH_ID | CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
12 | ACTION_PROFILE | CRM_MKTPL_ACTION_PROFILE | PPFDCNTXT | CHAR | 30 | 0 | ID of Action Profile | * | |
13 | CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | * | |
14 | CALENDAR_ID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
15 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
16 | STSMA | J_STSMA | J_STSMA | CHAR | 8 | 0 | Status Profile | * | |
17 | SURVEYID | CRM_SVY_DB_SID | CHAR32 | CHAR | 32 | 0 | CRM Surveys: Survey ID | ||
18 | SURVEYVERSION | CRM_SVY_DB_SVERS | NUMC10 | NUMC | 10 | 0 | CRM Surveys: Survey Version | ||
19 | PARENT_GUID | CRM_MKTPL_IB_MKTPROJECT_GUID | RAW | 16 | 0 | Marketing Project | |||
20 | BWIDENTIFIER | CGPL_BWIDENTIFIER | CGPL_BWIDENTIFIER | NUMC | 8 | 0 | Project Planning - BW Identification | ||
21 | NO_R3_INT | CRM_MKTPL_NO_R3_INT | CHAR1 | CHAR | 1 | 0 | Marketing Planning: Object Not Integrated into ERP PS | ||
22 | EXCL_IND | CRM_MKTPL_IB_EXCL_IND | CRM_BOOLEAN | CHAR | 1 | 0 | Exclusive (boolean) | ||
23 | INACTIVE | CRMT_MKTPL_INACTIVE | CHAR1 | CHAR | 1 | 0 | Inactive Marketing Project | ||
24 | ADI_FLAG | CRM_MKTPL_ADI | CRM_MKTPL_ADI | CHAR | 1 | 0 | Abnormal Demand Indicator | ||
25 | ENROLLMENT_REQ | CRM_MKTPL_ENR_ENROLLMENT_REQ | XFELD | CHAR | 1 | 0 | Indicator, that enrollment is required | ||
26 | REF_TYPE | CRM_MKTPL_REF_TYPE | CRM_MKTPL_REF_TYPE_DOM | CHAR | 4 | 0 | Usage Type | ||
27 | TEMPLATE | CRM_MKTPL_TEMPLATE | CRM_BOOLEAN | CHAR | 1 | 0 | Template Indicator | ||
28 | .INCLUDE | 0 | 0 | Include for Dates and Time | |||||
29 | PLANSTART | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
30 | PLANFINISH | CGPL_PLANFINISH | BCOS_TSTMP | DEC | 15 | 0 | Planned Finish Date | ||
31 | ACTUALSTART | CGPL_ACTUALSTART | BCOS_TSTMP | DEC | 15 | 0 | Actual Start Date | ||
32 | ACTUALFINISH | CGPL_ACTUALFINISH | BCOS_TSTMP | DEC | 15 | 0 | Actual Finish Date | ||
33 | .INCLUDE | 0 | 0 | Include for Constraints | |||||
34 | CONSTRAINT_TYPE | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
35 | CONSTRAINT_TIME | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
36 | .INCLUDE | 0 | 0 | Include for OrgData | |||||
37 | MKT_ORG | CRM_MKTPL_MORG | HROBJEC_14 | CHAR | 14 | 0 | Marketing Organization | ||
38 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
39 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
40 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
41 | .INCLUDE | 0 | 0 | Include for Channel Data | |||||
42 | CHANNEL | CRM_MKTPL_CHANNEL | CRM_MKTPL_CHANNEL | CHAR | 4 | 0 | ID of Communication Medium | ||
43 | MAIL_FORM | CRMT_MKTPL_MAIL_FORM | TDSFNAME | CHAR | 30 | 0 | Form for Sending a Letter | * | |
44 | MAIL_FORM_GUID | CRMT_PML_GUID | SYSUUID | RAW | 16 | 0 | Personalized Mails: GUID for Mail Form | ||
45 | SMARTFORM | CRMT_MKTPL_EMAIL_FORM | TDSFNAME | CHAR | 30 | 0 | Form for E-Mail | * | |
46 | SMARTFORM_GUID | CRMT_PML_GUID | SYSUUID | RAW | 16 | 0 | Personalized Mails: GUID for Mail Form | ||
47 | FAX_FORM | CRMT_MKTPL_FAX_FORM | TDSFNAME | CHAR | 30 | 0 | Form for Fax | * | |
48 | FAX_FORM_GUID | CRMT_PML_GUID | SYSUUID | RAW | 16 | 0 | Personalized Mails: GUID for Mail Form | ||
49 | SMS_FORM | CRMT_MKTPL_SMS_FORM | TDSFNAME | CHAR | 30 | 0 | Form for SMS/Pager Services | * | |
50 | SMS_FORM_GUID | CRMT_PML_GUID | SYSUUID | RAW | 16 | 0 | Personalized Mails: GUID for Mail Form | ||
51 | FILE_EXPORT_FORM | CRMT_IM_EXPORT_FORM | TDSFNAME | CHAR | 30 | 0 | File Export Form | * | |
52 | FILE_EXPORT_FORM_GUID | CRMT_PML_GUID | SYSUUID | RAW | 16 | 0 | Personalized Mails: GUID for Mail Form | ||
53 | ADRESS_ID | CRMT_IM_E_ID | CHAR12 | CHAR | 12 | 0 | Identification for an E-mail Address | ||
54 | SEND_PARTNER | CRM_IM_SEND_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business partner for Sender Address Determination | * | |
55 | SCRIPT | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
56 | SPICE_SCRIPT | CRM_IC_SCRNAME | CRM_IC_XMLNAME | CHAR | 32 | 0 | Name of Interaction Center (IC) WebClient Script | ||
57 | PRINT_ID | CRMT_IM_PRINT_ID | CHAR12 | CHAR | 12 | 0 | Profile for Print Parameters | ||
58 | .INCLUDE | 0 | 0 | Include for Campaign Automation on Element Level | |||||
59 | CPT_TYPE | CRMT_MKTCA_CPT_TYPE | CRM_MKTCA_CPT_TYPE | CHAR | 2 | 0 | Type of Campaign Element Used | ||
60 | RESPONSE_FLAG | CRMT_MKTCA_RESPONSE_FLAG | XFELD | CHAR | 1 | 0 | Start for Every Respondent? | ||
61 | DELAY | CRMT_MKTCA_DELAY | CRM_MKTCA_DELAY | INT1 | 3 | 0 | Delay (Relative Scheduling) | ||
62 | DELAY_UNIT | CRMT_MKTCA_DELAY_UNIT | CRM_MKTCA_DELAY_UNIT | CHAR | 2 | 0 | Unit for Delay (Relative Scheduling) | ||
63 | MKTCA_WFTASK | CRMT_MKTCA_WFTASK | CRM_MKTCA_WFTASK | CHAR | 4 | 0 | Assignment Term Workflow for Task ID | ||
64 | .INCLUDE | 0 | 0 | Include for Basic Data (external) | |||||
65 | CAMP_TYPETX | CRM_MKTPL_CAMPTYPETX | TEXT40 | CHAR | 40 | 0 | Description of Type | ||
66 | OBJECTIVETX | CRM_MKTPL_OBJECTIVETX | TEXT40 | CHAR | 40 | 0 | Objective(s) Description | ||
67 | TACTICSTX | CRM_MKTPL_TACTICSTX | TEXT40 | CHAR | 40 | 0 | Tactic Description | ||
68 | CAMP_PRIOTX | CRM_MKTPL_CAMPPRIOTX | TEXT40 | CHAR | 40 | 0 | Description of Priority | ||
69 | RESPONSIBLE_NAME | CRM_MKTPL_RESPONSIBLE | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible for Marketing Project | * | |
70 | RESPONSIBLE_TEXT | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
71 | TERR_DESCRIPTION | CRMT_TERRITORY_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Territory Description | ||
72 | TERR_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
73 | CURRENCY_TEXT | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
74 | FACTORY_CAL_TEXT | FKTEXT | TEXT60 | CHAR | 60 | 0 | Object Text | ||
75 | ACTION_PROFILE_TEXT | PPFDCNTXTT | TEXT60 | CHAR | 60 | 0 | PPF: Description of Action Profile | ||
76 | PSP_CREATION | CRMT_MKTPL_IB_R3_INT | CRM_BOOLEAN | CHAR | 1 | 0 | Transfer to ERP (boolean) | ||
77 | EXCL_IND_DESC | CRM_MKTPL_EXCL_IND_DESC | CRM_BOOLEAN | CHAR | 1 | 0 | Marketing Planner: Exclusive Indicator for Mult. Promotions | ||
78 | ACTIVE | CRMT_MKTPL_ACTIVE | XFELD | CHAR | 1 | 0 | Active Marketing Project | ||
79 | STSMA_TEXT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
80 | SURVEY_DESC_SHORT | CRM_MKTPL_SURVEY_DESC_SHORT | TEXT45 | CHAR | 45 | 0 | CRM Questionnaires: Short Description | ||
81 | REF_TYPE_TEXT | CRM_MKTPL_REF_TYPE_TEXT | TEXT40 | CHAR | 40 | 0 | Usage Type Description | ||
82 | HV_ACTIVE | CRM_MKTPL_HV_ACTIVE | CRM_MKTPL_HV_ACTIVE | CHAR | 1 | 0 | High-Volume Execution | ||
83 | .INCLUDE | 0 | 0 | Include for Dates and Time (external) | |||||
84 | PLANSTARTDATE | CRM_MKTPL_PLANSTARTDATE | DATUM | DATS | 8 | 0 | Planned Start Date | ||
85 | PLANSTARTTIME | CRM_MKTPL_PLANSTARTTIME | TIME | TIMS | 6 | 0 | Planned Start (Time) | ||
86 | PLANFINISHDATE | CRM_MKTPL_PLANFINISHDATE | DATUM | DATS | 8 | 0 | Planned Finish Date | ||
87 | PLANFINISHTIME | CRM_MKTPL_PLANFINISHTIME | TIME | TIMS | 6 | 0 | Planned Finish (Time) | ||
88 | ACTUALSTARTDATE | CRM_MKTPL_ACTUALSTARTDATE | DATUM | DATS | 8 | 0 | Actual Start Date | ||
89 | ACTUALSTARTTIME | CRM_MKTPL_ACTUALSTARTTIME | TIME | TIMS | 6 | 0 | Actual Start (Time) | ||
90 | ACTUALFINISHDATE | CRM_MKTPL_ACTUALFINISHDATE | DATUM | DATS | 8 | 0 | Actual Finish (Date) | ||
91 | ACTUALFINISHTIME | CRM_MKTPL_ACTUALFINISHTIME | TIME | TIMS | 6 | 0 | Actual Finish (time) | ||
92 | .INCLUDE | 0 | 0 | Include for Constraints (external) | |||||
93 | CONSTRAINT_TYPETX | CGPL_CONSTRAINTTX | TEXT40 | CHAR | 40 | 0 | Description of Type of Scheduling Constraint | ||
94 | CONSTRAINTDATE | CRM_MKTPL_CONSTRAINTDATE | DATUM | DATS | 8 | 0 | Constraint Date (Date) | ||
95 | CONSTRAINTTIME | CRM_MKTPL_CONSTRAINTTIME | TIME | TIMS | 6 | 0 | Constraint Date (Time) | ||
96 | .INCLUDE | 0 | 0 | Include for OrgData (external) | |||||
97 | MKT_ORG_DESC | CRM_MKTPL_MORG_DESC | CRM_MKTPL_MORG_DESC | CHAR | 40 | 0 | Marketing Organization Description | ||
98 | SALES_ORG_DESC | CRMT_SALES_ORG_DESC | CRMT_SALES_ORG_DESC | CHAR | 40 | 0 | Sales Organization Description | ||
99 | CHANNEL_DESC | CRMT_CHANNEL_DESC | CRMT_CHANNEL_DESC | CHAR | 40 | 0 | Distribution Channel Description | ||
100 | DIVISION_DESC | CRMT_DIVISION_DESC | CRMT_DIVISION_DESC | CHAR | 40 | 0 | Division Description | ||
101 | .INCLUDE | 0 | 0 | Include for Channel Data (external) | |||||
102 | CHANNELTX | CRM_MKTPL_CHANNELTX | TEXT40 | CHAR | 40 | 0 | Description of Communication Medium | ||
103 | ADRESS_NAME | CRMT_IM_E_ADDRESS | SO_STRI241 | CHAR | 241 | 0 | Marketing: E-mail Address | ||
104 | ADRESS_TEXT | CRMT_IM_E_TEXT | CHAR40 | CHAR | 40 | 0 | Text for E-Mail Address | ||
105 | SEND_PARTNER_TEXT | BU_DESCRIP_LONG | CHAR80 | CHAR | 80 | 0 | Description of a Business Partner | ||
106 | SCRIPT_TREEID | CRMT_TREEID | CRM_TREEID | NUMC | 8 | 0 | Name of Interaction Center (IC) WinClient Script | ||
107 | .INCLUDE | 0 | 0 | Include for Change History | |||||
108 | CREATED_BY | CGPL_CREATED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Created Object | ||
109 | CREATED_BY_DESC | CRM_MKTPL_IB_CREATED_BY_DESC | CHAR65 | CHAR | 65 | 0 | Description of Person Who Created Object | ||
110 | CREATED_ON | CGPL_CREATED_ON | DATUM | DATS | 8 | 0 | Date on Which the Object was Created | ||
111 | CHANGED_BY | CGPL_CHANGED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
112 | CHANGED_BY_DESC | CRM_MKTPL_IB_CHANGED_BY_DESC | CHAR65 | CHAR | 65 | 0 | Description of Person Who Changed Object | ||
113 | CHANGED_ON | CGPL_CHANGED_ON | DATUM | DATS | 8 | 0 | Date on Which Object Was Last Changed | ||
114 | .INCLUDE | 0 | 0 | ||||||
115 | .INCLUDE | 0 | 0 | ||||||
116 | .INCLUDE | 0 | 0 | ||||||
117 | TASK_LEVEL | CRM_MKTPL_LEVEL | CRM_MKTPL_INDEX | INT1 | 3 | 0 | Hierarchy Level | ||
118 | TEXT1 | CRM_MKTPL_IB_CPG_TEXT | TEXT40 | CHAR | 40 | 0 | Campaign Description | ||
119 | TIMEZONE_CREATED | CRM_MKTPL_TIMEZONE_CREATED | TZNZONE | CHAR | 6 | 0 | Time Zone of User Who Created the Marketing Project | * | |
120 | OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR3 | CHAR | 3 | 0 | Object Type in Project Planning | ||
121 | STATUS_TEXT | CRM_MKTPL_IB_STATUS_TEXT | TEXT40 | CHAR | 40 | 0 | Status of Scope Item (Concatenated) |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 510 |