SAP ABAP Table CRMT_OLTP_EXT_COMPL_INTERNAL (Extract Structure for OLTP Complaint internal fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_OLTP_EXT_COMPL_INTERNAL	Table Relationship Diagram
Short Description	Extract Structure for OLTP Complaint internal fields

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_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
2	OBJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
3	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
4	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
5	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
8	CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
9	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
10	CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
11	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
12	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
13	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
14	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
15	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
16	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
17	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
18	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
19	SOLD_TO_COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
20	SOLD_TO_REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
22	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
23	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
24	REFOBJ_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
25	REFOBJ_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
26	REFOBJ_PRODUCTID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
27	GUID_OBJECT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
28	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
29	CAT_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
30	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
31	.INCLUDE	☐				0	0	Coherent Catgory level GUID
32	CATLVLGUID01_01	☐	CRM_REP_CAT_GUID_LEV01_S1	SYSUUID	RAW	16	0	Category GUID 1- schema 1
33	CATLVLGUID02_01	☐	CRM_REP_CAT_GUID_LEV02_S1	SYSUUID	RAW	16	0	Category GUID 2- schema 1
34	CATLVLGUID03_01	☐	CRM_REP_CAT_GUID_LEV03_S1	SYSUUID	RAW	16	0	Category GUID 3- schema 1
35	CATLVLGUID04_01	☐	CRM_REP_CAT_GUID_LEV04_S1	SYSUUID	RAW	16	0	Category GUID 4- schema 1
36	CATLVLGUID05_01	☐	CRM_REP_CAT_GUID_LEV05_S1	SYSUUID	RAW	16	0	Category GUID 5- schema 1
37	CATLVLGUID06_01	☐	CRM_REP_CAT_GUID_LEV06_S1	SYSUUID	RAW	16	0	Category GUID 6- schema 1
38	CATLVLGUID07_01	☐	CRM_REP_CAT_GUID_LEV07_S1	SYSUUID	RAW	16	0	Category GUID 7- schema 1
39	CATLVLGUID08_01	☐	CRM_REP_CAT_GUID_LEV08_S1	SYSUUID	RAW	16	0	Category GUID 8- schema 1
40	CATLVLGUID09_01	☐	CRM_REP_CAT_GUID_LEV09_S1	SYSUUID	RAW	16	0	Category GUID 9- schema 1
41	CATLVLGUID10_01	☐	CRM_REP_CAT_GUID_LEV10_S1	SYSUUID	RAW	16	0	Category GUID 10- schema 1
42	CATLVLGUID01_02	☐	CRM_REP_CAT_GUID_LEV01_S2	SYSUUID	RAW	16	0	Category GUID 1- schema 2
43	CATLVLGUID02_02	☐	CRM_REP_CAT_GUID_LEV02_S2	SYSUUID	RAW	16	0	Category GUID 2- schema 2
44	CATLVLGUID03_02	☐	CRM_REP_CAT_GUID_LEV03_S2	SYSUUID	RAW	16	0	Category GUID 3- schema 2
45	CATLVLGUID04_02	☐	CRM_REP_CAT_GUID_LEV04_S2	SYSUUID	RAW	16	0	Category GUID 4- schema 2
46	CATLVLGUID05_02	☐	CRM_REP_CAT_GUID_LEV05_S2	SYSUUID	RAW	16	0	Category GUID 5- schema 2
47	CATLVLGUID06_02	☐	CRM_REP_CAT_GUID_LEV06_S2	SYSUUID	RAW	16	0	Category GUID 6- schema 2
48	CATLVLGUID07_02	☐	CRM_REP_CAT_GUID_LEV07_S2	SYSUUID	RAW	16	0	Category GUID 7- schema 2
49	CATLVLGUID08_02	☐	CRM_REP_CAT_GUID_LEV08_S2	SYSUUID	RAW	16	0	Category GUID 8- schema 2
50	CATLVLGUID09_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
51	CATLVLGUID10_02	☐	CRM_REP_CAT_GUID_LEV09_S2	SYSUUID	RAW	16	0	Category GUID 9- schema 2
52	CATLVLGUID01_03	☐	CRM_REP_CAT_GUID_LEV01_S3	SYSUUID	RAW	16	0	Category GUID 1- schema 3
53	CATLVLGUID02_03	☐	CRM_REP_CAT_GUID_LEV02_S3	SYSUUID	RAW	16	0	Category GUID 2- schema 3
54	CATLVLGUID03_03	☐	CRM_REP_CAT_GUID_LEV03_S3	SYSUUID	RAW	16	0	Category GUID 3- schema 3
55	CATLVLGUID04_03	☐	CRM_REP_CAT_GUID_LEV04_S3	SYSUUID	RAW	16	0	Category GUID 4- schema 3
56	CATLVLGUID05_03	☐	CRM_REP_CAT_GUID_LEV05_S3	SYSUUID	RAW	16	0	Category GUID 5- schema 3
57	CATLVLGUID06_03	☐	CRM_REP_CAT_GUID_LEV06_S3	SYSUUID	RAW	16	0	Category GUID 6- schema 3
58	CATLVLGUID07_03	☐	CRM_REP_CAT_GUID_LEV07_S3	SYSUUID	RAW	16	0	Category GUID 7- schema 3
59	CATLVLGUID08_03	☐	CRM_REP_CAT_GUID_LEV08_S3	SYSUUID	RAW	16	0	Category GUID 8- schema 3
60	CATLVLGUID09_03	☐	CRM_REP_CAT_GUID_LEV09_S3	SYSUUID	RAW	16	0	Category GUID 9- schema 3
61	CATLVLGUID10_03	☐	CRM_REP_CAT_GUID_LEV10_S3	SYSUUID	RAW	16	0	Category GUID 10- schema 3
62	CATLVLGUID01_04	☐	CRM_REP_CAT_GUID_LEV01_S4	SYSUUID	RAW	16	0	Category GUID 1- schema 4
63	CATLVLGUID02_04	☐	CRM_REP_CAT_GUID_LEV02_S4	SYSUUID	RAW	16	0	Category GUID 2- schema 4
64	CATLVLGUID03_04	☐	CRM_REP_CAT_GUID_LEV03_S4	SYSUUID	RAW	16	0	Category GUID 3- schema 4
65	CATLVLGUID04_04	☐	CRM_REP_CAT_GUID_LEV04_S4	SYSUUID	RAW	16	0	Category GUID 4- schema 4
66	CATLVLGUID05_04	☐	CRM_REP_CAT_GUID_LEV05_S4	SYSUUID	RAW	16	0	Category GUID 5- schema 4
67	CATLVLGUID06_04	☐	CRM_REP_CAT_GUID_LEV06_S4	SYSUUID	RAW	16	0	Category GUID 6- schema 4
68	CATLVLGUID07_04	☐	CRM_REP_CAT_GUID_LEV07_S4	SYSUUID	RAW	16	0	Category GUID 7- schema 4
69	CATLVLGUID08_04	☐	CRM_REP_CAT_GUID_LEV08_S4	SYSUUID	RAW	16	0	Category GUID 8- schema 4
70	CATLVLGUID09_04	☐	CRM_REP_CAT_GUID_LEV09_S4	SYSUUID	RAW	16	0	Category GUID 9- schema 4
71	CATLVLGUID10_04	☐	CRM_REP_CAT_GUID_LEV10_S4	SYSUUID	RAW	16	0	Category GUID 10- schema 4
72	CATLVLGUID01_05	☐	CRM_REP_CAT_GUID_LEV01_S5	SYSUUID	RAW	16	0	Category GUID 1- schema 5
73	CATLVLGUID02_05	☐	CRM_REP_CAT_GUID_LEV02_S5	SYSUUID	RAW	16	0	Category GUID 2- schema 5
74	CATLVLGUID03_05	☐	CRM_REP_CAT_GUID_LEV03_S5	SYSUUID	RAW	16	0	Category GUID 3- schema 5
75	CATLVLGUID04_05	☐	CRM_REP_CAT_GUID_LEV04_S5	SYSUUID	RAW	16	0	Category GUID 4- schema 5
76	CATLVLGUID05_05	☐	CRM_REP_CAT_GUID_LEV05_S5	SYSUUID	RAW	16	0	Category GUID 5- schema 5
77	CATLVLGUID06_05	☐	CRM_REP_CAT_GUID_LEV06_S5	SYSUUID	RAW	16	0	Category GUID 6- schema 5
78	CATLVLGUID07_05	☐	CRM_REP_CAT_GUID_LEV07_S5	SYSUUID	RAW	16	0	Category GUID 7- schema 5
79	CATLVLGUID08_05	☐	CRM_REP_CAT_GUID_LEV08_S5	SYSUUID	RAW	16	0	Category GUID 8- schema 5
80	CATLVLGUID09_05	☐	CRM_REP_CAT_GUID_LEV09_S5	SYSUUID	RAW	16	0	Category GUID 9- schema 5
81	CATLVLGUID10_05	☐	CRM_REP_CAT_GUID_LEV10_S5	SYSUUID	RAW	16	0	Category GUID 10- schema 5
82	.INCLUDE	☐				0	0	EEW Include
83	EEW_R_CPL_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
84	.INCLUDE	☐				0	0

History

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