SAP ABAP Table CRMV_HH_OPPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_HH_OPPT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client
2	ORGANIZATION	☑	CRMT_HH_ORGANIZATION	HROBJEC_14	CHAR	14	0	CRM Handheld: Organization	CRMC_HH_ORG
3	CHANNEL	☑	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_HH_ORG
4	TRANSACTION_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
5	TRANS_TYPE_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
6	ITEM_CATEGORY	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
7	ITEM_CAT_TEXT	☐	CRMT_ITM_TYPE_DESC	TEXT40	CHAR	40	0	Item Category Text
8	SALES_PROSP_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
9	CONTACT_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
10	EMPL_RESP_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
11	TEXT_ID	☐	TDID	TDID	CHAR	4	0	Text ID	TTXID
12	LOOK_BACK	☐	CRMT_HH_LOOK_BACK	NUMC4	NUMC	4	0	CRM Handheld: number of days back to search for documents
13	LOOK_AHEAD	☐	CRMT_HH_LOOK_AHEAD	NUMC4	NUMC	4	0	CRM Handheld: number of days ahead to search for documents

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMV_HH_OPPT	CHANNEL	CRMC_HH_ORG	CHANNEL		1	N
2	CRMV_HH_OPPT	CONTACT_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
3	CRMV_HH_OPPT	EMPL_RESP_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
4	CRMV_HH_OPPT	ITEM_CATEGORY	CRMC_ITEM_TYPE	ITM_TYPE		C	CN
5	CRMV_HH_OPPT	ORGANIZATION	CRMC_HH_ORG	ORGANIZATION		1	N
6	CRMV_HH_OPPT	SALES_PROSP_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
7	CRMV_HH_OPPT	TEXT_ID	TTXID	TDID
8	CRMV_HH_OPPT	TRANSACTION_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE		C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in