SAP ABAP Table CRM_UTIL_BW_SRV_CONTR (BW DataSource for Utilities Quotations Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S (Application Component) Utilities Industry: Sales
     ⤷ CRM_UTILITY_BW (Package) Utilities Industry: CRM Connection to BW and Planning

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_UTIL_BW_SRV_CONTR	Table Relationship Diagram
Short Description	BW DataSource for Utilities Quotations 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	ISU_OUTCONTR	☐	ECRM_ISU_OUTCONTR	CHECKBOX	CHAR	1	0	Indicator: Master Agreement
27	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
28	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
29	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
30	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
31	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
32	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
33	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
34	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
35	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
36	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
37	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
38	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
39	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
40	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
41	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
42	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
43	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
44	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
45	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
46	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
47	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
48	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
49	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
50	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
51	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
52	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
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	SALES Data for BW DataSources
78	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
79	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
80	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
81	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
82	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
83	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
84	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
85	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
86	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
87	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
88	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
89	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
90	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
91	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
92	.INCLUDE	☐				0	0	General Product Data for BW DataSources
93	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
94	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
95	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
96	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
97	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
98	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
99	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
100	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
101	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
102	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
103	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
104	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
105	.INCLUDE	☐				0	0	PRODUCT_I Data for BW DataSources
106	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
107	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
108	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
109	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
110	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
111	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
112	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
113	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
114	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
115	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
116	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
117	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
118	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
119	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
120	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
121	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
122	.INCLUDE	☐				0	0	Product Detail Data PPR for BW Datasources
123	PL_PRODUCT_ID	☐	CRMT_PRODUCT_ID_PL	COM_PRODUCT_ID	CHAR	40	0	Product ID from Product List
124	PL_PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_PL	SYSUUID_C	CHAR	32	0	Product GUID from Product List
125	PL_CATEGORY_ID	☐	CRMT_CATEGORY_ID_PL	COM_CATEGORY_ID	CHAR	20	0	Category ID from Product List
126	PL_CATEGORY_GUID	☐	CRMT_CATEGORY_GUID_PL	SYSUUID_C	CHAR	32	0	Category GUID from Product List
127	PL_SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
128	PL_CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
129	PL_CTLOG_ITEM_ID	☐	BBP_CATALOGITEM_PL	CRM_CATALOGITEM	CHAR	40	0	Catalog Item from Product List
130	PL_PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER_PL	PRSHTEXT40	CHAR	40	0	Product Number for PPR
131	PL_MASTER_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
132	PL_MAST_PRP_GUID	☐	CRMT_PRP_GUID_PL	SYSUUID_C	CHAR	32	0	Internal, Unique Identifier for PPR Objects
133	.INCLUDE	☐				0	0	Item Data Object List (PPR) for BW Datasources
134	OL_PRODUCT_ID	☐	CRMT_PRODUCT_ID_OL	COM_PRODUCT_ID	CHAR	40	0	Product ID from Object List
135	OL_PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_OL	SYSUUID_C	CHAR	32	0	Product GUID from Object List
136	OL_SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
137	OL_MASTER_PRP_ID	☐	CRMT_PRP_ID_OL	CRM_PRP_ID	CHAR	40	0	External Identifier for a Partner/Product Range (PPR) OBJL
138	OL_MAST_PRP_GUID	☐	CRMT_PRP_GUID_OL	SYSUUID_C	CHAR	32	0	Internal, Unique Identifier for PPR Objects OBJL
139	IBASE_HEADER	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
140	IBASE_HEADER_GUID	☐	IB_RECNO_32	SYSUUID_C	CHAR	32	0	IB: 32-Character Record Number
141	IBASE_COMPONENT	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
142	IBASE_COMPONENT_GUID	☐	IB_RECNO_32	SYSUUID_C	CHAR	32	0	IB: 32-Character Record Number
143	IB_IOBJ_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
144	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
145	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
146	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
147	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
148	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
149	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
150	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
151	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
152	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
153	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
154	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
155	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
156	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
157	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
158	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
159	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
160	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
161	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
162	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
163	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
164	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
165	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
166	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
167	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
168	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
169	.INCLUDE	☐				0	0	DATES Data for BW DataSources
170	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
171	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
172	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
173	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
174	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
175	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
176	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
177	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
178	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
179	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
180	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
181	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
182	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
183	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
184	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
185	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
186	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
187	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
188	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
189	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
190	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
191	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
192	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
193	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
194	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
195	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
196	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
197	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
198	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
199	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
200	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
201	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
202	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
203	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
204	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
205	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
206	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
207	PLANNED_END_DATE	☐	CRM_UTIL_PLANNED_END_DATE	CRM_RPRTNG_DATE	DATS	8	0	Planned End Date for Utilities Contract
208	.INCLUDE	☐				0	0	STATUS Data for BW DataSources
209	STATUS_INQUIRY	☐	CRMT_STATUS_INQUIRY	BOOLEAN	CHAR	1	0	Status of Inquiry
210	STATUS_QUOTATION	☐	CRMT_STATUS_QUOTATION	CRM_BOOLEAN	CHAR	1	0	Quotation Status
211	STATUS_ERROR	☐	CRMT_STATUS_ERROR	CRM_BOOLEAN	CHAR	1	0	Indicates Whether Document is Incorrect
212	STATUS_INVOICED	☐	CRMT_STATUS_INVOICED	CRM_BOOLEAN	CHAR	1	0	Billing Status
213	STATUS_ACCEPTED	☐	CRMT_STATUS_ACCEPTED	BOOLEAN	CHAR	1	0	Status Accepted
214	STATUS_COMPLETED	☐	CRMT_STATUS_COMPLETED	BOOLEAN	CHAR	1	0	Status: Completed
215	STATUS_CANCELLED	☐	CRMT_STATUS_CANCELLED	BOOLEAN	CHAR	1	0	Rejection Status
216	STATUS_DOC_SYS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
217	STATUS_DELIVERED	☐	CRMT_DELIVERY_STAT	CRMT_BW_DELIVERY_STAT_DOM	CHAR	1	0	Delivery Status (Use for BW Only)
218	STATUS_EXPIRED	☐	CRMT_STATUS_EXPIRED	BOOLEAN	CHAR	1	0	Status End of Validity Period (Quotation)
219	STATUS_INCOMPL	☐	CRMT_STATUS_INCOMPLETE	BOOLEAN	CHAR	1	0	Status: Incompleted
220	.INCLUDE	☐				0	0	CANCEL Data for BW DataSources
221	CANCPARTY	☐	CRMT_CANC_PARTY	CRM_CANC_PARTY	CHAR	4	0	Cancelling Party
222	CANC_REASON	☐	CRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	CRM Service : Reason for Cancellation	*
223	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
224	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
225	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
226	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
227	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
228	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
229	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
230	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
231	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
232	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
233	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
234	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
235	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
236	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
237	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
238	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
239	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
240	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
241	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
242	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
243	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
244	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
245	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
246	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
247	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
248	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
249	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
250	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
251	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
252	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
253	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
254	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
255	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
256	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
257	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
258	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
259	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
260	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
261	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
262	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
263	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
264	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
265	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
266	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
267	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
268	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
269	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
270	.INCLUDE	☐				0	0	CUMULATED_H Data for BW Data Sources
271	GROSS_VALUE_H	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
272	NET_VALUE_H	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
273	NET_VALUE_MAN_H	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
274	.INCLUDE	☐				0	0	ISU: System Status for BW
275	STATUS_ACTIVATE	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
276	STATUS_DEACTIVAT	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
277	STATUS_ITEM	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
278	STATUS_WAIT_EOS	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
279	.INCLU--AP	☐				0	0	General Util Package Data for BW DataSources
280	PACKAGE_ID	☐	CRM_ISU_PACKAGE_ID	COM_PRODUCT_ID	CHAR	40	0	Package Product ID
281	PACKAGE_GUID	☐	CRM_ISU_PACKAGE	SYSUUID	RAW	16	0	Package Product
282	PACKAGE_DESC	☐	CRM_ISU_PACKAGE_DESCR	PRSHTEXT40	CHAR	40	0	Package Desc.

Foreign Keys

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

History

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