SAP ABAP Table CRMT_BW_SALES_CONTRA (BW DataSource for CRM Sales Contracts: 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_SALES_CONTRA   Table Relationship Diagram
Short Description BW DataSource for CRM Sales Contracts: 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 (Locator) Various Partner Functions  
60 INSTALL_AT CRMT_INSTALL_AT_PART BU_PARTNER CHAR 10   0   Installed At *
61 INSTALL_AT_LIST CRMT_INSTALL_AT_LIST CHAR80 CHAR 80   0   Installed At - Name  
62 RESPONS_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
63 END_CUSTOMER CRMT_END_CUSTOMER BU_PARTNER CHAR 10   0   End Customer (Channel Management) *
64 RESP_AT_PART CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
65 .INCLUDE       0   0   PARTNER (Call Center) Data for BW Datasoures  
66 EXECUTING_CC CRMT_EXECUTING_CC BU_PARTNER CHAR 10   0   Executing Interaction Center *
67 RESP_GROUP CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
68 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
69 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
70 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
71 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
72 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
73 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
74 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
75 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
76 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
77 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
78 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
79 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
80 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
81 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
82 .INCLUDE       0   0   SALES Data for BW DataSources  
83 CUST_GROUP1 CRMT_CUST_GROUP1 CRM_CUST_GROUP1 CHAR 3   0   Customer Group 1 *
84 CUST_GROUP2 CRMT_CUST_GROUP2 CRM_CUST_GROUP2 CHAR 3   0   Customer Group 2 *
85 CUST_GROUP3 CRMT_CUST_GROUP3 CRM_CUST_GROUP3 CHAR 3   0   Customer Group 3 *
86 CUST_GROUP4 CRMT_CUST_GROUP4 CRM_CUST_GROUP4 CHAR 3   0   Customer Group 4 *
87 CUST_GROUP5 CRMT_CUST_GROUP5 CRM_CUST_GROUP5 CHAR 3   0   Customer Group 5 *
88 INDUSTRY CRMT_INDUSTRY CRM_INDUSTRY CHAR 4   0   Industry Sector *
89 REJECTION CRMT_REJECTION_CODE CRM_REJECTION_CODE CHAR 2   0   Cancellation Reason Code *
90 PROBABILITY CRMT_ORDER_PROBABILITY CRM_PROBABILITY NUMC 3   0   Order Probability  
91 PCAT_HDR_ID COMT_PCAT_ID COM_PCAT_OBJECTID CHAR 30   0   Product Catalog Number  
92 PCAT_VRT_ID COMT_PCAT_VRT_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Variant Number  
93 PCAT_CTY_ID COMT_PCAT_CTY_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Area Number  
94 ABNORMAL_DEMAND CRMT_ABNORMAL_DEMAND CRM_ABNORMAL_DEMAND CHAR 1   0   Abnormal Demand  
95 DLV_RELEVANCE CRMT_DELIVERY_RELEVANT CRM_DELIVERY_RELEVANT CHAR 1   0   Delivery-Relevant  
96 DATE_QTY_FIXED CRMT_DATE_QTY_FIXED CRM_BOOLEAN CHAR 1   0   Fixed Date and Quantity  
97 .INCLUDE       0   0   General Product Data for BW DataSources  
98 PRODUCT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
99 PRODUCT_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
100 MATERIAL CRMT_R3_MATERIAL CRM_R3_MATERIAL CHAR 18   0   Distribution CRM -> R/3: Material  
101 CATEGORY_ID COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
102 CATEGORY_GUID COMT_CATEGORY_GUID SYSUUID RAW 16   0   Category GUID  
103 SHORT_TEXT_UC COMT_PRSHTEXTX_UP PRSHTEXTG40 CHAR 40   0   Product Description  
104 CATALOG_ID CATALOG_PL KATALOGID CHAR 20   0   Catalog ID, from Which the Line PPR Was Selected *
105 CATALOG_ITEM_ID CRMT_CATALOGITEM CRM_CATALOGITEM CHAR 40   0   Catalog Item (Unique Key)  
106 PARTNER_PROD CRMT_ITEM_DESCR_PARTNER PRSHTEXT40 CHAR 40   0   Product Number of Business Partner  
107 PARENT_PRODUCT CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
108 COMPETITOR_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
109 REPLACED_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
110 .INCLUDE       0   0   PRODUCT_I Data for BW DataSources  
111 GROSS_WEIGHT CRMT_GROSS_WEIGHT MENG15 QUAN 15   3   Gross Weight  
112 NET_WEIGHT CRMT_NET_WEIGHT MENG15 QUAN 15   3   Net Weight  
113 WEIGHT_UNIT COMT_WEIGHT_UNIT MEINS UNIT 3   0   Weight Unit *
114 VOLUME CRMT_VOLUME MENG15 QUAN 15   3   Volume Occupied by the Product per Volume Unit  
115 VOLUME_UNIT COMT_VOLUME_UNIT MEINS UNIT 3   0   Unit for the Volume of a Product *
116 PROCESS_QTY_NUM CRMT_PROCESS_QTY_NUM CRM_PROCESS_QTY_NUM INT4 10   0   Numerator (factor) for conversion trans. quantity in BME  
117 PROCESS_QTY_DEN CRMT_PROCESS_QTY_DEN CRM_PROCESS_QTY_DEN INT4 10   0   Denominator (factor) for conversion trans. quantity in BME  
118 EXPONENT10 CRMT_EXPONENT10 CRM_EXPONENT10 INT2 5   0   10 Exponent for Quantity Conversion  
119 PROCESS_QTY_UNIT CRMT_PROCESS_QTY_UNIT MEINS UNIT 3   0   Unit of Measure in Which the Product Is Sold *
120 PROD_PR_GROUP CRMT_PROD_PR_GROUP CRM_PROD_PR_GROUP CHAR 2   0   Product Group *
121 PRC_GROUP1 CRMT_PRC_GROUP1 CRM_PRC_GROUP1 CHAR 3   0   Product Group 1 *
122 PRC_GROUP2 CRMT_PRC_GROUP2 CRM_PRC_GROUP2 CHAR 3   0   Product Group 2 *
123 PRC_GROUP3 CRMT_PRC_GROUP3 CRM_PRC_GROUP3 CHAR 3   0   Product Group 3 *
124 PRC_GROUP4 CRMT_PRC_GROUP4 CRM_PRC_GROUP4 CHAR 3   0   Product Group 4 *
125 PRC_GROUP5 CRMT_PRC_GROUP5 CRM_PRC_GROUP5 CHAR 3   0   Product Group 5 *
126 BASE_QTY_UNIT COMT_PRODUCT_BASE_UOM MEINS UNIT 3   0   Base Unit of Measure of Product *
127 .INCLUDE       0   0   Product Detail Data PPR for BW Datasources  
128 PL_PRODUCT_ID CRMT_PRODUCT_ID_PL COM_PRODUCT_ID CHAR 40   0   Product ID from Product List  
129 PL_PRODUCT_GUID CRMT_PRODUCT_GUID_PL SYSUUID_C CHAR 32   0   Product GUID from Product List  
130 PL_CATEGORY_ID CRMT_CATEGORY_ID_PL COM_CATEGORY_ID CHAR 20   0   Category ID from Product List  
131 PL_CATEGORY_GUID CRMT_CATEGORY_GUID_PL SYSUUID_C CHAR 32   0   Category GUID from Product List  
132 PL_SHORT_TEXT_UC COMT_PRSHTEXTX_UP PRSHTEXTG40 CHAR 40   0   Product Description  
133 PL_CATALOG_ID CATALOG_PL KATALOGID CHAR 20   0   Catalog ID, from Which the Line PPR Was Selected *
134 PL_CTLOG_ITEM_ID BBP_CATALOGITEM_PL CRM_CATALOGITEM CHAR 40   0   Catalog Item from Product List  
135 PL_PARTNER_PROD CRMT_ITEM_DESCR_PARTNER_PL PRSHTEXT40 CHAR 40   0   Product Number for PPR  
136 PL_MASTER_PRP_ID CRMT_PRP_ID CRM_PRP_ID CHAR 40   0   Identifier for a Partner/Product Range (PPR) Assignment  
137 PL_MAST_PRP_GUID CRMT_PRP_GUID_PL SYSUUID_C CHAR 32   0   Internal, Unique Identifier for PPR Objects  
138 .INCLUDE       0   0   Item Data Object List (PPR) for BW Datasources  
139 OL_PRODUCT_ID CRMT_PRODUCT_ID_OL COM_PRODUCT_ID CHAR 40   0   Product ID from Object List  
140 OL_PRODUCT_GUID CRMT_PRODUCT_GUID_OL SYSUUID_C CHAR 32   0   Product GUID from Object List  
141 OL_SHORT_TEXT_UC COMT_PRSHTEXTX_UP PRSHTEXTG40 CHAR 40   0   Product Description  
142 OL_MASTER_PRP_ID CRMT_PRP_ID_OL CRM_PRP_ID CHAR 40   0   External Identifier for a Partner/Product Range (PPR) OBJL  
143 OL_MAST_PRP_GUID CRMT_PRP_GUID_OL SYSUUID_C CHAR 32   0   Internal, Unique Identifier for PPR Objects OBJL  
144 IBASE_HEADER IB_IBASE IB_INSTANCE NUMC 18   0   IBase: Number of the Installed Base/IBase  
145 IBASE_HEADER_GUID IB_RECNO_32 SYSUUID_C CHAR 32   0   IB: 32-Character Record Number  
146 IBASE_COMPONENT IB_INSTANCE IB_INSTANCE NUMC 18   0   IB: Component (instance)  
147 IBASE_COMPONENT_GUID IB_RECNO_32 SYSUUID_C CHAR 32   0   IB: 32-Character Record Number  
148 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
149 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
150 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
151 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
152 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
153 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
154 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
155 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
156 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
157 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
158 .INCLUDE       0   0   PRICING_I Data for BW DataSources  
159 NET_VALUE_MAN CRMT_NET_VALUE_MAN WERTV8 CURR 15   2   Total Expected Net Value Products in Document Currency  
160 TARGET_VALUE CRMT_TARGET_VALUE WERTV10 CURR 19   2   Target Value for Contracts  
161 NET_PRICE CRMT_NET_PRICE WERTV8 CURR 15   2   Net Price  
162 NET_VALUE CRMT_NET_VALUE WERTV8 CURR 15   2   Net Value  
163 TAX_AMOUNT CRMT_TAX_AMOUNT WERTV8 CURR 15   2   Tax amount in document currency  
164 FREIGHT CRMT_FREIGHT WERTV8 CURR 15   2   Shipment costs in document currency  
165 SUBTOTAL1 CRMT_SUBTOTAL1 WERTV8 CURR 15   2   Subtotal 1 from pricing procedure for condition  
166 SUBTOTAL2 CRMT_SUBTOTAL2 WERTV8 CURR 15   2   Subtotal 2 from pricing procedure for condition  
167 SUBTOTAL3 CRMT_SUBTOTAL3 WERTV8 CURR 15   2   Subtotal 3 from pricing procedure for condition  
168 SUBTOTAL4 CRMT_SUBTOTAL4 WERTV8 CURR 15   2   Subtotal 4 from pricing procedure for condition  
169 SUBTOTAL5 CRMT_SUBTOTAL5 WERTV8 CURR 15   2   Subtotal 5 from pricing procedure for condition  
170 SUBTOTAL6 CRMT_SUBTOTAL6 WERTV8 CURR 15   2   Subtotal 6 from pricing procedure for condition  
171 CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CHAR 1   0   Credit Debit Indicator  
172 GROSS_VALUE CRMT_GROSS_VALUE WERTV8 CURR 15   2   Gross Order Value in PO Currency  
173 .INCLUDE       0   0   DATES Data for BW DataSources  
174 REQUESTED_DATE CRMT_REQUESTED_DATE CRM_RPRTNG_DATE DATS 8   0   Order Date  
175 CONFIRMED_DATE CRMT_CONFIRMED_DATE CRM_RPRTNG_DATE DATS 8   0   Latest Confirmation Date for Item Schedule Line  
176 BEGIN_DATE CRMT_BEGIN_DATE CRM_RPRTNG_DATE DATS 8   0   Contract Start Date  
177 ENDING_DATE CRMT_ENDING_DATE CRM_RPRTNG_DATE DATS 8   0   Contract End Date  
178 START_OF_BILLING CRMT_START_OF_BILLING CRM_RPRTNG_DATE DATS 8   0   Start Date of Billing Plan  
179 VALID_FROM_DATE CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
180 VALID_TO_DATE CRMT_VALID_TO_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation: Valid to Date  
181 BW_POST_DATE CRMT_BW_POST_DATE CRM_RPRTNG_DATE DATS 8   0   Posting Date for BW Reporting  
182 PLANNED_TS_FROM CRMT_PLANNED_TS_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Planned Date/Time from  
183 PLANNED_TS_TO CRMT_PLANNED_TS_TO BCOS_TSTMP DEC 15   0   Time Stamp: Planned Date/Time to  
184 ACTUAL_TS_FROM CRMT_ACTUAL_TS_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Actual Date/Time from  
185 ACTUAL_TS_TO CRMT_ACTUAL_TS_TO BCOS_TSTMP DEC 15   0   Time Stamp: Actual Date/Time to  
186 PLANNED_FROM CRMT_PLANNED_FROM CRM_RPRTNG_DATE DATS 8   0   Planned Date from  
187 PLANNED_TO CRMT_PLANNED_TO CRM_RPRTNG_DATE DATS 8   0   Planned Date to  
188 ACTUAL_FROM CRMT_ACTUAL_FROM CRM_RPRTNG_DATE DATS 8   0   Actual Date from  
189 ACTUAL_TO CRMT_ACTUAL_TO CRM_RPRTNG_DATE DATS 8   0   Actual Date to  
190 EARLIEST_CONFIRM CRMT_EARLIEST_CONFIRMED CRM_RPRTNG_DATE DATS 8   0   Earliest Confirmation Date Still Not Delivered  
191 DURA CRMT_BW_DURATION TIMEDURA DEC 13   0   Duration of Contract/Quotation  
192 DURA_FULLFILL CRMT_BW_DURA_FULLFILL TIMEDURA DEC 13   0   Duration Until Fulfillment of Contract  
193 DURA_UNIT CRMT_BW_DURA_UNIT TIMEUNITNA CHAR 12   0   Time Unit for Duration of Contract/Quotation in Days *
194 BEGIN_TO_COMPLET CRMT_BW_BEGIN_TO_COMPLETE TIMEDURA DEC 13   0   Duration Start to Conversion or Cancellation of a Quotation  
195 COMPLETE_TO_END CRMT_BW_COMPLETE_TO_END TIMEDURA DEC 13   0   Duration Conversion or Cancellation Before End of Quotation  
196 REL_TO_BEGIN CRMT_BW_REL_TO_BEGIN   DEC 7   2   Time Relation: Time to Completion / Validity Interval  
197 REL_BEFORE_END CRMT_BW_REL_BEFORE_END   DEC 5   2   Time Relation: Time Completed Before End / Validity Interval  
198 REQ_DLV_DATE CRMT_REQ_DELIVERY_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Required Delivery Date  
199 LAST_DLV_DATE CRMT_LAST_DELIVERY_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Delivery Date  
200 LAST_QI_ACT_DATE CRMT_LAST_QI_ACTUAL_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Actual Goods Issue Data  
201 LAST_REQ_AVA_DAT CRMT_LAST_REQ_AVAILABLE_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Material Availability Date (Requested)  
202 LAST_CONF_AV_DAT CRMT_LAST_CONF_AVAILABLE_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Material Availability Date (Confirmed)  
203 LAST_REQ_QI_PLDA CRMT_LAST_REQ_QI_PLANNED_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Planned Goods Issue Date (Requested)  
204 LAST_CONF_QI_PLD CRMT_LAST_CONF_QI_PLANNED_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Last Planned Goods Issue Date (Confirmed)  
205 CONFIRMED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
206 ACTUAL_FROM_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
207 EARLIEST_CON_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
208 REQUESTED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
209 VALID_FROM_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
210 VALID_TO_TS CRMT_DATE_TIMESTAMP_TO BCOS_TSTMP DEC 15   0   Time stamp (Date and Time) until a Date/Duration  
211 .INCLUDE       0   0   CUMULATED_I Data for BW DataSources  
212 CALL_OF_CURR_CUM CRMT_CALL_OF_CURRENCY_CUM WAERS CUKY 5   0   Currency for Value Called *
213 CALL_OF_QTY_CUM CRMT_CALL_OF_QTY_CUM CRM_MENGV15 QUAN 15   3   Quantity Retrieved for a Contract  
214 CALL_OF_UNIT_CUM CRMT_CALL_OF_QTY_UNIT_CUM MEINS UNIT 3   0   Quantity Unit Called *
215 CALL_OF_VAL_CUM CRMT_CALL_OF_VALUE_CUM CRM_COND_VALUE CURR 19   2   Released Value for a Contract  
216 COMPL_CURR_CUM CRMT_COMPLETED_CURRENCY_CUM WAERS CUKY 5   0   Currency of Actual Referenced Value *
217 COMPL_QTY_CUM CRMT_COMPLETED_QTY_CUM CRM_MENGV15 QUAN 15   3   Actual Referenced Quantity for a Quotation  
218 COMPL_UNIT_CUM CRMT_COMPLETED_QTY_UNIT_CUM MEINS UNIT 3   0   Unit for Actual Referenced Quantity *
219 COMPL_VALUE_CUM CRMT_COMPLETED_VALUE_CUM WERTV8 CURR 15   2   Actual Referenced Value for a Quotation  
220 TARGET_QUAN_CUM CRMT_TARGET_QUAN_CUM MENG13 QUAN 13   3   Target Quantity Cumulated  
221 TGT_QTY_UNIT_CUM CRMT_TARGET_QTY_UNIT_CUM MEINS UNIT 3   0   Unit for a Target Quantity *
222 DELIVERY_QTY_CUM CRMT_DELIVERED_QTY_CUM CRM_MENGV15 QUAN 15   3   Delivered Quantity for an Item  
223 INVOICED_QTY_CUM CRMT_INVOICED_QTY_CUM CRM_MENGV15 QUAN 15   3   Billed Quantity for an Item  
224 O_CALLOF_QTY_CUM CRMT_O_CALLOF_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Releasable Quantity for Item  
225 O_INV_QTY_CUM CRMT_OPEN_INV_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Item Quantity for Billing  
226 O_ORDER_QTY_CUM CRMT_OPEN_ORD_QTY_CUM CRM_MENGV15 QUAN 15   3   Open Order Quantity for Item  
227 DELIVERY_VAL_CUM CRMT_DELIVERED_VAL_CUM WERTV8 CURR 15   2   Delivered Value for an Item  
228 INVOICED_VAL_CUM CRMT_INVOICED_VAL_CUM WERTV8 CURR 15   2   Billed Value of an Item  
229 O_CALLOF_VAL_CUM CRMT_O_CALLOF_VAL_CUM CRM_COND_VALUE CURR 19   2   Open Releasable Value for Item  
230 O_INV_VAL_CUM CRMT_OPEN_INV_VAL_CUM WERTV8 CURR 15   2   Open Item Value for Billing  
231 O_ORDER_VAL_CUM CRMT_OPEN_ORD_VAL_CUM WERTV8 CURR 15   2   Open Order Value for Item  
232 FULLFILL_QTY CRMT_FULLFILLMENT_TGT   DEC 9   2   Degree of Fulfillment: Target/Quantity  
233 FULLFILL_VAL CRMT_FULLFILLMENT_TGT   DEC 9   2   Degree of Fulfillment: Target/Quantity  
234 CUMULAT_UNIT_CUM CRMT_CUMULAT_QTY_UNIT_CUM MEINS UNIT 3   0   Unit of Cumulated Quantity *
235 CUMULAT_CURR_CUM CRMT_CUMULAT_CURR_CUM WAERS CUKY 5   0   Currency of Cumulated Value *
236 QUOT_VAL_CUM CRMT_QUOT_VAL_CUM WERTV8 CURR 15   2   Quotation Value for an Item  
237 QUOT_QTY_CUM CRMT_QUOT_QTY_CUM CRM_MENGV15 QUAN 15   3   Quotation Quantity for Item  
238 GI_QTY_CUM CRMT_GOODS_ISSUE_QTY_CUM CRM_MENGV15 QUAN 15   3   Goods Issue Quantity for an Item  
239 GI_QTY_SINGLE CRMT_GOODS_ISSUE_QTY_CUM CRM_MENGV15 QUAN 15   3   Goods Issue Quantity for an Item  
240 DELIV_QTY_SINGLE CRMT_DELIVERED_QTY_CUM CRM_MENGV15 QUAN 15   3   Delivered Quantity for an Item  
241 .INCLUDE       0   0   BILLING Data for BW DataSources  
242 BILLING_DATE CRMT_BW_BILL_DATE CRM_RPRTNG_DATE DATS 8   0   Billing Date  
243 BILLING_BLOCK CRMT_BUS_BILL_BLOCK_REASON CRM_BILLING_BLOCK CHAR 2   0   Business Partner (CRM): Billing Block Reason *
244 LOC_GUID CRMT_LOC_GUID SYSUUID_C CHAR 32   0   Letter of Credit GUID from SAP Global Trade Services  
245 LOC_EXT_NUMBER CRMT_LOC_EXTERNAL_NUMBER   CHAR 40   0   External Number Letter of Credit  
246 BILLING_DATE_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
247 .INCLUDE       0   0   STATUS Data for BW DataSources  
248 STATUS_INQUIRY CRMT_STATUS_INQUIRY BOOLEAN CHAR 1   0   Status of Inquiry  
249 STATUS_QUOTATION CRMT_STATUS_QUOTATION CRM_BOOLEAN CHAR 1   0   Quotation Status  
250 STATUS_ERROR CRMT_STATUS_ERROR CRM_BOOLEAN CHAR 1   0   Indicates Whether Document is Incorrect  
251 STATUS_INVOICED CRMT_STATUS_INVOICED CRM_BOOLEAN CHAR 1   0   Billing Status  
252 STATUS_ACCEPTED CRMT_STATUS_ACCEPTED BOOLEAN CHAR 1   0   Status Accepted  
253 STATUS_COMPLETED CRMT_STATUS_COMPLETED BOOLEAN CHAR 1   0   Status: Completed  
254 STATUS_CANCELLED CRMT_STATUS_CANCELLED BOOLEAN CHAR 1   0   Rejection Status  
255 STATUS_DOC_SYS CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
256 STATUS_DELIVERED CRMT_DELIVERY_STAT CRMT_BW_DELIVERY_STAT_DOM CHAR 1   0   Delivery Status (Use for BW Only)  
257 STATUS_EXPIRED CRMT_STATUS_EXPIRED BOOLEAN CHAR 1   0   Status End of Validity Period (Quotation)  
258 STATUS_INCOMPL CRMT_STATUS_INCOMPLETE BOOLEAN CHAR 1   0   Status: Incompleted  
259 .INCLUDE       0   0   CANCEL Data for BW DataSources  
260 CANCPARTY CRMT_CANC_PARTY CRM_CANC_PARTY CHAR 4   0   Cancelling Party  
261 CANC_REASON CRMT_SRV_CANCEL_REASON QCODE CHAR 4   0   CRM Service : Reason for Cancellation *
262 .INCLUDE       0   0   SRV_OSSET Data for BW DataSources  
263 KATALOGART COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
264 CODEGRUPPE QCODEGRP QCODEGRP CHAR 8   0   Code Group *
265 CODE QCODE QCODE CHAR 4   0   Code *
266 ACT_REASON_CAT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
267 ACT_REASON_GROUP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
268 ACT_REASON_CODE QCODE QCODE CHAR 4   0   Code *
269 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
270 .INCLUDE       0   0   FINPROD_I Data for BW DataSoures  
271 RESID_VALUE_FLAG CRMT_RESID_VALUE_F CRMT_RESID_VALUE_F CHAR 1   0   Residual Risk  
272 PURCHASE_OPTION CRMT_PURCHASE_OPTION CRMT_PURCHASE_OPTION CHAR 1   0   End of Lease Purchase Option  
273 CLASSIFICATION CRMT_CLASSIFICATION CRMT_CLASSIFICATION NUMC 2   0   Contract Class  
274 CLASSIF_LOCAL CRMT_CLASSIF_LOCAL CRMT_FILA_CLASS CHAR 2   0   Local Classification Type (Tax)  
275 RESIDUAL_VALUE CRMT_RESIDUAL_VALUE WERTV8 CURR 15   2   Residual Value (Pricing)  
276 PURCHASE_OPT_VAL CRMT_PURCHASE_OPT_VALUE WERTV8 CURR 15   2   Purchase Option  
277 LESSOR_IRR CRMT_LESSOR_IRR CRMT_LEAS_INTEREST DEC 11   7   Lessor Internal Rate of Return  
278 AMOUNT_TO_FINANZ CRMT_AMOUNT_TO_FINANZE WERTV8 CURR 15   2   Amount Financed  
279 INT_TRANSFER_PR CRMT_INTERNAL_TRANSFER_PRICE WERTV8 CURR 15   2   Internal Transfer Price  
280 RESULT_RATEPERK CRMT_RESULT_RATEPERK CRMT_DECV7_10 DEC 17   10   Rate per x  
281 .INCLUDE       0   0   Time Characteristics for BW Reporting  
282 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
283 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
284 .INCLUDE       0   0   DOC_FLOW Data for BW DataSources  
285 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
286 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
287 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
288 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
289 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
290 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
291 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
292 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
293 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
294 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
295 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
296 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
297 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
298 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
299 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
300 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
301 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
302 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
303 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
304 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
305 LEAD_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
306 OPPT_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
307 QUOT_VALID_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
308 .INCLUDE       0   0   Schedule line quantities - Daten für BW Datasoures  
309 ORDER_QTY CRMT_QTY_ORDER MENG13 QUAN 13   3   CRM: Order Quantity  
310 CONFIRMED_QTY CRMT_QTY_CONFIRMED MENG13 QUAN 13   3   CRM: Confirmed Quantity  
311 .INCLUDE       0   0   CRM Service Item Data for BW Datasources  
312 SRV_ESCAL CRMT_SRV_ESCAL CRM_SRV_ESCAL CHAR 10   0   Response Profile *
313 SRV_SERWI CRMT_SRV_SERWI CRM_SRV_SERWI CHAR 10   0   Service Profile *
314 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
315 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
316 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
317 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
318 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
319 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
320 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
321 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
322 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
323 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
324 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
325 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
326 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
327 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
328 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
329 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
330 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
331 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
332 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
333 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
334 .INCLUDE       0   0   CUMULATED_H Data for BW Data Sources  
335 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
336 NET_VALUE_H CRMT_NET_VALUE_CUM WERTV8 CURR 15   2   Total Net Value of Document in Document Currency  
337 NET_VALUE_MAN_H CRMT_NET_VALUE_MAN_CUM WERTV8 CURR 15   2   Expected Total Net Value of Products in Document Currency  
338 .INCLUDE       0   0   Territory Data for BW Data Sources (Partner Attribute)  
339 PATH_GUID CRMT_PATH_GUID_32 SYSUUID_C CHAR 32   0   Path GUID of Territory 32  
340 TERR_GUID CRMT_TERR_GUID_32 SYSUUID_C CHAR 32   0   Territory GUID 32  
341 .INCLUDE       0   0   Further Product Data for BW DataSources  
342 IOBJECT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
343 IOBJECT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
344 CONFPROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
345 CONFPROD_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
346 PROD_OBJ_FAM COMT_PRODUCT_OBJECT_FAMILY COM_PRODUCT_OBJECT_FAMILY CHAR 4   0   Object Family *
347 BATCH_ID CRMT_BATCH_ID BATCH_ID CHAR 10   0   Batch Number  
348 SAMPLE CRMT_SAMPLE_INV CRM_BOOLEAN CHAR 1   0   Sample Indicator  
349 SAMPLE_SPEC CRMT_SAMPLE_SPEC CRMBWSAMPLE CHAR 1   0   Sample  
350 SAMPLE_QTY_ALLOW CRM_ACT_NUMBER_OF_SAMPLES DEC4 DEC 4   0   Number of samples  
351 .INCLUDE       0   0   CUOBJ for BW DataSources  
352 CUOBJ CRMT_INT_OBJ_NO IB_INSTANCE NUMC 18   0   Configuration (Internal Object Number)  
353 .INCLUDE       0   0   FLAGS Data for BW DataSources  
354 FLAG_ALT_ITM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
355 FLAG_STAT BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
356 .INCLUDE       0   0   CRM Billing Request Extension for BW Datasources  
357 RECORD_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BW_SALES_CONTRA OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20131122 
SAP Release Created in 20C