SAP ABAP Table CRMT_HH_SALE_VIEW (CRM Handheld: sales orders)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-HH (Application Component) Handheld
     ⤷ CRM_HH (Package) CRM Mobile Applications for Handhelds

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_HH_SALE_VIEW	Table Relationship Diagram
Short Description	CRM Handheld: sales orders

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	Generated Table for View
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	ORGANIZATION	☐	CRMT_HH_ORGANIZATION	HROBJEC_14	CHAR	14	0	CRM Handheld: Organization	CRMC_HH_ORG
4	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_HH_ORG
5	TRANSACTION_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
6	TRANS_TYPE_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
7	ITEM_CATEGORY	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
8	ITEM_CAT_TEXT	☐	CRMT_ITM_TYPE_DESC	TEXT40	CHAR	40	0	Item Category Text
9	SOLD_TO_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
10	SHIP_TO_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
11	EMPL_RESP_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
12	CND_DISCOUNT_REL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	/SAPCND/T685
13	CND_DISCOUNT_ABS	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	/SAPCND/T685
14	FROM_DATE	☐	/SAPDMC/LS_DATE_BEGIN	DATUM	DATS	8	0	Start Date
15	TO_DATE	☐	/SAPDMC/LS_DATE_END	DATUM	DATS	8	0	End Date
16	FREE_NUMBERS	☐	NUMC2	NUMC2	NUMC	2	0	Two digit number
17	VALID_FROM	☐	/SAPDMC/LS_DATE_BEGIN	DATUM	DATS	8	0	Start Date
18	VALID_TO	☐	/SAPDMC/LS_DATE_END	DATUM	DATS	8	0	End Date
19	LOOK_BACK	☐	CRMT_HH_LOOK_BACK	NUMC4	NUMC	4	0	CRM Handheld: number of days back to search for documents
20	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	CRMT_HH_SALE_VIEW	CHANNEL	CRMC_HH_ORG	CHANNEL		1	N
2	CRMT_HH_SALE_VIEW	CND_DISCOUNT_ABS	/SAPCND/T685	KSCHL
3	CRMT_HH_SALE_VIEW	CND_DISCOUNT_REL	/SAPCND/T685	KSCHL
4	CRMT_HH_SALE_VIEW	EMPL_RESP_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
5	CRMT_HH_SALE_VIEW	ITEM_CATEGORY	CRMC_ITEM_TYPE	ITM_TYPE		C	CN
6	CRMT_HH_SALE_VIEW	ORGANIZATION	CRMC_HH_ORG	ORGANIZATION		1	N
7	CRMT_HH_SALE_VIEW	SHIP_TO_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
8	CRMT_HH_SALE_VIEW	SOLD_TO_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
9	CRMT_HH_SALE_VIEW	TRANSACTION_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE		C	CN

History

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