SAP ABAP Table CRMT_ICM_SALES_ORDER_CONTRA_I (Extraction structure for ICM Commissions Engine)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-ICM (Application Component) Incentive and Commission Management
⤷

CRM-ICM (Package) Incentive and Commission Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ICM_SALES_ORDER_CONTRA_I	Table Relationship Diagram
Short Description	Extraction structure for ICM Commissions Engine

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	CRM Incentives - Sales document - admin data - header
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	LOGICAL_SYSTEM	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
8	OBJECT_TYPE	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
9	.INCLUDE				0	0	CRM Incentives - Sales document - admin data - line item
10	ITEM_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
11	ORDER_DATE	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
12	NUMBER_INT	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
13	ITEM_OBJECT_TYPE	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
14	ITM_TYPE	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
15	.INCLUDE				0	0	CRM Incentives - Sales document - partner (sales) data
16	SOLD_TO_PARTY	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
17	.INCLUDE				0	0	CRM Incentives - Sales document - org management data
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	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
23	DIVISION	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
24	.INCLUDE				0	0	CRM Incentives - Sales document - sales data
25	CUST_GROUP1	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
26	CUST_GROUP2	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
27	CUST_GROUP3	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
28	CUST_GROUP4	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
29	CUST_GROUP5	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
30	INDUSTRY	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
31	PCAT_HDR_ID	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
32	PCAT_VRT_ID	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
33	PCAT_CTY_ID	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
34	.INCLUDE				0	0	CRM Incentives - Sales document - product general data
35	PRODUCT_ID	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
36	CATEGORY_ID	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
37	CATALOG_ID	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
38	.INCLUDE				0	0	CRM Incentives - Sales document - product master data
39	PROCESS_QTY_UNIT	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
40	PROD_PR_GROUP	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
41	PRC_GROUP1	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
42	PRC_GROUP2	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
43	PRC_GROUP3	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
44	PRC_GROUP4	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
45	PRC_GROUP5	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
46	.INCLUDE				0	0	CRM Incentives - Sales document - pricing data - header
47	CURRENCY	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
48	PAYMENT_AMOUNT	CRMT_PAYMENT_AMT	WERTV8	CURR	15	2	Sum of Invoice Payments
49	.INCLUDE				0	0	CRM Incentives - Sales document - pricing data - line item
50	TARGET_VALUE	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
51	NET_VALUE	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
52	SUBTOTAL1	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
53	SUBTOTAL2	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
54	SUBTOTAL3	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
55	SUBTOTAL4	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
56	SUBTOTAL5	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
57	SUBTOTAL6	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
58	CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
59	GROSS_VALUE	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
60	.INCLUDE				0	0	CRM Incentives - Sales document - cumulated data - line item
61	CALL_OF_QTY_CUM	CRMT_CALL_OF_QTY_CUM	CRM_MENGV15	QUAN	15	3	Quantity Retrieved for a Contract
62	CALL_OF_UNIT_CUM	CRMT_CALL_OF_QTY_UNIT_CUM	MEINS	UNIT	3	0	Quantity Unit Called	*
63	CALL_OF_VAL_CUM	CRMT_CALL_OF_VALUE_CUM	CRM_COND_VALUE	CURR	19	2	Released Value for a Contract
64	TARGET_QUAN_CUM	CRMT_TARGET_QUAN_CUM	MENG13	QUAN	13	3	Target Quantity Cumulated
65	TGT_QTY_UNIT_CUM	CRMT_TARGET_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit for a Target Quantity	*
66	DELIVERY_QTY_CUM	CRMT_DELIVERED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Delivered Quantity for an Item
67	INVOICED_QTY_CUM	CRMT_INVOICED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Billed Quantity for an Item
68	DELIVERY_VAL_CUM	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
69	INVOICED_VAL_CUM	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
70	.INCLUDE				0	0	CRM Incentives - Sales document - schedue line quantity
71	ORDER_QTY	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
72	CONFIRMED_QTY	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
73	.INCLUDE				0	0	CRM Incentives - add'l fields for the Sales Interface to ICM
74	COMM_TRIGGER_DATE	CRMT_COMMISS_TRIGGER_DATE		DATS	8	0	Date, when commission calculation process started
75	COMM_TRIGGER_STATUS	CRMT_ICM_COMM_TRI_STATUS	CRM_ICM_COMM_TRI_STATUS	NUMC	2	0	Commission trigger status to transfer data to commiss.system	*
76	COMM_BAS_VAL	CRMT_COMMBAS_VALUE_CUM	WERTV8	CURR	15	2	Total Commiss Basis Value of Document in Document Currency
77	COMM_BASIS_TYPE	CRMT_ICM_COMM_BASIS_TYPE	CRM_ICM_COMM_BASIS_TYPE	NUMC	2	0	Name of key figure used as commission basis	*
78	.INCLUDE				0	0	CRM Incentives - Sales Ord/Cont Interface - Customer Fields
79	CRMDUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1