SAP ABAP Table CRMT_REPORT_REPORTLIST_ITEM (Compressed Reporting Structure at Item Level)

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_REPORT_REPORTLIST_ITEM	Table Relationship Diagram
Short Description	Compressed Reporting Structure at Item Level

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	.INCLUDE	☐				0	0	Shared adm_h Part During Item Selection
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	HD_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
7	.INCLUDE	☐				0	0	Collective Item Part for Locator Item View
8	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
9	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
10	CONCATSTAT_I	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
11	CONCATSTATUSER_I	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
12	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
13	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
14	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
15	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
16	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
17	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
18	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
19	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
20	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
21	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
22	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
23	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
24	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
25	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
26	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
27	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
28	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
29	PRODUCT_CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
30	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
31	PROD_HIERAR_TXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
32	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
33	FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
34	TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
35	FROM_TIME	☐	CRMT_BSP_TIME_HHMM_FROM	CRM_BSP_TIME_HHMM	TIMS	6	0	From
36	TO_TIME	☐	CRMT_BSP_TIME_HHMM_TO	CRM_BSP_TIME_HHMM	TIMS	6	0	To
37	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
38	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
39	VALID_FROM_TIME	☐	CRMT_BSP_TIME_HHMM_FROM	CRM_BSP_TIME_HHMM	TIMS	6	0	From
40	VALID_TO_TIME	☐	CRMT_BSP_TIME_HHMM_TO	CRM_BSP_TIME_HHMM	TIMS	6	0	To
41	STAT_QUOT_I	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
42	STAT_OPEN_I	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
43	STATUS_OPEN_I	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
44	STATUS_COMPL_I	☐	CRMT_STATUS_COMPLETED	BOOLEAN	CHAR	1	0	Status: Completed
45	STATUS_INPROC_I	☐	CRMT_STATUS_I_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	Status: Item In Process
46	STAT_PLANNED_I	☐	CRMT_STATUS_PLANNED	CRM_BOOLEAN	CHAR	1	0	Status: Planned
47	STAT_QACCEPTED_I	☐	CRMT_STATUS_ACCEPTED	BOOLEAN	CHAR	1	0	Status Accepted
48	STAT_REJECTED_I	☐	CRMT_STATUS_REJECTED	BOOLEAN	CHAR	1	0	Status: Rejected
49	STAT_CREDIT_OK_I	☐	CRMT_STATUS_CREDIT_OK	BOOLEAN	CHAR	1	0	Status: Credit Ok
50	STAT_CRDT_N_OK_I	☐	CRMT_STATUS_CREDIT_NOT_OK	BOOLEAN	CHAR	1	0	Status: Credit Not Ok
51	STAT_PART_DELV_I	☐	CRMT_STATUS_PART_DELV	BOOLEAN	CHAR	1	0	Status: Partially Delivered
52	STAT_COMP_DELV_I	☐	CRMT_STATUS_COMP_DELV	BOOLEAN	CHAR	1	0	Status: Completely Delivered
53	STAT_PURORDCOM_I	☐	CRMT_STATUS_PURORDCOM	BOOLEAN	CHAR	1	0	Status: Purchase Order Completed
54	STAT_PURORDCRE_I	☐	CRMT_STATUS_PURORDCRE	BOOLEAN	CHAR	1	0	Status: Purchase Order Created
55	STAT_OLTPIPARDELV_I	☐	CRMT_STATUS_OLTPIPARDELV	BOOLEAN	CHAR	1	0	Status: OLTP Item Partially Delivered
56	STAT_OLTPICOMDELV_I	☐	CRMT_STATUS_OLTPICOMDELV	BOOLEAN	CHAR	1	0	Status: OLTP Item Completely Delivered
57	STAT_OLTPIPARCONF_I	☐	CRMT_STATUS_OLTPIPARCONF	BOOLEAN	CHAR	1	0	Status: OLTP Item Partially Confirmed
58	STAT_OLTPICOMCONF_I	☐	CRMT_STATUS_OLTPICOMCONF	BOOLEAN	CHAR	1	0	Status: OLTP Item Completely Confirmed
59	STAT_COMGOODIS_I	☐	CRMT_STATUS_COMGOODIS	BOOLEAN	CHAR	1	0	Status: Goods Issue Complete
60	STAT_PARGOODIS_I	☐	CRMT_STATUS_PARGOODIS	BOOLEAN	CHAR	1	0	Status: Partial Goods Issue
61	STAT_INVOFULL_I	☐	CRMT_STATUS_INVOFULL	BOOLEAN	CHAR	1	0	Status: Fully Invoiced
62	STAT_INVOPART_I	☐	CRMT_STATUS_INVOPART	BOOLEAN	CHAR	1	0	Status: Partially Invoiced
63	STAT_CANCONSRV_I	☐	CRMT_STATUS_CANCONSRV	BOOLEAN	CHAR	1	0	Status: Cancellation of Service Confirmation
64	STATUS_USER_I	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
65	STATUS_SYSTEM_I	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
66	USER_STAT_PROC_I	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
67	PROCESS_I	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
68	KIND_I	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
69	TXT04_I	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
70	TXT30_I	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
71	CANCPROC_I	☐	CRMT_CANC_PROCEDURE	CRM_CANCPROCEDURE	CHAR	4	0	Cancellation Procedure
72	CANCPARTY_I	☐	CRMT_CANC_PARTY	CRM_CANC_PARTY	CHAR	4	0	Cancelling Party
73	CANC_REASON_I	☐	CRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	CRM Service : Reason for Cancellation	*
74	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
75	LATESTTIM_CNFRMD	☐	CRMT_SCHEDLIN_LTIME_CONFIRMED	BCOS_TSTMP	DEC	15	0	Latest Confirmation Date for an Item
76	LATESTTIME_ORDER	☐	CRMT_SCHEDLIN_LTIME_ORDER	BCOS_TSTMP	DEC	15	0	Latest Requested Date for an Item
77	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
78	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
79	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
80	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
81	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
82	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
83	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
84	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
85	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
86	MATERIAL	☐	COMT_OLTP_MAT_NUMBER	COM_LONG_MAT_NUMBER	CHAR	40	0	Material Number for Product in OLTP System (Display Only)
87	.INCLUDE	☐				0	0	Item: Structre of External Fields
88	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
89	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
90	ALTERNATIVE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
91	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
92	PRODUCT_SRC_SYS	☐	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
93	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
94	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
95	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
96	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
97	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
98	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
99	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
100	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
101	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
102	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
103	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
104	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
105	LOG_SYSTEM_EXT	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
106	.INCLUDE	☐				0	0	EEW Extension
107	ORDERADM_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
108	.INCLUDE	☐				0	0
109	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_I_EXT
110	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
111	PARENT_IN_COMP_TX	☐	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
112	NUMBER_INT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
113	.INCLUDE	☐				0	0	Item: Structure of System Fields
114	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
115	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
116	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
117	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
118	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
119	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
120	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
121	.INCLUDE	☐				0	0	Compressed Item Information for Sales
122	DATE_CONTSTART	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
123	TZONE_CONTSTART	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
124	DATE_CONTEND	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
125	TZONE_CONTEND	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
126	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
127	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
128	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
129	VENDOR	☐	CRMT_VENDOR	BU_PARTNER	CHAR	10	0	Vendor	*
130	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
131	SALES_EMPLOYEE_LIST	☐	CRMT_SALES_EMPLOYEE_LIST	TEXT80	CHAR	80	0	Sales Representative
132	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
133	PERSON_RESP_LIST	☐	CRMT_PERSON_RESP_LIST	TEXT80	CHAR	80	0	Employee Responsible
134	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
135	SHIP_TO_PARTY_LIST	☐	CRMT_SHIP_TO_PART_LIST	TEXT80	CHAR	80	0	Ship-To Party: Name
136	BILL_TO_PARTY_LIST	☐	CRMT_BILL_TO_PART_LIST	TEXT80	CHAR	80	0	Bill-To Party: Name
137	PAYER_LIST	☐	CRMT_RP_PAYER_LIST	TEXT80	CHAR	80	0	Payer: Name
138	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
139	CONTACT_PERSON_LIST	☐	CRMT_CONTACT_PERSON_LIST	TEXT80	CHAR	80	0	Contact Person
140	PPR_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
141	RELEASED_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
142	RELEASED_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
143	RELEASED_VALUE	☐	CRMT_CUM_VALUE	CRM_COND_VALUE	CURR	19	2	Cumulative Value
144	RELEASED_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
145	TARGET_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
146	TARGET_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
147	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
148	TARGET_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
149	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
150	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
151	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
152	GRADE	☐	BP_GRADE	BP_GRADE	CHAR	10	0	Rating	*
153	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	*
154	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
155	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
156	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
157	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
158	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
159	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
160	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
161	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
162	INT_OBJ_NO	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
163	EXIST_VCKEY	☐	CRMT_EXIST_VCKEY	BOOLEAN	CHAR	1	0	Indicator Variant Key Available for Item
164	ROOT_CONFIG	☐	CRMT_ROOT_CONFIG	BOOLEAN	CHAR	1	0	Root Configuration Indicator
165	COMP_QTY	☐	CRMT_COMP_QTY	MENG13	QUAN	13	3	Component quantity
166	COMP_QTY_UNIT	☐	CRMT_COMP_QTY_UNIT	MEINS	UNIT	3	0	Component unit of measure	*
167	BASE_QTY	☐	CRMT_BASE_QTY	MENG13	QUAN	13	3	Base quantity
168	OBJ_IDENT	☐	CRMT_OBJ_IDENT	CHAR50	CHAR	50	0	Object Identifier
169	OBJ_TYPE	☐	CRMT_OBJ_TYPE	CRM_OBJ_TYPE	CHAR	2	0	Type of Object Identifier
170	DATE_KB_DETERM	☐	CRMT_DATE_KB_DETERMINATION	DATUM	DATS	8	0	Date for KB Determination in IPC(Master Data Version Config)
171	CONFIG_FILTER	☐	CRMT_CONFIG_FILTER	IB_INSTANCE	NUMC	18	0	Configuration Filter
172	FILTER_REF	☐	CRMT_FILTER_REF	BOOLEAN	CHAR	1	0	Filter Flag is Referenced
173	PURCHASE_OPTION	☐	CRMT_PURCHASE_OPTION	CRMT_PURCHASE_OPTION	CHAR	1	0	End of Lease Purchase Option
174	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
175	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
176	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
177	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
178	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
179	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
180	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
181	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
182	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
183	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
184	CATALOG_ITEM	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
185	DESCRIPT_PARTNER_PUR	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
186	ITM_TYPE_TEXT	☐	CRMT_ITM_TYPE_DESC	TEXT40	CHAR	40	0	Item Category Text
187	DELIVERY_BLOCK	☐	CRMT_BUS_DEL_BLOCK_REASON	CRMT_BUS_DEL_BLOCK_REASON	CHAR	2	0	Business Partner (CRM): Delivery Block Reason	*
188	BILL_VALUE	☐	CRMT_INVOICED_VAL_OLTP	CRM_COND_VALUE	CURR	19	2	Billed Value of an Item
189	DELV_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
190	DELV_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
191	BILL_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
192	DELV_VALUE	☐	CRMT_DELV_VAL_OLTP	CRM_COND_VALUE	CURR	19	2	Delivered Value of an Item
193	DELV_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
194	BILL_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
195	BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
196	EARLCONF_DATE	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
197	CREATEDATDATE_I	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
198	CHANGEDATDATE_I	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
199	ORDER_DATE_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
200	.INCLUDE	☐				0	0	Reporting reference and configurated product data
201	REF_IOBJECTID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
202	REF_IOBJECTGU_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
203	REF_CNF_PRODID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
204	REF_CNF_PRODGU_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
205	REF_PROD_ID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
206	REF_PROD_GUID_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
207	REF_OBJ_FAM_I	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
208	.INCLUDE	☐				0	0	Item: Structure of System Fields
209	CUSTOMER_INT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
210	.INCLUDE	☐				0	0	Item: Structre of External Fields
211	CUSTOMER_EXT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
212	.INCLUDE	☐				0	0	EEW Include
213	CUSTOMER_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
214	.INCLUDE	☐				0	0
215	.INCLUDE	☐				0	0	PARTNER (Locator) Various Partner Functions
216	INSTALL_AT	☐	CRMT_INSTALL_AT_PART	BU_PARTNER	CHAR	10	0	Installed At	*
217	INSTALL_AT_LIST	☐	CRMT_INSTALL_AT_LIST	CHAR80	CHAR	80	0	Installed At - Name
218	RESPONS_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
219	END_CUSTOMER	☐	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
220	RESP_AT_PART	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
221	.INCLUDE	☐				0	0	Collective Purchasing Item Fields for Reporting Framework
222	PALTZHALTER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
223	.INCLUDE	☐				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
224	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
225	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
226	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
227	COMPETITOR_LIST	☐	CRMT_COMPETITOR_LIST	TEXT80	CHAR	80	0	Competitor
228	PROSPECT_LIST	☐	CRMT_PROSPECT_LIST	TEXT80	CHAR	80	0	Sales Prospect
229	ACTIVITY_PARTNER_LIST	☐	CRMT_ACTIVITY_PARTNER_LIST	TEXT80	CHAR	80	0	Activity Partner
230	.INCLUDE	☐				0	0	Output Fields: Service for CRM Transaction
231	KF_SRV_RREADY	☐	CRMT_BW_SRV_DATES	CRMT_BW_SRV_DATES	INT1	3	0	Data Element for Service - Date Key Figures
232	.INCLUDE	☐				0	0	Organizational Data (Service)
233	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
234	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
235	DATE_TS_SRVFIRST	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
236	TZONE_SRVFIRST	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
237	DATE_SRVFIRST	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
238	TIME_SRVFIRST	☐	CRMT_BSP_TIME_HHMM_FROM	CRM_BSP_TIME_HHMM	TIMS	6	0	From
239	DATE_TS_SRVEND	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
240	TZONE_SRVEND	☐	CRMT_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone for End Time	*
241	DATE_SRVEND	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
242	TIME_SRVEND	☐	CRMT_BSP_TIME_HHMM_TO	CRM_BSP_TIME_HHMM	TIMS	6	0	To
243	.INCLUDE	☐				0	0	Product Master attributes
244	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
245	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
246	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
247	COMPETITOR_PROD	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
248	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
249	COMP_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
250	.INCLUDE	☐				0	0
251	.INCLUDE	☐				0	0
252	.INCLUDE	☐				0	0
253	.INCLUDE	☐				0	0
254	.INCLUDE	☐				0	0
255	.INCLUDE	☐				0	0
256	.INCLUDE	☐				0	0
257	.INCLUDE	☐				0	0
258	.INCLUDE	☐				0	0	RMA Item Fields for Reporting Framework
259	RMA	☐	CRMT_RMA	CRM_RMA	CHAR	20	0	Approval Number - Return Delivery
260	TST_END_LOG_EXT	☐	CRMT_TIME_STAMP_END_LOG_EXT	TZNTSTMPS	DEC	15	0	Time Stamp of End of Appointment
261	ZONE_END_LOG_EXT	☐	CRMT_TIME_ZONE_RMA	TZNZONE	CHAR	6	0	Appointment Calendar: Time Zone of End of Appointment	*
262	.INCLUDE	☐				0	0	Provider Order Item Reporting Extension
263	.INCLUDE	☐				0	0	Provider Order Item Extension: Query Result relevant data
264	A3SELTYPE	☐	IST_SELECTION_TYPE	IST_SELECTION_TYPE	CHAR	1	0	Product Selection Type
265	A3EXTREF	☐	CRMT_IST_EXT_REF_TEXT	CRMT_IST_EXT_REF_TEXT	CHAR	40	0	IS-T Contract Number
266	MA_PROD_ID	☐	CRMT_ISX_PRVMA_PROD_ID	CRMT_ISX_PRVMA_PROD_ID	CHAR	40	0	Custom Specific ID for Product or Product Range
267	LEAD_TR_OBJ_ID	☐	CRMT_LEADING_TECH_RES_ID	CRM_TC_TECH_RES_ID	CHAR	50	0	ID of leading technical resource in a Provider Contract
268	TR_TYPE	☐	CRMT_TC_TR_TYPE	CRM_TC_TR_TYPE	CHAR	2	0	Technical Resource Type	*
269	TR_TYPE_DESC	☐	CRMT_TR_TYPE_DESC		CHAR	40	0	Technical Resource Type Description
270	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
271	MR_ELEMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
272	.INCLUDE	☐				0	0	CRM Service Item: Structure of External Fields
273	.INCLUDE	☐				0	0	Service Process
274	DISPO_FLG	☐	CRMT_SRV_DISPO_FLG	FLAG	CHAR	1	0	Relevant for Resource Planning
275	CONFIRM_RELEVANT	☐	CRMT_CONFIRM_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Confirmation
276	INSPEC_RELEVANT	☐	CRMT_INSPECTION_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Inspection
277	.INCLUDE	☐				0	0	Service Confirmation
278	SRV_CONF_TIME	☐	CRMT_SRV_CONF_DURATION	DAUER_5_2	QUAN	7	2	Confirmed Duration
279	SRV_CONF_TUNIT	☐	CRMT_SRV_CONF_TIME_UNIT	MEINS	UNIT	3	0	Time Unit for Confirmed Duration	T006
280	ASSIGNMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
281	.INCLUDE	☐				0	0	ServiceProcess General Fields for TransactionAndConfirmation
282	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
283	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
284	.INCLUDE	☐				0	0	Service Agreements (SLA)
285	SRV_ESCAL	☐	CRMT_SRV_ESCAL	CRM_SRV_ESCAL	CHAR	10	0	Response Profile	CRMD_ESCAL
286	SRV_SERWI	☐	CRMT_SRV_SERWI	CRM_SRV_SERWI	CHAR	10	0	Service Profile	CRMD_SERWI
287	SRV_RULE_ID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
288	SRCL_SERVICE_PROFILE	☐	CRMT_SRCL_SRVPRF	CRM_SRV_SERWI	CHAR	10	0	Processing Times: Service Profile	*
289	SRCL_RESPONSE_PROFILE	☐	CRMT_SRCL_RSPRF	CRM_SRCL_RSPRF	CHAR	10	0	Processing Time: Response Profile	*
290	.INCLUDE	☐				0	0	Service Process Fields for Warranty Management
291	WARRANTY	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
292	WARRANTY_ID	☐	CRMT_WTY_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Warranty ID
293	.INCLUDE	☐				0	0	EEW Include
294	SERVICE_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
295	.INCLUDE	☐				0	0
296	.INCLUDE	☐				0	0	Claim Item - Structure of Internal Fields
297	CLAIMED_AMOUNT	☐	CRMT_CLA_CLAIMED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Claimed Amount
298	.INCLUDE	☐				0	0	General docflow item data for Transaction Reporting
299	SUCC_SRVCONFOPN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
300	SUCC_SRVCONFEROR	☐	CRMT_STATUS_ERROR	CRM_BOOLEAN	CHAR	1	0	Indicates Whether Document is Incorrect
301	SUB_OPP_GUID_H	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
302	MASTEROPP_FLAG_I	☐	CRMT_MASTEROPP_FLAG	CRMT_MASTEROPP_FLAG	CHAR	1	0	Flag to indicate master opportunity
303	.INCLUDE	☐				0	0	Reporting Framework DocFlow BW DataSources on Item level
304	PREDEC_OBJKEY_I	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
305	PREDEC_OBJTYPE_I	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
306	LOGSYS_PRED_I	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
307	MKT_ELEMENT_I	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
308	PRED_LEAD_GUID_I	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
309	LEAD_CREATED_AT_I	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
310	PRED_OPPT_GUID_I	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
311	OPPT_CREATED_AT_I	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
312	PRED_ACT_GUID_IH	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
313	ACT_CATEGORY_IH	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
314	ACT_DIRECTION_IH	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
315	QUOTATION_GUID_I	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
316	QUOT_VALID_FROM_I	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
317	PROCESS_CATEGORY_IH	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
318	PROCESS_CATALOG_I	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
319	PROCESS_CODEGR_I	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
320	PROCESS_CODE_I	☐	QCODE	QCODE	CHAR	4	0	Code	*
321	PROCESS_OBJTYPE_I	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
322	PO_NUMBER_I	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
323	PO_ITEM_NUMBER_I	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
324	.INCLUDE	☐				0	0	Reporting Output requested objects on item level
325	ET_APPOINTMENT	☐	CRMT_REPORT_APPOINTMENTS_TA		TTYP	0	0
326	ET_STATUS	☐	CRMT_REPORT_STATUSS_ITEM_TA		TTYP	0	0
327	ET_PARTNER	☐	CRMT_REPORT_PARTNER_ITEM_TA		TTYP	0	0
328	ET_LANGU_SYSSTAT	☐	SLANSPRAST		TTYP	0	0
329	ET_LANGU_USERSTAT	☐	SLANSPRAST		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_REPORT_REPORTLIST_ITEM	SRV_CONF_TUNIT	T006	MSEHI		1	CN
2	CRMT_REPORT_REPORTLIST_ITEM	SRV_ESCAL	CRMD_ESCAL	SRV_ESCAL
3	CRMT_REPORT_REPORTLIST_ITEM	SRV_SERWI	CRMD_SERWI	SRV_SERWI

History

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