1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Query Attributes of Node Trade (IBOM MKTPL) - Include |
|
2 |
FUNDSPLAN_ID |
|
CRM_FM_FND_FUNDPLAN_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Funds Plan ID |
|
3 |
EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
4 |
TEXT1 |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|
5 |
OBJECT_TYPE |
|
CGPL_OBJECT_TYPE |
CHAR3 |
CHAR |
3 |
0 |
Object Type in Project Planning |
|
6 |
PARENT_EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
7 |
OBJECT_GROUP |
|
CRM_MKTPL_OBJ_GROUP |
CHAR3 |
CHAR |
3 |
0 |
Object Grouping for Various Object Types in Marketing |
|
8 |
OBJECT_CLASS |
|
CRM_MKTPL_OBJ_CLASS |
CRM_MKTPL_OBJECT_CLASS |
CHAR |
3 |
0 |
Category of Marketing Project |
* |
9 |
CAMP_TYPE |
|
CRM_MKTPL_CAMPTYPE |
CRM_MKTPL_CAMPTYPE |
CHAR |
4 |
0 |
Type |
* |
10 |
OBJECTIVE |
|
CRM_MKTPL_OBJECTIVE |
CRM_MKTPL_OBJECTIVE |
CHAR |
4 |
0 |
Objective |
|
11 |
TACTICS |
|
CRM_MKTPL_TACTICS |
CRM_MKTPL_TACTICS |
CHAR |
4 |
0 |
Tactic |
|
12 |
PRIORITY |
|
CGPL_PRIORITY |
NUMC3 |
NUMC |
3 |
0 |
Priority |
|
13 |
AUTH_GROUP |
|
CRM_MKTPL_AUTH_GROUP |
CRM_MKTPL_AUTH_GROUP |
CHAR |
4 |
0 |
Authorization Group |
|
14 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
15 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
16 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
17 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
18 |
RESPONSIBLE_NO |
|
CRM_MKTPL_RESPONSIBLE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible for Marketing Project |
* |
19 |
CUSTOMER_ID |
|
CRM_MKTPL_CUSTOMER_ID |
CHAR20 |
CHAR |
20 |
0 |
Planning Account ID |
|
20 |
CUSTOMER_DESC |
|
CRM_MKTPL_CUSTOMER_DESC |
CHAR50 |
CHAR |
50 |
0 |
Business Partner |
|
21 |
PLANCUST_TYPE |
|
CRM_MKTPL_PLCUST_TYPE |
CRM_MKTPL_PLCUST_TYPE |
CHAR |
2 |
0 |
Type of Account (BP, Hierarchy Node, Target Group) |
|
22 |
NODE_ID |
|
CRM_MKTPL_NODE_ID |
CHAR20 |
CHAR |
20 |
0 |
ID Hierarchy Node |
|
23 |
NODE_DESCR |
|
CRM_MKTPL_NODE_DESCR |
BU_TEXT50 |
CHAR |
50 |
0 |
Description Hierarchy Nodes |
|
24 |
TARGETGRP_DESCR |
|
CRM_MKTPL_SEGMENT_DESC |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Description of Segment |
|
25 |
PRSEG_DESCR |
|
CRM_MKTPL_PRSEG_DESC |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Description of Product Segment |
|
26 |
TG_AS_PC_DESC |
|
CRM_MKTPL_TARGETGRP_DESC |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Description of Target Group |
|
27 |
PRODUCT_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
28 |
PRODUCT_CATEGORY |
|
COMT_CATEGORY_ID |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Category ID |
|
29 |
PRODUCT_CATEGORY2 |
|
COMT_CATEGORY_ID |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Category ID |
|
30 |
PRODUCT_GROUP |
|
CRM_MKTPL_PROD_GROUP |
|
CHAR |
3 |
0 |
Product Group |
|
31 |
PARTNER_GUID |
|
CRMT_PARTNER_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for an Individual Partner |
|
32 |
PARTNER_NUMBER |
|
CRMT_PARTNER_NO |
CRM_PARTNER_NO |
CHAR |
32 |
0 |
Partner Number |
|
33 |
PARTNER_COMB |
|
CRM_MKTGS_PARTNER_TO_PAR_FCT |
CHAR40 |
CHAR |
40 |
0 |
Partner In Partner Function |
|
34 |
CREATED_BY |
|
CGPL_CREATED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Created Object |
|
35 |
CREATED_ON |
|
CGPL_CREATED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which the Object was Created |
|
36 |
CHANGED_BY |
|
CGPL_CHANGED_BY |
USNAM |
CHAR |
12 |
0 |
Name of Person Who Changed Object |
|
37 |
CHANGED_ON |
|
CGPL_CHANGED_ON |
DATUM |
DATS |
8 |
0 |
Date on Which Object Was Last Changed |
|
38 |
HIERARCHY_BP |
|
CRM_MKTPL_HIERARCHY_BP |
CRM_MKTPL_HIERARCHY_BP_TYPE |
CHAR |
10 |
0 |
Type of Hierarchy Search for Customers |
|
39 |
HIERARCHY_PRD |
|
CRM_MKTPL_HIERARCHY_PRD |
CRM_MKTPL_HIERARCHY_TYPE |
CHAR |
10 |
0 |
Type of Hierarchy Search for Product |
|
40 |
HIERARCHY_MKTPL |
|
CRM_MKTPL_HIERARCHY_MKTPL |
CRM_MKTPL_HIERARCHY_TYPE |
CHAR |
10 |
0 |
Type of Hierarchy Search for Marketing |
|
41 |
DEAL_ID |
|
CRM_MKTPL_DEALID |
CGPL_EXTID |
CHAR |
24 |
0 |
Deal |
|
42 |
CUSTOMER_ID_DEAL |
|
CRM_MKTPL_CUST_ID_DEAL |
CHAR20 |
CHAR |
20 |
0 |
Customer Deal |
|
43 |
CUSTOMER_DESC_DEAL |
|
CRM_MKTPL_CUST_DESC_DEAL |
CHAR50 |
CHAR |
50 |
0 |
Customer Deal (Description) |
|
44 |
CONTACT_BP |
|
CRM_MKTPL_CONTACT_BP |
CHAR50 |
CHAR |
50 |
0 |
Contacted Business Partner |
|
45 |
ACTIVE_STATE |
|
CRMT_MKTPL_ACTIVE_STATE |
CRM_MKTPL_ACTIVE_STATE |
CHAR |
10 |
0 |
Active State of Marketing Project (For Search) |
|
46 |
NEW_SINCE |
|
CRM_MKTPL_DATE_FROM |
DATUM |
DATS |
8 |
0 |
From Date (Search) |
|
47 |
CHANNEL |
|
CRM_MKTPL_CHANNEL |
CRM_MKTPL_CHANNEL |
CHAR |
4 |
0 |
ID of Communication Medium |
|
48 |
STATUS |
|
J_TXT30 |
TEXT30 |
CHAR |
30 |
0 |
Object status |
|
49 |
CAMPAIGN_ASSIGNED |
|
CRM_MKTPL_CAMPAIGN_ASSIGNED |
CGPL_EXTID |
CHAR |
24 |
0 |
Assigned Campaign |
|
50 |
PLANSTARTDATE |
|
CRM_MKTPL_PLANSTARTDATE |
DATUM |
DATS |
8 |
0 |
Planned Start Date |
|
51 |
PLANFINISHDATE |
|
CRM_MKTPL_PLANFINISHDATE |
DATUM |
DATS |
8 |
0 |
Planned Finish Date |
|
52 |
BUYINGSTARTDATE |
|
DATUM |
DATUM |
DATS |
8 |
0 |
Date |
|
53 |
BUYINGENDDATE |
|
DATUM |
DATUM |
DATS |
8 |
0 |
Date |
|
54 |
TARGETGRP_GUID |
|
CRMT_TARGETGRP_GUID |
SYSUUID |
RAW |
16 |
0 |
CRM Marketing: GUID of Target Group |
|
55 |
EXCL_IND |
|
CRM_MKTPL_EXCL_IND |
CRM_MKTPL_EXCL_IND |
CHAR |
1 |
0 |
Indicator: Marketing Project Is Exclusive |
|
56 |
EXCL_IND_DESC |
|
CRM_MKTPL_EXCL_IND_DESCRIPTION |
|
CHAR |
40 |
0 |
Exclusive Indicator Description |
|
57 |
ACTIVE_STATE_DESC |
|
CRMD_MKTPL_ACTIVE_FLAG_DESC |
|
CHAR |
40 |
0 |
ACTIVE Indicator Description |
|
58 |
INACTIVE |
|
CHAR10 |
CHAR10 |
CHAR |
10 |
0 |
Character Field Length = 10 |
|
59 |
ADI_FLAG |
|
CRM_MKTPL_ADI |
CRM_MKTPL_ADI |
CHAR |
1 |
0 |
Abnormal Demand Indicator |
|
60 |
REF_TYPE |
|
CRM_MKTPL_REF_TYPE |
CRM_MKTPL_REF_TYPE_DOM |
CHAR |
4 |
0 |
Usage Type |
|
61 |
ENROLLMENT_REQ |
|
CRM_MKTPL_ENR_ENROLLMENT_REQ |
XFELD |
CHAR |
1 |
0 |
Indicator, that enrollment is required |
|
62 |
ENROLLMENT_STARTDATE |
|
CRM_MKTPL_ENR_STARTDATE |
DATUM |
DATS |
8 |
0 |
Enrollment Start Date |
|
63 |
ENROLLMENT_ENDDATE |
|
CRM_MKTPL_ENR_ENDDATE |
DATUM |
DATS |
8 |
0 |
Enrollment End Date |
|
64 |
PPG_STATUS |
|
CRMT_PPGSTATUS |
CRM_PPGSTATUS |
CHAR |
1 |
0 |
PPG Status |
|
65 |
WHOLESALER |
|
CRM_MKTPL_SUPPLIER |
CHAR8 |
CHAR |
8 |
0 |
Supplier Partner Function |
|
66 |
PAYEE |
|
CRM_MKTGS_PARTNER_TO_PAR_FCT |
CHAR40 |
CHAR |
40 |
0 |
Partner In Partner Function |
|
67 |
BI_KYFG_REQUIRED |
|
CRM_MKTPL_IB_BI_KYFG_REQUIRED |
CHAR1 |
CHAR |
1 |
0 |
TPM: BI Key Figures Required |
|
68 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
69 |
.INCLUDE |
|
|
|
|
0 |
0 |
Attribute structure for Agreements Linked to Trade Promotion |
|
70 |
AGR_EXTERNAL_ID |
|
CRM_MKTPL_EXTERNAL_ID |
CGPL_EXTID |
CHAR |
24 |
0 |
External Identification |
|
71 |
AGR_TEXT1 |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|
72 |
TEMPLATE |
|
CRM_MKTPL_TEMPLATE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Template Indicator |
|
73 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Date Ranges for MKTPL Search |
|
74 |
ADD_DT_RANGE_01_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
75 |
ADD_DT_RANGE_01_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
76 |
ADD_DT_RANGE_02_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
77 |
ADD_DT_RANGE_02_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
78 |
ADD_DT_RANGE_03_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
79 |
ADD_DT_RANGE_03_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
80 |
ADD_DT_RANGE_04_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
81 |
ADD_DT_RANGE_04_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
82 |
ADD_DT_RANGE_05_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
83 |
ADD_DT_RANGE_05_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
84 |
ADD_DT_RANGE_06_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
85 |
ADD_DT_RANGE_06_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
86 |
ADD_DT_RANGE_07_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
87 |
ADD_DT_RANGE_07_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
88 |
ADD_DT_RANGE_08_STARTDATE |
|
CRM_MKTPL_START_DATE |
DATS |
DATS |
8 |
0 |
Start Date |
|
89 |
ADD_DT_RANGE_08_ENDDATE |
|
CRM_MKTPL_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
90 |
.INCLUDE |
|
|
|
|
0 |
0 |
Cusal Query Include |
|
91 |
CAU_RETAIL_PRC |
|
CRM_MKTPL_CAU_RETAIL_PRC |
CRM_MKTPL_CAU_RETAIL_PRC |
CURR |
15 |
2 |
Retail Price |
|
92 |
CAU_RETAIL_CURRENCY |
|
CRM_MKTPL_CAU_RETAIL_CURR |
WAERS |
CUKY |
5 |
0 |
Retail Price Currency |
* |
93 |
CAU_RETAIL_UNIT |
|
CRM_MKTPL_CAU_UNITS |
CRM_MKTPL_CAU_UNITS |
NUMC |
3 |
0 |
Promotion Retail Unit |
|
94 |
CAU_FEATURE_AD |
|
CRM_MKTPL_CAU_FEATURE_AD |
CRM_MKTPL_CAU_FEATURE_AD |
CHAR |
3 |
0 |
Causal Factor: Feature AD |
|
95 |
CAU_DISPLAY_TYPE |
|
CRM_MKTPL_CAU_DISPLAY_TYPE |
CRM_MKTPL_CAU_DISPLAY_TYPE |
CHAR |
3 |
0 |
Causal Factor: Display Type |
|
96 |
CAU_DISPLAY_LOC |
|
CRM_MKTPL_CAU_DISPLAY_LOCATION |
CRM_MKTPL_CAU_DISPLAY_LOCATION |
CHAR |
3 |
0 |
Causal Factor: Display Location |
|
97 |
CAU_SPACE |
|
CRM_MKTPL_CAU_SPACE |
CRM_MKTPL_CAU_SPACE |
NUMC |
3 |
0 |
Space |
|
98 |
SEG_GUID |
|
CRMT_MKTTG_SEG_GUID |
SYSUUID |
RAW |
16 |
0 |
CRM Marketing: Marketing Segment GUID |
|
99 |
SEG_DESC |
|
CRM_MKTPL_SEGMENT_DESC |
CRM_MARKETING_DESC |
CHAR |
72 |
0 |
Description of Segment |
|
100 |
CAU_RET_UNIT_PRC |
|
CRM_MKTPL_CAU_RETAIL_PRC |
CRM_MKTPL_CAU_RETAIL_PRC |
CURR |
15 |
2 |
Retail Price |
|
101 |
CP1_CAU_RETAIL_CURRENCY |
|
CRM_MKTPL_CAU_RETAIL_CURR |
WAERS |
CUKY |
5 |
0 |
Retail Price Currency |
* |
102 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
103 |
SPEND_VALUE |
|
CRM_MKTGS_SPEND_VALUE |
CRM_MKTGS_SPEND_VALUE |
CURR |
20 |
2 |
Spend Value |
|
104 |
CURRENCY |
|
CRM_MKTPL_CUKY |
WAERS |
CUKY |
5 |
0 |
MKTPL: Currency Object |
* |
105 |
COST_TYPE |
|
CRM_MKTPL_COST_TYPE |
CRM_MKTPL_COST_TYPE |
CHAR |
4 |
0 |
Spend Type |
* |
106 |
COST_CATEGORY |
|
CRM_MKTPL_COST_CAT |
CRM_MKTPL_COST_CAT |
CHAR |
30 |
0 |
Spend Category |
* |
107 |
SPEND_METHOD |
|
CRM_MKTPL_SPEND_METHOD |
CRM_MKTPL_SPEND_METHOD |
CHAR |
10 |
0 |
Spend Method for Key Figure Planning |
* |
108 |
TERR_DESCRIPTION |
|
CRMT_TERRITORY_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Territory Description |
|
109 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extension Include - Trade Promotion Query |
|
110 |
MKTPL_QUERY_TPM |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
111 |
USAGE_VALID_FROM |
|
CRM_MKTGS_USAGE_VALID_FROM_DAT |
DATS |
DATS |
8 |
0 |
Usage Valid From Date |
|
112 |
USAGE_VALID_TO |
|
CRM_MKTGS_USAGE_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Usage Valid To Date |
|
113 |
PLAN_VALID_FROM_DATE |
|
CRM_MKTGS_PLAN_VALID_FROM_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid From Date |
|
114 |
PLAN_VALID_TO_DATE |
|
CRM_MKTGS_PLAN_VALID_TO_DATE |
DATS |
DATS |
8 |
0 |
Plan Valid To Date |
|
115 |
INDIRECT_IND |
|
CRM_MKTPL_INDIRECT_IND |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Indirect Indicator |
|
116 |
CONTEXT_MASS_APPROVAL |
|
CHAR01 |
CHAR1 |
CHAR |
1 |
0 |
Character Field Length 1 |
|
117 |
DISC_METHOD |
|
CRM_MKTPL_DISC_METH |
CRM_MKTPL_DISC_METH |
CHAR |
4 |
0 |
Discount Method |
* |
118 |
PURCH_CRM_STATUS |
|
CRM_MKTPL_PURCH_CRM_STATUS |
CRM_MKTPL_PURCH_CRM_STATUS |
CHAR |
1 |
0 |
Item Status With Respect to PR Transfer |
|
119 |
FILTER_BY_TRADE_SPENDS |
|
CRM_FILTER_TRADE_SPENDS |
CRM_FILTER_TRADE_SPENDS |
CHAR |
1 |
0 |
Trade Spend Filter Flag |
|