SAP ABAP Table /CRMBW/OLTP_EXT_COMPLAINT_VDM (Extract Structure for OLTP Complaint 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_COMPLAINT_VDM	Table Relationship Diagram
Short Description	Extract Structure for OLTP Complaint 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	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
9	POSTING_DATE_Y	☐	RSCALYEAR	GJAHR	NUMC	4	0	Calendar year
10	POSTING_DATE_Q	☐	RSCALQUART	RSCALQUART	NUMC	5	0	Calendar year / quarter
11	POSTING_DATE_M	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
12	POSTING_DATE_W	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
13	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
14	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
15	CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
16	CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
17	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
18	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
19	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
20	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
21	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
22	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
23	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
24	SOLD_TO_COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
25	SOLD_TO_REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
26	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
27	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
28	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
29	CURRENCY_D	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
30	REFOBJ_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
31	REFOBJ_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
32	REFOBJ_PRODUCTID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
33	GUID_OBJECT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
34	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
35	CAT_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
36	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
37	STAT_RFC_APPROVD	☐	CRMT_STATUS_RFC_APPROVED	BOOLEAN	CHAR	1	0	Request for Change Approved or Awaiting Approval
38	STAT_RFC_REJECTD	☐	CRMT_STATUS_RFC_REJECTED	BOOLEAN	CHAR	1	0	Request for Change Rejected
39	SRV_REQ_END_DAT	☐	CRMT_REPORT_ENDDATE	DATUM	DATS	8	0	End Date
40	SRV_RSP_FRST_DAT	☐	CRMT_REPORT_STARTDATE	DATUM	DATS	8	0	Start Date
41	.INCLUDE	☐				0	0	Coherent Catgory level GUID
42	CATLVLGUID01_01	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
43	CATLVLGUID02_01	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
44	CATLVLGUID03_01	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
45	CATLVLGUID04_01	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
46	CATLVLGUID05_01	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
47	CATLVLGUID06_01	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
48	CATLVLGUID07_01	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
49	CATLVLGUID08_01	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
50	CATLVLGUID09_01	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
51	CATLVLGUID10_01	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
52	CATLVLGUID01_02	☐	CRM_REP_CAT_GUID_LEV01_S2	SYSUUID	RAW	16	0	Category GUID 1- schema 2
53	CATLVLGUID02_02	☐	CRM_REP_CAT_GUID_LEV02_S2	SYSUUID	RAW	16	0	Category GUID 2- schema 2
54	CATLVLGUID03_02	☐	CRM_REP_CAT_GUID_LEV03_S2	SYSUUID	RAW	16	0	Category GUID 3- schema 2
55	CATLVLGUID04_02	☐	CRM_REP_CAT_GUID_LEV04_S2	SYSUUID	RAW	16	0	Category GUID 4- schema 2
56	CATLVLGUID05_02	☐	CRM_REP_CAT_GUID_LEV05_S2	SYSUUID	RAW	16	0	Category GUID 5- schema 2
57	CATLVLGUID06_02	☐	CRM_REP_CAT_GUID_LEV06_S2	SYSUUID	RAW	16	0	Category GUID 6- schema 2
58	CATLVLGUID07_02	☐	CRM_REP_CAT_GUID_LEV07_S2	SYSUUID	RAW	16	0	Category GUID 7- schema 2
59	CATLVLGUID08_02	☐	CRM_REP_CAT_GUID_LEV08_S2	SYSUUID	RAW	16	0	Category GUID 8- schema 2
60	CATLVLGUID09_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
61	CATLVLGUID10_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
62	CATLVLGUID01_03	☐	CRM_REP_CAT_GUID_LEV01_S3	SYSUUID	RAW	16	0	Category GUID 1- schema 3
63	CATLVLGUID02_03	☐	CRM_REP_CAT_GUID_LEV02_S3	SYSUUID	RAW	16	0	Category GUID 2- schema 3
64	CATLVLGUID03_03	☐	CRM_REP_CAT_GUID_LEV03_S3	SYSUUID	RAW	16	0	Category GUID 3- schema 3
65	CATLVLGUID04_03	☐	CRM_REP_CAT_GUID_LEV04_S3	SYSUUID	RAW	16	0	Category GUID 4- schema 3
66	CATLVLGUID05_03	☐	CRM_REP_CAT_GUID_LEV05_S3	SYSUUID	RAW	16	0	Category GUID 5- schema 3
67	CATLVLGUID06_03	☐	CRM_REP_CAT_GUID_LEV06_S3	SYSUUID	RAW	16	0	Category GUID 6- schema 3
68	CATLVLGUID07_03	☐	CRM_REP_CAT_GUID_LEV07_S3	SYSUUID	RAW	16	0	Category GUID 7- schema 3
69	CATLVLGUID08_03	☐	CRM_REP_CAT_GUID_LEV08_S3	SYSUUID	RAW	16	0	Category GUID 8- schema 3
70	CATLVLGUID09_03	☐	CRM_REP_CAT_GUID_LEV09_S3	SYSUUID	RAW	16	0	Category GUID 9- schema 3
71	CATLVLGUID10_03	☐	CRM_REP_CAT_GUID_LEV10_S3	SYSUUID	RAW	16	0	Category GUID 10- schema 3
72	CATLVLGUID01_04	☐	CRM_REP_CAT_GUID_LEV01_S4	SYSUUID	RAW	16	0	Category GUID 1- schema 4
73	CATLVLGUID02_04	☐	CRM_REP_CAT_GUID_LEV02_S4	SYSUUID	RAW	16	0	Category GUID 2- schema 4
74	CATLVLGUID03_04	☐	CRM_REP_CAT_GUID_LEV03_S4	SYSUUID	RAW	16	0	Category GUID 3- schema 4
75	CATLVLGUID04_04	☐	CRM_REP_CAT_GUID_LEV04_S4	SYSUUID	RAW	16	0	Category GUID 4- schema 4
76	CATLVLGUID05_04	☐	CRM_REP_CAT_GUID_LEV05_S4	SYSUUID	RAW	16	0	Category GUID 5- schema 4
77	CATLVLGUID06_04	☐	CRM_REP_CAT_GUID_LEV06_S4	SYSUUID	RAW	16	0	Category GUID 6- schema 4
78	CATLVLGUID07_04	☐	CRM_REP_CAT_GUID_LEV07_S4	SYSUUID	RAW	16	0	Category GUID 7- schema 4
79	CATLVLGUID08_04	☐	CRM_REP_CAT_GUID_LEV08_S4	SYSUUID	RAW	16	0	Category GUID 8- schema 4
80	CATLVLGUID09_04	☐	CRM_REP_CAT_GUID_LEV09_S4	SYSUUID	RAW	16	0	Category GUID 9- schema 4
81	CATLVLGUID10_04	☐	CRM_REP_CAT_GUID_LEV10_S4	SYSUUID	RAW	16	0	Category GUID 10- schema 4
82	CATLVLGUID01_05	☐	CRM_REP_CAT_GUID_LEV01_S5	SYSUUID	RAW	16	0	Category GUID 1- schema 5
83	CATLVLGUID02_05	☐	CRM_REP_CAT_GUID_LEV02_S5	SYSUUID	RAW	16	0	Category GUID 2- schema 5
84	CATLVLGUID03_05	☐	CRM_REP_CAT_GUID_LEV03_S5	SYSUUID	RAW	16	0	Category GUID 3- schema 5
85	CATLVLGUID04_05	☐	CRM_REP_CAT_GUID_LEV04_S5	SYSUUID	RAW	16	0	Category GUID 4- schema 5
86	CATLVLGUID05_05	☐	CRM_REP_CAT_GUID_LEV05_S5	SYSUUID	RAW	16	0	Category GUID 5- schema 5
87	CATLVLGUID06_05	☐	CRM_REP_CAT_GUID_LEV06_S5	SYSUUID	RAW	16	0	Category GUID 6- schema 5
88	CATLVLGUID07_05	☐	CRM_REP_CAT_GUID_LEV07_S5	SYSUUID	RAW	16	0	Category GUID 7- schema 5
89	CATLVLGUID08_05	☐	CRM_REP_CAT_GUID_LEV08_S5	SYSUUID	RAW	16	0	Category GUID 8- schema 5
90	CATLVLGUID09_05	☐	CRM_REP_CAT_GUID_LEV09_S5	SYSUUID	RAW	16	0	Category GUID 9- schema 5
91	CATLVLGUID10_05	☐	CRM_REP_CAT_GUID_LEV10_S5	SYSUUID	RAW	16	0	Category GUID 10- schema 5
92	.INCLUDE	☐				0	0	ADVS Selection fields for Local BI Reporting
93	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
94	SELECTION_ID	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
95	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
96	APP_SERVER	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
97	REPORT_AREA	☐	CRMT_OR_INFOTYPE		CHAR	30	0	Report Area
98	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
99	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
100	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
101	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
102	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
103	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
104	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
105	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
106	GROSS_VALUE_D	☐	/CRMBW/OLTP_VDM_GROSS_VALUE_D		CURR	15	2	Gross Value (Document Currency)
107	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
108	WARRANTY	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
109	WARRANTY_ID	☐	CRMT_WTY_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Warranty ID
110	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
111	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
112	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
113	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
114	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
115	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
116	OBJECT_TYPE_I	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
117	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
118	N_OF_COMPL_WARR	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
119	CREATEDATDATE_I	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
120	CMNVIC	☐	/CRMBW/OLTP_VDM_CMNVIC		CURR	15	2	Credit Memo Net Value Items
121	CMNVEIC	☐	/CRMBW/OLTP_VDM_CMNVEIC		CURR	15	2	Credit Memo Net Value Service Items
122	CMNVAIC	☐	/CRMBW/OLTP_VDM_CMNVAIC		CURR	15	2	Credit Memo Net Value Sales Items
123	DMNVIC	☐	/CRMBW/OLTP_VDM_DMNVIC		CURR	15	2	Debit Memo Net Value Items
124	DMNVEIC	☐	/CRMBW/OLTP_VDM_DMNVEIC		CURR	15	2	Debit Memo Net Value Service Items
125	DMNVAIC	☐	/CRMBW/OLTP_VDM_DMNVAIC		CURR	15	2	Debit Memo Net Value Sales Items
126	REPNVIC	☐	/CRMBW/OLTP_VDM_REPNVIC		CURR	15	2	Replacement Net Value Items
127	SACNVIC	☐	/CRMBW/OLTP_VDM_SACNVIC		CURR	15	2	Sales Complaint Net Value Items
128	SCNVIC	☐	/CRMBW/OLTP_VDM_SCNVIC		CURR	15	2	Service Complaint Net Value Items
129	NVOCIC	☐	/CRMBW/OLTP_VDM_NVOCIC		CURR	15	2	Net Value of Complaint Items (Service and Sales)
130	NVORIC	☐	/CRMBW/OLTP_VDM_NVORIC		CURR	15	2	Net Value of Returns Items
131	NOCIS	☐	/CRMBW/OLTP_VDM_NOCIS		INT4	10	0	Number of Complaint Items (Service)
132	NOCISA	☐	/CRMBW/OLTP_VDM_NOCISA		INT4	10	0	Number of Complaint Items (Sales)
133	NOCISS	☐	/CRMBW/OLTP_VDM_NOCISS		INT4	10	0	Number of Complaint Items (Service and Sales)
134	NVOCI	☐	/CRMBW/OLTP_VDM_NVOCI		CURR	15	2	Net Value of Complaint Items (Service & Sales) (Doc. Curr.)
135	NOSCMI	☐	/CRMBW/OLTP_VDM_NOSCMI		INT4	10	0	Number of Service Credit Memo Items
136	NOSACMI	☐	/CRMBW/OLTP_VDM_NOSACMI		INT4	10	0	Number of Sales Credit Memo Items
137	NOSDMI	☐	/CRMBW/OLTP_VDM_NOSDMI		INT4	10	0	Number of Service Debit Memo Items
138	NOSADMI	☐	/CRMBW/OLTP_VDM_NOSADMI		INT4	10	0	Number of Sales Debit Memo Items
139	NOREPI	☐	/CRMBW/OLTP_VDM_NOREPI		INT4	10	0	Number of Replacement Items
140	NORETNI	☐	/CRMBW/OLTP_VDM_NORETNI		INT4	10	0	Number of Return Items
141	NVORI	☐	/CRMBW/OLTP_VDM_NVORI		CURR	15	2	Net Value of Returns Items (Document Currency)
142	SCNVI	☐	/CRMBW/OLTP_VDM_SCNVI		CURR	15	2	Service Complaint Net Value Items (Document Currency)
143	SACNVI	☐	/CRMBW/OLTP_VDM_SACNVI		CURR	15	2	Sales Complaint Net Value Items (Document Currency)
144	CMNVI	☐	/CRMBW/OLTP_VDM_CMNVI		CURR	15	2	Credit Memo Net Value Items (Document Currency)
145	CMNVSI	☐	/CRMBW/OLTP_VDM_CMNVSI		CURR	15	2	Credit Memo Net Value Service Items (Document Currency)
146	CMNVSAI	☐	/CRMBW/OLTP_VDM_CMNVSAI		CURR	15	2	Credit Memo Net Value Sales Items (Document Currency)
147	DMNVI	☐	/CRMBW/OLTP_VDM_DMNVI		CURR	15	2	Debit Memo Net Value Items (Document Currency)
148	DMNVSI	☐	/CRMBW/OLTP_VDM_DMNVSI		CURR	15	2	Debit Memo Net Value Service Items (Document Currency)
149	DMNVSAI	☐	/CRMBW/OLTP_VDM_DMNVSAI		CURR	15	2	Debit Memo Net Value Sales Items (Document Currency)
150	REPNVI	☐	/CRMBW/OLTP_VDM_REPNVI		CURR	15	2	Replacement Net Value Items (Document Currency)
151	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