1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Opportunity Überblick (Interaction Layer ppm) |
|
2 |
OBJECT_KEY |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
3 |
GUID |
|
CRMT_OBJECT_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID of a CRM Order Object |
|
4 |
.INCLUDE |
|
|
|
|
0 |
0 |
Internal PPM Opportunity Fields Provided Within 1O |
|
5 |
CHANGED_AT |
|
CRMT_CHANGED_AT_USR |
CRM_TSTMP |
DEC |
15 |
0 |
Changed On (Output in User Time Zone) |
|
6 |
OBJECT_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
7 |
DESCRIPTION |
|
CRMT_PROCESS_DESCRIPTION |
CRM_PROCESS_DESCRIPTION |
CHAR |
40 |
0 |
Transaction Description |
|
8 |
DESCRIPTION_OPP |
|
CRMT_DESCRIPTION_OPP |
TEXT40 |
CHAR |
40 |
0 |
Opportunity Description |
|
9 |
STARTDATE |
|
CRMT_STARTDATE |
DATUM |
DATS |
8 |
0 |
Opportunity Start Date |
|
10 |
EXPECT_END |
|
CRMT_EXPECT_END |
DATUM |
DATS |
8 |
0 |
Expected Closing Date |
|
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 |
SALESCYCLE_TXT |
|
CRMT_SALESCYCLE_DESC |
TEXT40 |
CHAR |
40 |
0 |
Sales Cycle (Description) |
|
25 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
26 |
CONCATSTATUSER |
|
CRMT_PPM_OPP_STATUS |
TEXT40 |
CHAR |
40 |
0 |
User Status Text |
|
27 |
PROSPECT_NAME |
|
CRMT_PROSPECT_NAME |
BU_TEXT50 |
CHAR |
50 |
0 |
Prospect - Name (Name Only, Without Address) |
|
28 |
CURR_PHASE_TXT |
|
CRMT_PPM_REPORT_PHASE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Sales Stage |
|
29 |
CHANGED_AT_DATE |
|
CRMT_CHANGED_AT_DATE |
SYDATS |
DATS |
8 |
0 |
Date on Which Transaction Was Last Changed |
|
30 |
CREATED_AT_DATE |
|
CRMT_CREATED_AT_DATE |
SYDATS |
DATS |
8 |
0 |
Transaction Was Created on This Date |
|
31 |
PROSPECT |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
32 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
33 |
SALES_EMPLOYEE |
|
CRMT_SALES_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee |
* |
34 |
STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
35 |
STAT_OPEN |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
36 |
PERSON_RESP_NAME |
|
CRMT_PPM_OPP_OWNER |
BU_TEXT50 |
CHAR |
50 |
0 |
Owner |
|
37 |
CHANGED_BY |
|
CRMT_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Transaction Last Changed By |
|
38 |
IMPORTANCE_TXT |
|
CRMT_REPORT_IMPORTANCE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Priority |
|
39 |
TYPE_TXT |
|
CRMT_REPORT_TYPE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Opportunity Group |
|
40 |
SOURCE_TXT |
|
CRMT_REPORT_SOURCE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts on Origin |
|
41 |
PROCESS_TYPE_TXT |
|
CRMT_REPORT_PROCESS_TYPE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Text Description for Transaction Category |
|
42 |
CODETEXT |
|
QTXT_CODE |
QKURZTEXT |
CHAR |
40 |
0 |
Short Text for Code |
|
43 |
LISTCODE_OPP |
|
CRMT_SRV_OPP_RESULT_LIST |
CHAR14 |
CHAR |
14 |
0 |
CRM Service: Opportunity Status Reason |
|
44 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
45 |
SALES_ORG_RESP |
|
CRMT_SALES_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Sales) |
|
46 |
.INCLUDE |
|
|
|
|
0 |
0 |
External PPM Opportunity Fields Provided Outside 1O |
|
47 |
VELOCITY_TXT_SHORT |
|
CRMT_PPM_VELOCITY_TXT |
TEXT20 |
CHAR |
20 |
0 |
Progress Short Text |
|
48 |
WEIGHTED_EXP_REVENUE |
|
CRMT_WEIGHTED_EXP_REVENUE |
WERTV8 |
CURR |
15 |
2 |
Sales Revenue |
|
49 |
WEIGHTED_EXP_REVENUE_REF |
|
CRMT_WEIGHTED_EXP_REVENUE |
WERTV8 |
CURR |
15 |
2 |
Sales Revenue |
|
50 |
DIRTY_FLAG |
|
|
|
CHAR |
1 |
0 |
|
|
51 |
CON_PHASE |
|
CRMT_CON_PHASE |
CRM_CON_PHASE |
CHAR |
3 |
0 |
Analysis Stage |
* |
52 |
CON_PHASE_TXT |
|
CRMT_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
53 |
EXP_REVENUE_REF |
|
CRMT_EXP_REVENUE |
WERTV8 |
CURR |
15 |
2 |
Expected Sales Volume |
|
54 |
CURRENCY_REF |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
55 |
VELOCITY |
|
CRMT_PPM_OPPSPEED |
CRM_PPM_OPPSPEED |
CHAR |
3 |
0 |
Opportunity Speed |
* |
56 |
CONC_KEY |
|
CRM_PPM_CONC_KEY |
CHAR20 |
CHAR |
20 |
0 |
Reason |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Opportunity item fields, inclusively calculated fields |
|
58 |
.INCLUDE |
|
|
|
|
0 |
0 |
Oppo PPM Reporting application Res Structure on Item level |
|
59 |
ITEM_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
60 |
.INCLUDE |
|
|
|
|
0 |
0 |
Internal oppo PPM Application Res Structure on Item level |
|
61 |
NUMBER_INT |
|
CRMT_ITEM_NO |
CRM_ITEM_NO |
NUMC |
10 |
0 |
Item Number in Document |
|
62 |
ITEM_CHANGED_BY |
|
CRMT_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Transaction Last Changed By |
|
63 |
PRODUCT_ID |
|
CRMT_ORDERED_PROD |
CRM_ORDERED_PROD |
CHAR |
54 |
0 |
Product Name Entered |
|
64 |
PROD_DESCRIPTION |
|
CRMT_PRSHTEXTX_DB |
CRM_PRSHTEXT40_DB |
CHAR |
40 |
0 |
Product Short Text |
|
65 |
NET_VALUE_MAN |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
66 |
PROD_HIERARCHY |
|
CRMT_PROD_HIERARCHY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
67 |
PROD_HIERAR_TXT |
|
COMT_CATEGORY_TEXT |
TEXT80 |
CHAR |
80 |
0 |
Category Description |
|
68 |
QUANTITY |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
69 |
PROCESS_QTY_UNIT |
|
CRMT_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in Which the Product Is Sold |
* |
70 |
STAT_OPEN_I |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
71 |
STATUS_USER_I |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
72 |
TXT30_I |
|
J_TXT30 |
TEXT30 |
CHAR |
30 |
0 |
Object status |
|
73 |
USER_STAT_PROC_I |
|
CRM_J_STSMA |
CRM_J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
74 |
CHANGED_AT_I |
|
COMT_CHANGED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Changed At (Output in User Time Zone) |
|
75 |
CREATED_AT_I |
|
COMT_CREATED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Created At (Output in User Time Zone) |
|
76 |
STATUS_SYSTEM_I |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
77 |
PRODUCT |
|
CRMT_PRODUCT_GUID_DB |
SYSUUID |
RAW |
16 |
0 |
Internal Unique ID of Product |
|
78 |
PERSON_RESP_I |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
79 |
SALES_EMPLOYEE_I |
|
CRMT_SALES_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee |
* |
80 |
PROSPECT_I |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
81 |
.INCLUDE |
|
|
|
|
0 |
0 |
PPM: Opportunity calculated item fields |
|
82 |
STATUS_I |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
83 |
NET_VALUE_MAN_REF |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
84 |
QUANTITY_REF |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
85 |
PROCESS_QTY_UNIT_REF |
|
CRMT_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in Which the Product Is Sold |
* |
86 |
WEIGHTED_NET_VALUE_MAN |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
87 |
WEIGHTED_QUANTITY |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
88 |
WEIGHTED_NET_VALUE_MAN_REF |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
89 |
WEIGHTED_QUANTITY_REF |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
90 |
DATA_LEVEL |
|
CRM_PPM_DATA_LEVEL |
CRM_PPM_DATA_LEVEL |
CHAR |
1 |
0 |
PPM Data Level |
|