1 |
EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
2 |
TEXT1 |
|
CRM_MKTPL_IB_CPG_TEXT |
TEXT40 |
CHAR |
40 |
0 |
Campaign Description |
|
3 |
RESPONSIBLE_NO |
|
CRM_MKTPL_RESPONSIBLE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible for Marketing Project |
* |
4 |
RESP_NAME_FIRST |
|
CRM_MKTPL_IB_RESP_NAME_FIRST |
BU_NAME |
CHAR |
40 |
0 |
Person Responsible: First Name |
|
5 |
RESP_NAME_LAST |
|
CRM_MKTPL_IB_RESP_NAME_LAST |
BU_NAME |
CHAR |
40 |
0 |
Person Responsible: Last Name |
|
6 |
PRIORITY |
|
CRM_MKTPL_IB_PRIORITY |
NUMC3 |
NUMC |
3 |
0 |
Priority String Element (iBom MKTPL) |
|
7 |
STATUS_KEY |
|
CRM_MKTPL_IB_STATUS_KEY |
CRM_MKTPL_IB_STATUS_KEY |
CHAR |
23 |
0 |
Key for Status Node (iBom MKTPL) |
|
8 |
STSMA |
|
J_STSMA |
J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
9 |
SYSTEM_STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
10 |
USER_STATUS |
|
CRM_MKTPL_IB_USER_STATUS_STSMA |
CRM_MKTPL_IB_USER_STATUS_STSMA |
CHAR |
13 |
0 |
Concatenated User Status and Status Profile |
|
11 |
CAMP_TYPE |
|
CRM_MKTPL_CAMPTYPE |
CRM_MKTPL_CAMPTYPE |
CHAR |
4 |
0 |
Type |
* |
12 |
SHORTCUT |
|
CRMT_MKTPL_CAMPAIGN_SHORTCUT |
CHAR4 |
CHAR |
4 |
0 |
Campaign Code |
|
13 |
OBJECTIVE |
|
CRM_MKTPL_OBJECTIVE |
CRM_MKTPL_OBJECTIVE |
CHAR |
4 |
0 |
Objective |
|
14 |
TACTICS |
|
CRM_MKTPL_TACTICS |
CRM_MKTPL_TACTICS |
CHAR |
4 |
0 |
Tactic |
|
15 |
CPRO_NUMBER |
|
CRM_MKTPL_IB_CPG_CPRO |
CGPL_EXTID |
CHAR |
24 |
0 |
cProjects External ID |
|
16 |
CHANNEL |
|
CRM_MKTPL_CHANNEL |
CRM_MKTPL_CHANNEL |
CHAR |
4 |
0 |
ID of Communication Medium |
|
17 |
SMARTFORM |
|
CRMT_MKTPL_EMAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for E-Mail |
* |
18 |
SMS_FORM |
|
CRMT_MKTPL_SMS_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for SMS/Pager Services |
* |
19 |
FAX_FORM |
|
CRMT_MKTPL_FAX_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Fax |
* |
20 |
MAIL_FORM |
|
CRMT_MKTPL_MAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Sending a Letter |
* |
21 |
FILE_EXPORT_FORM |
|
CRMT_IM_EXPORT_FORM |
TDSFNAME |
CHAR |
30 |
0 |
File Export Form |
* |
22 |
MKT_ORG |
|
CRM_MKTPL_MORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Marketing Organization |
|
23 |
TERR_PATH_ID |
|
CRMT_TERRITORY_PATH_ID |
CRM_TERRITORY_PATH_ID |
CHAR |
30 |
0 |
Territory Hierarchy ID |
|
24 |
PRODUCT_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
25 |
TARGETGRP_DESCR |
|
CRM_MKTPL_IB_CPG_TGRP |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Target Group Description |
|
26 |
PRSEG_DESCR |
|
CRM_MKTPL_IB_CPG_PRSEG |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Product Segment Description |
|
27 |
PLANGROUP |
|
CGPL_SEM_PLGRP |
|
CHAR |
4 |
0 |
Planning Profile Group |
|
28 |
PLANSTARTDATE |
|
CRM_MKTPL_PLANSTARTDATE |
DATUM |
DATS |
8 |
0 |
Planned Start Date |
|
29 |
PLANFINISHDATE |
|
CRM_MKTPL_PLANFINISHDATE |
DATUM |
DATS |
8 |
0 |
Planned Finish Date |
|
30 |
PARENT_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
31 |
CREATED_BY |
|
CGPL_CREATED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Created Object |
|
32 |
CREATED_ON |
|
CGPL_CREATED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which the Object was Created |
|
33 |
CHANGED_BY |
|
CGPL_CHANGED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Changed Object |
|
34 |
CHANGED_ON |
|
CGPL_CHANGED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which Object Was Last Changed |
|
35 |
R3_INT |
|
CRMT_MKTPL_R3_INT |
CHAR1 |
CHAR |
1 |
0 |
Marketing Planning: Object Replicated in ERP |
|
36 |
EXCL_IND |
|
CRM_MKTPL_EXCL_IND |
CRM_MKTPL_EXCL_IND |
CHAR |
1 |
0 |
Indicator: Marketing Project Is Exclusive |
|
37 |
INACTIVE |
|
CHAR10 |
CHAR10 |
CHAR |
10 |
0 |
Character Field Length = 10 |
|
38 |
ACTION_PROFILE |
|
CRM_MKTPL_ACTION_PROFILE |
PPFDCNTXT |
CHAR |
30 |
0 |
ID of Action Profile |
* |
39 |
CURRENCY |
|
CRM_MKTPL_CUKY |
WAERS |
CUKY |
5 |
0 |
MKTPL: Currency Object |
* |
40 |
CALENDAR_ID |
|
WFCID |
WFCID |
CHAR |
2 |
0 |
Factory Calendar |
* |
41 |
ET_CAMPAIGN |
|
CRMT_MKTCA_EVENT_TRIGGERED_CPG |
XFELD |
CHAR |
1 |
0 |
Indicator for Event Triggered Campaigns |
|
42 |
CHM_RELEVANT |
|
CRMT_MKTPL_CHM_RELEVANT |
XFELD |
CHAR |
1 |
0 |
Open to Partners |
|
43 |
COMPLETION |
|
CGPL_COMPLETION |
CGPL_COMPLETION |
NUMC |
3 |
0 |
Percentage of Completion |
|
44 |
CONTACT_BP |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
45 |
CONTACT_DATE |
|
CRM_MKTPL_CONTACT_DATE_FROM |
DATUM |
DATS |
8 |
0 |
Businss Contact: From Date |
|
46 |
MANUFACTCODE |
|
CRM_MKTPL_MANUCODE |
CRM_MKTPL_MANUCODE |
CHAR |
12 |
0 |
Manufacturer Code for Coupon |
|
47 |
FAMCODE |
|
CRM_MKTPL_FAMCODE |
CRM_MKTPL_FAMCODE |
CHAR |
4 |
0 |
Family Code for Coupon |
|
48 |
OFR_BRAND_ID |
|
CRM_MKTPL_OFR_BRAND |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Coupon Product Category |
|
49 |
OFRCODE |
|
CRM_MKTPL_OFRCODE |
CRM_MKTPL_OFRCODE |
CHAR |
16 |
0 |
Coupon Code |
|
50 |
VALCODE |
|
CRM_MKTPL_VALCODE |
CRM_MKTPL_VALCODE |
CHAR |
3 |
0 |
Value Code for Coupon |
|
51 |
BARCODE_TYPE |
|
CRM_MKTPL_BARCODE_TYPE |
CRM_MKTPL_BARCODE_TYPE |
CHAR |
20 |
0 |
Barcode Type for Coupon |
|
52 |
EXP_DATE |
|
CRM_MKTPL_EXP_DATE |
CRM_MKTPL_EXP_DATE |
DATS |
8 |
0 |
Expiration Date for Coupon |
|
53 |
CLEARING_HOUSE_NR |
|
CRM_MKTPL_CLEARING_HOUSE_NR |
BU_PARTNER |
CHAR |
10 |
0 |
Clearing House |
* |
54 |
ACTUALSTARTDATE |
|
CRM_MKTPL_ACTUALSTARTDATE |
DATUM |
DATS |
8 |
0 |
Actual Start Date |
|
55 |
ACTUALFINISHDATE |
|
CRM_MKTPL_ACTUALFINISHDATE |
DATUM |
DATS |
8 |
0 |
Actual Finish (Date) |
|
56 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Date Ranges for MKTPL Search |
|
57 |
ADD_DT_RANGE_01_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
58 |
ADD_DT_RANGE_01_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
59 |
ADD_DT_RANGE_02_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
60 |
ADD_DT_RANGE_02_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
61 |
ADD_DT_RANGE_03_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
62 |
ADD_DT_RANGE_03_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
63 |
ADD_DT_RANGE_04_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
64 |
ADD_DT_RANGE_04_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
65 |
ADD_DT_RANGE_05_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
66 |
ADD_DT_RANGE_05_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
67 |
ADD_DT_RANGE_06_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
68 |
ADD_DT_RANGE_06_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
69 |
ADD_DT_RANGE_07_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
70 |
ADD_DT_RANGE_07_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
71 |
ADD_DT_RANGE_08_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
72 |
ADD_DT_RANGE_08_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
73 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
74 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
75 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
76 |
AUTH_GROUP |
|
CRM_MKTPL_AUTH_GROUP |
CRM_MKTPL_AUTH_GROUP |
CHAR |
4 |
0 |
Authorization Group |
|
77 |
EXTERNAL_ID_TASK |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
78 |
MY_ORGS |
|
CRM_MKTPL_IB_BELONGING_TO |
TEXT50 |
CHAR |
50 |
0 |
Belonging To |
|
79 |
ADI_FLAG |
|
CRM_MKTPL_ADI |
CRM_MKTPL_ADI |
CHAR |
1 |
0 |
Abnormal Demand Indicator |
|
80 |
REF_TYPE |
|
CRM_MKTPL_REF_TYPE |
CRM_MKTPL_REF_TYPE_DOM |
CHAR |
4 |
0 |
Usage Type |
|
81 |
ENROLLMENT_REQ |
|
CRM_MKTPL_ENR_ENROLLMENT_REQ |
XFELD |
CHAR |
1 |
0 |
Indicator, that enrollment is required |
|
82 |
ENROLLMENT_STARTDATE |
|
CRM_MKTPL_ENR_STARTDATE |
DATUM |
DATS |
8 |
0 |
Enrollment Start Date |
|
83 |
ENROLLMENT_ENDDATE |
|
CRM_MKTPL_ENR_ENDDATE |
DATUM |
DATS |
8 |
0 |
Enrollment End Date |
|
84 |
COPY_SOURCE_ID |
|
CGPL_EXTID |
CGPL_EXTID |
CHAR |
24 |
0 |
Project Planning: External Indentifier of an Element |
|
85 |
PARTNER_COMB |
|
CRMT_UIU_PARTNER_TO_PARTNERFCT |
CHAR40 |
CHAR |
40 |
0 |
Partner In Partner Function |
|
86 |
INCLUDE_TASKS |
|
CRM_MKTPL_IB_INCLUDE_TASKS |
CRM_MKTPL_IB_INCLUDE_TASKS |
CHAR |
4 |
0 |
Include Elements (Tasks) Flag |
|
87 |
TEMPLATE |
|
CRM_MKTPL_TEMPLATE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Template Indicator |
|
88 |
USAGE_VALID_FROM |
|
CRM_MKTGS_USAGE_VALID_FROM_DAT |
DATS |
DATS |
8 |
0 |
Usage Valid From Date |
|
89 |
USAGE_VALID_TO |
|
CRM_MKTGS_USAGE_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Usage Valid To Date |
|
90 |
PLAN_VALID_FROM |
|
CRM_MKTGS_PLAN_VALID_FROM_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid From Date |
|
91 |
PLAN_VALID_TO |
|
CRM_MKTGS_PLAN_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid To Date |
|
92 |
ASSIGNED_TEMPLATE_ID |
|
CRM_MKTPL_ASSIGNED_TEMPLATE_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
Assigned Template External ID |
|
93 |
COLLABORATIVE_CAMPAIGN_ID |
|
CRM_MKTPL_COLLAB_CAMPAIGN_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
Collaborative Campaign External ID |
|
94 |
FUNDSPLAN_ID |
|
CRM_FM_FND_FUNDPLAN_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Funds Plan ID |
|
95 |
AVAILABILITY |
|
CRM_MKTGS_IB_AVAILABILITY |
CRM_MKTGS_IB_AVAILABILITY |
CHAR |
1 |
0 |
Search criterion for Availability of Marketing Project |
|
96 |
IC_RELEVANT |
|
CRM_MKTPL_IC_RELEVANT |
BOOLE |
CHAR |
1 |
0 |
Interaction Center |
|
97 |
WEBSHOP_RELEVANT |
|
CRM_MKTPL_EXTERNAL_RELEVANT |
BOOLE |
CHAR |
1 |
0 |
External |
|
98 |
BUSINESS_GOAL_ID |
|
CRM_MKTPL_BGOAL_ID |
|
CHAR |
4 |
0 |
Business Goal ID |
|
99 |
OFFER_TYPE |
|
CRM_MKTPL_OFFER_TYPE |
CRM_MKTPL_OFFER_TYPE |
CHAR |
1 |
0 |
Offer Type |
|
100 |
EXECUTED |
|
FLAG |
FLAG |
CHAR |
1 |
0 |
General Flag |
|
101 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
102 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
103 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
104 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extension Include - Campaign Query Structure |
|
105 |
MKTPL_QUERY_CPG |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
106 |
PURCH_CRM_STATUS |
|
CRM_MKTPL_PURCH_CRM_STATUS |
CRM_MKTPL_PURCH_CRM_STATUS |
CHAR |
1 |
0 |
Item Status With Respect to PR Transfer |
|