SAP ABAP Table CACS_CRM_SALES_ORDER_CONTRA (Additional CRM Fields (Construction) From Sales Order Area)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CRM001 (Package) ICM: CRM Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CACS_CRM_SALES_ORDER_CONTRA	Table Relationship Diagram
Short Description	Additional CRM Fields (Construction) From Sales Order Area

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
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

History

Last changed by/on	SAP	20110901
SAP Release Created in	200