SAP ABAP Table CRMT_WEBREQ_SEARCH (Search structure for webrequests)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISE-WBF (Application Component) Web Forms
     ⤷ CRM_WEBREQUEST_IL (Package) Interaction Layer of Webrequests

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_WEBREQ_SEARCH	Table Relationship Diagram
Short Description	Search structure for webrequests

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	Service: General Output Fields for Search
2	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
3	.INCLUDE	☐				0	0	Collective Search Fields for CRM_Transaction OIC
4	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS	CRM_OJ_NAME_PROCESS	CHAR	10	0	Leading Business Transaction Category	*
5	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
9	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
10	FROM	☐	CRMT_REPORT_FROM	SYDATS	DATS	8	0	Valid from
11	TO	☐	CRMT_REPORT_TO	SYDATS	DATS	8	0	Valid To
12	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
13	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
14	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
15	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
16	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
17	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
18	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
19	BU_PARTNER	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
20	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
21	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
22	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
23	.INCLUDE	☐				0	0	Service: Service Search Fields for CRM_Transaction
24	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
25	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
26	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
27	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
28	PRODUCT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
29	OBJID	☐	CRMT_BSP_SRV_OBJEKTID	NUM08	NUMC	8	0	Technician: Service Organization
30	SERVICE_ORG_RESP	☐	CRMT_BSP_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
31	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	TQ15
32	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
33	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
34	PRODUCT_KIND_SEL	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
35	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
36	REQ_GROUP	☐	CRMT_REQTYPE_GROUP	CHAR10	CHAR	10	0	Request Category Group
37	REQ_TYPE	☐	CRMT_REQ_TYPE	CRM_REQ_TYPE	CHAR	10	0	Request Category	*
38	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE	CRM_TEMPLATE_TYPE	CHAR	1	0	CRM Transaction: Template Type
39	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
40	SERVICE_ID	☐	CRMT_BSP_SERVICE_ID	CRM_SERVICE_ID	CHAR	14	0	Template Search Term
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	Structure for Multiple Value Search and Value Areas
43	OBJECT_ID_M	☐	CRMT_BSP_OBJECT_ID_M	CRM_BSP_STRING	STRG	0	0	Transaction ID, Advanced Search with Several Values
44	BU_PARTNER_M	☐	CRMT_BSP_PARTNER_M	CRM_BSP_STRING	STRG	0	0	Partner Number, Multi-Value for Advanced Search
45	PRODUCT_ID_M	☐	CRMT_BSP_SRQ_PRODUCT_NUM_MULTI		STRG	0	0	Product ID for Multiple Search Query
46	PO_NUMBER_UC_M	☐	CRMT_BSP_PO_NUMBER_SOLD_M	CRM_BSP_STRING	STRG	0	0	Ext. Reference No. for Sold-To Party, Multivalue Adv. Search
47	DESCRIPTION_M	☐	CRMT_BSP_DESCRIPTION_M	CRM_BSP_STRING	STRG	0	0	Description
48	EXT_OBJ_NAME	☐	CRMT_EXT_OBJ_NAME	CRM_OBJEXT_NAME	CHAR	30	0	External Name of Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_WEBREQ_SEARCH	KATALOGART	TQ15	KATALOGART

History

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