SAP ABAP Table CRMT_BW_COMPLAINTS_I (BW: Datasource for CRM Complaints - Item Data)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     CRM_REPORT (Package) Operative Reporting in CRM
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_BW_COMPLAINTS_I   Table Relationship Diagram
Short Description BW: Datasource for CRM Complaints - Item Data    
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 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 CRMC_SUBOB_CAT
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   ORDERADM_I Data for BW DataSources  
27 ITEM_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
28 ITEM_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
29 ITEM_CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
30 ITEM_CHANGED_AT CRMT_OPPT_CHANGED_AT DATUM DATS 8   0   Time of Last Change to the Transaction  
31 ITEM_CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
32 ORDER_DATE CRMT_OPPT_ORDER_DATE DATUM DATS 8   0   Posting Date  
33 NUMBER_INT CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
34 ITEM_OBJECT_TYPE CRMT_SWO_OBJTYP_PROCESS_ITEM CRM_OJ_NAME_PROCESS_ITEM CHAR 10   0   CRM Item Object Type *
35 ITM_TYPE CRMT_ITEM_TYPE CRM_ITEM_TYPE CHAR 4   0   Item Category *
36 NUMBER_OF_I CRMT_NUMBER_OF_I INT4 INT4 10   0   Order Item Number  
37 BW_ASSIGN CRMT_BW_ASSIGN CRMT_BW_ASSIGN CHAR 1   0   Assign BW and CO  
38 ITM_USAGE CRMT_ITEM_USAGE CRM_ITEM_USAGE CHAR 2   0   Usage of Higher-Level Item  
39 ITM_TYPE_USAGE CRMT_IT_TYPE_USAGE CRM_IT_TYPE_USAGE CHAR 4   0   Item Category Usage *
40 ALTERNATIVE CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
41 PARENT CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
42 ITM_BP CRM_ISU_PARTNER_NO CRM_ISU_PARTNER_NO CHAR 10   0   Partner Number  
43 ITEM_CREATED_TS COMT_CREATED_AT_USR COM_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
44 ITEM_CHANGED_TS COMT_CHANGED_AT_USR COM_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
45 ORDER_DATE_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
46 .INCLUDE       0   0   PARTNER (Sales) Data for BW DataSources  
47 SOLD_TO_PARTY CRMT_SOLD_TO_PART BU_PARTNER CHAR 10   0   Sold-To Party *
48 SHIP_TO_PARTY CRMT_SHIP_TO_PART BU_PARTNER CHAR 10   0   Ship-To Party *
49 BILL_TO_PARTY CRMT_BILL_TO_PART BU_PARTNER CHAR 10   0   Bill-To Party *
50 PAYER CRMT_RP_PAYER BU_PARTNER CHAR 10   0   Payer *
51 SOLD_FROM CRMT_SOLD_FROM_PARTY_ID BU_PARTNER CHAR 10   0   Salesperson ID *
52 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
53 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
54 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
55 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
56 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
57 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
58 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
59 .INCLUDE       0   0   PARTNER (Call Center) Data for BW Datasoures  
60 EXECUTING_CC CRMT_EXECUTING_CC BU_PARTNER CHAR 10   0   Executing Interaction Center *
61 RESP_GROUP CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
62 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
63 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
64 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
65 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
66 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
67 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
68 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
69 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
70 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
71 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
72 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
73 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
74 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
75 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
76 .INCLUDE       0   0   SALES Data for BW DataSources  
77 CUST_GROUP1 CRMT_CUST_GROUP1 CRM_CUST_GROUP1 CHAR 3   0   Customer Group 1 *
78 CUST_GROUP2 CRMT_CUST_GROUP2 CRM_CUST_GROUP2 CHAR 3   0   Customer Group 2 *
79 CUST_GROUP3 CRMT_CUST_GROUP3 CRM_CUST_GROUP3 CHAR 3   0   Customer Group 3 *
80 CUST_GROUP4 CRMT_CUST_GROUP4 CRM_CUST_GROUP4 CHAR 3   0   Customer Group 4 *
81 CUST_GROUP5 CRMT_CUST_GROUP5 CRM_CUST_GROUP5 CHAR 3   0   Customer Group 5 *
82 INDUSTRY CRMT_INDUSTRY CRM_INDUSTRY CHAR 4   0   Industry Sector *
83 REJECTION CRMT_REJECTION_CODE CRM_REJECTION_CODE CHAR 2   0   Cancellation Reason Code *
84 PROBABILITY CRMT_ORDER_PROBABILITY CRM_PROBABILITY NUMC 3   0   Order Probability  
85 PCAT_HDR_ID COMT_PCAT_ID COM_PCAT_OBJECTID CHAR 30   0   Product Catalog Number  
86 PCAT_VRT_ID COMT_PCAT_VRT_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Variant Number  
87 PCAT_CTY_ID COMT_PCAT_CTY_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Area Number  
88 ABNORMAL_DEMAND CRMT_ABNORMAL_DEMAND CRM_ABNORMAL_DEMAND CHAR 1   0   Abnormal Demand  
89 DLV_RELEVANCE CRMT_DELIVERY_RELEVANT CRM_DELIVERY_RELEVANT CHAR 1   0   Delivery-Relevant  
90 DATE_QTY_FIXED CRMT_DATE_QTY_FIXED CRM_BOOLEAN CHAR 1   0   Fixed Date and Quantity  
91 .INCLUDE       0   0   General Product Data for BW DataSources  
92 PRODUCT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
93 PRODUCT_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
94 MATERIAL CRMT_R3_MATERIAL CRM_R3_MATERIAL CHAR 18   0   Distribution CRM -> R/3: Material  
95 CATEGORY_ID COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
96 CATEGORY_GUID COMT_CATEGORY_GUID SYSUUID RAW 16   0   Category GUID  
97 SHORT_TEXT_UC COMT_PRSHTEXTX_UP PRSHTEXTG40 CHAR 40   0   Product Description  
98 CATALOG_ID CATALOG_PL KATALOGID CHAR 20   0   Catalog ID, from Which the Line PPR Was Selected *
99 CATALOG_ITEM_ID CRMT_CATALOGITEM CRM_CATALOGITEM CHAR 40   0   Catalog Item (Unique Key)  
100 PARTNER_PROD CRMT_ITEM_DESCR_PARTNER PRSHTEXT40 CHAR 40   0   Product Number of Business Partner  
101 PARENT_PRODUCT CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
102 COMPETITOR_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
103 REPLACED_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
104 .INCLUDE       0   0   PRODUCT_I Data for BW DataSources  
105 GROSS_WEIGHT CRMT_GROSS_WEIGHT MENG15 QUAN 15   3   Gross Weight  
106 NET_WEIGHT CRMT_NET_WEIGHT MENG15 QUAN 15   3   Net Weight  
107 WEIGHT_UNIT COMT_WEIGHT_UNIT MEINS UNIT 3   0   Weight Unit *
108 VOLUME CRMT_VOLUME MENG15 QUAN 15   3   Volume Occupied by the Product per Volume Unit  
109 VOLUME_UNIT COMT_VOLUME_UNIT MEINS UNIT 3   0   Unit for the Volume of a Product *
110 PROCESS_QTY_NUM CRMT_PROCESS_QTY_NUM CRM_PROCESS_QTY_NUM INT4 10   0   Numerator (factor) for conversion trans. quantity in BME  
111 PROCESS_QTY_DEN CRMT_PROCESS_QTY_DEN CRM_PROCESS_QTY_DEN INT4 10   0   Denominator (factor) for conversion trans. quantity in BME  
112 EXPONENT10 CRMT_EXPONENT10 CRM_EXPONENT10 INT2 5   0   10 Exponent for Quantity Conversion  
113 PROCESS_QTY_UNIT CRMT_PROCESS_QTY_UNIT MEINS UNIT 3   0   Unit of Measure in Which the Product Is Sold *
114 PROD_PR_GROUP CRMT_PROD_PR_GROUP CRM_PROD_PR_GROUP CHAR 2   0   Product Group *
115 PRC_GROUP1 CRMT_PRC_GROUP1 CRM_PRC_GROUP1 CHAR 3   0   Product Group 1 *
116 PRC_GROUP2 CRMT_PRC_GROUP2 CRM_PRC_GROUP2 CHAR 3   0   Product Group 2 *
117 PRC_GROUP3 CRMT_PRC_GROUP3 CRM_PRC_GROUP3 CHAR 3   0   Product Group 3 *
118 PRC_GROUP4 CRMT_PRC_GROUP4 CRM_PRC_GROUP4 CHAR 3   0   Product Group 4 *
119 PRC_GROUP5 CRMT_PRC_GROUP5 CRM_PRC_GROUP5 CHAR 3   0   Product Group 5 *
120 BASE_QTY_UNIT COMT_PRODUCT_BASE_UOM MEINS UNIT 3   0   Base Unit of Measure of Product *
121 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
122 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
123 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
124 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
125 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
126 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
127 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
128 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
129 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
130 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
131 .INCLUDE       0   0   PRICING_I Data for BW DataSources  
132 NET_VALUE_MAN CRMT_NET_VALUE_MAN WERTV8 CURR 15   2   Total Expected Net Value Products in Document Currency  
133 TARGET_VALUE CRMT_TARGET_VALUE WERTV10 CURR 19   2   Target Value for Contracts  
134 NET_PRICE CRMT_NET_PRICE WERTV8 CURR 15   2   Net Price  
135 NET_VALUE CRMT_NET_VALUE WERTV8 CURR 15   2   Net Value  
136 TAX_AMOUNT CRMT_TAX_AMOUNT WERTV8 CURR 15   2   Tax amount in document currency  
137 FREIGHT CRMT_FREIGHT WERTV8 CURR 15   2   Shipment costs in document currency  
138 SUBTOTAL1 CRMT_SUBTOTAL1 WERTV8 CURR 15   2   Subtotal 1 from pricing procedure for condition  
139 SUBTOTAL2 CRMT_SUBTOTAL2 WERTV8 CURR 15   2   Subtotal 2 from pricing procedure for condition  
140 SUBTOTAL3 CRMT_SUBTOTAL3 WERTV8 CURR 15   2   Subtotal 3 from pricing procedure for condition  
141 SUBTOTAL4 CRMT_SUBTOTAL4 WERTV8 CURR 15   2   Subtotal 4 from pricing procedure for condition  
142 SUBTOTAL5 CRMT_SUBTOTAL5 WERTV8 CURR 15   2   Subtotal 5 from pricing procedure for condition  
143 SUBTOTAL6 CRMT_SUBTOTAL6 WERTV8 CURR 15   2   Subtotal 6 from pricing procedure for condition  
144 CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CHAR 1   0   Credit Debit Indicator  
145 GROSS_VALUE CRMT_GROSS_VALUE WERTV8 CURR 15   2   Gross Order Value in PO Currency  
146 .INCLUDE       0   0   DATES Data for BW DataSources  
147 REQUESTED_DATE CRMT_REQUESTED_DATE CRM_RPRTNG_DATE DATS 8   0   Order Date  
148 CONFIRMED_DATE CRMT_CONFIRMED_DATE CRM_RPRTNG_DATE DATS 8   0   Latest Confirmation Date for Item Schedule Line  
149 BEGIN_DATE CRMT_BEGIN_DATE CRM_RPRTNG_DATE DATS 8   0   Contract Start Date  
150 ENDING_DATE CRMT_ENDING_DATE CRM_RPRTNG_DATE DATS 8   0   Contract End Date  
151 START_OF_BILLING CRMT_START_OF_BILLING CRM_RPRTNG_DATE DATS 8   0   Start Date of Billing Plan  
152 VALID_FROM_DATE CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
153 VALID_TO_DATE CRMT_VALID_TO_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation: Valid to Date  
154 BW_POST_DATE CRMT_BW_POST_DATE CRM_RPRTNG_DATE DATS 8   0   Posting Date for BW Reporting  
155 PLANNED_TS_FROM CRMT_PLANNED_TS_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Planned Date/Time from  
156 PLANNED_TS_TO CRMT_PLANNED_TS_TO BCOS_TSTMP DEC 15   0   Time Stamp: Planned Date/Time to  
157 ACTUAL_TS_FROM CRMT_ACTUAL_TS_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Actual Date/Time from  
158 ACTUAL_TS_TO CRMT_ACTUAL_TS_TO BCOS_TSTMP DEC 15   0   Time Stamp: Actual Date/Time to  
159 PLANNED_FROM CRMT_PLANNED_FROM CRM_RPRTNG_DATE DATS 8   0   Planned Date from  
160 PLANNED_TO CRMT_PLANNED_TO CRM_RPRTNG_DATE DATS 8   0   Planned Date to  
161 ACTUAL_FROM CRMT_ACTUAL_FROM CRM_RPRTNG_DATE DATS 8   0   Actual Date from  
162 ACTUAL_TO CRMT_ACTUAL_TO CRM_RPRTNG_DATE DATS 8   0   Actual Date to  
163 EARLIEST_CONFIRM CRMT_EARLIEST_CONFIRMED CRM_RPRTNG_DATE DATS 8   0   Earliest Confirmation Date Still Not Delivered  
164 DURA CRMT_BW_DURATION TIMEDURA DEC 13   0   Duration of Contract/Quotation  
165 DURA_FULLFILL CRMT_BW_DURA_FULLFILL TIMEDURA DEC 13   0   Duration Until Fulfillment of Contract  
166 DURA_UNIT CRMT_BW_DURA_UNIT TIMEUNITNA CHAR 12   0   Time Unit for Duration of Contract/Quotation in Days *
167 BEGIN_TO_COMPLET CRMT_BW_BEGIN_TO_COMPLETE TIMEDURA DEC 13   0   Duration Start to Conversion or Cancellation of a Quotation  
168 COMPLETE_TO_END CRMT_BW_COMPLETE_TO_END TIMEDURA DEC 13   0   Duration Conversion or Cancellation Before End of Quotation  
169 REL_TO_BEGIN CRMT_BW_REL_TO_BEGIN   DEC 7   2   Time Relation: Time to Completion / Validity Interval  
170 REL_BEFORE_END CRMT_BW_REL_BEFORE_END   DEC 5   2   Time Relation: Time Completed Before End / Validity Interval  
171 REQ_DLV_DATE CRMT_REQ_DELIVERY_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Required Delivery Date  
172 LAST_DLV_DATE CRMT_LAST_DELIVERY_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Delivery Date  
173 LAST_QI_ACT_DATE CRMT_LAST_QI_ACTUAL_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Actual Goods Issue Data  
174 LAST_REQ_AVA_DAT CRMT_LAST_REQ_AVAILABLE_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Material Availability Date (Requested)  
175 LAST_CONF_AV_DAT CRMT_LAST_CONF_AVAILABLE_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Material Availability Date (Confirmed)  
176 LAST_REQ_QI_PLDA CRMT_LAST_REQ_QI_PLANNED_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Planned Goods Issue Date (Requested)  
177 LAST_CONF_QI_PLD CRMT_LAST_CONF_QI_PLANNED_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Planned Goods Issue Date (Confirmed)  
178 CONFIRMED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
179 ACTUAL_FROM_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
180 EARLIEST_CON_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
181 REQUESTED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
182 VALID_FROM_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
183 VALID_TO_TS CRMT_DATE_TIMESTAMP_TO BCOS_TSTMP DEC 15   0   Time stamp (Date and Time) until a Date/Duration  
184 .INCLUDE       0   0   CUMULATED_I Data for BW DataSources  
185 CALL_OF_CURR_CUM CRMT_CALL_OF_CURRENCY_CUM WAERS CUKY 5   0   Currency for Value Called *
186 CALL_OF_QTY_CUM CRMT_CALL_OF_QTY_CUM CRM_MENGV15 QUAN 15   3   Quantity Retrieved for a Contract  
187 CALL_OF_UNIT_CUM CRMT_CALL_OF_QTY_UNIT_CUM MEINS UNIT 3   0   Quantity Unit Called *
188 CALL_OF_VAL_CUM CRMT_CALL_OF_VALUE_CUM CRM_COND_VALUE CURR 19   2   Released Value for a Contract  
189 COMPL_CURR_CUM CRMT_COMPLETED_CURRENCY_CUM WAERS CUKY 5   0   Currency of Actual Referenced Value *
190 COMPL_QTY_CUM CRMT_COMPLETED_QTY_CUM CRM_MENGV15 QUAN 15   3   Actual Referenced Quantity for a Quotation  
191 COMPL_UNIT_CUM CRMT_COMPLETED_QTY_UNIT_CUM MEINS UNIT 3   0   Unit for Actual Referenced Quantity *
192 COMPL_VALUE_CUM CRMT_COMPLETED_VALUE_CUM WERTV8 CURR 15   2   Actual Referenced Value for a Quotation  
193 TARGET_QUAN_CUM CRMT_TARGET_QUAN_CUM MENG13 QUAN 13   3   Target Quantity Cumulated  
194 TGT_QTY_UNIT_CUM CRMT_TARGET_QTY_UNIT_CUM MEINS UNIT 3   0   Unit for a Target Quantity *
195 DELIVERY_QTY_CUM CRMT_DELIVERED_QTY_CUM CRM_MENGV15 QUAN 15   3   Delivered Quantity for an Item  
196 INVOICED_QTY_CUM CRMT_INVOICED_QTY_CUM CRM_MENGV15 QUAN 15   3   Billed Quantity for an Item  
197 O_CALLOF_QTY_CUM CRMT_O_CALLOF_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Releasable Quantity for Item  
198 O_INV_QTY_CUM CRMT_OPEN_INV_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Item Quantity for Billing  
199 O_ORDER_QTY_CUM CRMT_OPEN_ORD_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Order Quantity for Item  
200 DELIVERY_VAL_CUM CRMT_DELIVERED_VAL_CUM WERTV8 CURR 15   2   Delivered Value for an Item  
201 INVOICED_VAL_CUM CRMT_INVOICED_VAL_CUM WERTV8 CURR 15   2   Billed Value of an Item  
202 O_CALLOF_VAL_CUM CRMT_O_CALLOF_VAL_CUM CRM_COND_VALUE CURR 19   2   Open Releasable Value for Item  
203 O_INV_VAL_CUM CRMT_OPEN_INV_VAL_CUM WERTV8 CURR 15   2   Open Item Value for Billing  
204 O_ORDER_VAL_CUM CRMT_OPEN_ORD_VAL_CUM WERTV8 CURR 15   2   Open Order Value for Item  
205 FULLFILL_QTY CRMT_FULLFILLMENT_TGT   DEC 9   2   Degree of Fulfillment: Target/Quantity  
206 FULLFILL_VAL CRMT_FULLFILLMENT_TGT   DEC 9   2   Degree of Fulfillment: Target/Quantity  
207 CUMULAT_UNIT_CUM CRMT_CUMULAT_QTY_UNIT_CUM MEINS UNIT 3   0   Unit of Cumulated Quantity *
208 CUMULAT_CURR_CUM CRMT_CUMULAT_CURR_CUM WAERS CUKY 5   0   Currency of Cumulated Value *
209 QUOT_VAL_CUM CRMT_QUOT_VAL_CUM WERTV8 CURR 15   2   Quotation Value for an Item  
210 QUOT_QTY_CUM CRMT_QUOT_QTY_CUM CRM_MENGV15 QUAN 15   3   Quotation Quantity for Item  
211 GI_QTY_CUM CRMT_GOODS_ISSUE_QTY_CUM CRM_MENGV15 QUAN 15   3   Goods Issue Quantity for an Item  
212 GI_QTY_SINGLE CRMT_GOODS_ISSUE_QTY_CUM CRM_MENGV15 QUAN 15   3   Goods Issue Quantity for an Item  
213 DELIV_QTY_SINGLE CRMT_DELIVERED_QTY_CUM CRM_MENGV15 QUAN 15   3   Delivered Quantity for an Item  
214 .INCLUDE       0   0   SHIPPING Data for BW DataSources  
215 INCOTERMS1 CRMT_INCOTERMS1 CRM_INCOTERMS1 CHAR 3   0   Incoterms (Part 1) *
216 INCOTERMS2 CRMT_INCOTERMS2 CRM_INCOTERMS2 CHAR 28   0   Incoterms (Part 2)  
217 .INCLUDE       0   0   BILLING Data for BW DataSources  
218 BILLING_DATE CRMT_BW_BILL_DATE CRM_RPRTNG_DATE DATS 8   0   Billing Date  
219 BILLING_BLOCK CRMT_BUS_BILL_BLOCK_REASON CRM_BILLING_BLOCK CHAR 2   0   Business Partner (CRM): Billing Block Reason *
220 LOC_GUID CRMT_LOC_GUID SYSUUID_C CHAR 32   0   Letter of Credit GUID from SAP Global Trade Services  
221 LOC_EXT_NUMBER CRMT_LOC_EXTERNAL_NUMBER   CHAR 40   0   External Number Letter of Credit  
222 BILLING_DATE_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
223 .INCLUDE       0   0   STATUS Data for BW DataSources  
224 STATUS_INQUIRY CRMT_STATUS_INQUIRY BOOLEAN CHAR 1   0   Status of Inquiry  
225 STATUS_QUOTATION CRMT_STATUS_QUOTATION CRM_BOOLEAN CHAR 1   0   Quotation Status  
226 STATUS_ERROR CRMT_STATUS_ERROR CRM_BOOLEAN CHAR 1   0   Indicates Whether Document is Incorrect  
227 STATUS_INVOICED CRMT_STATUS_INVOICED CRM_BOOLEAN CHAR 1   0   Billing Status  
228 STATUS_ACCEPTED CRMT_STATUS_ACCEPTED BOOLEAN CHAR 1   0   Status Accepted  
229 STATUS_COMPLETED CRMT_STATUS_COMPLETED BOOLEAN CHAR 1   0   Status: Completed  
230 STATUS_CANCELLED CRMT_STATUS_CANCELLED BOOLEAN CHAR 1   0   Rejection Status  
231 STATUS_DOC_SYS CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
232 STATUS_DELIVERED CRMT_DELIVERY_STAT CRMT_BW_DELIVERY_STAT_DOM CHAR 1   0   Delivery Status (Use for BW Only)  
233 STATUS_EXPIRED CRMT_STATUS_EXPIRED BOOLEAN CHAR 1   0   Status End of Validity Period (Quotation)  
234 STATUS_INCOMPL CRMT_STATUS_INCOMPLETE BOOLEAN CHAR 1   0   Status: Incompleted  
235 .INCLUDE       0   0   SRV_OSSET Data for BW DataSources  
236 KATALOGART COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
237 CODEGRUPPE QCODEGRP QCODEGRP CHAR 8   0   Code Group *
238 CODE QCODE QCODE CHAR 4   0   Code *
239 ACT_REASON_CAT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
240 ACT_REASON_GROUP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
241 ACT_REASON_CODE QCODE QCODE CHAR 4   0   Code *
242 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
243 .INCLUDE       0   0   Time Characteristics for BW Reporting  
244 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
245 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
246 .INCLUDE       0   0   DOC_FLOW Data for BW DataSources  
247 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
248 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
249 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
250 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
251 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
252 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
253 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
254 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
255 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
256 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
257 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
258 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
259 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
260 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
261 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
262 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
263 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
264 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
265 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
266 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
267 LEAD_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
268 OPPT_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
269 QUOT_VALID_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
270 .INCLUDE       0   0   Schedule line quantities - Daten für BW Datasoures  
271 ORDER_QTY CRMT_QTY_ORDER MENG13 QUAN 13   3   CRM: Order Quantity  
272 CONFIRMED_QTY CRMT_QTY_CONFIRMED MENG13 QUAN 13   3   CRM: Confirmed Quantity  
273 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
274 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
275 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
276 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
277 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
278 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
279 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
280 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
281 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
282 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
283 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
284 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
285 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
286 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
287 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
288 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
289 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
290 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
291 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
292 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
293 .INCLUDE       0   0   Territory Data for BW Data Sources (Partner Attribute)  
294 PATH_GUID CRMT_PATH_GUID_32 SYSUUID_C CHAR 32   0   Path GUID of Territory 32  
295 TERR_GUID CRMT_TERR_GUID_32 SYSUUID_C CHAR 32   0   Territory GUID 32  
296 .INCLUDE       0   0   Further Product Data for BW DataSources  
297 IOBJECT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
298 IOBJECT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
299 CONFPROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
300 CONFPROD_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
301 PROD_OBJ_FAM COMT_PRODUCT_OBJECT_FAMILY COM_PRODUCT_OBJECT_FAMILY CHAR 4   0   Object Family *
302 BATCH_ID CRMT_BATCH_ID BATCH_ID CHAR 10   0   Batch Number  
303 SAMPLE CRMT_SAMPLE_INV CRM_BOOLEAN CHAR 1   0   Sample Indicator  
304 SAMPLE_SPEC CRMT_SAMPLE_SPEC CRMBWSAMPLE CHAR 1   0   Sample  
305 SAMPLE_QTY_ALLOW CRM_ACT_NUMBER_OF_SAMPLES DEC4 DEC 4   0   Number of samples  
306 .INCLUDE       0   0   CUOBJ for BW DataSources  
307 CUOBJ CRMT_INT_OBJ_NO IB_INSTANCE NUMC 18   0   Configuration (Internal Object Number)  
308 .INCLUDE       0   0   FLAGS Data for BW DataSources  
309 FLAG_ALT_ITM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
310 FLAG_STAT BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
311 .INCLUDE       0   0   CUMULATED_H Data for BW Data Sources  
312 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
313 NET_VALUE_H CRMT_NET_VALUE_CUM WERTV8 CURR 15   2   Total Net Value of Document in Document Currency  
314 NET_VALUE_MAN_H CRMT_NET_VALUE_MAN_CUM WERTV8 CURR 15   2   Expected Total Net Value of Products in Document Currency  
315 WARRANTY CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
316 WARRANTY_ID CRMT_WTY_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Warranty ID  
317 CC_CAT_SUBJECT CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
318 .INCLUDE       0   0   SPM Complaint Enhancements  
319 RET_PROC_IND PROCESS_INDICATOR PROCESS_INDICATOR CHAR 1   0   Process Indicator  
320 HU_EXID CRMT_EX_HANDLING_UNIT CRM_EX_HU CHAR 20   0   External Handling Unit ID  
321 PACK_MAT CRMT_PACK_MAT MATNR CHAR 18   0   Packaging Material  
322 .INCLUDE       0   0   SPM Scrapping Extract  
323 SCRAP_INSTR_LOW CRMT_SPL_SCRAP_INSTR_LOW CRM_SPL_SCRAP_INSTRUCTION CHAR 1   0   Procedure for Values under Threshold  
324 SCRAP_INSTR_HIGH CRMT_SPL_SCRAP_INSTR_HIGH CRM_SPL_SCRAP_INSTRUCTION CHAR 1   0   Procedure for Values over Threshold  
325 SCRAP_CURR CRMT_SPL_SCRAP_CUKY WAERS CUKY 5   0   Currency Key for Reuse Threshold Value *
326 .INCLUDE       0   0   CRM Return Request Extension: External Fields  
327 INSP_AT_CUST CRM_RET_INSPECTION_AT_CUST CRM_RET_INSPECTION_AT_CUST CHAR 1   0   Return Inspection at Customer Site  
328 MAT_RECEIVED CRM_RET_MATERIAL_RECEIVED CRM_RET_MATERIAL_RECEIVED CHAR 1   0   Return Product Received  
329 VENDOR_RMA CRM_RET_VENDOR_RMA CRM_RET_VENDOR_RMA CHAR 20   0   Return Vendor Return Material Authorization  
330 RFD_CTRL_CODE CRM_RET_REFUND_CONTROL_CODE CRM_RET_REFUND_CONTROL_CODE CHAR 1   0   Return Refund Control  
331 APPROVAL_BLOCK CRM_RET_APPROVAL_BLOCK CRM_RET_APPROVAL_BLOCK CHAR 1   0   Approval  
332 REFUND_TYPE CRM_RET_REFUND_TYPE CRM_RET_REFUND_TYPE CHAR 1   0   Refund Type  
333 PRE_REFUND CRM_RET_PRELIMINARY_REFUND CRM_RET_PRELIMINARY_REFUND CHAR 1   0   Preliminary Refund Determined  
334 REPLACE_REQUEST CRM_RET_REPLACEMENT_REQUEST CRM_RET_REPLACEMENT_REQUEST CHAR 1   0   Replacement from Vendor Requested  
335 REPLACE_PRODUCT CRMT_PRODUCT_GUID_DB SYSUUID RAW 16   0   Internal Unique ID of Product  
336 REPLACE_QTY CRM_RET_REPLACEMENT_QTY MENG13 QUAN 13   3   Replacement Product Quantity  
337 REPLACE_UNIT CRM_RET_REPLACEMENT_UNIT MEINS UNIT 3   0   Replacement Product Unit of Measure *
338 FOL_UP_ACT_CAT CRM_RET_FOLLOW_UP_CATALOG COM_CATALOG CHAR 2   0   Follow-Up Activity: Catalog *
339 FOL_UP_ACT_COGR CRM_RET_FOLLOW_UP_CODE_GROUP QCODEGRP CHAR 8   0   Follow-Up Activity: Code Group *
340 FOL_UP_ACT_CODE CRM_RET_FOLLOW_UP_CODE QCODE CHAR 4   0   Follow-Up Activity Code *
341 NFOL_UP_ACT_CAT CRM_RET_NEXT_FOLLOW_UP_CATALOG COM_CATALOG CHAR 2   0   Next Follow-Up Activity: Catalog *
342 NFOL_UP_ACT_COGR CRM_RET_NEXT_FOLLOW_UP_CODE_GP QCODEGRP CHAR 8   0   Next Follow-Up Activity: Code Group *
343 NFOL_UP_ACT_CODE CRM_RET_NEXT_FOLLOW_UP_CODE QCODE CHAR 4   0   Next Follow-Up Activity Code *
344 REAS_CODE_CAT CRM_RET_REASON_CODE_CATALOG COM_CATALOG CHAR 2   0   Return Reason Code: Catalog *
345 REAS_CODE_COGR CRM_RET_REASON_CODE_CODE_GROUP QCODEGRP CHAR 8   0   Return Reason Code: Code Group *
346 REAS_CODE_CODE CRM_RET_REASON_CODE_CODE QCODE CHAR 4   0   Return Reason Code *
347 REF_CODE_CAT CRM_RET_REFUND_CODE_CATALOG COM_CATALOG CHAR 2   0   Refund Code: Catalog *
348 REF_CODE_COGR CRM_RET_REFUND_CODE_CODE_GROUP QCODEGRP CHAR 8   0   Return Refund Code: Code Group *
349 REF_CODE_CODE CRM_RET_REFUND_CODE_CODE QCODE CHAR 4   0   Refund Code *
350 INSP_CODE_CAT CRM_RET_INSP_CODE_CATALOG COM_CATALOG CHAR 2   0   Inspection Code: Catalog *
351 INSP_CODE_COGR CRM_RET_INSP_CODE_CODE_GROUP QCODEGRP CHAR 8   0   Inspection Code: Code Group *
352 INSP_CODE_CODE CRM_RET_INSP_CODE_CODE QCODE CHAR 4   0   Inspection Code *
353 CINSP_CODE_CAT CRM_RET_CUST_INSP_CODE_CATALOG COM_CATALOG CHAR 2   0   Customer Inspection Code: Catalog *
354 CINSP_CODE_COGR CRM_RET_CUST_INSP_CODE_CODE_GP QCODEGRP CHAR 8   0   Customer Inspection Code: Code Group *
355 CINSP_CODE_CODE CRM_RET_CUST_INSP_CODE_CODE QCODE CHAR 4   0   Customer Inspection Code *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BW_COMPLAINTS_I OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20131122 
SAP Release Created in 30A