SAP ABAP Table CRMT_SEARCH_LOC (Search Structure for CRM Order Locator)

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_SEARCH_LOC	Table Relationship Diagram
Short Description	Search Structure for CRM Order Locator

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	.INCLUDE	☐				0	0	General Search Field Structure for Locator Search Screen
2	RESPONS_AREA	☐	CRMT_RESPONS_AREA	CRM_RESPONS_AREA	CHAR	2	0	Belonging to (Me, My Department, My Group)
3	PRODUCT_LOC_1050	☐	CRMT_PRODUCT_LOC_1050	CRM_PRODUCT_LOC_1050	CHAR	2	0	Product Range for Locator (Sales Contracts)
4	PRODUCT_LOC_1100	☐	CRMT_PRODUCT_LOC_1100	CRM_PRODUCT_LOC_1100	CHAR	2	0	Product Range for Locator (Financing Contracts)
5	PRODUCT_LOC	☐	CRMT_PRODUCT_LOC	CRM_PRODUCT_LOC	CHAR	2	0	Product_Product Catalog Selection for Locator
6	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
7	PARTNER_FCT_1000	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
8	PARTNER_FCT_1030	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
9	PARTNER_FCT_1100	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
10	PARTNER_FCT_1050	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
11	PARTNER_FCT_1110	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
12	PARTNER_FCT_1060	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
13	PARTNER_FCT_1090	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
14	PARTNER_FCT_1120	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
15	PARTNER_FCT_2010	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
16	PARTNER_FCT_2000	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
17	PARTNER_FCT_2200	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
18	PARTNER_FCT_2300	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
19	PARTNER_FCT_2400	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
20	PARTNER_FCT_2500	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
21	BU_PARTNER	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
22	DATE_FROM	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
23	DATE_UNTIL	☐	DATBI	DATUM	DATS	8	0	Valid To Date
24	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
25	PROCESS_TYPE_1000	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
26	PROCESS_TYPE_1100	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
27	PROCESS_TYPE_1050	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
28	PROCESS_TYPE_1110	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
29	PROCESS_TYPE_1060	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
30	PROCESS_TYPE_1090	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
31	PROCESS_TYPE_1120	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
32	PROCESS_TYPE_2000	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
33	PROCESS_TYPE_2300	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
34	PROCESS_TYPE_2400	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
35	PROCESS_TYPE_2500	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
36	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status	*
37	STATUS_2000	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status	*
38	STATUS_2500	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
39	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
40	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE	CRM_TEMPLATE_TYPE	CHAR	1	0	CRM Transaction: Template Type
41	PRODUCT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
42	APPLICATION_AREA	☐	CRMT_APPLICATION_AREA	CRM_APPLICATION_AREA	CHAR	2	0	Transaction Category
43	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
44	CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
45	SEL_VARIANT	☐	RALDB_VARI	RALDB_VARI	CHAR	14	0	Variant Name
46	PRODUCT_LOC_1110	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
47	PRODUCT_LOC_1060	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
48	PRODUCT_LOC_PROD	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
49	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
50	OBJECT_LOC	☐	CRMT_OBJECT_LOC	CRM_OBJECT_LOC	CHAR	2	0	Object Type in Object List
51	OBJECT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
52	PRODUCT_LOC_5000	☐	CRMT_PRODUCT_LOC_1100	CRM_PRODUCT_LOC_1100	CHAR	2	0	Product Range for Locator (Financing Contracts)
53	PARTNER_FCT_5000	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
54	PROCESS_TYPE_5000	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
55	DATE_START	☐	DATS	DATS	DATS	8	0	Field of type DATS
56	DATE_END	☐	DATS	DATS	DATS	8	0	Field of type DATS
57	CARD_NO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
58	CARD_TYPE	☐	CRMT_CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment Card Type	*
59	.INCLUDE	☐				0	0	Activity Search Field Structure for Locator Search Screen
60	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	CRMC_ACT_CATEGOR
61	NO_CONTACT	☐	CRMT_NO_CONTACT	XFELD	CHAR	1	0	Selection Flag: Partner Was Not Contacted
62	.INCLUDE	☐				0	0	Opportunity Search Field Structure for Locator Search Screen
63	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
64	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
65	.INCLUDE	☐				0	0	Include structure for sales
66	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
67	.INCLUDE	☐				0	0	Screen Fields for the Service Locator
68	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	SCPRIO
69	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	CRMC_ACT_OBJ
70	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
71	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
72	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	TQ15
73	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
74	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
75	CONF_NO	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
76	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
77	REQ_GROUP	☐	CRMT_REQTYPE_GROUP	CHAR10	CHAR	10	0	Request Category Group	CRMC_REQT_GRP
78	DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
79	REQ_TYPE	☐	CRMT_REQ_TYPE	CRM_REQ_TYPE	CHAR	10	0	Request Category	CRMC_REQ_TYPE
80	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
81	IB_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
82	IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
83	SERVICE_ID	☐	CRMT_TSRV_SERVICE_ID	CRM_TSRV_SERVICE_ID	CHAR	54	0	Template Search Term
84	REFOBJ_SEL	☐	CRMT_TSRV_REP_REFOBJ_SEL	CRM_TSRV_REP_REFOBJ_SEL	CHAR	1	0	Search for Reference Object
85	REFOBJ	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
86	.INCLUDE	☐				0	0	Lead Search Field Structure for Locator Search Screens
87	QUAL_LEVEL	☐	CRMT_LEAD_QUAL_LEVEL	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level	CRMC_LEAD_QL
88	.INCLUDE	☐				0	0	Search fields for Project
89	PROJ_FROM_DATE	☐	CRMT_CSDR_VALID_FROM	DATS	DATS	8	0	Valid from date
90	PROJ_TO_DATE	☐	CRMT_CSDR_VALID_TO	DATS	DATS	8	0	Valid to date
91	IS_DESREG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	.INCLUDE	☐				0	0	Screen Fields for Complaints Locator
93	RMA	☐	CRMT_RMA	CRM_RMA	CHAR	20	0	Approval Number - Return Delivery
94	INVOICE_NO	☐	CRMT_INVOICE_NO	CRM_OBJECT_ID	CHAR	10	0	Billing Document Number
95	RMA_STATUS	☐	CRMT_RMA_STATUS	CRM_RMA_STATUS	CHAR	5	0	RMA Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_SEARCH_LOC	CATEGORY	CRMC_ACT_CATEGOR	CATEGORY
2	CRMT_SEARCH_LOC	CODE	QPCD	CODE
3	CRMT_SEARCH_LOC	CODEGRUPPE	QPGR	CODEGRUPPE
4	CRMT_SEARCH_LOC	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE
5	CRMT_SEARCH_LOC	KATALOGART	TQ15	KATALOGART
6	CRMT_SEARCH_LOC	OBJECTIVE	CRMC_ACT_OBJ	OBJECTIVE
7	CRMT_SEARCH_LOC	PARTNER_FCT	CRMC_PARTNER_FCT	PARTNER_FCT
8	CRMT_SEARCH_LOC	PARTNER_FCT_1000	CRMC_PARTNER_FCT	PARTNER_FCT
9	CRMT_SEARCH_LOC	PARTNER_FCT_1030	CRMC_PARTNER_FCT	PARTNER_FCT
10	CRMT_SEARCH_LOC	PARTNER_FCT_1050	CRMC_PARTNER_FCT	PARTNER_FCT
11	CRMT_SEARCH_LOC	PARTNER_FCT_1060	CRMC_PARTNER_FCT	PARTNER_FCT
12	CRMT_SEARCH_LOC	PARTNER_FCT_1090	CRMC_PARTNER_FCT	PARTNER_FCT
13	CRMT_SEARCH_LOC	PARTNER_FCT_1100	CRMC_PARTNER_FCT	PARTNER_FCT
14	CRMT_SEARCH_LOC	PARTNER_FCT_1110	CRMC_PARTNER_FCT	PARTNER_FCT
15	CRMT_SEARCH_LOC	PARTNER_FCT_2000	CRMC_PARTNER_FCT	PARTNER_FCT
16	CRMT_SEARCH_LOC	PARTNER_FCT_2010	CRMC_PARTNER_FCT	PARTNER_FCT
17	CRMT_SEARCH_LOC	PARTNER_FCT_2200	CRMC_PARTNER_FCT	PARTNER_FCT
18	CRMT_SEARCH_LOC	PARTNER_FCT_2300	CRMC_PARTNER_FCT	PARTNER_FCT
19	CRMT_SEARCH_LOC	PARTNER_FCT_2400	CRMC_PARTNER_FCT	PARTNER_FCT
20	CRMT_SEARCH_LOC	PRIORITY	SCPRIO	PRIORITY
21	CRMT_SEARCH_LOC	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE
22	CRMT_SEARCH_LOC	PROCESS_TYPE_1000	CRMC_PROC_TYPE	PROCESS_TYPE
23	CRMT_SEARCH_LOC	PROCESS_TYPE_1050	CRMC_PROC_TYPE	PROCESS_TYPE
24	CRMT_SEARCH_LOC	PROCESS_TYPE_1060	CRMC_PROC_TYPE	PROCESS_TYPE
25	CRMT_SEARCH_LOC	PROCESS_TYPE_1090	CRMC_PROC_TYPE	PROCESS_TYPE
26	CRMT_SEARCH_LOC	PROCESS_TYPE_1100	CRMC_PROC_TYPE	PROCESS_TYPE
27	CRMT_SEARCH_LOC	PROCESS_TYPE_1110	CRMC_PROC_TYPE	PROCESS_TYPE
28	CRMT_SEARCH_LOC	PROCESS_TYPE_2300	CRMC_PROC_TYPE	PROCESS_TYPE
29	CRMT_SEARCH_LOC	PROCESS_TYPE_2400	CRMC_PROC_TYPE	PROCESS_TYPE
30	CRMT_SEARCH_LOC	QUAL_LEVEL	CRMC_LEAD_QL	QUAL_LEVEL
31	CRMT_SEARCH_LOC	REQ_GROUP	CRMC_REQT_GRP	REQ_TYPE_GROUP
32	CRMT_SEARCH_LOC	REQ_TYPE	CRMC_REQ_TYPE	REQ_TYPE

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A