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 project level specific attributes |
|
29 |
AUTH_GROUP |
|
CRM_MKTPL_AUTH_GROUP |
CRM_MKTPL_AUTH_GROUP |
CHAR |
4 |
0 |
Authorization Group |
|
30 |
CHM_RELEVANT |
|
CRMT_MKTPL_CHM_RELEVANT |
XFELD |
CHAR |
1 |
0 |
Open to Partners |
|
31 |
PLANGROUP |
|
CGPL_SEM_PLGRP |
|
CHAR |
4 |
0 |
Planning Profile Group |
|
32 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Dates and Time |
|
33 |
PLANSTART |
|
CGPL_PLANSTART |
BCOS_TSTMP |
DEC |
15 |
0 |
Planned start date |
|
34 |
PLANFINISH |
|
CGPL_PLANFINISH |
BCOS_TSTMP |
DEC |
15 |
0 |
Planned Finish Date |
|
35 |
ACTUALSTART |
|
CGPL_ACTUALSTART |
BCOS_TSTMP |
DEC |
15 |
0 |
Actual Start Date |
|
36 |
ACTUALFINISH |
|
CGPL_ACTUALFINISH |
BCOS_TSTMP |
DEC |
15 |
0 |
Actual Finish Date |
|
37 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for OrgData |
|
38 |
MKT_ORG |
|
CRM_MKTPL_MORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Marketing Organization |
|
39 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
40 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
41 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
42 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Channel Data |
|
43 |
CHANNEL |
|
CRM_MKTPL_CHANNEL |
CRM_MKTPL_CHANNEL |
CHAR |
4 |
0 |
ID of Communication Medium |
|
44 |
MAIL_FORM |
|
CRMT_MKTPL_MAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Sending a Letter |
* |
45 |
MAIL_FORM_GUID |
|
CRMT_PML_GUID |
SYSUUID |
RAW |
16 |
0 |
Personalized Mails: GUID for Mail Form |
|
46 |
SMARTFORM |
|
CRMT_MKTPL_EMAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for E-Mail |
* |
47 |
SMARTFORM_GUID |
|
CRMT_PML_GUID |
SYSUUID |
RAW |
16 |
0 |
Personalized Mails: GUID for Mail Form |
|
48 |
FAX_FORM |
|
CRMT_MKTPL_FAX_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Fax |
* |
49 |
FAX_FORM_GUID |
|
CRMT_PML_GUID |
SYSUUID |
RAW |
16 |
0 |
Personalized Mails: GUID for Mail Form |
|
50 |
SMS_FORM |
|
CRMT_MKTPL_SMS_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for SMS/Pager Services |
* |
51 |
SMS_FORM_GUID |
|
CRMT_PML_GUID |
SYSUUID |
RAW |
16 |
0 |
Personalized Mails: GUID for Mail Form |
|
52 |
FILE_EXPORT_FORM |
|
CRMT_IM_EXPORT_FORM |
TDSFNAME |
CHAR |
30 |
0 |
File Export Form |
* |
53 |
FILE_EXPORT_FORM_GUID |
|
CRMT_PML_GUID |
SYSUUID |
RAW |
16 |
0 |
Personalized Mails: GUID for Mail Form |
|
54 |
ADRESS_ID |
|
CRMT_IM_E_ID |
CHAR12 |
CHAR |
12 |
0 |
Identification for an E-mail Address |
|
55 |
SEND_PARTNER |
|
CRM_IM_SEND_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business partner for Sender Address Determination |
* |
56 |
SCRIPT |
|
CRMT_OBJECT_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID of a CRM Order Object |
|
57 |
SPICE_SCRIPT |
|
CRM_IC_SCRNAME |
CRM_IC_XMLNAME |
CHAR |
32 |
0 |
Name of Interaction Center (IC) WebClient Script |
|
58 |
PRINT_ID |
|
CRMT_IM_PRINT_ID |
CHAR12 |
CHAR |
12 |
0 |
Profile for Print Parameters |
|
59 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Campaign Automation |
|
60 |
RECURRING |
|
CRMT_MKTCA_CPG_RECURRING |
CRM_MKTCA_CPG_RECURRING |
CHAR |
1 |
0 |
Indicator Recurring Campaign for Camp. Automation |
|
61 |
CAMP_PERIOD |
|
CRMT_MKTCA_PERIOD |
CRM_MKTCA_PERIOD |
CHAR |
30 |
0 |
Period for Campaign |
|
62 |
CAMP_PERIOD_DUR |
|
CRMT_MKTCA_PERIOD_N |
INT4 |
INT4 |
10 |
0 |
Period Duration for Recurring Campaigns |
|
63 |
N_CAMP_PERIODS |
|
CRMT_MKTCA_NUMBER_PERIODS |
CRM_MKTCA_NUMBER_PERIODS |
INT4 |
10 |
0 |
No. of Processing Periods |
|
64 |
ET_CAMPAIGN |
|
CRMT_MKTCA_EVENT_TRIGGERED_CPG |
XFELD |
CHAR |
1 |
0 |
Indicator for Event Triggered Campaigns |
|
65 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Basic Data (external) |
|
66 |
CAMP_TYPETX |
|
CRM_MKTPL_CAMPTYPETX |
TEXT40 |
CHAR |
40 |
0 |
Description of Type |
|
67 |
OBJECTIVETX |
|
CRM_MKTPL_OBJECTIVETX |
TEXT40 |
CHAR |
40 |
0 |
Objective(s) Description |
|
68 |
TACTICSTX |
|
CRM_MKTPL_TACTICSTX |
TEXT40 |
CHAR |
40 |
0 |
Tactic Description |
|
69 |
CAMP_PRIOTX |
|
CRM_MKTPL_CAMPPRIOTX |
TEXT40 |
CHAR |
40 |
0 |
Description of Priority |
|
70 |
RESPONSIBLE_NAME |
|
CRM_MKTPL_RESPONSIBLE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible for Marketing Project |
* |
71 |
RESPONSIBLE_TEXT |
|
BU_DESCRIP |
BU_TEXT50 |
CHAR |
50 |
0 |
Short name of business partner |
|
72 |
TERR_DESCRIPTION |
|
CRMT_TERRITORY_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Territory Description |
|
73 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
74 |
CURRENCY_TEXT |
|
LTEXT |
TEXT40 |
CHAR |
40 |
0 |
Long Text |
|
75 |
FACTORY_CAL_TEXT |
|
FKTEXT |
TEXT60 |
CHAR |
60 |
0 |
Object Text |
|
76 |
ACTION_PROFILE_TEXT |
|
PPFDCNTXTT |
TEXT60 |
CHAR |
60 |
0 |
PPF: Description of Action Profile |
|
77 |
PSP_CREATION |
|
CRMT_MKTPL_IB_R3_INT |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transfer to ERP (boolean) |
|
78 |
EXCL_IND_DESC |
|
CRM_MKTPL_EXCL_IND_DESC |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Marketing Planner: Exclusive Indicator for Mult. Promotions |
|
79 |
ACTIVE |
|
CRMT_MKTPL_ACTIVE |
XFELD |
CHAR |
1 |
0 |
Active Marketing Project |
|
80 |
STSMA_TEXT |
|
TEXT30 |
TEXT30 |
CHAR |
30 |
0 |
Text (30 Characters) |
|
81 |
SURVEY_DESC_SHORT |
|
CRM_MKTPL_SURVEY_DESC_SHORT |
TEXT45 |
CHAR |
45 |
0 |
CRM Questionnaires: Short Description |
|
82 |
REF_TYPE_TEXT |
|
CRM_MKTPL_REF_TYPE_TEXT |
TEXT40 |
CHAR |
40 |
0 |
Usage Type Description |
|
83 |
HV_ACTIVE |
|
CRM_MKTPL_HV_ACTIVE |
CRM_MKTPL_HV_ACTIVE |
CHAR |
1 |
0 |
High-Volume Execution |
|
84 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Project Specific Attribute (external) |
|
85 |
PLANGROUP_TEXT |
|
CGPL_SEM_PLGRPT |
TEXT40 |
CHAR |
40 |
0 |
Description of Planning Profile Group |
|
86 |
AUTH_GROUP_TEXT |
|
CRM_MKTPL_AUTH_GROUPTX |
TEXT40 |
CHAR |
40 |
0 |
Description of Authorization Group |
|
87 |
.INCLUDE |
|
|
|
|
0 |
0 |
Include for Dates and Time (external) |
|
88 |
PLANSTARTDATE |
|
CRM_MKTPL_PLANSTARTDATE |
DATUM |
DATS |
8 |
0 |
Planned Start Date |
|
89 |
PLANSTARTTIME |
|
CRM_MKTPL_PLANSTARTTIME |
TIME |
TIMS |
6 |
0 |
Planned Start (Time) |
|
90 |
PLANFINISHDATE |
|
CRM_MKTPL_PLANFINISHDATE |
DATUM |
DATS |
8 |
0 |
Planned Finish Date |
|
91 |
PLANFINISHTIME |
|
CRM_MKTPL_PLANFINISHTIME |
TIME |
TIMS |
6 |
0 |
Planned Finish (Time) |
|
92 |
ACTUALSTARTDATE |
|
CRM_MKTPL_ACTUALSTARTDATE |
DATUM |
DATS |
8 |
0 |
Actual Start Date |
|
93 |
ACTUALSTARTTIME |
|
CRM_MKTPL_ACTUALSTARTTIME |
TIME |
TIMS |
6 |
0 |
Actual Start (Time) |
|
94 |
ACTUALFINISHDATE |
|
CRM_MKTPL_ACTUALFINISHDATE |
DATUM |
DATS |
8 |
0 |
Actual Finish (Date) |
|
95 |
ACTUALFINISHTIME |
|
CRM_MKTPL_ACTUALFINISHTIME |
TIME |
TIMS |
6 |
0 |
Actual Finish (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 |
Generic template attributes |
|
115 |
PLAN_VALID_FROM |
|
CRM_MKTGS_PLAN_VALID_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Plan Valid From |
|
116 |
PLAN_VALID_TO |
|
CRM_MKTGS_PLAN_VALID_TO |
BCOS_TSTMP |
DEC |
15 |
0 |
Plan Valid To |
|
117 |
USAGE_VALID_FROM |
|
CRM_MKTGS_USAGE_VALID_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Usage Valid From |
|
118 |
USAGE_VALID_TO |
|
CRM_MKTGS_USAGE_VALID_TO |
BCOS_TSTMP |
DEC |
15 |
0 |
Usage Valid To |
|
119 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
120 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
121 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
122 |
.INCLUDE |
|
|
|
|
0 |
0 |
External Attributes for Template Assignment |
|
123 |
PLAN_VALID_FROM_DATE |
|
CRM_MKTGS_PLAN_VALID_FROM_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid From Date |
|
124 |
PLAN_VALID_FROM_TIME |
|
CRM_MKTGS_PLAN_VALID_FROM_TIME |
TIME |
TIMS |
6 |
0 |
Plan Valid From Time |
|
125 |
PLAN_VALID_TO_DATE |
|
CRM_MKTGS_PLAN_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid To Date |
|
126 |
PLAN_VALID_TO_TIME |
|
CRM_MKTGS_PLAN_VALID_TO_TIME |
TIME |
TIMS |
6 |
0 |
Plan Valid To Time |
|
127 |
USAGE_VALID_FROM_DATE |
|
CRM_MKTGS_USAGE_VALID_FROM_DAT |
DATS |
DATS |
8 |
0 |
Usage Valid From Date |
|
128 |
USAGE_VALID_FROM_TIME |
|
CRM_MKTGS_USAGE_VALID_FROM_TIM |
TIME |
TIMS |
6 |
0 |
Usage Valid From Time |
|
129 |
USAGE_VALID_TO_DATE |
|
CRM_MKTGS_USAGE_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Usage Valid To Date |
|
130 |
USAGE_VALID_TO_TIME |
|
CRM_MKTGS_USAGE_VALID_TO_TIME |
TIME |
TIMS |
6 |
0 |
Usage Valid To Time |
|
131 |
TEXT1 |
|
CRM_MKTPL_IB_CPG_TEXT |
TEXT40 |
CHAR |
40 |
0 |
Campaign Description |
|
132 |
TIMEZONE_CREATED |
|
CRM_MKTPL_TIMEZONE_CREATED |
TZNZONE |
CHAR |
6 |
0 |
Time Zone of User Who Created the Marketing Project |
* |
133 |
OBJECT_TYPE |
|
CGPL_OBJECT_TYPE |
CHAR3 |
CHAR |
3 |
0 |
Object Type in Project Planning |
|
134 |
STATUS_TEXT |
|
CRM_MKTPL_IB_STATUS_TEXT |
TEXT40 |
CHAR |
40 |
0 |
Status of Scope Item (Concatenated) |
|
135 |
PARENT_EXT_ID |
|
CGPL_EXTID |
CGPL_EXTID |
CHAR |
24 |
0 |
Project Planning: External Indentifier of an Element |
|
136 |
USE_FIX_TZ_UTC |
|
CRM_MKTPL_USE_FIX_TIMEZONE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv. |
|
137 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extension Include - Campaign Query Result Structure |
|
138 |
MKTPL_RESULT_CPG |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|