1 |
OBJECT_KEY |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
2 |
GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extract Structure for OLTP Opportunties (objlayer) fields |
|
4 |
OBJECT_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
5 |
OBJECT_TYPE |
|
SWO_OBJTYP |
OJ_NAME |
CHAR |
10 |
0 |
Object Type |
* |
6 |
DESCRIPTION |
|
CRMT_PROCESS_DESCRIPTION |
CRM_PROCESS_DESCRIPTION |
CHAR |
40 |
0 |
Transaction Description |
|
7 |
DESCRIPTION_OPP |
|
CRMT_DESCRIPTION_OPP |
TEXT40 |
CHAR |
40 |
0 |
Opportunity Description |
|
8 |
STARTDATE |
|
CRMT_STARTDATE |
DATUM |
DATS |
8 |
0 |
Opportunity Start Date |
|
9 |
EXPECT_END |
|
CRMT_EXPECT_END |
DATUM |
DATS |
8 |
0 |
Expected Closing Date |
|
10 |
POSTING_DATE |
|
CRMT_POSTING_DATE |
|
DATS |
8 |
0 |
Posting Date for a Business Transaction |
|
11 |
SALESCYCLE |
|
CRMT_SALESCYCLE |
CRM_SALESCYCLE |
CHAR |
5 |
0 |
Sales Cycle |
* |
12 |
PROBABILITY |
|
CRMT_PROBABILITY_NO_F4 |
CRM_SYSTEM_PROBABILITY |
NUMC |
3 |
0 |
Chance of Success |
|
13 |
SYS_PROBABILITY |
|
CRMT_SYSTEM_PROBABILITY |
CRM_SYSTEM_PROBABILITY |
NUMC |
3 |
0 |
Chance of Success of Opportunity - Calculated by System |
|
14 |
CURR_PHASE |
|
CRMT_CURR_PHASE |
CRM_PHASE |
CHAR |
3 |
0 |
Sales Stage |
* |
15 |
PHASE_SINCE |
|
CRMT_PHASE_SINCE |
DATUM |
DATS |
8 |
0 |
Sales Stage Since |
|
16 |
STATUS_SINCE |
|
CRMT_STATUS_SINCE |
DATUM |
DATS |
8 |
0 |
Status Since |
|
17 |
EXP_REVENUE |
|
CRMT_REPORT_EXP_REVENUE |
WERTV8 |
CURR |
15 |
2 |
Expected Sales Revenue |
|
18 |
CURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
19 |
FORECAST_REL |
|
CRMT_FORECAST_REL |
CRM_FORECAST_REL |
CHAR |
1 |
0 |
Forecast Relevance |
|
20 |
BUDGET_BP |
|
CRMT_BUDGET_BP |
WERTV8 |
CURR |
15 |
2 |
Budget Prospect |
|
21 |
TYPE |
|
CRMT_OPPORT_TYPE |
CRM_OPPORT_TYPE |
CHAR |
4 |
0 |
Opportunity Type |
* |
22 |
IMPORTANCE |
|
CRMT_IMPORTANCE |
CRM_IMPORTANCE |
CHAR |
1 |
0 |
Opportunity/Lead Priority |
* |
23 |
SOURCE |
|
CRMT_SOURCE |
CRM_SOURCE |
CHAR |
3 |
0 |
Origin of Opportunity/Lead |
* |
24 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
25 |
PROSPECT |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
26 |
SOLD_TO_PARTY |
|
CRMT_SOLD_TO_PARTY_ID |
BU_PARTNER |
CHAR |
10 |
0 |
Sold-To Party ID |
* |
27 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
28 |
SERVICE_ORG_RESP |
|
CRMT_SERVICE_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Service Organization |
|
29 |
SALES_ORG_RESP |
|
CRMT_SALES_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Sales) |
|
30 |
STAT_OPEN |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
31 |
COMPETITOR |
|
CRMT_COMPETITOR |
BU_PARTNER |
CHAR |
10 |
0 |
Competitors |
* |
32 |
KATALOGART_OPP |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
33 |
CODEGRUPPE_OPP |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
34 |
CODE_OPP |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
35 |
STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
36 |
USER_STAT_PROC |
|
CRM_J_STSMA |
CRM_J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
37 |
RESP_AT_PARTNER |
|
CRMT_RESPONSIBLE_AT_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Person Responsible at Partners (Channel Management) |
* |
38 |
CHANNEL_PARTNER |
|
CMST_CHANNEL_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Channel Partner |
* |
39 |
OPP_SUCCES_SLSO |
|
CRMT_BOOLEAN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Logical Variable |
|
40 |
STAT_QUOT |
|
CRMT_BOOLEAN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Logical Variable |
|
41 |
CONTROL_PHASE |
|
CRMT_CON_PHASE |
CRM_CON_PHASE |
CHAR |
3 |
0 |
Analysis Stage |
* |
42 |
PATH_ID |
|
CRMT_TERRITORY_PATH_ID |
CRM_TERRITORY_PATH_ID |
CHAR |
30 |
0 |
Territory Hierarchy ID |
|
43 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
44 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
45 |
SALES_OFFICE |
|
CRMT_SALES_OFFICE |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Office |
|
46 |
SALES_GROUP |
|
CRMT_SALES_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Group |
|
47 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
48 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
49 |
.INCLUDE |
|
|
|
|
0 |
0 |
Reporting Structure for Partner Attributes |
|
50 |
COUNTRY |
|
CRMT_COUNTRY |
LAND1 |
CHAR |
3 |
0 |
Country |
* |
51 |
INDUSTRY |
|
CRMT_INDUSTRY |
CRM_INDUSTRY |
CHAR |
4 |
0 |
Industry Sector |
* |
52 |
REGION |
|
CRMT_REGION |
REGIO |
CHAR |
3 |
0 |
Region (State, Province, County) |
* |
53 |
SOLD_TO_COUNTRY |
|
CRMT_COUNTRY |
LAND1 |
CHAR |
3 |
0 |
Country |
* |
54 |
SOLD_TO_REGION |
|
CRMT_REGION |
REGIO |
CHAR |
3 |
0 |
Region (State, Province, County) |
* |
55 |
CP_PROGRAM |
|
CHM_PARTNER_PROGRAM |
CHM_PARTNER_PROGRAM |
CHAR |
4 |
0 |
Channel Management - Channel Partner Programm |
* |
56 |
CP_TYPE |
|
CHM_PARTNER_TYPE |
CHM_PARTNER_TYPE |
CHAR |
4 |
0 |
Channel Management - Channel Partner Type |
* |
57 |
CP_STATUS |
|
CHM_PARTNER_STATUS |
CHM_PARTNER_STATUS |
CHAR |
4 |
0 |
Channel Management - Channel Partner Status |
* |
58 |
.INCLUDE |
|
|
|
|
0 |
0 |
EEW Include |
|
59 |
EEW_R_OPP_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
60 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
61 |
.INCLUDE |
|
|
|
|
0 |
0 |
ADVS Selection fields for Local BI Reporting |
|
62 |
USERNAME |
|
USERNAME |
USERNAME |
CHAR |
12 |
0 |
User name |
|
63 |
SELECTION_ID |
|
NUMC4 |
NUMC4 |
NUMC |
4 |
0 |
Count parameters |
|
64 |
LOG_SYSTEM |
|
LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical system |
* |
65 |
APP_SERVER |
|
SYHOST |
HOST_ID |
CHAR |
32 |
0 |
Application Server |
|
66 |
STATUS_COMMON |
|
CRMT_STATUS_COMMON |
|
CHAR |
13 |
0 |
General Status (User, System, Area) |
|
67 |
NUM_OF_HEAD |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
68 |
NUM_OF_SLSORD |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
69 |
N_OF_OPP_SUC_SLS |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
70 |
N_SLS_SUC_OPP |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
71 |
WEIGHTED_MAN_EXP_REV |
|
CRMT_EXP_WEIGHTED_REVENUE |
WERTV8 |
CURR |
15 |
2 |
Expected Weighted Sales Volume |
|
72 |
REASON_COMMON |
|
/CRMBW/CODEC |
|
CHAR |
20 |
0 |
Concatenated Catalog Type, Code Group, Code |
|
73 |
PARTNER_OPP_SLS |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
74 |
DATE_OPP_SLS |
|
CRMT_EXPECT_END |
DATUM |
DATS |
8 |
0 |
Expected Closing Date |
|
75 |
.INCLUDE |
|
|
|
|
0 |
0 |
OLTP ApplFields for the Opportunity Extr. Item |
|
76 |
ITEM_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
77 |
.INCLUDE |
|
|
|
|
0 |
0 |
Internal Structure for Opportunities Items |
|
78 |
NUMBER_INT |
|
CRMT_ITEM_NO |
CRM_ITEM_NO |
NUMC |
10 |
0 |
Item Number in Document |
|
79 |
NUMBER_OF_I |
|
CRMT_NUMBER_OF_I |
INT4 |
INT4 |
10 |
0 |
Order Item Number |
|
80 |
PRODUCT_ID |
|
CRMT_ORDERED_PROD |
CRM_ORDERED_PROD |
CHAR |
54 |
0 |
Product Name Entered |
|
81 |
PRODUCT |
|
CRMT_PRODUCT_GUID_DB |
SYSUUID |
RAW |
16 |
0 |
Internal Unique ID of Product |
|
82 |
CATEGORY_GUID |
|
COMT_CATEGORY_GUID |
SYSUUID |
RAW |
16 |
0 |
Category GUID |
|
83 |
NET_VALUE_MAN |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
84 |
QUANTITY |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
85 |
GROSS_VALUE |
|
CRMT_GROSS_VALUE |
WERTV8 |
CURR |
15 |
2 |
Gross Order Value in PO Currency |
|
86 |
NET_VALUE |
|
CRMT_NET_VALUE |
WERTV8 |
CURR |
15 |
2 |
Net Value |
|
87 |
PROCESS_QTY_UNIT |
|
CRMT_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in Which the Product Is Sold |
* |
88 |
BASE_QTY_UNIT |
|
COMT_PRODUCT_BASE_UOM |
MEINS |
UNIT |
3 |
0 |
Base Unit of Measure of Product |
* |
89 |
PROCESS_QTY_NUM |
|
CRMT_PROCESS_QTY_NUM |
CRM_PROCESS_QTY_NUM |
INT4 |
10 |
0 |
Numerator (factor) for conversion trans. quantity in BME |
|
90 |
PROCESS_QTY_DEN |
|
CRMT_PROCESS_QTY_DEN |
CRM_PROCESS_QTY_DEN |
INT4 |
10 |
0 |
Denominator (factor) for conversion trans. quantity in BME |
|
91 |
QUAN_BASE_UN |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
92 |
.INCLUDE |
|
|
|
|
0 |
0 |
EEW Include |
|
93 |
Q_R_OPP_I_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
94 |
PROD_HIERARCHY |
|
CRMT_PROD_HIERARCHY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|