| 1 |
OBJECT_KEY |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
| 2 |
GUID |
|
CRMT_OBJECT_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID of a CRM Order Object |
|
| 3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for activity buffer table |
|
| 4 |
CHANGED_AT |
|
CRMT_CHANGED_AT_USR |
CRM_TSTMP |
DEC |
15 |
0 |
Changed On (Output in User Time Zone) |
|
| 5 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extract Structure for OLTP Activities Internal Fields |
|
| 6 |
OBJECT_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
| 7 |
PRIVATE_FLAG |
|
CRMT_PRIVAT |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Indicator: Task is Private |
|
| 8 |
CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
| 9 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
| 10 |
PRIORITY |
|
CRMT_PRIORITY |
SC_PRIO |
NUMC |
1 |
0 |
Activity Priority |
* |
| 11 |
DESCRIPTION_UC |
|
CRMT_PROCESS_DESCRIPTION_UC |
CRM_PROCESS_DESCRIPTION_UC |
CHAR |
40 |
0 |
Transaction Description (Upper Case) |
|
| 12 |
ACTIVITY_PARTNER |
|
CRMT_ACTIVITY_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Activity Partner |
* |
| 13 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE_DB |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
| 14 |
CONTACT_PERSON |
|
CRMT_CONTACT_PERSON |
BU_PARTNER |
CHAR |
10 |
0 |
Customer Contact Person |
* |
| 15 |
DIRECTION |
|
CRMT_DIRECTION |
CRM_DIRECTION |
CHAR |
1 |
0 |
Direction of an Activity |
|
| 16 |
FROMDATE |
|
CRMT_DATES_START_DATE |
DATUM |
DATS |
8 |
0 |
Start Date |
|
| 17 |
TODATE |
|
CRMT_DATES_END_DATE |
DATS |
DATS |
8 |
0 |
End Date |
|
| 18 |
STAT_OPEN |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
| 19 |
SALES_ORG_RESP |
|
CRMT_SALES_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Sales) |
|
| 20 |
STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
| 21 |
USER_STAT_PROC |
|
CRM_J_STSMA |
CRM_J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
| 22 |
ACT_TOT_DURA |
|
TIMEDURA |
TIMEDURA |
DEC |
13 |
0 |
Numerical Value of Duration |
|
| 23 |
ACT_TOT_UNIT |
|
TIMEUNITDU |
TIMEUNITNA |
CHAR |
12 |
0 |
Default Value for Time Unit |
* |
| 24 |
RESP_AT_PARTNER |
|
CRMT_RESPONSIBLE_AT_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Person Responsible at Partners (Channel Management) |
* |
| 25 |
CHANNEL_PARTNER |
|
CMST_CHANNEL_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Channel Partner |
* |
| 26 |
CP_PROGRAM |
|
CHM_PARTNER_PROGRAM |
CHM_PARTNER_PROGRAM |
CHAR |
4 |
0 |
Channel Management - Channel Partner Programm |
* |
| 27 |
CP_TYPE |
|
CHM_PARTNER_TYPE |
CHM_PARTNER_TYPE |
CHAR |
4 |
0 |
Channel Management - Channel Partner Type |
* |
| 28 |
CP_STATUS |
|
CHM_PARTNER_STATUS |
CHM_PARTNER_STATUS |
CHAR |
4 |
0 |
Channel Management - Channel Partner Status |
* |
| 29 |
PATH_ID |
|
CRMT_TERRITORY_PATH_ID |
CRM_TERRITORY_PATH_ID |
CHAR |
30 |
0 |
Territory Hierarchy ID |
|
| 30 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
| 31 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
| 32 |
SALES_OFFICE |
|
CRMT_SALES_OFFICE |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Office |
|
| 33 |
SALES_GROUP |
|
CRMT_SALES_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Group |
|
| 34 |
.INCLUDE |
|
|
|
|
0 |
0 |
Reporting Coherent Catgory level GUID for interaction record |
|
| 35 |
CATLVLGUID01_IR |
|
CRM_REP_CAT_GUID_LEV01_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 1- schema 1 |
|
| 36 |
CATLVLGUID02_IR |
|
CRM_REP_CAT_GUID_LEV02_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 2- schema 1 |
|
| 37 |
CATLVLGUID03_IR |
|
CRM_REP_CAT_GUID_LEV03_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 3- schema 1 |
|
| 38 |
CATLVLGUID04_IR |
|
CRM_REP_CAT_GUID_LEV04_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 4- schema 1 |
|
| 39 |
CATLVLGUID05_IR |
|
CRM_REP_CAT_GUID_LEV05_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 5- schema 1 |
|
| 40 |
CATLVLGUID06_IR |
|
CRM_REP_CAT_GUID_LEV06_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 6- schema 1 |
|
| 41 |
CATLVLGUID07_IR |
|
CRM_REP_CAT_GUID_LEV07_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 7- schema 1 |
|
| 42 |
CATLVLGUID08_IR |
|
CRM_REP_CAT_GUID_LEV08_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 8- schema 1 |
|
| 43 |
CATLVLGUID09_IR |
|
CRM_REP_CAT_GUID_LEV09_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 9- schema 1 |
|
| 44 |
CATLVLGUID10_IR |
|
CRM_REP_CAT_GUID_LEV10_S1 |
SYSUUID |
RAW |
16 |
0 |
Category GUID 10- schema 1 |
|
| 45 |
.INCLUDE |
|
|
|
|
0 |
0 |
EEW Include |
|
| 46 |
EEW_R_ACT_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|