SAP ABAP Table CRMT_BSP_ISU_OPP_SEARCH (Utilities Opportunity Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S (Application Component) Utilities Industry: Sales
     ⤷ CRM_BSP_MODEL_IL_QUO (Package) Quotation for Utilities Contracts

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_ISU_OPP_SEARCH	Table Relationship Diagram
Short Description	Utilities Opportunity Search

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	Collective Search Fields for CRM_Opportunity for OIC
2	.INCLUDE	☐				0	0	Collective Search Fields for CRM_Transaction OIC
3	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS	CRM_OJ_NAME_PROCESS	CHAR	10	0	Leading Business Transaction Category	*
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
7	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
8	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
9	FROM	☐	CRMT_REPORT_FROM	SYDATS	DATS	8	0	Valid from
10	TO	☐	CRMT_REPORT_TO	SYDATS	DATS	8	0	Valid To
11	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
12	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
13	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
14	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
15	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
16	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
17	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
18	BU_PARTNER	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
19	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
20	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
21	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
22	.INCLUDE	☐				0	0	Opportunity Search Field Structure for OIC
23	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
24	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
25	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
26	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
27	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
28	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
29	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description
30	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
31	OPP_SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
32	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	*
33	POSTING_DATE_FROM	☐	CRMT_REPORT_POSTING_DATE_FROM		DATS	8	0	Date of Creation of a Transaction (From)
34	POSTING_DATE_TO	☐	CRMT_REPORT_POSTING_DATE_TO		DATS	8	0	Date of Creation of a Transaction (To)
35	SHOW_ITEMS	☐	CRMT_BSP_SHOW_ITEMS	CRM_BOOLEAN	CHAR	1	0	Display Items in Result List
36	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_ISU_OPP_SEARCH	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE

History

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