SAP ABAP Table CRMT_BW_LEAD_I (BW: Datasource for CRM Leads, 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_LEAD_I   Table Relationship Diagram
Short Description BW: Datasource for CRM Leads, 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   LEAD_H Data for BW Datasources  
27 LEAD_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
28 TYPE CRMT_LEAD_TYPE CRM_LEAD_TYPE CHAR 4   0   Lead Group *
29 STATUS_LEAD CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
30 STATUS_SINCE CRMT_STATUS_SINCE DATUM DATS 8   0   Status Since  
31 IMPORTANCE CRMT_IMPORTANCE CRM_IMPORTANCE CHAR 1   0   Opportunity/Lead Priority *
32 SOURCE CRMT_SOURCE CRM_SOURCE CHAR 3   0   Origin of Opportunity/Lead *
33 QUAL_LEVEL CRMT_LEAD_QUAL_LEVEL CRM_LEAD_QUAL_LEVEL CHAR 2   0   Lead Qualification Level *
34 QUAL_LEVEL_INIT CRMT_LEAD_QUAL_LEVEL CRM_LEAD_QUAL_LEVEL CHAR 2   0   Lead Qualification Level *
35 NUMBER_OF_H CRMT_NUMBER_OF_H INT4 INT4 10   0   Order Header Number  
36 DUR_LEAD CRMT_DUR_LEAD INT4 INT4 10   0   Duration of Lead in Days  
37 EXP_DUR_LEAD CRMT_DUR_LEAD INT4 INT4 10   0   Duration of Lead in Days  
38 NUMBER_CHDLEV CRMT_NUMBER_CHDLEV INT4 INT4 10   0   Number of Changes in Qualification Level for Lead  
39 NUMBER_OF_LACT CRMT_NUMBER_LACT INT4 INT4 10   0   Number of Activities for a Lead  
40 WON_LEADS CRMT_WON_LEADS INT4 INT4 10   0   Number of Leads Won  
41 QUANTITY CRMT_SCHEDLIN_QUAN MENG13 QUAN 13   3   CRM Schedule Line Quantity  
42 PRIME_LEAD_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
43 .INCLUDE       0   0   PARTNER (Locator) Various Partner Functions  
44 INSTALL_AT CRMT_INSTALL_AT_PART BU_PARTNER CHAR 10   0   Installed At *
45 INSTALL_AT_LIST CRMT_INSTALL_AT_LIST CHAR80 CHAR 80   0   Installed At - Name  
46 RESPONS_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
47 END_CUSTOMER CRMT_END_CUSTOMER BU_PARTNER CHAR 10   0   End Customer (Channel Management) *
48 RESP_AT_PART CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
49 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
50 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
51 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
52 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
53 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
54 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
55 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
56 .INCLUDE       0   0   PARTNER (Opportunity/Activity) Data for BW DataSoures  
57 COMPETITOR CRMT_COMPETITOR BU_PARTNER CHAR 10   0   Competitors *
58 PROSPECT CRMT_PROSPECT BU_PARTNER CHAR 10   0   Prospect *
59 ACTIVITY_PARTNER CRMT_ACTIVITY_PARTNER BU_PARTNER CHAR 10   0   Activity Partner *
60 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
61 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
62 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
63 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
64 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
65 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
66 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
67 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
68 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
69 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
70 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
71 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
72 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
73 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
74 .INCLUDE       0   0   ORDERADM_I Data for BW DataSources  
75 ITEM_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
76 ITEM_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
77 ITEM_CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
78 ITEM_CHANGED_AT CRMT_OPPT_CHANGED_AT DATUM DATS 8   0   Time of Last Change to the Transaction  
79 ITEM_CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
80 ORDER_DATE CRMT_OPPT_ORDER_DATE DATUM DATS 8   0   Posting Date  
81 NUMBER_INT CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
82 ITEM_OBJECT_TYPE CRMT_SWO_OBJTYP_PROCESS_ITEM CRM_OJ_NAME_PROCESS_ITEM CHAR 10   0   CRM Item Object Type *
83 ITM_TYPE CRMT_ITEM_TYPE CRM_ITEM_TYPE CHAR 4   0   Item Category *
84 NUMBER_OF_I CRMT_NUMBER_OF_I INT4 INT4 10   0   Order Item Number  
85 BW_ASSIGN CRMT_BW_ASSIGN CRMT_BW_ASSIGN CHAR 1   0   Assign BW and CO  
86 ITM_USAGE CRMT_ITEM_USAGE CRM_ITEM_USAGE CHAR 2   0   Usage of Higher-Level Item  
87 ITM_TYPE_USAGE CRMT_IT_TYPE_USAGE CRM_IT_TYPE_USAGE CHAR 4   0   Item Category Usage *
88 ALTERNATIVE CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
89 PARENT CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
90 ITM_BP CRM_ISU_PARTNER_NO CRM_ISU_PARTNER_NO CHAR 10   0   Partner Number  
91 ITEM_CREATED_TS COMT_CREATED_AT_USR COM_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
92 ITEM_CHANGED_TS COMT_CHANGED_AT_USR COM_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
93 ORDER_DATE_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
94 .INCLUDE       0   0   General Product Data for BW DataSources  
95 PRODUCT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
96 PRODUCT_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
97 MATERIAL CRMT_R3_MATERIAL CRM_R3_MATERIAL CHAR 18   0   Distribution CRM -> R/3: Material  
98 CATEGORY_ID COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
99 CATEGORY_GUID COMT_CATEGORY_GUID SYSUUID RAW 16   0   Category GUID  
100 SHORT_TEXT_UC COMT_PRSHTEXTX_UP PRSHTEXTG40 CHAR 40   0   Product Description  
101 CATALOG_ID CATALOG_PL KATALOGID CHAR 20   0   Catalog ID, from Which the Line PPR Was Selected *
102 CATALOG_ITEM_ID CRMT_CATALOGITEM CRM_CATALOGITEM CHAR 40   0   Catalog Item (Unique Key)  
103 PARTNER_PROD CRMT_ITEM_DESCR_PARTNER PRSHTEXT40 CHAR 40   0   Product Number of Business Partner  
104 PARENT_PRODUCT CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
105 COMPETITOR_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
106 REPLACED_PROD CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
107 .INCLUDE       0   0   PRODUCT_I Data for BW DataSources  
108 GROSS_WEIGHT CRMT_GROSS_WEIGHT MENG15 QUAN 15   3   Gross Weight  
109 NET_WEIGHT CRMT_NET_WEIGHT MENG15 QUAN 15   3   Net Weight  
110 WEIGHT_UNIT COMT_WEIGHT_UNIT MEINS UNIT 3   0   Weight Unit *
111 VOLUME CRMT_VOLUME MENG15 QUAN 15   3   Volume Occupied by the Product per Volume Unit  
112 VOLUME_UNIT COMT_VOLUME_UNIT MEINS UNIT 3   0   Unit for the Volume of a Product *
113 PROCESS_QTY_NUM CRMT_PROCESS_QTY_NUM CRM_PROCESS_QTY_NUM INT4 10   0   Numerator (factor) for conversion trans. quantity in BME  
114 PROCESS_QTY_DEN CRMT_PROCESS_QTY_DEN CRM_PROCESS_QTY_DEN INT4 10   0   Denominator (factor) for conversion trans. quantity in BME  
115 EXPONENT10 CRMT_EXPONENT10 CRM_EXPONENT10 INT2 5   0   10 Exponent for Quantity Conversion  
116 PROCESS_QTY_UNIT CRMT_PROCESS_QTY_UNIT MEINS UNIT 3   0   Unit of Measure in Which the Product Is Sold *
117 PROD_PR_GROUP CRMT_PROD_PR_GROUP CRM_PROD_PR_GROUP CHAR 2   0   Product Group *
118 PRC_GROUP1 CRMT_PRC_GROUP1 CRM_PRC_GROUP1 CHAR 3   0   Product Group 1 *
119 PRC_GROUP2 CRMT_PRC_GROUP2 CRM_PRC_GROUP2 CHAR 3   0   Product Group 2 *
120 PRC_GROUP3 CRMT_PRC_GROUP3 CRM_PRC_GROUP3 CHAR 3   0   Product Group 3 *
121 PRC_GROUP4 CRMT_PRC_GROUP4 CRM_PRC_GROUP4 CHAR 3   0   Product Group 4 *
122 PRC_GROUP5 CRMT_PRC_GROUP5 CRM_PRC_GROUP5 CHAR 3   0   Product Group 5 *
123 BASE_QTY_UNIT COMT_PRODUCT_BASE_UOM MEINS UNIT 3   0   Base Unit of Measure of Product *
124 .INCLUDE       0   0   SRV_OSSET Data for BW DataSources  
125 KATALOGART COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
126 CODEGRUPPE QCODEGRP QCODEGRP CHAR 8   0   Code Group *
127 CODE QCODE QCODE CHAR 4   0   Code *
128 ACT_REASON_CAT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
129 ACT_REASON_GROUP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
130 ACT_REASON_CODE QCODE QCODE CHAR 4   0   Code *
131 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
132 .INCLUDE       0   0   Time Characteristics for BW Reporting  
133 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
134 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
135 .INCLUDE       0   0   DOC_FLOW Data for BW DataSources  
136 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
137 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
138 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
139 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
140 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
141 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
142 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
143 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
144 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
145 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
146 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
147 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
148 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
149 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
150 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
151 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
152 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
153 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
154 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
155 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
156 LEAD_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
157 OPPT_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
158 QUOT_VALID_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
159 .INCLUDE       0   0   Schedule line quantities - Daten für BW Datasoures  
160 ORDER_QTY CRMT_QTY_ORDER MENG13 QUAN 13   3   CRM: Order Quantity  
161 CONFIRMED_QTY CRMT_QTY_CONFIRMED MENG13 QUAN 13   3   CRM: Confirmed Quantity  
162 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
163 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
164 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
165 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
166 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
167 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
168 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
169 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
170 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
171 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
172 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
173 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
174 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
175 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
176 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
177 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
178 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
179 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
180 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
181 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
182 .INCLUDE       0   0   Territory Data for BW Data Sources (Partner Attribute)  
183 PATH_GUID CRMT_PATH_GUID_32 SYSUUID_C CHAR 32   0   Path GUID of Territory 32  
184 TERR_GUID CRMT_TERR_GUID_32 SYSUUID_C CHAR 32   0   Territory GUID 32  
185 LAST_DLV_DATE CRMT_DOC_FLOW_DATE BCOS_TSTMP DEC 15   0   Date and Time in Document Flow  
186 LAST_QI_ACT_DATE CRMT_DOC_FLOW_DATE BCOS_TSTMP DEC 15   0   Date and Time in Document Flow  
187 .INCLUDE       0   0   Specific Lead Header Fields for BW DataSource  
188 BWSTONELEAD CRMBWST J_STONR NUMC 2   0   BW Status  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BW_LEAD_I OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20130604 
SAP Release Created in 30A