SAP ABAP Table CRMT_BSP_CSDR_PROJ_SEARCH (Search Structure for Project)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IHT-PDP (Application Component) Partner Design Projects
     ⤷ CRM_CSDR_BSP_UI (Package) CRM Design Registration BSP UI

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_CSDR_PROJ_SEARCH	Table Relationship Diagram
Short Description	Search Structure for Project

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

Foreign Keys

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

History

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