SAP ABAP Table CRMST_QUERY_COMPL_BTIL (Business Trans. IL Structure for Complaint - Search Criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_COMPL_BTIL	Table Relationship Diagram
Short Description	Business Trans. IL Structure for Complaint - Search Criteria

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	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
3	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
4	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
5	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
6	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
7	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
8	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
9	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
10	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
11	PRODUCT_KIND_SEL	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
12	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
13	RMA_NUMBER	☐	CRMT_RMA	CRM_RMA	CHAR	20	0	Approval Number - Return Delivery
14	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
15	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
16	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
17	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
18	OWNER_FIRSTNAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
19	OWNER_LASTNAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
20	CONTACT_FIRSTNAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
21	CONTACT_LASTNAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
22	SOLD_TO_PARTY_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
23	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
24	CONTACT_PERSON	☐	CRMT_UIU_CONTACT_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Contact
25	SOLD_TO_PARTY	☐	CRMT_UIU_SOLD_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Sold-To Party
26	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
27	END_LOG_EXT	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
28	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
29	RMA_STATUS	☐	CRMT_RMA_STATUS	CRM_RMA_STATUS	CHAR	5	0	RMA Status
30	.INCLUDE	☐				0	0	EEW Include
31	EEW_BUS2000120_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
32	.INCLUDE	☐				0	0
33	.INCLUDE	☐				0	0	Object Settype Attributes for Searching Objects
34	OBJ_R3SER_NO	☐	R3SERIAL_NO	R3SERIAL_NO	CHAR	18	0	Serial Number
35	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
36	CHANGED_AT_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
37	CREATED_AT_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
38	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
39	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
40	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
41	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
42	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
43	REFOBJ_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
44	REFOBJ_IOBJECT_ID	☐	COMT_PRODUCT_OBJECT_ID	COM_PRODUCT_ID	CHAR	40	0	Object ID
45	REFOBJ_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
46	REFOBJ_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
47	REFOBJ_PRODUCT_NAME	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
48	REFOBJ_IOBJECT_NAME	☐	COMT_PRSHTEXTX_OBJECT	PRSHTEXT40	CHAR	40	0	Object Description
49	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
50	SCHEMA_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
51	CATEGORY_ID	☐	CRM_ERMS_CAT_CA_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	Coherent Cat. - Category ID
52	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
53	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
54	INCL_SUB_TERR	☐	CRMT_SUB_TERR_IND	CRM_SUB_TERR_IND	CHAR	1	0	Indicator: Include Subterritories in Territory Search

History

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