SAP ABAP Table CRMT_CSDR_BW_DR_I (DR item level extract information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IHT-PDP (Application Component) Partner Design Projects
     ⤷ CRM_CSDR_BWA_MAP (Package) Project Assembly Extraction for design registration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CSDR_BW_DR_I	Table Relationship Diagram
Short Description	DR item level extract information

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	BW Datasource for CRM Opportunities: Item Data
2	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
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	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
9	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
10	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
11	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
12	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
13	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
14	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
15	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
16	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
17	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
18	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
19	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
20	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
21	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
23	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
24	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
25	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
26	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
27	.INCLUDE	☐				0	0	OPPORT_H Data for BW DataSources
28	OPPT_GUID	☐	CDBT_OPPORT_H_GUID	SYSUUID	RAW	16	0	Opportunity header own guid.
29	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
30	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
31	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
32	PHASE_SINCE	☐	CRMT_PHASE_SINCE	DATUM	DATS	8	0	Sales Stage Since
33	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
34	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	*
35	TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
36	CONTROL_PHASE	☐	CRMT_CON_PHASE	CRM_CON_PHASE	CHAR	3	0	Analysis Stage	*
37	EXP_REVENUE	☐	CRMT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Volume
38	BUDGET_BP	☐	CRMT_BUDGET_BP	WERTV8	CURR	15	2	Budget Prospect
39	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
40	DURATION	☐	CRMT_DURATION	CRM_DURATION	NUMC	3	0	Expected Duration of Sales Stage in Days
41	STATUS_OPPT	☐	CRMT_STATUS_OPPORTUNITY	CRM_J_STATUS	CHAR	5	0	Opportunity Status
42	STATUS_SINCE	☐	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
43	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
44	NUMBER_OF_H	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
45	SYS_PROBABILITY	☐	CRMT_SYSTEM_PROBABILITY	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success of Opportunity - Calculated by System
46	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
47	FORECAST_REL	☐	CRMT_FORECAST_REL	CRM_FORECAST_REL	CHAR	1	0	Forecast Relevance
48	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description
49	.INCLUDE	☐				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
50	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
51	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
52	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
53	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
54	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
55	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
56	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
57	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
58	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
59	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
60	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
61	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
62	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
63	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
64	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
65	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
66	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
67	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
68	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
69	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
70	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
71	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
72	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
73	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
74	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
75	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
76	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
77	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
78	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
79	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
80	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
81	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
82	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
83	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
84	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
85	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
86	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
87	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
88	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
89	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
90	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
91	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
92	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
93	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
94	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
95	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
96	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
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	PRICING_H Data for BW DataSources
128	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
129	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
130	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
131	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
132	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
133	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
134	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
135	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
136	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
137	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
138	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
139	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
140	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
141	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
142	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
143	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
144	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
145	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
146	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
147	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
148	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
149	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
150	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
151	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
152	.INCLUDE	☐				0	0	CUMULATED_I Data for BW DataSources
153	CALL_OF_CURR_CUM	☐	CRMT_CALL_OF_CURRENCY_CUM	WAERS	CUKY	5	0	Currency for Value Called	*
154	CALL_OF_QTY_CUM	☐	CRMT_CALL_OF_QTY_CUM	CRM_MENGV15	QUAN	15	3	Quantity Retrieved for a Contract
155	CALL_OF_UNIT_CUM	☐	CRMT_CALL_OF_QTY_UNIT_CUM	MEINS	UNIT	3	0	Quantity Unit Called	*
156	CALL_OF_VAL_CUM	☐	CRMT_CALL_OF_VALUE_CUM	CRM_COND_VALUE	CURR	19	2	Released Value for a Contract
157	COMPL_CURR_CUM	☐	CRMT_COMPLETED_CURRENCY_CUM	WAERS	CUKY	5	0	Currency of Actual Referenced Value	*
158	COMPL_QTY_CUM	☐	CRMT_COMPLETED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Actual Referenced Quantity for a Quotation
159	COMPL_UNIT_CUM	☐	CRMT_COMPLETED_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit for Actual Referenced Quantity	*
160	COMPL_VALUE_CUM	☐	CRMT_COMPLETED_VALUE_CUM	WERTV8	CURR	15	2	Actual Referenced Value for a Quotation
161	TARGET_QUAN_CUM	☐	CRMT_TARGET_QUAN_CUM	MENG13	QUAN	13	3	Target Quantity Cumulated
162	TGT_QTY_UNIT_CUM	☐	CRMT_TARGET_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit for a Target Quantity	*
163	DELIVERY_QTY_CUM	☐	CRMT_DELIVERED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Delivered Quantity for an Item
164	INVOICED_QTY_CUM	☐	CRMT_INVOICED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Billed Quantity for an Item
165	O_CALLOF_QTY_CUM	☐	CRMT_O_CALLOF_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Releasable Quantity for Item
166	O_INV_QTY_CUM	☐	CRMT_OPEN_INV_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Item Quantity for Billing
167	O_ORDER_QTY_CUM	☐	CRMT_OPEN_ORD_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Order Quantity for Item
168	DELIVERY_VAL_CUM	☐	CRMT_DELIVERED_VAL_CUM	WERTV8	CURR	15	2	Delivered Value for an Item
169	INVOICED_VAL_CUM	☐	CRMT_INVOICED_VAL_CUM	WERTV8	CURR	15	2	Billed Value of an Item
170	O_CALLOF_VAL_CUM	☐	CRMT_O_CALLOF_VAL_CUM	CRM_COND_VALUE	CURR	19	2	Open Releasable Value for Item
171	O_INV_VAL_CUM	☐	CRMT_OPEN_INV_VAL_CUM	WERTV8	CURR	15	2	Open Item Value for Billing
172	O_ORDER_VAL_CUM	☐	CRMT_OPEN_ORD_VAL_CUM	WERTV8	CURR	15	2	Open Order Value for Item
173	FULLFILL_QTY	☐	CRMT_FULLFILLMENT_TGT		DEC	9	2	Degree of Fulfillment: Target/Quantity
174	FULLFILL_VAL	☐	CRMT_FULLFILLMENT_TGT		DEC	9	2	Degree of Fulfillment: Target/Quantity
175	CUMULAT_UNIT_CUM	☐	CRMT_CUMULAT_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit of Cumulated Quantity	*
176	CUMULAT_CURR_CUM	☐	CRMT_CUMULAT_CURR_CUM	WAERS	CUKY	5	0	Currency of Cumulated Value	*
177	QUOT_VAL_CUM	☐	CRMT_QUOT_VAL_CUM	WERTV8	CURR	15	2	Quotation Value for an Item
178	QUOT_QTY_CUM	☐	CRMT_QUOT_QTY_CUM	CRM_MENGV15	QUAN	15	3	Quotation Quantity for Item
179	GI_QTY_CUM	☐	CRMT_GOODS_ISSUE_QTY_CUM	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity for an Item
180	GI_QTY_SINGLE	☐	CRMT_GOODS_ISSUE_QTY_CUM	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity for an Item
181	DELIV_QTY_SINGLE	☐	CRMT_DELIVERED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Delivered Quantity for an Item
182	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
183	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
184	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
185	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
186	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
187	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
188	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
189	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
190	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
191	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
192	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
193	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
194	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
195	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
196	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
197	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
198	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
199	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
200	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
201	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
202	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
203	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
204	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
205	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
206	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
207	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
208	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
209	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
210	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
211	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
212	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
213	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
214	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
215	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
216	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
217	.INCLUDE	☐				0	0	Schedule line quantities - Daten für BW Datasoures
218	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
219	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
220	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
221	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
222	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
223	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
224	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
225	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
226	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
227	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
228	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
229	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
230	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
231	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
232	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
233	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
234	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
235	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
236	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
237	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
238	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
239	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
240	.INCLUDE	☐				0	0	Territory Data for BW Data Sources (Partner Attribute)
241	PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
242	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
243	.INCLUDE	☐				0	0	Opportunity Hierarchy Data for BW Data Sources
244	MAST_OPP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
245	MAST_OPITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
246	SUB_OPP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
247	MASTEROPP_FLAG	☐	CRMT_MASTEROPP_FLAG	CRMT_MASTEROPP_FLAG	CHAR	1	0	Flag to indicate master opportunity
248	.INCLUDE	☐				0	0	Further Product Data for BW DataSources
249	IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
250	IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
251	CONFPROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
252	CONFPROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
253	PROD_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
254	BATCH_ID	☐	CRMT_BATCH_ID	BATCH_ID	CHAR	10	0	Batch Number
255	SAMPLE	☐	CRMT_SAMPLE_INV	CRM_BOOLEAN	CHAR	1	0	Sample Indicator
256	SAMPLE_SPEC	☐	CRMT_SAMPLE_SPEC	CRMBWSAMPLE	CHAR	1	0	Sample
257	SAMPLE_QTY_ALLOW	☐	CRM_ACT_NUMBER_OF_SAMPLES	DEC4	DEC	4	0	Number of samples
258	.INCLUDE	☐				0	0	CUOBJ for BW DataSources
259	CUOBJ	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
260	.INCLUDE	☐				0	0	FLAGS Data for BW DataSources
261	FLAG_ALT_ITM	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
262	FLAG_STAT	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
263	.INCLUDE	☐				0	0	PARTNER (Locator) Various Partner Functions
264	INSTALL_AT	☐	CRMT_INSTALL_AT_PART	BU_PARTNER	CHAR	10	0	Installed At	*
265	INSTALL_AT_LIST	☐	CRMT_INSTALL_AT_LIST	CHAR80	CHAR	80	0	Installed At - Name
266	RESPONS_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
267	END_CUSTOMER	☐	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
268	RESP_AT_PART	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
269	.INCLUDE	☐				0	0	Specific Opportunity Item Fields for BW DataSource
270	BWSTONEOPPT	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
271	LAST_DLV_DATE	☐	CRMT_DOC_FLOW_DATE	BCOS_TSTMP	DEC	15	0	Date and Time in Document Flow
272	LAST_QI_ACT_DATE	☐	CRMT_DOC_FLOW_DATE	BCOS_TSTMP	DEC	15	0	Date and Time in Document Flow
273	OEM	☐	CRMT_OEM	BU_PARTNER	CHAR	10	0	Original Equipment Manufacturer	*
274	DES_SRV_PROV	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
275	MS_TECH_REP	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
276	.INCLUDE	☐				0	0	Partners for the Project / Assembly
277	DR_BRANCH	☐	CMST_PROJ_DR_BRCH	BU_PARTNER	CHAR	10	0	Channel Partner Branch	*
278	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
279	FAE	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
280	CORP_CHANNEL_PARTNER	☐	CMST_CORPORATE_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
281	CLAIMING_ACCOUNT	☐	CMST_CLAIMING_ACCOUNT	BU_PARTNER	CHAR	10	0	Claiming Account	*
282	INVOICE_RECIPIENT	☐	CRMT_INVOICE_RECIPIENT	BU_PARTNER	CHAR	10	0	Invoice Recipient	*
283	ERP_DISP_CASE_PROCESSOR	☐	CMST_ERP_DISP_CASE_PROCESSOR	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
284	ERP_DISP_CASE_COORDINATOR	☐	CMST_ERP_DISP_CASE_PROCESSOR	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
285	ERP_DISP_CASE_RESPONSIBLE	☐	CMST_ERP_DISP_CASE_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
286	OEM_PROD_LOC	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
287	MS_SALES_MGR	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
288	MS_SALES_REP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
289	OEM_DES_ENGG	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
290	OEM_DES_LOC	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
291	REQUESTOR	☐	CMST_PROJ_REQUESTOR	BU_PARTNER	CHAR	10	0	Design Registration Request Creator	*
292	OEM_PROJ_OWNER	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
293	OEM_PUR_CONTACT	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
294	ASSEMBLY_OWNER	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
295	DESIGN_HOUSE	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
296	PROJECT_OWNER	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
297	DISTRIBUTOR	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
298	DISTRIBUTOR_LOC	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
299	APPROVER	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
300	VALIDATOR	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
301	DES_REG_OWNER	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_CSDR_BW_DR_I	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

Last changed by/on	SAP	20130604
SAP Release Created in	400