1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Query Attributes of Node Campaign (IBOM MKTPL) |
|
2 |
EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
3 |
TEXT1 |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|
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 |
RESPONSIBLE_NO |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
8 |
PLANSTARTDATE |
|
CRM_MKTPL_PLANSTARTDATE |
DATUM |
DATS |
8 |
0 |
Planned Start Date |
|
9 |
PLANFINISHDATE |
|
CRM_MKTPL_PLANFINISHDATE |
DATUM |
DATS |
8 |
0 |
Planned Finish Date |
|
10 |
TARGETGRP_DESCR |
|
CRMT_TARGETGRP_DESCR |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
CRM Marketing: Description for Target Group |
|
11 |
PRSEG_DESCR |
|
CRMT_TARGETGRP_DESCR |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
CRM Marketing: Description for Target Group |
|
12 |
CHANNEL |
|
CRM_MKTPL_CHANNEL |
CRM_MKTPL_CHANNEL |
CHAR |
4 |
0 |
ID of Communication Medium |
|
13 |
STATUS_KEY |
|
CRM_MKTPL_IB_STATUS_KEY |
CRM_MKTPL_IB_STATUS_KEY |
CHAR |
23 |
0 |
Key for Status Node (iBom MKTPL) |
|
14 |
SMARTFORM |
|
CRMT_MKTPL_EMAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for E-Mail |
* |
15 |
FILE_EXPORT_FORM |
|
CRMT_IM_EXPORT_FORM |
TDSFNAME |
CHAR |
30 |
0 |
File Export Form |
* |
16 |
SHORTCUT |
|
CRMT_MKTPL_CAMPAIGN_SHORTCUT |
CHAR4 |
CHAR |
4 |
0 |
Campaign Code |
|
17 |
MAIL_FORM |
|
CRMT_MKTPL_MAIL_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Sending a Letter |
* |
18 |
MKT_ORG |
|
CRM_MKTPL_MORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Marketing Organization |
|
19 |
FAX_FORM |
|
CRMT_MKTPL_FAX_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for Fax |
* |
20 |
SMS_FORM |
|
CRMT_MKTPL_SMS_FORM |
TDSFNAME |
CHAR |
30 |
0 |
Form for SMS/Pager Services |
* |
21 |
AUTH_GROUP |
|
CRM_MKTPL_AUTH_GROUP |
CRM_MKTPL_AUTH_GROUP |
CHAR |
4 |
0 |
Authorization Group |
|
22 |
ACTION_PROFILE |
|
CRM_MKTPL_ACTION_PROFILE |
PPFDCNTXT |
CHAR |
30 |
0 |
ID of Action Profile |
* |
23 |
CURRENCY |
|
CRM_MKTPL_CUKY |
WAERS |
CUKY |
5 |
0 |
MKTPL: Currency Object |
* |
24 |
ET_CAMPAIGN |
|
CRMT_MKTCA_EVENT_TRIGGERED_CPG |
XFELD |
CHAR |
1 |
0 |
Indicator for Event Triggered Campaigns |
|
25 |
CHM_RELEVANT |
|
CRMT_MKTPL_CHM_RELEVANT |
XFELD |
CHAR |
1 |
0 |
Open to Partners |
|
26 |
CREATED_BY |
|
CGPL_CREATED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Created Object |
|
27 |
CREATED_ON |
|
CGPL_CREATED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which the Object was Created |
|
28 |
CHANGED_BY |
|
CGPL_CHANGED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Changed Object |
|
29 |
CHANGED_ON |
|
CGPL_CHANGED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which Object Was Last Changed |
|
30 |
PRIORITY |
|
CRM_MKTPL_IB_PRIORITY |
NUMC3 |
NUMC |
3 |
0 |
Priority String Element (iBom MKTPL) |
|
31 |
ACTUALSTARTDATE |
|
CRM_MKTPL_ACTUALSTARTDATE |
DATUM |
DATS |
8 |
0 |
Actual Start Date |
|
32 |
ACTUALFINISHDATE |
|
CRM_MKTPL_ACTUALFINISHDATE |
DATUM |
DATS |
8 |
0 |
Actual Finish (Date) |
|
33 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Date Ranges for MKTPL Search |
|
34 |
ADD_DT_RANGE_01_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
35 |
ADD_DT_RANGE_01_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
36 |
ADD_DT_RANGE_02_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
37 |
ADD_DT_RANGE_02_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
38 |
ADD_DT_RANGE_03_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
39 |
ADD_DT_RANGE_03_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
40 |
ADD_DT_RANGE_04_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
41 |
ADD_DT_RANGE_04_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
42 |
ADD_DT_RANGE_05_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
43 |
ADD_DT_RANGE_05_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
44 |
ADD_DT_RANGE_06_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
45 |
ADD_DT_RANGE_06_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
46 |
ADD_DT_RANGE_07_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
47 |
ADD_DT_RANGE_07_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
48 |
ADD_DT_RANGE_08_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
49 |
ADD_DT_RANGE_08_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
50 |
PLANGROUP |
|
CGPL_SEM_PLGRP |
|
CHAR |
4 |
0 |
Planning Profile Group |
|
51 |
COMPLETION |
|
CGPL_COMPLETION |
CGPL_COMPLETION |
NUMC |
3 |
0 |
Percentage of Completion |
|
52 |
MANUFACTCODE |
|
CRM_MKTPL_MANUCODE |
CRM_MKTPL_MANUCODE |
CHAR |
12 |
0 |
Manufacturer Code for Coupon |
|
53 |
FAMCODE |
|
CRM_MKTPL_FAMCODE |
CRM_MKTPL_FAMCODE |
CHAR |
4 |
0 |
Family Code for Coupon |
|
54 |
OFR_BRAND_ID |
|
CRM_MKTPL_OFR_BRAND |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Coupon Product Category |
|
55 |
OFRCODE |
|
CRM_MKTPL_OFRCODE |
CRM_MKTPL_OFRCODE |
CHAR |
16 |
0 |
Coupon Code |
|
56 |
PRODUCT_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
57 |
TERR_PATH_ID |
|
CRMT_TERRITORY_PATH_ID |
CRM_TERRITORY_PATH_ID |
CHAR |
30 |
0 |
Territory Hierarchy ID |
|
58 |
OBJECT_TYPE |
|
CGPL_OBJECT_TYPE |
CHAR3 |
CHAR |
3 |
0 |
Object Type in Project Planning |
|
59 |
RESP_NAME_FIRST |
|
CRM_MKTPL_IB_RESP_NAME_FIRST |
BU_NAME |
CHAR |
40 |
0 |
Person Responsible: First Name |
|
60 |
RESP_NAME_LAST |
|
CRM_MKTPL_IB_RESP_NAME_LAST |
BU_NAME |
CHAR |
40 |
0 |
Person Responsible: Last Name |
|
61 |
CPRO_NUMBER |
|
CRM_MKTPL_IB_CPG_CPRO |
CGPL_EXTID |
CHAR |
24 |
0 |
cProjects External ID |
|
62 |
EXCL_IND |
|
CRM_MKTPL_EXCL_IND |
CRM_MKTPL_EXCL_IND |
CHAR |
1 |
0 |
Indicator: Marketing Project Is Exclusive |
|
63 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
64 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
65 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
66 |
CALENDAR_ID |
|
WFCID |
WFCID |
CHAR |
2 |
0 |
Factory Calendar |
* |
67 |
R3_INT |
|
CRMT_MKTPL_R3_INT |
CHAR1 |
CHAR |
1 |
0 |
Marketing Planning: Object Replicated in ERP |
|
68 |
TG_AS_PC_DESC |
|
CRM_MKTPL_TARGETGRP_DESC |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Description of Target Group |
|
69 |
NODE_ID |
|
CRM_MKTPL_NODE_ID |
CHAR20 |
CHAR |
20 |
0 |
ID Hierarchy Node |
|
70 |
CUSTOMER_ID |
|
CRM_MKTPL_CUSTOMER_ID |
CHAR20 |
CHAR |
20 |
0 |
Planning Account ID |
|
71 |
VALCODE |
|
CRM_MKTPL_VALCODE |
CRM_MKTPL_VALCODE |
CHAR |
3 |
0 |
Value Code for Coupon |
|
72 |
BARCODE_TYPE |
|
CRM_MKTPL_BARCODE_TYPE |
CRM_MKTPL_BARCODE_TYPE |
CHAR |
20 |
0 |
Barcode Type for Coupon |
|
73 |
EXP_DATE |
|
CRM_MKTPL_EXP_DATE |
CRM_MKTPL_EXP_DATE |
DATS |
8 |
0 |
Expiration Date for Coupon |
|
74 |
CLEARING_HOUSE_NR |
|
CRM_MKTPL_CLEARING_HOUSE_NR |
BU_PARTNER |
CHAR |
10 |
0 |
Clearing House |
* |
75 |
PARENT_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
76 |
REF_TYPE |
|
CRM_MKTPL_REF_TYPE |
CRM_MKTPL_REF_TYPE_DOM |
CHAR |
4 |
0 |
Usage Type |
|
77 |
PRODUCT_CATEGORY |
|
COMT_CATEGORY_ID |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Category ID |
|
78 |
PRODUCT_GROUP |
|
CRM_MKTPL_PROD_GROUP |
|
CHAR |
3 |
0 |
Product Group |
|
79 |
TEMPLATE |
|
CRM_MKTPL_TEMPLATE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Template Indicator |
|
80 |
USAGE_VALID_FROM |
|
CRM_MKTGS_USAGE_VALID_FROM_DAT |
DATS |
DATS |
8 |
0 |
Usage Valid From Date |
|
81 |
USAGE_VALID_TO |
|
CRM_MKTGS_USAGE_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Usage Valid To Date |
|
82 |
PARTNER_COMB |
|
CRM_MKTGS_PARTNER_TO_PAR_FCT |
CHAR40 |
CHAR |
40 |
0 |
Partner In Partner Function |
|
83 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
84 |
INDIRECT_IND |
|
CRM_MKTPL_INDIRECT_IND |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Indirect Indicator |
|
85 |
PPG_STATUS |
|
CRMT_PPGSTATUS |
CRM_PPGSTATUS |
CHAR |
1 |
0 |
PPG Status |
|
86 |
INCLUDE_HIERARCHY |
|
CRM_MKTPL_FLAG |
CRM_MKTPL_FLAG |
CHAR |
1 |
0 |
Indicator |
|
87 |
INCL_HIERARCHY |
|
CRM_MKTPL_GUID |
CRM_MKTPL_GUID |
RAW |
16 |
0 |
CRM Marketing Planning - Marketing Element GUID |
|
88 |
.INCLUDE |
|
|
|
|
0 |
0 |
Query include for marketing project search |
|
89 |
MKT_PROJECT_QUERY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
90 |
.INCLUDE |
|
|
|
|
0 |
0 |
Attribute structure for Agreements Linked to Trade Promotion |
|
91 |
AGR_EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
92 |
AGR_TEXT1 |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|