SAP ABAP Table CRMT_BW_SERVICEPROCESS_I (BW Extract Structure for CRM Service Process Items)

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_SERVICEPROCESS_I	Table Relationship Diagram
Short Description	BW Extract Structure for CRM Service Process Items

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	Activities Header Data for BW Data Sources
47	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
48	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
49	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
50	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
51	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
52	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
53	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
54	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
55	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
56	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
57	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
58	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
59	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
60	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
61	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
62	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
63	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
64	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
65	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
66	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
67	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
68	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
69	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
70	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
71	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
72	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
73	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
74	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
75	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
76	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
77	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
78	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
79	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
80	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
81	.INCLUDE	☐				0	0	SALES Data for BW DataSources
82	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
83	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
84	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
85	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
86	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
87	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
88	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
89	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
90	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
91	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
92	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
93	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
94	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
95	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
96	.INCLUDE	☐				0	0	General Product Data for BW DataSources
97	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
98	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
99	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
100	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
101	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
102	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
103	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
104	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
105	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
106	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
107	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
108	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
109	.INCLUDE	☐				0	0	PRODUCT_I Data for BW DataSources
110	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
111	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
112	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
113	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
114	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
115	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
116	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
117	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
118	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
119	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
120	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
121	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
122	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
123	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
124	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
125	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
126	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
127	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
128	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
129	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
130	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
131	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
132	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
133	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
134	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
135	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
136	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
137	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
138	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
139	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
140	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
141	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
142	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
143	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
144	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
145	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
146	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
147	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
148	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
149	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
150	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
151	.INCLUDE	☐				0	0	DATES Data for BW DataSources
152	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
153	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
154	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
155	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
156	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
157	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
158	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
159	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
160	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
161	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
162	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
163	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
164	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
165	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
166	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
167	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
168	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
169	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
170	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
171	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
172	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
173	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
174	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
175	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
176	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
177	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
178	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
179	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
180	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
181	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
182	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
183	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
184	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
185	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
186	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
187	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
188	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
189	.INCLUDE	☐				0	0	CUMULATED_I Data for BW DataSources
190	CALL_OF_CURR_CUM	☐	CRMT_CALL_OF_CURRENCY_CUM	WAERS	CUKY	5	0	Currency for Value Called	*
191	CALL_OF_QTY_CUM	☐	CRMT_CALL_OF_QTY_CUM	CRM_MENGV15	QUAN	15	3	Quantity Retrieved for a Contract
192	CALL_OF_UNIT_CUM	☐	CRMT_CALL_OF_QTY_UNIT_CUM	MEINS	UNIT	3	0	Quantity Unit Called	*
193	CALL_OF_VAL_CUM	☐	CRMT_CALL_OF_VALUE_CUM	CRM_COND_VALUE	CURR	19	2	Released Value for a Contract
194	COMPL_CURR_CUM	☐	CRMT_COMPLETED_CURRENCY_CUM	WAERS	CUKY	5	0	Currency of Actual Referenced Value	*
195	COMPL_QTY_CUM	☐	CRMT_COMPLETED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Actual Referenced Quantity for a Quotation
196	COMPL_UNIT_CUM	☐	CRMT_COMPLETED_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit for Actual Referenced Quantity	*
197	COMPL_VALUE_CUM	☐	CRMT_COMPLETED_VALUE_CUM	WERTV8	CURR	15	2	Actual Referenced Value for a Quotation
198	TARGET_QUAN_CUM	☐	CRMT_TARGET_QUAN_CUM	MENG13	QUAN	13	3	Target Quantity Cumulated
199	TGT_QTY_UNIT_CUM	☐	CRMT_TARGET_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit for a Target Quantity	*
200	DELIVERY_QTY_CUM	☐	CRMT_DELIVERED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Delivered Quantity for an Item
201	INVOICED_QTY_CUM	☐	CRMT_INVOICED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Billed Quantity for an Item
202	O_CALLOF_QTY_CUM	☐	CRMT_O_CALLOF_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Releasable Quantity for Item
203	O_INV_QTY_CUM	☐	CRMT_OPEN_INV_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Item Quantity for Billing
204	O_ORDER_QTY_CUM	☐	CRMT_OPEN_ORD_QTY_CUM	CRM_MENGV15	QUAN	15	3	Open Order Quantity for Item
205	DELIVERY_VAL_CUM	☐	CRMT_DELIVERED_VAL_CUM	WERTV8	CURR	15	2	Delivered Value for an Item
206	INVOICED_VAL_CUM	☐	CRMT_INVOICED_VAL_CUM	WERTV8	CURR	15	2	Billed Value of an Item
207	O_CALLOF_VAL_CUM	☐	CRMT_O_CALLOF_VAL_CUM	CRM_COND_VALUE	CURR	19	2	Open Releasable Value for Item
208	O_INV_VAL_CUM	☐	CRMT_OPEN_INV_VAL_CUM	WERTV8	CURR	15	2	Open Item Value for Billing
209	O_ORDER_VAL_CUM	☐	CRMT_OPEN_ORD_VAL_CUM	WERTV8	CURR	15	2	Open Order Value for Item
210	FULLFILL_QTY	☐	CRMT_FULLFILLMENT_TGT		DEC	9	2	Degree of Fulfillment: Target/Quantity
211	FULLFILL_VAL	☐	CRMT_FULLFILLMENT_TGT		DEC	9	2	Degree of Fulfillment: Target/Quantity
212	CUMULAT_UNIT_CUM	☐	CRMT_CUMULAT_QTY_UNIT_CUM	MEINS	UNIT	3	0	Unit of Cumulated Quantity	*
213	CUMULAT_CURR_CUM	☐	CRMT_CUMULAT_CURR_CUM	WAERS	CUKY	5	0	Currency of Cumulated Value	*
214	QUOT_VAL_CUM	☐	CRMT_QUOT_VAL_CUM	WERTV8	CURR	15	2	Quotation Value for an Item
215	QUOT_QTY_CUM	☐	CRMT_QUOT_QTY_CUM	CRM_MENGV15	QUAN	15	3	Quotation Quantity for Item
216	GI_QTY_CUM	☐	CRMT_GOODS_ISSUE_QTY_CUM	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity for an Item
217	GI_QTY_SINGLE	☐	CRMT_GOODS_ISSUE_QTY_CUM	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity for an Item
218	DELIV_QTY_SINGLE	☐	CRMT_DELIVERED_QTY_CUM	CRM_MENGV15	QUAN	15	3	Delivered Quantity for an Item
219	.INCLUDE	☐				0	0	SHIPPING Data for BW DataSources
220	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
221	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
222	.INCLUDE	☐				0	0	BILLING Data for BW DataSources
223	BILLING_DATE	☐	CRMT_BW_BILL_DATE	CRM_RPRTNG_DATE	DATS	8	0	Billing Date
224	BILLING_BLOCK	☐	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
225	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
226	LOC_EXT_NUMBER	☐	CRMT_LOC_EXTERNAL_NUMBER		CHAR	40	0	External Number Letter of Credit
227	BILLING_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
228	.INCLUDE	☐				0	0	STATUS Data for BW DataSources
229	STATUS_INQUIRY	☐	CRMT_STATUS_INQUIRY	BOOLEAN	CHAR	1	0	Status of Inquiry
230	STATUS_QUOTATION	☐	CRMT_STATUS_QUOTATION	CRM_BOOLEAN	CHAR	1	0	Quotation Status
231	STATUS_ERROR	☐	CRMT_STATUS_ERROR	CRM_BOOLEAN	CHAR	1	0	Indicates Whether Document is Incorrect
232	STATUS_INVOICED	☐	CRMT_STATUS_INVOICED	CRM_BOOLEAN	CHAR	1	0	Billing Status
233	STATUS_ACCEPTED	☐	CRMT_STATUS_ACCEPTED	BOOLEAN	CHAR	1	0	Status Accepted
234	STATUS_COMPLETED	☐	CRMT_STATUS_COMPLETED	BOOLEAN	CHAR	1	0	Status: Completed
235	STATUS_CANCELLED	☐	CRMT_STATUS_CANCELLED	BOOLEAN	CHAR	1	0	Rejection Status
236	STATUS_DOC_SYS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
237	STATUS_DELIVERED	☐	CRMT_DELIVERY_STAT	CRMT_BW_DELIVERY_STAT_DOM	CHAR	1	0	Delivery Status (Use for BW Only)
238	STATUS_EXPIRED	☐	CRMT_STATUS_EXPIRED	BOOLEAN	CHAR	1	0	Status End of Validity Period (Quotation)
239	STATUS_INCOMPL	☐	CRMT_STATUS_INCOMPLETE	BOOLEAN	CHAR	1	0	Status: Incompleted
240	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
241	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
242	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
243	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
244	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
245	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
246	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
247	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
248	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
249	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
250	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
251	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
252	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
253	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
254	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
255	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
256	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
257	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
258	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
259	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
260	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
261	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
262	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
263	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
264	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
265	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
266	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
267	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
268	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
269	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
270	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
271	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
272	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
273	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
274	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
275	.INCLUDE	☐				0	0	Schedule line quantities - Daten für BW Datasoures
276	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
277	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
278	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
279	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
280	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
281	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
282	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
283	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
284	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
285	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
286	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
287	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
288	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
289	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
290	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
291	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
292	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
293	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
294	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
295	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
296	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
297	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
298	.INCLUDE	☐				0	0	CUMULATED_H Data for BW Data Sources
299	GROSS_VALUE_H	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
300	NET_VALUE_H	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
301	NET_VALUE_MAN_H	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
302	.INCLUDE	☐				0	0	Territory Data for BW Data Sources (Partner Attribute)
303	PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
304	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
305	.INCLUDE	☐				0	0	Service Partner for BW Extraction
306	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
307	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
308	.INCLUDE	☐				0	0	SRV_SUBJECT Data for BW Extraction
309	CATALOG_TYPE_C	☐	CRMT_CATALOGTYPE	CRM_CATALOGTYPE	CHAR	1	0	Catalog Category
310	KATALOGART_C	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
311	CODEGRUPPE_C	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
312	CODE_C	☐	QCODE	QCODE	CHAR	4	0	Code	*
313	DEFECTCLASS_C	☐	CRMT_DEFECTCLASS	CRM_DEFECTCLASS	CHAR	2	0	Defect Class	*
314	QUALITY_C	☐	CRMT_QUALITY	CRM_BOOLEAN	CHAR	1	0	Quality Defect
315	DEFQUANTITY_C	☐	CRMT_DEFQUANTITY	CRM_DEFQUANTITY	INT4	10	0	Defect Count
316	COUNTER_C	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
317	ASP_ID_C	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
318	CAT_ID_C	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
319	CC_CAT_SUBJECT_C	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
320	CATALOG_TYPE_D	☐	CRMT_CATALOGTYPE	CRM_CATALOGTYPE	CHAR	1	0	Catalog Category
321	KATALOGART_D	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
322	CODEGRUPPE_D	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
323	CODE_D	☐	QCODE	QCODE	CHAR	4	0	Code	*
324	DEFECTCLASS_D	☐	CRMT_DEFECTCLASS	CRM_DEFECTCLASS	CHAR	2	0	Defect Class	*
325	QUALITY_D	☐	CRMT_QUALITY	CRM_BOOLEAN	CHAR	1	0	Quality Defect
326	DEFQUANTITY_D	☐	CRMT_DEFQUANTITY	CRM_DEFQUANTITY	INT4	10	0	Defect Count
327	COUNTER_D	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
328	ASP_ID_D	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
329	CAT_ID_D	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
330	CC_CAT_SUBJECT_D	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
331	CATALOG_TYPE_E	☐	CRMT_CATALOGTYPE	CRM_CATALOGTYPE	CHAR	1	0	Catalog Category
332	KATALOGART_E	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
333	CODEGRUPPE_E	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
334	CODE_E	☐	QCODE	QCODE	CHAR	4	0	Code	*
335	DEFECTCLASS_E	☐	CRMT_DEFECTCLASS	CRM_DEFECTCLASS	CHAR	2	0	Defect Class	*
336	QUALITY_E	☐	CRMT_QUALITY	CRM_BOOLEAN	CHAR	1	0	Quality Defect
337	DEFQUANTITY_E	☐	CRMT_DEFQUANTITY	CRM_DEFQUANTITY	INT4	10	0	Defect Count
338	COUNTER_E	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
339	ASP_ID_E	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
340	CAT_ID_E	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
341	CC_CAT_SUBJECT_E	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
342	CATALOG_TYPE_T	☐	CRMT_CATALOGTYPE	CRM_CATALOGTYPE	CHAR	1	0	Catalog Category
343	KATALOGART_T	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
344	CODEGRUPPE_T	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
345	CODE_T	☐	QCODE	QCODE	CHAR	4	0	Code	*
346	DEFECTCLASS_T	☐	CRMT_DEFECTCLASS	CRM_DEFECTCLASS	CHAR	2	0	Defect Class	*
347	QUALITY_T	☐	CRMT_QUALITY	CRM_BOOLEAN	CHAR	1	0	Quality Defect
348	DEFQUANTITY_T	☐	CRMT_DEFQUANTITY	CRM_DEFQUANTITY	INT4	10	0	Defect Count
349	COUNTER_T	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
350	ASP_ID_T	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
351	CAT_ID_T	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
352	CC_CAT_SUBJECT_T	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
353	CATALOG_TYPE_W	☐	CRMT_CATALOGTYPE	CRM_CATALOGTYPE	CHAR	1	0	Catalog Category
354	KATALOGART_W	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
355	CODEGRUPPE_W	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
356	CODE_W	☐	QCODE	QCODE	CHAR	4	0	Code	*
357	DEFECTCLASS_W	☐	CRMT_DEFECTCLASS	CRM_DEFECTCLASS	CHAR	2	0	Defect Class	*
358	QUALITY_W	☐	CRMT_QUALITY	CRM_BOOLEAN	CHAR	1	0	Quality Defect
359	DEFQUANTITY_W	☐	CRMT_DEFQUANTITY	CRM_DEFQUANTITY	INT4	10	0	Defect Count
360	COUNTER_W	☐	CRMT_NOACT	NUMC1	NUMC	1	0	Number of Activities (always 1)
361	ASP_ID_W	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
362	CAT_ID_W	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
363	CC_CAT_SUBJECT_W	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
364	PROFILE_TYPE	☐	CRMT_SUBJECT_PROFILE_TYPE	CRM_SUBJECT_PROFILE_TYPE	CHAR	2	0	Subject Profile Category
365	CC_CAT_SUBJECT	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
366	.INCLUDE	☐				0	0	Sched. Line Quantity: Data for BW Data Sourcs
367	SCHED_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
368	.INCLUDE	☐				0	0	Further Product Data for BW DataSources
369	IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
370	IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
371	CONFPROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
372	CONFPROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
373	PROD_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
374	BATCH_ID	☐	CRMT_BATCH_ID	BATCH_ID	CHAR	10	0	Batch Number
375	SAMPLE	☐	CRMT_SAMPLE_INV	CRM_BOOLEAN	CHAR	1	0	Sample Indicator
376	SAMPLE_SPEC	☐	CRMT_SAMPLE_SPEC	CRMBWSAMPLE	CHAR	1	0	Sample
377	SAMPLE_QTY_ALLOW	☐	CRM_ACT_NUMBER_OF_SAMPLES	DEC4	DEC	4	0	Number of samples
378	.INCLUDE	☐				0	0	Additional Service-Specific Data for BW DataSources
379	KF_SRV_RREADY	☐	CRMT_BW_SRV_DATES	CRMT_BW_SRV_DATES	INT1	3	0	Data Element for Service - Date Key Figures
380	KF_SRV_CUST_END	☐	CRMT_BW_SRV_DATES	CRMT_BW_SRV_DATES	INT1	3	0	Data Element for Service - Date Key Figures
381	CHA_SRV_RREADY	☐	CHA_SRV_RREADY	CRMT_BW_SRV_CHA_DATES	CHAR	1	0	Data Element for Service-Date Characteristic SLA Date
382	CHA_SRV_CUST_END	☐	CHA_SRV_CUST_END	CRMT_BW_SRV_CHA_DATES	CHAR	1	0	Data Element for Service-Date Char. :Date Requested by Cust.
383	PLAN_FLAG	☐	CRMT_BW_PLAN_FLAG	CRMT_BW_PLAN_FLAG	CHAR	2	0	Planning Indicator
384	DISPO_FLG	☐	CRMT_SRV_DISPO_FLG	FLAG	CHAR	1	0	Relevant for Resource Planning
385	CONFIRM_RELEVANT	☐	CRMT_CONFIRM_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Confirmation
386	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
387	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
388	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
389	SRV_ESCAL	☐	CRMT_SRV_ESCAL	CRM_SRV_ESCAL	CHAR	10	0	Response Profile	*
390	SRV_SERWI	☐	CRMT_SRV_SERWI	CRM_SRV_SERWI	CHAR	10	0	Service Profile	*
391	DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
392	DURATION_UNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
393	PERSONS	☐	CRMT_SRV_PERSONS	NUMC3	NUMC	3	0	Number of Persons
394	STATUS_OPEN_SRV	☐	CRMT_BW_STATUS_ASSIGN	CRMT_BW_STATUS_ASSIGN	INT1	3	0	Status Identifier
395	STATUS_IP_SRV	☐	CRMT_BW_STATUS_ASSIGN	CRMT_BW_STATUS_ASSIGN	INT1	3	0	Status Identifier
396	STATUS_RE_SRV	☐	CRMT_BW_STATUS_ASSIGN	CRMT_BW_STATUS_ASSIGN	INT1	3	0	Status Identifier
397	STATUS_CO_SRV	☐	CRMT_BW_STATUS_ASSIGN	CRMT_BW_STATUS_ASSIGN	INT1	3	0	Status Identifier
398	LC_SRV_DURATION	☐	CRMT_BW_LIFECYCLE	CRMT_DAUER_10_3	QUAN	10	3	CRM Service: Lifecycle (Duration)
399	LC_SRV_DUR_UNIT	☐	CRMT_BW_LIFECYCLE_UNIT	MEINS	UNIT	3	0	CRM Service Lifecycle Unit (Duration)	*
400	BILL_RELEVANT	☐	CRMT_BILLING_RELEVANT	CRM_BILLING_RELEVANT	CHAR	1	0	Billing Relevance
401	WARRANTY	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
402	WARRANTY_ID	☐	CRMT_WTY_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Warranty ID
403	PRED_PSL_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
404	PRED_TMPL_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
405	CONTR_OBJ_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
406	.INCLUDE	☐				0	0	REFOBJ Data for BW DataSources
407	GUID_OBJECT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
408	GUID_OBJ_OBJFAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
409	BOSS_OBJTYP	☐	CRMT_TYPE_OBJECT	TYPE_OBJECT	CHAR	1	0	Object Type for Reference Object in Subject Set
410	BOSS_IOBJ_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
411	BOSS_IOBJ_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
412	BOSS_CFPRD_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
413	BOSS_CFPRD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
414	BOSS_PROD_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
415	BOSS_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
416	.INCLUDE	☐				0	0	Specific Service Process Item Fields for BW DataSource
417	BWSTONESVTK	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
418	.INCLUDE	☐				0	0	Additional Service-Specific Dates for BW DataSources
419	ESCALATE_1_DATE	☐	CRMT_BW_ESCALATION_1_DATE	CRM_RPRTNG_DATE	DATS	8	0	Escalation Date Level 1
420	ESCALATE_2_DATE	☐	CRMT_BW_ESCALATION_2_DATE	CRM_RPRTNG_DATE	DATS	8	0	Escalation Date Level 2
421	WORK_DURATION	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
422	WORK_DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
423	TOTAL_DURATION	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
424	TOTAL_DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
425	REQ_START_DATE	☐	CRMT_BW_REQ_START_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Requested Start Date/Time
426	REQ_END_DATE	☐	CRMT_BW_REQ_END_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Requested End Date/Time
427	COMPLETION_DATE	☐	CRMT_BW_CLOSE_DATE	CRM_RPRTNG_DATE	DATS	8	0	Closing Date
428	DUE_DATE	☐	CRMT_BW_DUE_DATE	BCOS_TSTMP	DEC	15	0	Timestamp: Due Date/Time
429	COMPLETION_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
430	ESCALATE_1_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
431	ESCALATE_2_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration

Foreign Keys

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

History

Last changed by/on	SAP	20131122
SAP Release Created in	30A