SAP ABAP Table CRMT_ICM_SALES_OBJ_SUPERSTRUCT (CRM Incentives: object transfer struct w/addit fields)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-ICM (Application Component) Incentive and Commission Management
⤷ CRM-ICM (Package) Incentive and Commission Management
⤷ 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_OBJ_SUPERSTRUCT | Table Relationship Diagram |
Short Description | CRM Incentives: object transfer struct w/addit fields |
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 | Extraction structure for ICM Commissions Engine | |||||
2 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - admin data - header | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
5 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
6 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
7 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
8 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
9 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Transaction Category | * | |
10 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - admin data - line item | |||||
11 | ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
12 | ORDER_DATE | CRMT_OPPT_ORDER_DATE | DATUM | DATS | 8 | 0 | Posting Date | ||
13 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
14 | ITEM_OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITEM | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | * | |
15 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
16 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - partner (sales) data | |||||
17 | SOLD_TO_PARTY | CRMT_SOLD_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party | * | |
18 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - org management data | |||||
19 | SALES_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
20 | SALES_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
21 | SALES_OFFICE | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
22 | SALES_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
23 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
24 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
25 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - sales data | |||||
26 | CUST_GROUP1 | CRMT_CUST_GROUP1 | CRM_CUST_GROUP1 | CHAR | 3 | 0 | Customer Group 1 | * | |
27 | CUST_GROUP2 | CRMT_CUST_GROUP2 | CRM_CUST_GROUP2 | CHAR | 3 | 0 | Customer Group 2 | * | |
28 | CUST_GROUP3 | CRMT_CUST_GROUP3 | CRM_CUST_GROUP3 | CHAR | 3 | 0 | Customer Group 3 | * | |
29 | CUST_GROUP4 | CRMT_CUST_GROUP4 | CRM_CUST_GROUP4 | CHAR | 3 | 0 | Customer Group 4 | * | |
30 | CUST_GROUP5 | CRMT_CUST_GROUP5 | CRM_CUST_GROUP5 | CHAR | 3 | 0 | Customer Group 5 | * | |
31 | INDUSTRY | CRMT_INDUSTRY | CRM_INDUSTRY | CHAR | 4 | 0 | Industry Sector | * | |
32 | PCAT_HDR_ID | COMT_PCAT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Product Catalog Number | ||
33 | PCAT_VRT_ID | COMT_PCAT_VRT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Variant Number | ||
34 | PCAT_CTY_ID | COMT_PCAT_CTY_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Area Number | ||
35 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - product general data | |||||
36 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
37 | CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
38 | CATALOG_ID | CATALOG_PL | KATALOGID | CHAR | 20 | 0 | Catalog ID, from Which the Line PPR Was Selected | * | |
39 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - product master data | |||||
40 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
41 | PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CRM_PROD_PR_GROUP | CHAR | 2 | 0 | Product Group | * | |
42 | PRC_GROUP1 | CRMT_PRC_GROUP1 | CRM_PRC_GROUP1 | CHAR | 3 | 0 | Product Group 1 | * | |
43 | PRC_GROUP2 | CRMT_PRC_GROUP2 | CRM_PRC_GROUP2 | CHAR | 3 | 0 | Product Group 2 | * | |
44 | PRC_GROUP3 | CRMT_PRC_GROUP3 | CRM_PRC_GROUP3 | CHAR | 3 | 0 | Product Group 3 | * | |
45 | PRC_GROUP4 | CRMT_PRC_GROUP4 | CRM_PRC_GROUP4 | CHAR | 3 | 0 | Product Group 4 | * | |
46 | PRC_GROUP5 | CRMT_PRC_GROUP5 | CRM_PRC_GROUP5 | CHAR | 3 | 0 | Product Group 5 | * | |
47 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - pricing data - header | |||||
48 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
49 | PAYMENT_AMOUNT | CRMT_PAYMENT_AMT | WERTV8 | CURR | 15 | 2 | Sum of Invoice Payments | ||
50 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - pricing data - line item | |||||
51 | TARGET_VALUE | CRMT_TARGET_VALUE | WERTV10 | CURR | 19 | 2 | Target Value for Contracts | ||
52 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
53 | SUBTOTAL1 | CRMT_SUBTOTAL1 | WERTV8 | CURR | 15 | 2 | Subtotal 1 from pricing procedure for condition | ||
54 | SUBTOTAL2 | CRMT_SUBTOTAL2 | WERTV8 | CURR | 15 | 2 | Subtotal 2 from pricing procedure for condition | ||
55 | SUBTOTAL3 | CRMT_SUBTOTAL3 | WERTV8 | CURR | 15 | 2 | Subtotal 3 from pricing procedure for condition | ||
56 | SUBTOTAL4 | CRMT_SUBTOTAL4 | WERTV8 | CURR | 15 | 2 | Subtotal 4 from pricing procedure for condition | ||
57 | SUBTOTAL5 | CRMT_SUBTOTAL5 | WERTV8 | CURR | 15 | 2 | Subtotal 5 from pricing procedure for condition | ||
58 | SUBTOTAL6 | CRMT_SUBTOTAL6 | WERTV8 | CURR | 15 | 2 | Subtotal 6 from pricing procedure for condition | ||
59 | CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CHAR | 1 | 0 | Credit Debit Indicator | ||
60 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
61 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - cumulated data - line item | |||||
62 | CALL_OF_QTY_CUM | CRMT_CALL_OF_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Quantity Retrieved for a Contract | ||
63 | CALL_OF_UNIT_CUM | CRMT_CALL_OF_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Quantity Unit Called | * | |
64 | CALL_OF_VAL_CUM | CRMT_CALL_OF_VALUE_CUM | CRM_COND_VALUE | CURR | 19 | 2 | Released Value for a Contract | ||
65 | TARGET_QUAN_CUM | CRMT_TARGET_QUAN_CUM | MENG13 | QUAN | 13 | 3 | Target Quantity Cumulated | ||
66 | TGT_QTY_UNIT_CUM | CRMT_TARGET_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Unit for a Target Quantity | * | |
67 | DELIVERY_QTY_CUM | CRMT_DELIVERED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Delivered Quantity for an Item | ||
68 | INVOICED_QTY_CUM | CRMT_INVOICED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Billed Quantity for an Item | ||
69 | DELIVERY_VAL_CUM | CRMT_NET_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Net Value of Document in Document Currency | ||
70 | INVOICED_VAL_CUM | CRMT_NET_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Net Value of Document in Document Currency | ||
71 | .INCLUDE | 0 | 0 | CRM Incentives - Sales document - schedue line quantity | |||||
72 | ORDER_QTY | CRMT_QTY_ORDER | MENG13 | QUAN | 13 | 3 | CRM: Order Quantity | ||
73 | CONFIRMED_QTY | CRMT_QTY_CONFIRMED | MENG13 | QUAN | 13 | 3 | CRM: Confirmed Quantity | ||
74 | .INCLUDE | 0 | 0 | CRM Incentives - add'l fields for the Sales Interface to ICM | |||||
75 | COMM_TRIGGER_DATE | CRMT_COMMISS_TRIGGER_DATE | DATS | 8 | 0 | Date, when commission calculation process started | |||
76 | 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 | * | |
77 | COMM_BAS_VAL | CRMT_COMMBAS_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Commiss Basis Value of Document in Document Currency | ||
78 | COMM_BASIS_TYPE | CRMT_ICM_COMM_BASIS_TYPE | CRM_ICM_COMM_BASIS_TYPE | NUMC | 2 | 0 | Name of key figure used as commission basis | * | |
79 | .INCLUDE | 0 | 0 | CRM Incentives - Sales Ord/Cont Interface - Customer Fields | |||||
80 | CRMDUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
81 | .INCLUDE | 0 | 0 | STATUS GROUPS Data for BW Datasources | |||||
82 | BWSTONESYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
83 | BWSTONESYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
84 | BWSTONESYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
85 | BWSTONESYS3 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
86 | BWSTONESYS4 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
87 | BWSTONESYS5 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
88 | BWSTONESYS6 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
89 | BWSTONESYS7 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
90 | BWSTONESYS8 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
91 | BWSTONESYS9 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
92 | BWSTONESYSA | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
93 | BWSTTECSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
94 | BWSTTECSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
95 | BWSTTECSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
96 | BWSTLOCSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
97 | BWSTLOCSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
98 | BWSTLOCSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
99 | BWSTONESYSB | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
100 | BWSTONESYSC | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
101 | CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
102 | CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
103 | PL_CTLOG_ITEM_ID | BBP_CATALOGITEM_PL | CRM_CATALOGITEM | CHAR | 40 | 0 | Catalog Item from Product List | ||
104 | CATALOG_ITEM_ID | CRMT_CATALOGITEM | CRM_CATALOGITEM | CHAR | 40 | 0 | Catalog Item (Unique Key) | ||
105 | PRODUCT_GUID | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 310 |