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