1 |
GUID |
|
CRMT_OBJECT_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID of a CRM Order Object |
|
2 |
OBJECT_ID |
|
CRMT_OBJECT_ID_DB |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
3 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE_DB |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
4 |
POSTING_DATE |
|
CRMT_POSTING_DATE |
|
DATS |
8 |
0 |
Posting Date for a Business Transaction |
|
5 |
DESCRIPTION |
|
CRMT_PROCESS_DESCRIPTION |
CRM_PROCESS_DESCRIPTION |
CHAR |
40 |
0 |
Transaction Description |
|
6 |
TEMPLATE_TYPE |
|
CRMT_TEMPLATE_TYPE_DB |
CRM_TEMPLATE_TYPE |
CHAR |
1 |
0 |
Template Type of CRM Transaction |
|
7 |
STATUS_SYSTEM |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
8 |
CREATED_AT |
|
CRMT_CREATED_AT |
BCOS_TSTMP |
DEC |
15 |
0 |
Transaction was Created at this Time |
|
9 |
CHANGED_AT |
|
CRMT_CHANGED_AT |
BCOS_TSTMP |
DEC |
15 |
0 |
Time of Last Change to the Transaction |
|
10 |
OBJECT_TYPE_TXT |
|
SAEOBJTEXT |
SADC40 |
CHAR |
40 |
0 |
Object text for language-dependent table |
|
11 |
CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
12 |
PRIORITY |
|
CRMT_PRIORITY |
SC_PRIO |
NUMC |
1 |
0 |
Activity Priority |
* |
13 |
OBJECTIVE |
|
CRMT_OBJECTIVE |
CRM_OBJECTIVE |
CHAR |
3 |
0 |
Goal of an Activity |
* |
14 |
CALENDAR |
|
CRMT_CALENDAR |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Include Activity in Calendar |
|
15 |
TASK |
|
CRMT_TASK |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Indicator: Activity is a Task |
|
16 |
CLASS |
|
CRMT_ACTIVITY_CLASS |
CRM_ACTIVITY_CLASS |
CHAR |
1 |
0 |
Activity Class |
|
17 |
CATEGORY_TXT |
|
CRMT_REPORT_CATEGORY_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Category |
|
18 |
PRIORITY_TXT |
|
CRMT_REPORT_PRIORITY_TXT |
DDTEXT |
CHAR |
60 |
0 |
Text Description for Priority |
|
19 |
DIRECTION_TXT |
|
CRMT_REPORT_DIRECTION_TXT |
DDTEXT |
CHAR |
60 |
0 |
Text Description for Direction |
|
20 |
COMPLETION |
|
CRMT_COMPLETION |
CRM_COMPLETION |
NUMC |
3 |
0 |
Completion Rate in Percent |
|
21 |
ADDRESS_ID |
|
CRMT_ADDRESS |
AD_ADDRNUM |
CHAR |
10 |
0 |
Location where Activity takes place |
* |
22 |
EXTERN_ACT_ID |
|
CRMT_EXTERNAL_ACTIVITY_ID |
CRM_EXTERNAL_ACTIVITY_ID |
CHAR |
20 |
0 |
External Business Transaction Number |
|
23 |
ACT_LOCATION |
|
CRMT_ACTIVITY_LCTN |
CRM_ACTIVITY_LOCATION |
CHAR |
100 |
0 |
Location |
|
24 |
PRIVATE_FLAG |
|
CRMT_PRIVAT |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Indicator: Task is Private |
|
25 |
STARTDATE |
|
CRMT_STARTDATE |
DATUM |
DATS |
8 |
0 |
Opportunity Start Date |
|
26 |
EXPECT_END |
|
CRMT_EXPECT_END |
DATUM |
DATS |
8 |
0 |
Expected Closing Date |
|
27 |
CURR_PHASE |
|
CRMT_CURR_PHASE |
CRM_PHASE |
CHAR |
3 |
0 |
Sales Stage |
* |
28 |
PHASE_SINCE |
|
CRMT_PHASE_SINCE |
DATUM |
DATS |
8 |
0 |
Sales Stage Since |
|
29 |
PROBABILITY |
|
CRMT_PROBABILITY |
CRM_PROBABILITY |
NUMC |
3 |
0 |
Chance of Success |
|
30 |
FORECAST_REL |
|
CRMT_FORECAST_REL |
CRM_FORECAST_REL |
CHAR |
1 |
0 |
Forecast Relevance |
|
31 |
SOURCE |
|
CRMT_SOURCE |
CRM_SOURCE |
CHAR |
3 |
0 |
Origin of Opportunity/Lead |
* |
32 |
IMPORTANCE |
|
CRMT_IMPORTANCE |
CRM_IMPORTANCE |
CHAR |
1 |
0 |
Opportunity/Lead Priority |
* |
33 |
SALESCYCLE |
|
CRMT_SALESCYCLE |
CRM_SALESCYCLE |
CHAR |
5 |
0 |
Sales Cycle |
* |
34 |
ADDRESS_NO |
|
CRMT_OPP_ADDRESS |
AD_ADDRNUM |
CHAR |
10 |
0 |
Opportunity Address |
* |
35 |
TYPE |
|
CRMT_OPPORT_TYPE |
CRM_OPPORT_TYPE |
CHAR |
4 |
0 |
Opportunity Type |
* |
36 |
STATUS_SINCE |
|
CRMT_STATUS_SINCE |
DATUM |
DATS |
8 |
0 |
Status Since |
|
37 |
SYS_PROBABILITY |
|
CRMT_SYSTEM_PROBABILITY |
CRM_SYSTEM_PROBABILITY |
NUMC |
3 |
0 |
Chance of Success of Opportunity - Calculated by System |
|
38 |
DESCRIPTION_OPP |
|
CRMT_DESCRIPTION_OPP |
TEXT40 |
CHAR |
40 |
0 |
Opportunity Description |
|
39 |
CUSTOMER_STATUS |
|
CRMT_CUSTSTAT |
CRM_CUSTSTAT |
CHAR |
4 |
0 |
Design Registration Project Phase |
* |
40 |
IMPORTANCE_TXT |
|
CRMT_REPORT_IMPORTANCE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Priority |
|
41 |
CURR_PHASE_TXT |
|
CRMT_REPORT_PHASE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Phase |
|
42 |
SALESCYCLE_TXT |
|
CRMT_REPORT_SALESCYCLE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Sales Cycle |
|
43 |
TYPE_TXT |
|
CRMT_REPORT_TYPE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Opportunity Group |
|
44 |
SOURCE_TXT |
|
CRMT_REPORT_SOURCE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts on Origin |
|
45 |
LEAD_TYPE |
|
CRMT_LEAD_TYPE |
CRM_LEAD_TYPE |
CHAR |
4 |
0 |
Lead Group |
* |
46 |
QUAL_LEVEL_MAN |
|
CRMT_LEAD_QUAL_LEVEL_MAN |
CRM_LEAD_QUAL_LEVEL |
CHAR |
2 |
0 |
Lead Qualification Level |
* |
47 |
QUAL_LEVEL_AUTO |
|
CRMT_LEAD_QUAL_LEVEL_AUTO |
CRM_LEAD_QUAL_LEVEL |
CHAR |
2 |
0 |
Lead Qualification Level (Automatic) |
* |
48 |
QUAL_LEVEL_SVY |
|
CRMT_LEAD_QUAL_LEVEL_AUTO_SVY |
CHAR32 |
CHAR |
32 |
0 |
Questionnaire that Q-Level Sets (Automatically) |
|
49 |
LEAD_TYPE_TXT |
|
CRMT_REPORT_LEAD_TYPE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Lead Group |
|
50 |
QUAL_LEVEL_MAN_TXT |
|
CRMT_REPORT_QUAL_LEVEL_MAN_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Lead Qualification Level (Manual) |
|
51 |
QUAL_LEVEL_AUTO_TXT |
|
CRMT_REPORT_QUAL_LEVEL_AUT_TXT |
DDTEXT |
CHAR |
60 |
0 |
Texts for Lead Qualification Level (Automatic) |
|
52 |
CURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
53 |
BUAG_ID |
|
CRMT_BUAG_ID |
CRMT_BUAG_ID |
CHAR |
12 |
0 |
Number of Business Agreement |
|
54 |
BUAG_TEXT |
|
CRMT_BUAG_TEXT |
CHAR30LOW |
CHAR |
30 |
0 |
Text for Business Agreement |
|
55 |
CUST_GROUP1 |
|
CRMT_CUST_GROUP1 |
CRM_CUST_GROUP1 |
CHAR |
3 |
0 |
Customer Group 1 |
* |
56 |
CUST_GROUP2 |
|
CRMT_CUST_GROUP2 |
CRM_CUST_GROUP2 |
CHAR |
3 |
0 |
Customer Group 2 |
* |
57 |
CUST_GROUP3 |
|
CRMT_CUST_GROUP3 |
CRM_CUST_GROUP3 |
CHAR |
3 |
0 |
Customer Group 3 |
* |
58 |
CUST_GROUP4 |
|
CRMT_CUST_GROUP4 |
CRM_CUST_GROUP4 |
CHAR |
3 |
0 |
Customer Group 4 |
* |
59 |
CUST_GROUP5 |
|
CRMT_CUST_GROUP5 |
CRM_CUST_GROUP5 |
CHAR |
3 |
0 |
Customer Group 5 |
* |
60 |
PO_NUMBER_SOLD |
|
CRMT_PO_NUMBER_SOLD |
TEXT35 |
CHAR |
35 |
0 |
Sold-To Party's External Reference Number |
|
61 |
PO_DATE_SOLD |
|
CRMT_PO_DATE_SOLD |
DATUM |
DATS |
8 |
0 |
Reference Document Date |
|
62 |
YOUR_REF_SOLD |
|
CRMT_YOUR_REFERENCE_SOLD |
TEXT12 |
CHAR |
12 |
0 |
Sold-to Party Reference |
|
63 |
PO_NUMBER_SHIP |
|
CRMT_PO_NUMBER_SHIP |
TEXT35 |
CHAR |
35 |
0 |
Ship-To Party's External Reference Number |
|
64 |
YOUR_REF_SHIP |
|
CRMT_YOUR_REFERENCE_SHIP |
TEXT12 |
CHAR |
12 |
0 |
Ship-To Party Reference |
|
65 |
USAGE_TYPE |
|
CRMT_USAGE |
CRM_USAGE |
CHAR |
3 |
0 |
Usage Indicator |
* |
66 |
SUBMISSION |
|
CRMT_SUBMISSION |
TEXT10 |
CHAR |
10 |
0 |
Collective Number for Quotations |
|
67 |
REJECTION |
|
CRMT_REJECTION_CODE |
CRM_REJECTION_CODE |
CHAR |
2 |
0 |
Cancellation Reason Code |
* |
68 |
STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
69 |
USER_STAT_PROC |
|
CRM_J_STSMA |
CRM_J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
70 |
PROCESS |
|
J_VORGANG |
J_VORGANG |
CHAR |
4 |
0 |
Business Transaction |
* |
71 |
KIND |
|
CRMT_OBJECT_KIND |
CRM_OBJECTKIND |
CHAR |
1 |
0 |
Object Type |
|
72 |
TXT04 |
|
J_TXT04 |
TEXT4 |
CHAR |
4 |
0 |
Individual status of an object (short form) |
|
73 |
TXT30 |
|
J_TXT30 |
TEXT30 |
CHAR |
30 |
0 |
Object status |
|
74 |
VALID_FROM |
|
CRMT_REPORT_FROM |
SYDATS |
DATS |
8 |
0 |
Valid from |
|
75 |
VALID_TO_TIME |
|
SC_TIMEFRO |
SYTIME |
TIMS |
6 |
0 |
From Time |
|
76 |
STAT_OPEN |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
77 |
STAT_QUOT |
|
CRMT_BOOLEAN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Logical Variable |
|
78 |
CONCATSTAT |
|
J_STEXT |
TEXT40 |
CHAR |
40 |
0 |
System status line |
|
79 |
CONCATSTATUSER |
|
J_ATEXT |
TEXT40 |
CHAR |
40 |
0 |
User Status Line |
|
80 |
VALID_FROM_TIME |
|
SC_TIMEFRO |
SYTIME |
TIMS |
6 |
0 |
From Time |
|
81 |
VALID_TO |
|
CRMT_REPORT_TO |
SYDATS |
DATS |
8 |
0 |
Valid To |
|
82 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
83 |
SALES_OFFICE |
|
CRMT_SALES_OFFICE |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Office |
|
84 |
SALES_GROUP |
|
CRMT_SALES_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Group |
|
85 |
SALES_ORG_RESP |
|
CRMT_SALES_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Sales) |
|
86 |
SERVICE_ORG |
|
CRMT_SERVICE_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Service Organization |
|
87 |
SERVICE_ORG_RESP |
|
CRMT_SERVICE_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Service) |
|
88 |
PURCH_ORG |
|
CRMT_PURCH_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Purchasing Organization |
|
89 |
PURCH_GROUP |
|
CRMT_PURCH_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Purchasing Group |
|
90 |
PURCH_ORG_RESP |
|
CRMT_PURCH_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Purchasing) |
|
91 |
PARTNER_FCT |
|
CRMT_PARTNER_FCT |
COM_PARTNER_FCT |
CHAR |
8 |
0 |
Partner Function |
|
92 |
CREATED_BY |
|
CRMT_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
User that Created the Transaction |
|
93 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
94 |
OBJECT_TYPE |
|
CRMT_SWO_OBJTYP_PROCESS_ITM_DB |
CRM_OJ_NAME_PROCESS_ITEM |
CHAR |
10 |
0 |
CRM Item Object Type |
* |
95 |
PROCESS_TYPE_TXT |
|
CRMT_REPORT_PROCESS_TYPE_TXT |
DDTEXT |
CHAR |
60 |
0 |
Text Description for Transaction Category |
|
96 |
SALES_EMPLOYEE |
|
CRMT_SALES_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee |
* |
97 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
98 |
CONTACT_PERSON |
|
CRMT_CONTACT_PERSON |
BU_PARTNER |
CHAR |
10 |
0 |
Customer Contact Person |
* |
99 |
SALESPARTNER |
|
CRMT_SALESPARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Sales Partners |
* |
100 |
ACTIVITY_PARTNER |
|
CRMT_ACTIVITY_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Activity Partner |
* |
101 |
PROSPECT |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
102 |
COMPETITOR |
|
CRMT_COMPETITOR |
BU_PARTNER |
CHAR |
10 |
0 |
Competitors |
* |
103 |
VENDOR |
|
CRMT_VENDOR |
BU_PARTNER |
CHAR |
10 |
0 |
Vendor |
* |
104 |
PLANT |
|
CRMT_PLANT |
BU_PARTNER |
CHAR |
10 |
0 |
Purchasing: Plant Represented as Partner (Ship-To Party) |
* |
105 |
SOLD_TO_PARTY |
|
CRMT_SOLD_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Sold-To Party |
* |
106 |
SHIP_TO_PARTY |
|
CRMT_SHIP_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Ship-To Party |
* |
107 |
BILL_TO_PARTY |
|
CRMT_BILL_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Bill-To Party |
* |
108 |
PAYER |
|
CRMT_RP_PAYER |
BU_PARTNER |
CHAR |
10 |
0 |
Payer |
* |
109 |
SOLD_FROM |
|
CRMT_SOLD_FROM_PARTY_ID |
BU_PARTNER |
CHAR |
10 |
0 |
Salesperson ID |
* |
110 |
SERVICE_TEAM |
|
CRMT_SERVICE_TEAM |
BU_PARTNER |
CHAR |
10 |
0 |
Service Team |
* |
111 |
SERVICE_EMPLOYEE |
|
CRMT_SERVICE_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Executing Service Employee |
* |
112 |
RESPONS_AT_PARTNER |
|
CRMT_RESPONSIBLE_AT_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Person Responsible at Partners (Channel Management) |
* |
113 |
END_CUSTOMER |
|
CRMT_END_CUSTOMER |
BU_PARTNER |
CHAR |
10 |
0 |
End Customer (Channel Management) |
* |
114 |
EXECUTING_CC |
|
CRMT_EXECUTING_CC |
BU_PARTNER |
CHAR |
10 |
0 |
Executing Interaction Center |
* |
115 |
OEM |
|
CRMT_OEM |
BU_PARTNER |
CHAR |
10 |
0 |
Original Equipment Manufacturer |
* |
116 |
OEM_LIST |
|
CRMT_OEM_PART_LIST |
TEXT80 |
CHAR |
80 |
0 |
OEM: Name |
|
117 |
OEM_GUID |
|
CRMT_PARTNER_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for an Individual Partner |
|
118 |
FROM_TIME |
|
SC_TIMEFRO |
SYTIME |
TIMS |
6 |
0 |
From Time |
|
119 |
TO_TIME |
|
SC_TIMETO |
SYTIME |
TIMS |
6 |
0 |
To Time |
|
120 |
SALES_EMPLOYEE_LIST |
|
CRMT_SALES_EMPLOYEE_LIST |
TEXT80 |
CHAR |
80 |
0 |
Sales Representative |
|
121 |
PERSON_RESP_LIST |
|
CRMT_PERSON_RESP_LIST |
TEXT80 |
CHAR |
80 |
0 |
Employee Responsible |
|
122 |
CONTACT_PERSON_LIST |
|
CRMT_CONTACT_PERSON_LIST |
TEXT80 |
CHAR |
80 |
0 |
Contact Person |
|
123 |
ACTIVITY_PARTNER_LIST |
|
CRMT_ACTIVITY_PARTNER_LIST |
TEXT80 |
CHAR |
80 |
0 |
Activity Partner |
|
124 |
SOLD_TO_PARTY_LIST |
|
CRMT_SOLD_TO_PART_LIST |
TEXT80 |
CHAR |
80 |
0 |
Sold-To Party |
|
125 |
SHIP_TO_PARTY_LIST |
|
CRMT_SHIP_TO_PART_LIST |
TEXT80 |
CHAR |
80 |
0 |
Ship-To Party: Name |
|
126 |
BILL_TO_PARTY_LIST |
|
CRMT_BILL_TO_PART_LIST |
TEXT80 |
CHAR |
80 |
0 |
Bill-To Party: Name |
|
127 |
PAYER_LIST |
|
CRMT_RP_PAYER_LIST |
TEXT80 |
CHAR |
80 |
0 |
Payer: Name |
|
128 |
COMPETITOR_LIST |
|
CRMT_COMPETITOR_LIST |
TEXT80 |
CHAR |
80 |
0 |
Competitor |
|
129 |
PROSPECT_LIST |
|
CRMT_PROSPECT_LIST |
TEXT80 |
CHAR |
80 |
0 |
Sales Prospect |
|
130 |
PO_NUMBER_UC |
|
CRMT_PO_NUMBER_UC |
CHAR35 |
CHAR |
35 |
0 |
Sold-to Party's External Reference No. (in Capital Letters) |
|
131 |
KURZTEXT |
|
QKTEXTGRCD |
QKURZTEXT80 |
CHAR |
80 |
0 |
Code Group Short Text |
|
132 |
ACT_TEXT |
|
QKTEXTGRCD |
QKURZTEXT80 |
CHAR |
80 |
0 |
Code Group Short Text |
|
133 |
REQ_TYPE |
|
CRMT_REQ_TYPE |
CRM_REQ_TYPE |
CHAR |
10 |
0 |
Request Category |
* |
134 |
TYPE_NAME |
|
CRMT_WEBREQ_DESCR |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
135 |
CHANGED_AT_DATE |
|
CRMT_CHANGED_AT_DATE |
SYDATS |
DATS |
8 |
0 |
Date on Which Transaction Was Last Changed |
|
136 |
CREATED_AT_DATE |
|
CRMT_CREATED_AT_DATE |
SYDATS |
DATS |
8 |
0 |
Transaction Was Created on This Date |
|