| 1 |
.INCLUDE |
|
|
|
|
0 |
0 |
ORDERADM_H Data for BW DataSources |
|
| 2 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
* |
| 3 |
GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 4 |
OBJECT_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
| 5 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
| 6 |
POSTING_DATE |
|
CRMT_POSTING_DATE |
|
DATS |
8 |
0 |
Posting Date for a Business Transaction |
|
| 7 |
DESCRIPTION_UC |
|
CRMT_PROCESS_DESCRIPTION_UC |
CRM_PROCESS_DESCRIPTION_UC |
CHAR |
40 |
0 |
Transaction Description (Upper Case) |
|
| 8 |
DESCR_LANGUAGE |
|
CRMT_PROCESS_DESCRIPTION_LANGU |
SPRAS |
LANG |
1 |
0 |
Language Key of Description |
* |
| 9 |
LOGICAL_SYSTEM |
|
CRMT_LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
* |
| 10 |
OBJECT_TYPE |
|
CRMT_SUBOBJECT_CATEGORY |
CRM_OJ_NAME_PROCESS |
CHAR |
10 |
0 |
Business Transaction Category |
* |
| 11 |
CREATED_AT |
|
CRMT_OPPT_CREATED_AT |
DATUM |
DATS |
8 |
0 |
Transaction Was Created at This Time |
|
| 12 |
CREATED_BY |
|
CRMT_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
User that Created the Transaction |
|
| 13 |
CHANGED_AT |
|
CRMT_OPPT_CHANGED_AT |
DATUM |
DATS |
8 |
0 |
Time of Last Change to the Transaction |
|
| 14 |
CHANGED_BY |
|
CRMT_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Transaction Last Changed By |
|
| 15 |
RECORDMODE |
|
RODMUPDMOD |
RODMUPDMOD |
CHAR |
1 |
0 |
BW Delta Process: Record Mode |
|
| 16 |
NUM_OF_HEAD |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
| 17 |
OCCURRENCE |
|
CRMT_OCC_AT_LEAST_ONCE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Counter: Document Cat. Appears at Least Once in Document |
|
| 18 |
SCENARIO |
|
CRMT_SCENARIO |
CRM_SCENARIO |
CHAR |
10 |
0 |
Scenario Identity |
|
| 19 |
TEMPLATE_TYPE |
|
CRMT_TEMPLATE_TYPE_DB |
CRM_TEMPLATE_TYPE |
CHAR |
1 |
0 |
Template Type of CRM Transaction |
|
| 20 |
OCCURR_QUOT |
|
CRMT_QUO_AT_LEAST_ONCE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Counter: Document Cat. Appears at Least Once in Document |
|
| 21 |
OCCURR_CONT |
|
CRMT_CON_AT_LEAST_ONCE |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Counter: Document Cat. Appears at Least Once in Document |
|
| 22 |
REF_UPDATE |
|
CRMT_FLG_REF_UPDATE_BW |
XFELD |
CHAR |
1 |
0 |
Flag: Ref. Update (Extract Structure Only Partially Filled) |
|
| 23 |
INPUT_CHANNEL |
|
CRMT_INPUT_CHANNEL |
CRM_INPUT_CHANNEL |
CHAR |
3 |
0 |
Input channel |
|
| 24 |
CREATED_TS |
|
COMT_CREATED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Created At (Output in User Time Zone) |
|
| 25 |
CHANGED_TS |
|
COMT_CHANGED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Changed At (Output in User Time Zone) |
|
| 26 |
.INCLUDE |
|
|
|
|
0 |
0 |
Activities Header Data for BW Data Sources |
|
| 27 |
CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
| 28 |
PRIORITY |
|
CRMT_PRIORITY |
SC_PRIO |
NUMC |
1 |
0 |
Activity Priority |
* |
| 29 |
OBJECTIVE |
|
CRMT_OBJECTIVE |
CRM_OBJECTIVE |
CHAR |
3 |
0 |
Goal of an Activity |
* |
| 30 |
DIRECTION |
|
CRMT_DIRECTION |
CRM_DIRECTION |
CHAR |
1 |
0 |
Direction of an Activity |
|
| 31 |
.INCLUDE |
|
|
|
|
0 |
0 |
PARTNER (Sales) Data for BW DataSources |
|
| 32 |
SOLD_TO_PARTY |
|
CRMT_SOLD_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Sold-To Party |
* |
| 33 |
SHIP_TO_PARTY |
|
CRMT_SHIP_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Ship-To Party |
* |
| 34 |
BILL_TO_PARTY |
|
CRMT_BILL_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Bill-To Party |
* |
| 35 |
PAYER |
|
CRMT_RP_PAYER |
BU_PARTNER |
CHAR |
10 |
0 |
Payer |
* |
| 36 |
SOLD_FROM |
|
CRMT_SOLD_FROM_PARTY_ID |
BU_PARTNER |
CHAR |
10 |
0 |
Salesperson ID |
* |
| 37 |
.INCLUDE |
|
|
|
|
0 |
0 |
PARTNER (General) Data for BW DataSoures |
|
| 38 |
SALES_EMPLOYEE |
|
CRMT_SALES_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Employee |
* |
| 39 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
| 40 |
CONTACT_PERSON |
|
CRMT_CONTACT_PERSON |
BU_PARTNER |
CHAR |
10 |
0 |
Customer Contact Person |
* |
| 41 |
SALESPARTNER |
|
CRMT_SALESPARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Sales Partners |
* |
| 42 |
RESP_GROUP_RFW |
|
CRMT_RESPONSIBLE_GROUP |
BU_PARTNER |
CHAR |
10 |
0 |
Responsible Group |
* |
| 43 |
PLANNING_ACCOUNT |
|
CRMT_PLANNING_ACCOUNT |
BU_PARTNER |
CHAR |
10 |
0 |
Planning Account |
* |
| 44 |
.INCLUDE |
|
|
|
|
0 |
0 |
PARTNER (Call Center) Data for BW Datasoures |
|
| 45 |
EXECUTING_CC |
|
CRMT_EXECUTING_CC |
BU_PARTNER |
CHAR |
10 |
0 |
Executing Interaction Center |
* |
| 46 |
RESP_GROUP |
|
CRMT_RESPONSIBLE_GROUP |
BU_PARTNER |
CHAR |
10 |
0 |
Responsible Group |
* |
| 47 |
.INCLUDE |
|
|
|
|
0 |
0 |
ORGMAN Data for BW DataSources |
|
| 48 |
SALES_ORG_RESP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 49 |
SALES_ORG |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 50 |
SALES_OFFICE |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 51 |
SALES_GROUP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 52 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
| 53 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
| 54 |
SERVICE_ORG_RESP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 55 |
SERVICE_ORG |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 56 |
PURCH_ORG_RESP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 57 |
PURCH_ORG |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 58 |
PURCH_GROUP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
| 59 |
IC_BD_CCODE |
|
CRM_IC_BD_CCODE |
BUKRS |
CHAR |
4 |
0 |
Company Code for a Business Transaction |
* |
| 60 |
IC_BD_LOGSYS |
|
CRM_IC_BD_LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System for a Business Transaction |
* |
| 61 |
.INCLUDE |
|
|
|
|
0 |
0 |
Service Partner for BW Extraction |
|
| 62 |
SERVICE_TEAM |
|
CRMT_SERVICE_TEAM |
BU_PARTNER |
CHAR |
10 |
0 |
Service Team |
* |
| 63 |
SERVICE_EMPLOYEE |
|
CRMT_SERVICE_EMPLOYEE |
BU_PARTNER |
CHAR |
10 |
0 |
Executing Service Employee |
* |
| 64 |
.INCLUDE |
|
|
|
|
0 |
0 |
PRICING_H Data for BW DataSources |
|
| 65 |
EXCHG_TYPE |
|
CRMT_EXCHG_TYPE |
KURST |
CHAR |
4 |
0 |
Exchange Rate Type |
* |
| 66 |
EXCHG_DATE |
|
CRMT_EXCHG_DATE |
CRM_EXCHG_DATE |
DATS |
8 |
0 |
Exchange Rate Date |
|
| 67 |
EXCHG_RATE |
|
CRMT_EXCHG_RATE |
CRM_EXCHG_RATE |
DEC |
9 |
5 |
Exchange Rate |
|
| 68 |
CURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
| 69 |
PRICE_DATE |
|
CRMT_PRICE_DATE |
CRM_PRICE_DATE |
DATS |
8 |
0 |
Pricing Date |
|
| 70 |
REF_CURRENCY |
|
CRMT_REF_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Reference Currency |
* |
| 71 |
PMNTTRMS |
|
CRMT_PMNTTRMS |
CRM_PMNTTRMS |
CHAR |
4 |
0 |
Terms of Payment |
* |
| 72 |
CUST_GROUP |
|
CRMT_CUST_GROUP |
CRM_CUST_GROUP |
CHAR |
2 |
0 |
Customer Group |
* |
| 73 |
CUSTOMER_TYPE |
|
CRMT_CUSTOMER_TYPE |
BU_KIND |
CHAR |
4 |
0 |
Business Partner Type |
* |
| 74 |
.INCLUDE |
|
|
|
|
0 |
0 |
Time Characteristics for BW Reporting |
|
| 75 |
CALDAY |
|
SMOCALDAY |
DATUM |
DATS |
8 |
0 |
Calendar Day |
|
| 76 |
CALDAY_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 77 |
.INCLUDE |
|
|
|
|
0 |
0 |
DOC_FLOW Data for BW DataSources |
|
| 78 |
PREDEC_OBJKEY |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 79 |
PREDEC_OBJTYPE |
|
CRMT_PRED_OBJECT_TYPE |
OJ_NAME |
CHAR |
10 |
0 |
Object Type of a Preceding Document |
* |
| 80 |
LOGSYS_PRED |
|
CRMT_LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
* |
| 81 |
MKT_ELEMENT |
|
CRM_MKTPL_MKT_PLAN_TASKID |
CGPL_EXTID |
CHAR |
24 |
0 |
Marketing Plan Element |
|
| 82 |
PRED_LEAD_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 83 |
LEAD_CREATED_AT |
|
CRMT_OPPT_CREATED_AT |
DATUM |
DATS |
8 |
0 |
Transaction Was Created at This Time |
|
| 84 |
PRED_OPPT_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 85 |
OPPT_CREATED_AT |
|
CRMT_OPPT_CREATED_AT |
DATUM |
DATS |
8 |
0 |
Transaction Was Created at This Time |
|
| 86 |
PRED_ACT_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 87 |
ACT_CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
| 88 |
ACT_DIRECTION |
|
CRMT_DIRECTION |
CRM_DIRECTION |
CHAR |
1 |
0 |
Direction of an Activity |
|
| 89 |
QUOTATION_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 90 |
QUOT_VALID_FROM |
|
CRMT_VALID_FROM_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Quotation Valid from Date |
|
| 91 |
PROCESS_CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
| 92 |
PROCESS_CATALOG |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 93 |
PROCESS_CODEGR |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 94 |
PROCESS_CODE |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 95 |
PROCESS_OBJTYPE |
|
CRMT_PRED_OBJECT_TYPE |
OJ_NAME |
CHAR |
10 |
0 |
Object Type of a Preceding Document |
* |
| 96 |
PO_NUMBER |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
| 97 |
PO_ITEM_NUMBER |
|
CRMT_ITEM_NO |
CRM_ITEM_NO |
NUMC |
10 |
0 |
Item Number in Document |
|
| 98 |
LEAD_CREATED_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 99 |
OPPT_CREATED_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 100 |
QUOT_VALID_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 101 |
.INCLUDE |
|
|
|
|
0 |
0 |
SRV_SUBJECT Data for BW Extraction |
|
| 102 |
CATALOG_TYPE_C |
|
CRMT_CATALOGTYPE |
CRM_CATALOGTYPE |
CHAR |
1 |
0 |
Catalog Category |
|
| 103 |
KATALOGART_C |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 104 |
CODEGRUPPE_C |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 105 |
CODE_C |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 106 |
DEFECTCLASS_C |
|
CRMT_DEFECTCLASS |
CRM_DEFECTCLASS |
CHAR |
2 |
0 |
Defect Class |
* |
| 107 |
QUALITY_C |
|
CRMT_QUALITY |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Quality Defect |
|
| 108 |
DEFQUANTITY_C |
|
CRMT_DEFQUANTITY |
CRM_DEFQUANTITY |
INT4 |
10 |
0 |
Defect Count |
|
| 109 |
COUNTER_C |
|
CRMT_NOACT |
NUMC1 |
NUMC |
1 |
0 |
Number of Activities (always 1) |
|
| 110 |
ASP_ID_C |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 111 |
CAT_ID_C |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 112 |
CC_CAT_SUBJECT_C |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 113 |
CATALOG_TYPE_D |
|
CRMT_CATALOGTYPE |
CRM_CATALOGTYPE |
CHAR |
1 |
0 |
Catalog Category |
|
| 114 |
KATALOGART_D |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 115 |
CODEGRUPPE_D |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 116 |
CODE_D |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 117 |
DEFECTCLASS_D |
|
CRMT_DEFECTCLASS |
CRM_DEFECTCLASS |
CHAR |
2 |
0 |
Defect Class |
* |
| 118 |
QUALITY_D |
|
CRMT_QUALITY |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Quality Defect |
|
| 119 |
DEFQUANTITY_D |
|
CRMT_DEFQUANTITY |
CRM_DEFQUANTITY |
INT4 |
10 |
0 |
Defect Count |
|
| 120 |
COUNTER_D |
|
CRMT_NOACT |
NUMC1 |
NUMC |
1 |
0 |
Number of Activities (always 1) |
|
| 121 |
ASP_ID_D |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 122 |
CAT_ID_D |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 123 |
CC_CAT_SUBJECT_D |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 124 |
CATALOG_TYPE_E |
|
CRMT_CATALOGTYPE |
CRM_CATALOGTYPE |
CHAR |
1 |
0 |
Catalog Category |
|
| 125 |
KATALOGART_E |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 126 |
CODEGRUPPE_E |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 127 |
CODE_E |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 128 |
DEFECTCLASS_E |
|
CRMT_DEFECTCLASS |
CRM_DEFECTCLASS |
CHAR |
2 |
0 |
Defect Class |
* |
| 129 |
QUALITY_E |
|
CRMT_QUALITY |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Quality Defect |
|
| 130 |
DEFQUANTITY_E |
|
CRMT_DEFQUANTITY |
CRM_DEFQUANTITY |
INT4 |
10 |
0 |
Defect Count |
|
| 131 |
COUNTER_E |
|
CRMT_NOACT |
NUMC1 |
NUMC |
1 |
0 |
Number of Activities (always 1) |
|
| 132 |
ASP_ID_E |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 133 |
CAT_ID_E |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 134 |
CC_CAT_SUBJECT_E |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 135 |
CATALOG_TYPE_T |
|
CRMT_CATALOGTYPE |
CRM_CATALOGTYPE |
CHAR |
1 |
0 |
Catalog Category |
|
| 136 |
KATALOGART_T |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 137 |
CODEGRUPPE_T |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 138 |
CODE_T |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 139 |
DEFECTCLASS_T |
|
CRMT_DEFECTCLASS |
CRM_DEFECTCLASS |
CHAR |
2 |
0 |
Defect Class |
* |
| 140 |
QUALITY_T |
|
CRMT_QUALITY |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Quality Defect |
|
| 141 |
DEFQUANTITY_T |
|
CRMT_DEFQUANTITY |
CRM_DEFQUANTITY |
INT4 |
10 |
0 |
Defect Count |
|
| 142 |
COUNTER_T |
|
CRMT_NOACT |
NUMC1 |
NUMC |
1 |
0 |
Number of Activities (always 1) |
|
| 143 |
ASP_ID_T |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 144 |
CAT_ID_T |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 145 |
CC_CAT_SUBJECT_T |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 146 |
CATALOG_TYPE_W |
|
CRMT_CATALOGTYPE |
CRM_CATALOGTYPE |
CHAR |
1 |
0 |
Catalog Category |
|
| 147 |
KATALOGART_W |
|
COMT_CATALOG |
COM_CATALOG |
CHAR |
2 |
0 |
Catalog |
* |
| 148 |
CODEGRUPPE_W |
|
QCODEGRP |
QCODEGRP |
CHAR |
8 |
0 |
Code Group |
* |
| 149 |
CODE_W |
|
QCODE |
QCODE |
CHAR |
4 |
0 |
Code |
* |
| 150 |
DEFECTCLASS_W |
|
CRMT_DEFECTCLASS |
CRM_DEFECTCLASS |
CHAR |
2 |
0 |
Defect Class |
* |
| 151 |
QUALITY_W |
|
CRMT_QUALITY |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Quality Defect |
|
| 152 |
DEFQUANTITY_W |
|
CRMT_DEFQUANTITY |
CRM_DEFQUANTITY |
INT4 |
10 |
0 |
Defect Count |
|
| 153 |
COUNTER_W |
|
CRMT_NOACT |
NUMC1 |
NUMC |
1 |
0 |
Number of Activities (always 1) |
|
| 154 |
ASP_ID_W |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 155 |
CAT_ID_W |
|
CRM_ERMS_CAT_AS_ID |
CRM_ERMS_CAT_AS_ID_DO |
CHAR |
40 |
0 |
Coherent Cat. - Aspect ID |
|
| 156 |
CC_CAT_SUBJECT_W |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 157 |
PROFILE_TYPE |
|
CRMT_SUBJECT_PROFILE_TYPE |
CRM_SUBJECT_PROFILE_TYPE |
CHAR |
2 |
0 |
Subject Profile Category |
|
| 158 |
CC_CAT_SUBJECT |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 159 |
.INCLUDE |
|
|
|
|
0 |
0 |
STATUS_H - Data for BW DataSources |
|
| 160 |
STATUS_INQU |
|
CRMT_STATUS_H_INQUIRY |
CRM_STATUS_H_INQUIRY |
CHAR |
1 |
0 |
Inquiry Status |
|
| 161 |
STATUS_QUOT |
|
CRMT_STATUS_H_QUOTATION |
CRM_STATUS_H_QUOTATION |
CHAR |
1 |
0 |
Quotation Status |
|
| 162 |
STATUS_REJECTION |
|
CRMT_REJECTION_STATUS |
CRM_REJECTION_STATUS |
CHAR |
1 |
0 |
Rejection Status |
|
| 163 |
.INCLUDE |
|
|
|
|
0 |
0 |
STATUS GROUPS Data for BW Datasources |
|
| 164 |
BWSTONESYS0 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 165 |
BWSTONESYS1 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 166 |
BWSTONESYS2 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 167 |
BWSTONESYS3 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 168 |
BWSTONESYS4 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 169 |
BWSTONESYS5 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 170 |
BWSTONESYS6 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 171 |
BWSTONESYS7 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 172 |
BWSTONESYS8 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 173 |
BWSTONESYS9 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 174 |
BWSTONESYSA |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 175 |
BWSTTECSYS0 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 176 |
BWSTTECSYS1 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 177 |
BWSTTECSYS2 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 178 |
BWSTLOCSYS0 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 179 |
BWSTLOCSYS1 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 180 |
BWSTLOCSYS2 |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 181 |
BWSTONESYSB |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 182 |
BWSTONESYSC |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 183 |
.INCLUDE |
|
|
|
|
0 |
0 |
CUMULATED_H Data for BW Data Sources |
|
| 184 |
GROSS_VALUE_H |
|
CRMT_GROSS_VALUE_CUM |
WERTV8 |
CURR |
15 |
2 |
Total Gross Value of Document in Document Currency |
|
| 185 |
NET_VALUE_H |
|
CRMT_NET_VALUE_CUM |
WERTV8 |
CURR |
15 |
2 |
Total Net Value of Document in Document Currency |
|
| 186 |
NET_VALUE_MAN_H |
|
CRMT_NET_VALUE_MAN_CUM |
WERTV8 |
CURR |
15 |
2 |
Expected Total Net Value of Products in Document Currency |
|
| 187 |
.INCLUDE |
|
|
|
|
0 |
0 |
Territory Data for BW Data Sources (Partner Attribute) |
|
| 188 |
PATH_GUID |
|
CRMT_PATH_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
Path GUID of Territory 32 |
|
| 189 |
TERR_GUID |
|
CRMT_TERR_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
Territory GUID 32 |
|
| 190 |
.INCLUDE |
|
|
|
|
0 |
0 |
REFOBJ Data for BW DataSources |
|
| 191 |
GUID_OBJECT |
|
CRMT_PRODUCT_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Product CHAR32 |
|
| 192 |
GUID_OBJ_OBJFAM |
|
COMT_PRODUCT_OBJECT_FAMILY |
COM_PRODUCT_OBJECT_FAMILY |
CHAR |
4 |
0 |
Object Family |
* |
| 193 |
BOSS_OBJTYP |
|
CRMT_TYPE_OBJECT |
TYPE_OBJECT |
CHAR |
1 |
0 |
Object Type for Reference Object in Subject Set |
|
| 194 |
BOSS_IOBJ_GUID |
|
CRMT_PRODUCT_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Product CHAR32 |
|
| 195 |
BOSS_IOBJ_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
| 196 |
BOSS_CFPRD_GUID |
|
CRMT_PRODUCT_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Product CHAR32 |
|
| 197 |
BOSS_CFPRD_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
| 198 |
BOSS_PROD_GUID |
|
CRMT_PRODUCT_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Product CHAR32 |
|
| 199 |
BOSS_PROD_ID |
|
COMT_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
| 200 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Service-Specific Data for BW DataSources |
|
| 201 |
KF_SRV_RREADY |
|
CRMT_BW_SRV_DATES |
CRMT_BW_SRV_DATES |
INT1 |
3 |
0 |
Data Element for Service - Date Key Figures |
|
| 202 |
KF_SRV_CUST_END |
|
CRMT_BW_SRV_DATES |
CRMT_BW_SRV_DATES |
INT1 |
3 |
0 |
Data Element for Service - Date Key Figures |
|
| 203 |
CHA_SRV_RREADY |
|
CHA_SRV_RREADY |
CRMT_BW_SRV_CHA_DATES |
CHAR |
1 |
0 |
Data Element for Service-Date Characteristic SLA Date |
|
| 204 |
CHA_SRV_CUST_END |
|
CHA_SRV_CUST_END |
CRMT_BW_SRV_CHA_DATES |
CHAR |
1 |
0 |
Data Element for Service-Date Char. :Date Requested by Cust. |
|
| 205 |
PLAN_FLAG |
|
CRMT_BW_PLAN_FLAG |
CRMT_BW_PLAN_FLAG |
CHAR |
2 |
0 |
Planning Indicator |
|
| 206 |
DISPO_FLG |
|
CRMT_SRV_DISPO_FLG |
FLAG |
CHAR |
1 |
0 |
Relevant for Resource Planning |
|
| 207 |
CONFIRM_RELEVANT |
|
CRMT_CONFIRM_RELEVANT |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Relevant for Confirmation |
|
| 208 |
AC_INDICATOR |
|
CRMT_AC_INDICATOR |
CRMT_AC_INDICATOR |
CHAR |
2 |
0 |
Accounting Indicator |
* |
| 209 |
SERVICE_TYPE |
|
CRMT_SERVICE_TYPE |
CRMT_SERVICE_TYPE |
CHAR |
4 |
0 |
Service Type |
* |
| 210 |
VALUATION_TYPE |
|
CRMT_VALUATION_TYPE |
CRMT_VALUATION_TYPE |
CHAR |
6 |
0 |
Valuation Type |
* |
| 211 |
SRV_ESCAL |
|
CRMT_SRV_ESCAL |
CRM_SRV_ESCAL |
CHAR |
10 |
0 |
Response Profile |
* |
| 212 |
SRV_SERWI |
|
CRMT_SRV_SERWI |
CRM_SRV_SERWI |
CHAR |
10 |
0 |
Service Profile |
* |
| 213 |
DURATION |
|
CRMT_SRV_DURATION |
MENG13 |
QUAN |
13 |
3 |
Duration |
|
| 214 |
DURATION_UNIT |
|
CRMT_SRV_DURATION_UOM |
MEINS |
UNIT |
3 |
0 |
Unit for Duration of Work |
* |
| 215 |
PERSONS |
|
CRMT_SRV_PERSONS |
NUMC3 |
NUMC |
3 |
0 |
Number of Persons |
|
| 216 |
STATUS_OPEN_SRV |
|
CRMT_BW_STATUS_ASSIGN |
CRMT_BW_STATUS_ASSIGN |
INT1 |
3 |
0 |
Status Identifier |
|
| 217 |
STATUS_IP_SRV |
|
CRMT_BW_STATUS_ASSIGN |
CRMT_BW_STATUS_ASSIGN |
INT1 |
3 |
0 |
Status Identifier |
|
| 218 |
STATUS_RE_SRV |
|
CRMT_BW_STATUS_ASSIGN |
CRMT_BW_STATUS_ASSIGN |
INT1 |
3 |
0 |
Status Identifier |
|
| 219 |
STATUS_CO_SRV |
|
CRMT_BW_STATUS_ASSIGN |
CRMT_BW_STATUS_ASSIGN |
INT1 |
3 |
0 |
Status Identifier |
|
| 220 |
LC_SRV_DURATION |
|
CRMT_BW_LIFECYCLE |
CRMT_DAUER_10_3 |
QUAN |
10 |
3 |
CRM Service: Lifecycle (Duration) |
|
| 221 |
LC_SRV_DUR_UNIT |
|
CRMT_BW_LIFECYCLE_UNIT |
MEINS |
UNIT |
3 |
0 |
CRM Service Lifecycle Unit (Duration) |
* |
| 222 |
BILL_RELEVANT |
|
CRMT_BILLING_RELEVANT |
CRM_BILLING_RELEVANT |
CHAR |
1 |
0 |
Billing Relevance |
|
| 223 |
WARRANTY |
|
CRMT_PRODUCT_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Product CHAR32 |
|
| 224 |
WARRANTY_ID |
|
CRMT_WTY_PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Warranty ID |
|
| 225 |
PRED_PSL_OBJKEY |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 226 |
PRED_TMPL_OBJKEY |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
| 227 |
CONTR_OBJ_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
| 228 |
.INCLUDE |
|
|
|
|
0 |
0 |
Specific Service Process Header Fields for BW DataSource |
|
| 229 |
BWSTONESVTK |
|
CRMBWST |
J_STONR |
NUMC |
2 |
0 |
BW Status |
|
| 230 |
.INCLUDE |
|
|
|
|
0 |
0 |
Service Request Header Data for BW Data Sources |
|
| 231 |
REC_PRIORITY |
|
CRMT_SRQM_REC_PRIORITY |
SC_PRIO |
NUMC |
1 |
0 |
Recommended Priority |
* |
| 232 |
URGENCY |
|
CRMT_SRQM_URGENCY |
CRM_SRQM_URGENCY |
NUMC |
2 |
0 |
Urgency |
* |
| 233 |
IMPACT |
|
CRMT_SRQM_IMPACT |
CRM_SRQM_IMPACT |
NUMC |
2 |
0 |
Impact |
* |
| 234 |
ESCALATION |
|
CRMT_SRQM_ESCALATION |
CRM_SRQM_ESCALATION |
NUMC |
1 |
0 |
Escalation |
|
| 235 |
CHANGE_CATEGORY |
|
CRMT_SRQM_CHANGE_CAT |
CRM_SRQM_CHANGE_CAT |
CHAR |
3 |
0 |
Change Category |
* |
| 236 |
RISK |
|
CRMT_SRQM_RISK |
CRM_SRQM_RISK |
NUMC |
3 |
0 |
Risk |
* |
| 237 |
PROBLEM_CATEGORY |
|
CRMT_SRQM_PROBLEM_CATEGORY |
CRM_SRQM_PROBLEM_CATEGORY |
CHAR |
3 |
0 |
Problem Category |
* |
| 238 |
LAST_UPDATED_AT |
|
CRMT_SRQM_LAST_UPDATED_AT |
COM_TSTMP |
DEC |
15 |
0 |
Last Updated On |
|
| 239 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Service-Specific Dates for BW DataSources |
|
| 240 |
ESCALATE_1_DATE |
|
CRMT_BW_ESCALATION_1_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Escalation Date Level 1 |
|
| 241 |
ESCALATE_2_DATE |
|
CRMT_BW_ESCALATION_2_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Escalation Date Level 2 |
|
| 242 |
WORK_DURATION |
|
CRMT_BW_DURATION |
TIMEDURA |
DEC |
13 |
0 |
Duration of Contract/Quotation |
|
| 243 |
WORK_DURA_UNIT |
|
CRMT_BW_DURA_UNIT |
TIMEUNITNA |
CHAR |
12 |
0 |
Time Unit for Duration of Contract/Quotation in Days |
* |
| 244 |
TOTAL_DURATION |
|
CRMT_BW_DURATION |
TIMEDURA |
DEC |
13 |
0 |
Duration of Contract/Quotation |
|
| 245 |
TOTAL_DURA_UNIT |
|
CRMT_BW_DURA_UNIT |
TIMEUNITNA |
CHAR |
12 |
0 |
Time Unit for Duration of Contract/Quotation in Days |
* |
| 246 |
REQ_START_DATE |
|
CRMT_BW_REQ_START_DATE |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp: Requested Start Date/Time |
|
| 247 |
REQ_END_DATE |
|
CRMT_BW_REQ_END_DATE |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp: Requested End Date/Time |
|
| 248 |
COMPLETION_DATE |
|
CRMT_BW_CLOSE_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Closing Date |
|
| 249 |
DUE_DATE |
|
CRMT_BW_DUE_DATE |
BCOS_TSTMP |
DEC |
15 |
0 |
Timestamp: Due Date/Time |
|
| 250 |
COMPLETION_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 251 |
ESCALATE_1_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 252 |
ESCALATE_2_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 253 |
VALID_FROM_DATE |
|
CRMT_VALID_FROM_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Quotation Valid from Date |
|
| 254 |
VALID_FROM_TS |
|
CRMT_DATE_TIMESTAMP_FROM |
BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp (Date and Time) of a Date/Duration |
|
| 255 |
VALID_TO_DATE |
|
CRMT_VALID_TO_DATE |
CRM_RPRTNG_DATE |
DATS |
8 |
0 |
Quotation: Valid to Date |
|
| 256 |
VALID_TO_TS |
|
CRMT_DATE_TIMESTAMP_TO |
BCOS_TSTMP |
DEC |
15 |
0 |
Time stamp (Date and Time) until a Date/Duration |
|
| 257 |
HIGHEST_ITEM_NO |
|
CRMT_HIGHEST_ITEM_NUMBER |
CRM_ITEM_NO |
NUMC |
10 |
0 |
Highest item number for a document |
|
| 258 |
CC_CAT_ACTREASON |
|
CRM_ERMS_CAT_GUID |
SYSUUID |
RAW |
16 |
0 |
Multilevel Cat. - GUID Data Element |
|
| 259 |
NO_OF_IR |
|
CRMT_NO_OF_IR |
|
INT4 |
10 |
0 |
Number of Interaction Records |
|
| 260 |
IN_COMPL_BEFORE |
|
CRMT_SRV_REQ_STAT_COMP_BEFORE |
|
INT4 |
10 |
0 |
Status Is In Process but Was Previously Completed |
|
| 261 |
LINKED_INCIDENTS |
|
CRMT_SRV_REQ_RFC_INCI |
CRM_SRV_REQ_NUM_INCI |
INT4 |
10 |
0 |
Number of Incidents Linked to Request for Change |
|
| 262 |
LINKED_PROBLEMS |
|
CRMT_SRV_REQ_RFC_PROB |
CRM_SRV_REQ_NUM_INCI |
INT4 |
10 |
0 |
Number of Problems Linked to Request for Change |
|
| 263 |
BTX_CLASS |
|
CRMT_TRANSACTION_CLASSIFICATN |
CRM_TRANSACTION_CLASSIFICATION |
CHAR |
1 |
0 |
CRM Business Transaction Classification |
|