1 |
.INCLUDE |
|
|
|
|
0 |
0 |
ORDERADM_H Data for Business Warehouse (BW) |
|
2 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
* |
3 |
GUID |
|
CACS_CRM_PROZESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
Transaction GUID |
|
4 |
OBJECT_ID |
|
CACS_CRM_OBJECT_ID |
CACS_CRM_OBJEKT_ID |
CHAR |
10 |
0 |
Transaction Number |
|
5 |
PROCESS_TYPE |
|
CACS_CRM_PROCESS_TYPE |
CACS_CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
|
6 |
POSTING_DATE |
|
CACS_CRM_POSTING_DATE |
|
DATS |
8 |
0 |
Posting Date of Business Transaction |
|
7 |
LOGICAL_SYSTEM |
|
CACS_CRM_LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
* |
8 |
OBJECT_TYPE |
|
CACS_CRM_SUBOBJECT_CATEGORY |
CACS_CRM_OJ_NAME_PROCESS |
CHAR |
10 |
0 |
Business Transaction Category |
|
9 |
.INCLUDE |
|
|
|
|
0 |
0 |
ORDERADM_I Data for Business Warehouse (BW) |
|
10 |
ITEM_GUID |
|
CACS_CRM_PROZESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
Transaction GUID |
|
11 |
ORDER_DATE |
|
CACS_CRM_OPPT_ORDER_DATE |
DATUM |
DATS |
8 |
0 |
Posting Date |
|
12 |
NUMBER_INT |
|
CACS_CRM_ITEM_NO |
CACS_CRM_ITEM_NO |
NUMC |
10 |
0 |
Document Item Number |
|
13 |
ITEM_OBJECT_TYPE |
|
CACS_CRM_SWO_OBJTYP_PROCESS_IT |
CACS_CRM_OJ_NAME_PROCESS_ITEM |
CHAR |
10 |
0 |
Object Type in CRM Posting Item |
|
14 |
ITM_TYPE |
|
CACS_CRM_ITEM_TYPE |
CACS_CRM_ITEM_TYPE |
CHAR |
4 |
0 |
Posting Item Category |
|
15 |
.INCLUDE |
|
|
|
|
0 |
0 |
Partner - Data for Business Warehouse (BW) |
|
16 |
SOLD_TO_PARTY |
|
CACS_CRM_SOLD_TO_PART |
BU_PARTNER |
CHAR |
10 |
0 |
Customer |
* |
17 |
.INCLUDE |
|
|
|
|
0 |
0 |
ORMMAN Data for Business Warehouse (BW) |
|
18 |
SALES_ORG_RESP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
19 |
SALES_ORG |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
20 |
SALES_OFFICE |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
21 |
SALES_GROUP |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
22 |
DIS_CHANNEL |
|
CACS_CRM_DISTRIBUTION_CHANNEL |
CACS_CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
|
23 |
DIVISION |
|
CACS_CRM_DIVISION |
CACS_CRM_DIVISION |
CHAR |
2 |
0 |
Unit |
|
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Data for Business Warehouse (BW) |
|
25 |
CUST_GROUP1 |
|
CACS_CRM_CUST_GROUP1 |
CACS_CRM_CUST_GROUP1 |
CHAR |
3 |
0 |
Customer group 1 |
|
26 |
CUST_GROUP2 |
|
CACS_CRM_CUST_GROUP2 |
CACS_CRM_CUST_GROUP2 |
CHAR |
3 |
0 |
Customer group 2 |
|
27 |
CUST_GROUP3 |
|
CACS_CRM_CUST_GROUP3 |
CACS_CRM_CUST_GROUP3 |
CHAR |
3 |
0 |
Customer group 3 |
|
28 |
CUST_GROUP4 |
|
CACS_CRM_CUST_GROUP4 |
CACS_CRM_CUST_GROUP4 |
CHAR |
3 |
0 |
Customer group 4 |
|
29 |
CUST_GROUP5 |
|
CACS_CRM_CUST_GROUP5 |
CACS_CRM_CUST_GROUP5 |
CHAR |
3 |
0 |
Customer group 5 |
|
30 |
INDUSTRY |
|
CACS_CRM_INDUSTRY |
CACS_CRM_INDUSTRY |
CHAR |
4 |
0 |
Industry Sector |
|
31 |
PCAT_HDR_ID |
|
CACS_COM_PCAT_ID |
CACS_COM_PCAT_OBJECTID |
CHAR |
30 |
0 |
Product - Catalog Number |
|
32 |
PCAT_VRT_ID |
|
CACS_COM_PCAT_VRT_ID |
CACS_COM_PCAT_OBJECTID |
CHAR |
30 |
0 |
Catalog Variant Number |
|
33 |
PCAT_CTY_ID |
|
CACS_COM_PCAT_CTY_ID |
CACS_COM_PCAT_OBJECTID |
CHAR |
30 |
0 |
Catalog - Sales Territory Number |
|
34 |
.INCLUDE |
|
|
|
|
0 |
0 |
Important Product Data for BW |
|
35 |
PRODUCT_ID |
|
CACS_COM_PRODUCT_ID |
CACS_COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
36 |
CATEGORY_ID |
|
CACS_COM_CATEGORY_ID |
CACS_COM_CATEGORY_ID |
CHAR |
20 |
0 |
Category ID |
|
37 |
CATALOG_ID |
|
CACS__CATALOG |
KATALOGID |
CHAR |
20 |
0 |
Selected Catalog ID |
* |
38 |
.INCLUDE |
|
|
|
|
0 |
0 |
PRODUCT_I Data for BW |
|
39 |
PROCESS_QTY_UNIT |
|
CACS_CRM_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Sales Unit |
* |
40 |
PROD_PR_GROUP |
|
CACS_CRM_PROD_PR_GROUP |
CACS_CRM_PROD_PR_GROUP |
CHAR |
2 |
0 |
Product Group |
|
41 |
PRC_GROUP1 |
|
CACS_CRM_PRC_GROUP1 |
CACS_CRM_PRC_GROUP1 |
CHAR |
3 |
0 |
Product Group 1 |
|
42 |
PRC_GROUP2 |
|
CACS_CRM_PRC_GROUP2 |
CACS_CRM_PRC_GROUP2 |
CHAR |
3 |
0 |
Product Group 2 |
|
43 |
PRC_GROUP3 |
|
CACS_CRM_PRC_GROUP3 |
CACS_CRM_PRC_GROUP3 |
CHAR |
3 |
0 |
Product Group 3 |
|
44 |
PRC_GROUP4 |
|
CACS_CRM_PRC_GROUP4 |
CACS_CRM_PRC_GROUP4 |
CHAR |
3 |
0 |
Product Group 4 |
|
45 |
PRC_GROUP5 |
|
CACS_CRM_PRC_GROUP5 |
CACS_CRM_PRC_GROUP5 |
CHAR |
3 |
0 |
Product Group 5 |
|
46 |
.INCLUDE |
|
|
|
|
0 |
0 |
PRICING_H Data for BW |
|
47 |
CURRENCY |
|
CACS_CRM_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
48 |
.INCLUDE |
|
|
|
|
0 |
0 |
PRICING_I Data for BW |
|
49 |
TARGET_VALUE |
|
CACS_CRM_TARGET_VALUE |
WERTV10 |
CURR |
19 |
2 |
Invoice Amount for a Contract |
|
50 |
NET_VALUE |
|
CACS_CRM_NET_VALUE |
WERTV8 |
CURR |
15 |
2 |
Net Value of Total Contract |
|
51 |
SUBTOTAL1 |
|
CACS_CRM_SUBTOTAL1 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 1 |
|
52 |
SUBTOTAL2 |
|
CACS_CRM_SUBTOTAL2 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 2 |
|
53 |
SUBTOTAL3 |
|
CACS_CRM_SUBTOTAL3 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 3 |
|
54 |
SUBTOTAL4 |
|
CACS_CRM_SUBTOTAL4 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 4 |
|
55 |
SUBTOTAL5 |
|
CACS_CRM_SUBTOTAL5 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 5 |
|
56 |
SUBTOTAL6 |
|
CACS_CRM_SUBTOTAL6 |
WERTV8 |
CURR |
15 |
2 |
Subtotal 6 |
|
57 |
CREDIT_INDICATOR |
|
CACS_CRM_CREDIT_INDICATOR |
CACS_CRM_CREDIT_INDICATOR |
CHAR |
1 |
0 |
Credit/Debit Indicator |
|
58 |
GROSS_VALUE |
|
CACS_CRM_GROSS_VALUE |
WERTV8 |
CURR |
15 |
2 |
Total Contract Value |
|
59 |
.INCLUDE |
|
|
|
|
0 |
0 |
CUMULATED_I Data for BW |
|
60 |
CALL_OF_QTY_CUM |
|
CACS_CRM_CALL_OF_QTY_CUM |
CACS_CRMMENGV15 |
QUAN |
15 |
3 |
Quantity Call from Contract |
|
61 |
CALL_OF_UNIT_CUM |
|
CACS_CRM_CALL_OF_QTY_UNIT_CUM |
MEINS |
UNIT |
3 |
0 |
Unit of Measure Called Up |
* |
62 |
CALL_OF_VAL_CUM |
|
CACS_CRM_CALL_OF_VALUE_CUM |
CACS_CRM_PRC_COND_VALUE |
CURR |
19 |
2 |
Value Calledd from Contract |
|
63 |
TARGET_QUAN_CUM |
|
CACS_CRM_TARGET_QUAN_CUM |
MENG13 |
QUAN |
13 |
3 |
Total Target Quantity |
|
64 |
TGT_QTY_UNIT_CUM |
|
CACS_CRM_TARGET_QTY_UNIT_CUM |
MEINS |
UNIT |
3 |
0 |
Target Quantity Unit |
* |
65 |
DELIVERY_QTY_CUM |
|
CACS_CRM_DELIVERED_QTY_CUM |
CACS_CRMMENGV15 |
QUAN |
15 |
3 |
Delivery Quantity of the Article |
|
66 |
INVOICED_QTY_CUM |
|
CACS_CRM_INVOICED_QTY_CUM |
CACS_CRMMENGV15 |
QUAN |
15 |
3 |
Invoiced Quantity of Article |
|
67 |
DELIVERY_VAL_CUM |
|
CACS_CRM_DELIVERED_VAL_CUM |
WERTV8 |
CURR |
15 |
2 |
Delivery Value of the Article |
|
68 |
INVOICED_VAL_CUM |
|
CACS_CRM_INVOICED_VAL_CUM |
WERTV8 |
CURR |
15 |
2 |
Invoice Value of Article |
|
69 |
.INCLUDE |
|
|
|
|
0 |
0 |
Table Row Quantity |
|
70 |
ORDER_QTY |
|
CACS_CRM_QTY_ORDER |
MENG13 |
QUAN |
13 |
3 |
Purchase Order Quantity |
|
71 |
CONFIRMED_QTY |
|
CACS_CRM_QTY_CONFIRMED |
MENG13 |
QUAN |
13 |
3 |
Complete Quantity |
|
72 |
.INCLUDE |
|
|
|
|
0 |
0 |
CRM Incentives - Additional Fields of Interface to ICM |
|
73 |
COMM_TRI_DATE |
|
CACS_CRM_COMMISS_TRIGGER_DATE |
|
DATS |
8 |
0 |
Date of Commission Run Start |
|
74 |
COMM_TRI_STATUS |
|
CACS_CRM_COMMISS_TRIGGER_TYPE |
CACSCRM_COMMISS_TRIGGER_TYPE |
CHAR |
2 |
0 |
Start Type for Commission (Posted, Delievered etc.) |
|
75 |
COMM_BAS_VAL |
|
CACS_CRM_COMMBAS_VALUE_CUM |
WERTV8 |
CURR |
15 |
2 |
Commission Basis Value |
|
76 |
COMM_BASIS_TYPE |
|
CACS_CRM_COMMISS_BASIS_VAL_TYP |
CACS_CRM_COMMISS_BASIS_VAL_TYP |
CHAR |
2 |
0 |
Commission Value Basis Type |
|
77 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Customer Fields (Optional) |
|
78 |
CRMDUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
79 |
.INCLUDE |
|
|
|
|
0 |
0 |
CACSCRM: Fields for Preconfiguration (not CRM) |
|
80 |
INCENTIVE_BAS |
|
INCENTIVE_BASIS_VALUE_CUM |
WERTV8 |
CURR |
15 |
2 |
Bonus Basis Value |
|