SAP ABAP Table CRMC_HH_SALE (CRM Handheld: Sales Attributes)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_HH_SALE	Table Relationship Diagram
Short Description	CRM Handheld: Sales Attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	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	ITEM_CATEGORY	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
6	SOLD_TO_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
7	SHIP_TO_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
8	EMPL_RESP_PFC	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
9	NR_OBJECT	☐	NROBJ	NROBJ	CHAR	10	0	Name of number range object	*
10	NR_NUMBER	☐	NRNR	CHAR2	CHAR	2	0	Number range number
11	FREE_NUMBERS	☐	NUMC2	NUMC2	NUMC	2	0	Two digit number
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	CND_APPL	☐	CRMT_HH_CND_APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	CRM Handheld: Application for Condition Technique	/SAPCND/T681A
15	PRIC_PROC	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	PRCC_COND_PPD
16	CND_USAGE	☐	CRMT_HH_CND_USAGE	/SAPCND/USAGE	CHAR	2	0	CRM Handheld: Usage for Condition Technique	/SAPCND/T681V
17	CND_LOOK_AHEAD	☐	CRMT_HH_LOOK_AHEAD	NUMC4	NUMC	4	0	CRM Handheld: number of days ahead to search for documents
18	LOOK_BACK	☐	CRMT_HH_LOOK_BACK	NUMC4	NUMC	4	0	CRM Handheld: number of days back to search for documents
19	LOOK_AHEAD	☐	CRMT_HH_LOOK_AHEAD	NUMC4	NUMC	4	0	CRM Handheld: number of days ahead to search for documents
20	FROM_DATE	☐	/SAPDMC/LS_DATE_BEGIN	DATUM	DATS	8	0	Start Date
21	TO_DATE	☐	/SAPDMC/LS_DATE_END	DATUM	DATS	8	0	End Date
22	VALID_FROM	☐	/SAPDMC/LS_DATE_BEGIN	DATUM	DATS	8	0	Start Date
23	VALID_TO	☐	/SAPDMC/LS_DATE_END	DATUM	DATS	8	0	End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_HH_SALE	CHANNEL	CRMC_HH_ORG	CHANNEL		1	N
2	CRMC_HH_SALE	CND_DISCOUNT_ABS	/SAPCND/T685	KSCHL
3	CRMC_HH_SALE	CND_DISCOUNT_REL	/SAPCND/T685	KSCHL
4	CRMC_HH_SALE	EMPL_RESP_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
5	CRMC_HH_SALE	ITEM_CATEGORY	CRMC_ITEM_TYPE	ITM_TYPE		C	CN
6	CRMC_HH_SALE	ORGANIZATION	CRMC_HH_ORG	ORGANIZATION		1	N
7	CRMC_HH_SALE	PRIC_PROC	PRCC_COND_PPD	KAPPL
8	CRMC_HH_SALE	SHIP_TO_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
9	CRMC_HH_SALE	SOLD_TO_PFC	CRMC_PARTNER_FCT	PARTNER_FCT
10	CRMC_HH_SALE	TRANSACTION_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE		C	CN

History

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