SAP ABAP Table CRMT_PPM_OPP_SEARCH (Common Search Fields for CRM_Opportunity PPM)

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_PPM_OPP_SEARCH	Table Relationship Diagram
Short Description	Common Search Fields for CRM_Opportunity PPM

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_Transaction OIC
2	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS	CRM_OJ_NAME_PROCESS	CHAR	10	0	Leading Business Transaction Category	*
3	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
5	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
6	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
7	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
8	FROM	☐	CRMT_REPORT_FROM	SYDATS	DATS	8	0	Valid from
9	TO	☐	CRMT_REPORT_TO	SYDATS	DATS	8	0	Valid To
10	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
11	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
12	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
13	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
14	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
15	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
16	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
17	BU_PARTNER	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
18	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
19	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
20	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
21	.INCLUDE	☐				0	0	Opportunity Search Field Structure for OIC
22	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
23	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
24	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
25	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
26	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
27	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
28	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description
29	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
30	OPP_SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
31	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	*
32	POSTING_DATE_FROM	☐	CRMT_REPORT_POSTING_DATE_FROM		DATS	8	0	Date of Creation of a Transaction (From)
33	POSTING_DATE_TO	☐	CRMT_REPORT_POSTING_DATE_TO		DATS	8	0	Date of Creation of a Transaction (To)
34	.INCLUDE	☐				0	0	organizational Data Sales Part 2
35	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
36	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
37	EXP_REVENUE	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
38	START_DATE_RANGE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
39	END_DATE_RANGE	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
40	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
41	CHANGED_AT_RANGE	☐	CRMT_BSP_CHANGED_AT_TO	DATS	DATS	8	0	Changed From To, Advanced Search
42	PHASE_SINCE_RANGE	☐	CRMT_PHASE_SINCE	DATUM	DATS	8	0	Sales Stage Since
43	FORECAST_REL	☐	CRMT_FORECAST_REL	CRM_FORECAST_REL	CHAR	1	0	Forecast Relevance
44	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
45	PCR_KEYDATE	☐	CRMT_REPORT_PCR_KEYDATE	CRMT_REPORT_PCR_KEYDATE	INT4	10	0	PCR - How Many Days in the Past Is the Key Date
46	VELOCITY	☐	CRMT_PPM_OPPSPEED	CRM_PPM_OPPSPEED	CHAR	3	0	Opportunity Speed	*
47	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
48	PARTNER_FCT_SECOND	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
49	BU_PARTNER_SECOND	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
50	.INCLUDE	☐				0	0	External PPM Search Fields
51	START_DELTA	☐	INT4	INT4	INT4	10	0	Natural number
52	END_DELTA	☐	INT4	INT4	INT4	10	0	Natural number
53	END_DATE_RANGE_D	☐	INT4	INT4	INT4	10	0	Natural number
54	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
55	PRODUCT_DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
56	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
57	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
58	CHANGED_AT_I_RANGE	☐	CRMT_REPORT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Change Date for a Document

Foreign Keys

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

History

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