SAP ABAP Table /CRMBW/OLTP_EXT_SRV_REQU_VDM (Extract Structure for OLTP Service Request data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-OR (Application Component) Interactive Reporting
     ⤷ /CRMBW/OP_REPORTING_VDM (Package) Operational (Interactive) Reporting (HANA VDM based)

Basic Data

Table Category	INTTAB	Structure
Structure	/CRMBW/OLTP_EXT_SRV_REQU_VDM	Table Relationship Diagram
Short Description	Extract Structure for OLTP Service Request data

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	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	OBJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
7	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
8	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
9	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
10	POSTING_DATE_Y	☐	RSCALYEAR	GJAHR	NUMC	4	0	Calendar year
11	POSTING_DATE_Q	☐	RSCALQUART	RSCALQUART	NUMC	5	0	Calendar year / quarter
12	POSTING_DATE_M	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
13	POSTING_DATE_W	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
14	POSTING_DATE_D	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
15	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
16	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
17	CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
18	CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
19	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
20	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
21	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
22	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
23	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
24	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
25	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
26	SOLD_TO_COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
27	SOLD_TO_REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
28	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
29	CURRENCY_D	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
30	GROSS_VALUE_H	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
31	GROSS_VALUE_H_D	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
32	REFOBJ_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
33	REFOBJ_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
34	REFOBJ_PRODUCTID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
35	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
36	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
37	GUID_OBJECT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
38	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
39	CAT_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
40	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
41	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
42	REC_PRIORITY	☐	CRMT_SRQM_REC_PRIORITY	SC_PRIO	NUMC	1	0	Recommended Priority	*
43	URGENCY	☐	CRMT_SRQM_URGENCY	CRM_SRQM_URGENCY	NUMC	2	0	Urgency	*
44	IMPACT	☐	CRMT_SRQM_IMPACT	CRM_SRQM_IMPACT	NUMC	2	0	Impact	*
45	ESCALATION	☐	CRMT_SRQM_ESCALATION	CRM_SRQM_ESCALATION	NUMC	1	0	Escalation
46	CHANGE_CATEGORY	☐	CRMT_SRQM_CHANGE_CAT	CRM_SRQM_CHANGE_CAT	CHAR	3	0	Change Category	*
47	SRQ_WORK_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
48	SRQ_WORK_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
49	SRQ_TOT_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
50	SRQ_TOT_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
51	SRQ_WORK_DURA_QU	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
52	SRQ_WORK_UNIT_QU	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
53	SRQ_TOT_DURA_QU	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
54	SRQ_TOT_UNIT_QU	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
55	SRV_REQ_END_DAT	☐	CRMT_REPORT_ENDDATE	DATUM	DATS	8	0	End Date
56	SRV_RSP_FRST_DAT	☐	CRMT_REPORT_STARTDATE	DATUM	DATS	8	0	Start Date
57	.INCLUDE	☐				0	0	Coherent Catgory level GUID
58	CATLVLGUID01_01	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
59	CATLVLGUID02_01	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
60	CATLVLGUID03_01	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
61	CATLVLGUID04_01	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
62	CATLVLGUID05_01	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
63	CATLVLGUID06_01	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
64	CATLVLGUID07_01	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
65	CATLVLGUID08_01	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
66	CATLVLGUID09_01	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
67	CATLVLGUID10_01	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
68	CATLVLGUID01_02	☐	CRM_REP_CAT_GUID_LEV01_S2	SYSUUID	RAW	16	0	Category GUID 1- schema 2
69	CATLVLGUID02_02	☐	CRM_REP_CAT_GUID_LEV02_S2	SYSUUID	RAW	16	0	Category GUID 2- schema 2
70	CATLVLGUID03_02	☐	CRM_REP_CAT_GUID_LEV03_S2	SYSUUID	RAW	16	0	Category GUID 3- schema 2
71	CATLVLGUID04_02	☐	CRM_REP_CAT_GUID_LEV04_S2	SYSUUID	RAW	16	0	Category GUID 4- schema 2
72	CATLVLGUID05_02	☐	CRM_REP_CAT_GUID_LEV05_S2	SYSUUID	RAW	16	0	Category GUID 5- schema 2
73	CATLVLGUID06_02	☐	CRM_REP_CAT_GUID_LEV06_S2	SYSUUID	RAW	16	0	Category GUID 6- schema 2
74	CATLVLGUID07_02	☐	CRM_REP_CAT_GUID_LEV07_S2	SYSUUID	RAW	16	0	Category GUID 7- schema 2
75	CATLVLGUID08_02	☐	CRM_REP_CAT_GUID_LEV08_S2	SYSUUID	RAW	16	0	Category GUID 8- schema 2
76	CATLVLGUID09_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
77	CATLVLGUID10_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
78	CATLVLGUID01_03	☐	CRM_REP_CAT_GUID_LEV01_S3	SYSUUID	RAW	16	0	Category GUID 1- schema 3
79	CATLVLGUID02_03	☐	CRM_REP_CAT_GUID_LEV02_S3	SYSUUID	RAW	16	0	Category GUID 2- schema 3
80	CATLVLGUID03_03	☐	CRM_REP_CAT_GUID_LEV03_S3	SYSUUID	RAW	16	0	Category GUID 3- schema 3
81	CATLVLGUID04_03	☐	CRM_REP_CAT_GUID_LEV04_S3	SYSUUID	RAW	16	0	Category GUID 4- schema 3
82	CATLVLGUID05_03	☐	CRM_REP_CAT_GUID_LEV05_S3	SYSUUID	RAW	16	0	Category GUID 5- schema 3
83	CATLVLGUID06_03	☐	CRM_REP_CAT_GUID_LEV06_S3	SYSUUID	RAW	16	0	Category GUID 6- schema 3
84	CATLVLGUID07_03	☐	CRM_REP_CAT_GUID_LEV07_S3	SYSUUID	RAW	16	0	Category GUID 7- schema 3
85	CATLVLGUID08_03	☐	CRM_REP_CAT_GUID_LEV08_S3	SYSUUID	RAW	16	0	Category GUID 8- schema 3
86	CATLVLGUID09_03	☐	CRM_REP_CAT_GUID_LEV09_S3	SYSUUID	RAW	16	0	Category GUID 9- schema 3
87	CATLVLGUID10_03	☐	CRM_REP_CAT_GUID_LEV10_S3	SYSUUID	RAW	16	0	Category GUID 10- schema 3
88	CATLVLGUID01_04	☐	CRM_REP_CAT_GUID_LEV01_S4	SYSUUID	RAW	16	0	Category GUID 1- schema 4
89	CATLVLGUID02_04	☐	CRM_REP_CAT_GUID_LEV02_S4	SYSUUID	RAW	16	0	Category GUID 2- schema 4
90	CATLVLGUID03_04	☐	CRM_REP_CAT_GUID_LEV03_S4	SYSUUID	RAW	16	0	Category GUID 3- schema 4
91	CATLVLGUID04_04	☐	CRM_REP_CAT_GUID_LEV04_S4	SYSUUID	RAW	16	0	Category GUID 4- schema 4
92	CATLVLGUID05_04	☐	CRM_REP_CAT_GUID_LEV05_S4	SYSUUID	RAW	16	0	Category GUID 5- schema 4
93	CATLVLGUID06_04	☐	CRM_REP_CAT_GUID_LEV06_S4	SYSUUID	RAW	16	0	Category GUID 6- schema 4
94	CATLVLGUID07_04	☐	CRM_REP_CAT_GUID_LEV07_S4	SYSUUID	RAW	16	0	Category GUID 7- schema 4
95	CATLVLGUID08_04	☐	CRM_REP_CAT_GUID_LEV08_S4	SYSUUID	RAW	16	0	Category GUID 8- schema 4
96	CATLVLGUID09_04	☐	CRM_REP_CAT_GUID_LEV09_S4	SYSUUID	RAW	16	0	Category GUID 9- schema 4
97	CATLVLGUID10_04	☐	CRM_REP_CAT_GUID_LEV10_S4	SYSUUID	RAW	16	0	Category GUID 10- schema 4
98	CATLVLGUID01_05	☐	CRM_REP_CAT_GUID_LEV01_S5	SYSUUID	RAW	16	0	Category GUID 1- schema 5
99	CATLVLGUID02_05	☐	CRM_REP_CAT_GUID_LEV02_S5	SYSUUID	RAW	16	0	Category GUID 2- schema 5
100	CATLVLGUID03_05	☐	CRM_REP_CAT_GUID_LEV03_S5	SYSUUID	RAW	16	0	Category GUID 3- schema 5
101	CATLVLGUID04_05	☐	CRM_REP_CAT_GUID_LEV04_S5	SYSUUID	RAW	16	0	Category GUID 4- schema 5
102	CATLVLGUID05_05	☐	CRM_REP_CAT_GUID_LEV05_S5	SYSUUID	RAW	16	0	Category GUID 5- schema 5
103	CATLVLGUID06_05	☐	CRM_REP_CAT_GUID_LEV06_S5	SYSUUID	RAW	16	0	Category GUID 6- schema 5
104	CATLVLGUID07_05	☐	CRM_REP_CAT_GUID_LEV07_S5	SYSUUID	RAW	16	0	Category GUID 7- schema 5
105	CATLVLGUID08_05	☐	CRM_REP_CAT_GUID_LEV08_S5	SYSUUID	RAW	16	0	Category GUID 8- schema 5
106	CATLVLGUID09_05	☐	CRM_REP_CAT_GUID_LEV09_S5	SYSUUID	RAW	16	0	Category GUID 9- schema 5
107	CATLVLGUID10_05	☐	CRM_REP_CAT_GUID_LEV10_S5	SYSUUID	RAW	16	0	Category GUID 10- schema 5
108	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
109	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
110	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
111	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
112	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
113	REPORT_AREA	☐	CRMT_OR_INFOTYPE		CHAR	30	0	Report Area
114	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
115	PRE_SRV_CONTRACT	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
116	PREDGUID_BRELVONAE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
117	PREDOBJTYPE_BRELVONAE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
118	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
119	NCLOSRQ	☐	/CRMBW/OLTP_VDM_NCLOSRQ		INT4	10	0	Number of Closed Service Requests
120	NOPNSRQ	☐	/CRMBW/OLTP_VDM_NOPNSRQ		INT4	10	0	Number of Open Service Requests
121	NSRQWRE	☐	/CRMBW/OLTP_VDM_NSRQWRE		INT4	10	0	Number of Service Requests Within Requested End
122	NSRQORE	☐	/CRMBW/OLTP_VDM_NSRQORE		INT4	10	0	Number of Service Requests Outside Requested End
123	NESRQL1	☐	/CRMBW/OLTP_VDM_NESRQL1		INT4	10	0	Number of Escalated Service Requests (Escalation Level 1)
124	NESRQL2	☐	/CRMBW/OLTP_VDM_NESRQL2		INT4	10	0	Number of Escalated Service Requests (Escalation Level 2)
125	NSRQORT	☐	/CRMBW/OLTP_VDM_NSRQORT		INT4	10	0	Number of Service Requests Outside Reaction Time
126	NCSRQTM	☐	/CRMBW/OLTP_VDM_NCSRQTM		INT4	10	0	Number of Closed Service Requests This Month
127	SEL_GUID	☐	/CRMBW/OLTP_VDM_SEL_GUID_CHAR		CHAR	32	0	Selection GUID as char

History

Last changed by/on	SAP	20141013
SAP Release Created in	713