SAP ABAP Table /CRMBW/OLTP_EXT_SRV_TICKET (Extract Structure for OLTP Service Ticket Reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA (Application Component) CRM Analytics
     ⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI

Basic Data

Table Category	INTTAB	Structure
Structure	/CRMBW/OLTP_EXT_SRV_TICKET	Table Relationship Diagram
Short Description	Extract Structure for OLTP Service Ticket Reporting

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
4	.INCLUDE	☐				0	0	Extract Structure for OLTP Service Internal Fields
5	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
9	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
10	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
11	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
12	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
13	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
14	KATALOGART_SRV	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
15	CODEGRUPPE_SRV	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
16	CODE_SRV	☐	QCODE	QCODE	CHAR	4	0	Code	*
17	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
18	.INCLUDE	☐				0	0	EEW Include Service Order Search Result
19	EEW_R_SRVO_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
20	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
21	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
22	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
23	CAT_ID	☐	CRM_ERMS_CAT_CA_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	Coherent Cat. - Category ID
24	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
25	N_OF_CLOSED_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
26	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
27	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
28	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
29	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
30	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
31	LC_SRV_DURATION	☐	CRMT_BW_LIFECYCLE	CRMT_DAUER_10_3	QUAN	10	3	CRM Service: Lifecycle (Duration)
32	LC_SRV_DUR_UNIT	☐	CRMT_BW_LIFECYCLE_UNIT	MEINS	UNIT	3	0	CRM Service Lifecycle Unit (Duration)	*
33	SRV_RFIRST_RANGE	☐	CRMT_REPORT_STARTDATE	DATUM	DATS	8	0	Start Date
34	SRV_RREADY_RANGE	☐	CRMT_REPORT_ENDDATE	DATUM	DATS	8	0	End Date
35	SRV_CLOSE_RANGE	☐	CRMT_REPORT_ENDDATE	DATUM	DATS	8	0	End Date
36	.INCLUDE	☐				0	0	Field Catalog: Fields for the Service Ticket Extraction Item
37	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
38	.INCLUDE	☐				0	0	Internal Structure for Service Ticket Items
39	STAT_OPEN_I	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
40	KF_SRV_RREADY	☐	CRMT_BW_SRV_DATES	CRMT_BW_SRV_DATES	INT1	3	0	Data Element for Service - Date Key Figures
41	CHANGED_AT_I	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)

History

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