SAP ABAP Table CRMST_QUERY_R_SRV_MON_ITA_BTIL (Service Monitor: Advanced Item Result)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-SRV (Application Component) Service Analytics
     ⤷ CRM_SRVMON (Package) Service Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_R_SRV_MON_ITA_BTIL	Table Relationship Diagram
Short Description	Service Monitor: Advanced Item Result

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	Search Result Structure for Service Monitor: Item
2	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
3	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
7	NUMBER_PARENT	☐	CRMT_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Transaction
8	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
9	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
10	ITM_TYPE_TEXT	☐	CRMT_ITM_TYPE_DESC_20	TEXT20	CHAR	20	0	Item Category Text(20 character)
11	CONCATSTAT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
12	CONCATSTATUSER	☐	CRMT_REPORT_USERSTATUS	TEXT40	CHAR	40	0	User Status
13	STAT_REJECTION	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
14	STAT_STOCKTRANSFER	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
15	STAT_DELIVERY	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
16	STAT_GOODSISSUE	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
17	STAT_CONFIRMATION	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
18	STAT_BILLING	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
19	STAT_AVAILABILITY	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
20	STAT_CANCELLATION	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
21	STAT_SLA	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
22	STAT_CHECKLIST	☐	CRMT_SRV_MONITOR_STATUS	CRMT_SRV_MONITOR_STATUS	CHAR	1	0	CRM Service Monitor: Status
23	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
24	PROCESS_TYPE_TXT	☐	CRMT_REPORT_PROCESS_TYPE_TXT	DDTEXT	CHAR	60	0	Text Description for Transaction Category
25	HD_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
26	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
27	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
28	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
29	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
30	BILL_TO_PARTY_LIST	☐	CRMT_BILL_TO_PART_LIST	TEXT80	CHAR	80	0	Bill-To Party: Name
31	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
32	CONTACT_PERSON_LIST	☐	CRMT_CONTACT_PERSON_LIST	TEXT80	CHAR	80	0	Contact Person
33	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
34	PAYER_LIST	☐	CRMT_RP_PAYER_LIST	TEXT80	CHAR	80	0	Payer: Name
35	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
36	SHIP_TO_PARTY_LIST	☐	CRMT_SHIP_TO_PART_LIST	TEXT80	CHAR	80	0	Ship-To Party: Name
37	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
38	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
39	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
40	SALES_EMPLOYEE_LIST	☐	CRMT_SALES_EMPLOYEE_LIST	TEXT80	CHAR	80	0	Sales Representative
41	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
42	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
43	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
44	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
45	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
46	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
47	TZONE_SRVFIRST	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
48	DATE_SRVFIRST	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
49	TIME_SRVFIRST	☐	CRMT_BSP_TIME_HHMM_FROM	CRM_BSP_TIME_HHMM	TIMS	6	0	From
50	TZONE_SRVEND	☐	CRMT_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone for End Time	*
51	DATE_SRVEND	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
52	TIME_SRVEND	☐	CRMT_BSP_TIME_HHMM_TO	CRM_BSP_TIME_HHMM	TIMS	6	0	To
53	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
54	SALES_GROUP_SHORT	☐	CRMT_SALES_GROUP_SHORT	TEXT12	CHAR	12	0	Sales Group Abbreviation
55	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
56	SALES_OFFICE_SHORT	☐	CRMT_SALES_OFFICE_SHORT	TEXT12	CHAR	12	0	Sales Office Abbreviation
57	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
58	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
59	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
60	SALES_ORG_RESP_SHORT	☐	CRMT_SALES_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Sales)
61	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
62	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
63	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
64	SERVICE_ORG_SHORT	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
65	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
66	SERVICE_ORG_RESP_SHORT	☐	CRMT_SERVICE_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Service)
67	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
68	PERSON_RESP_LIST	☐	CRMT_PERSON_RESP_LIST	TEXT80	CHAR	80	0	Employee Responsible

History

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