SAP ABAP Table CRMT_PRP_LISTING_SELECT (Selection parameters for displaying listed products)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_LISTING (Package) Listing-specific PPR Functionality

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_LISTING_SELECT	Table Relationship Diagram
Short Description	Selection parameters for displaying listed products

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	R_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	R_HIERARCHY	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
3	R_MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
4	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	PARTNER_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
6	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
7	HIERARCHY	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
8	BUHI_NODE_TEXT	☐	CRM_BU_NODE_DESCRIPTION_LONG	CRM_BU_NODE_DESCRIPTION_LONG	CHAR	201	0	Description of a Node
9	BUHI_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
10	BUHI_NODE_ID	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
11	MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
12	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
13	MKT_SEG_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
14	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
15	TEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
16	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
17	DIVISION_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
18	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
19	DIS_CHANNEL_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
20	EXCLUSION	☐	CRMT_PRP_EXCL_FLAG	COM_BOOLEAN	CHAR	1	0	Display excluded products
21	PPR_TYPE_LOW	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
22	PPR_TYPE_HIGH	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
23	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
24	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
25	R_DATE_SINGLE	☐	CRMT_PRP_R_DATE	CHAR8	CHAR	8	0	Validity Date for Listing Display
26	DATE_SINGLE	☐	CRMT_PRP_DATE	DATE	DATS	8	0	Validity date for listing display
27	R_DATE_LOW	☐	CRMT_PRP_R_DATE_FROM	CHAR8	CHAR	8	0	Radiobutton: Date 'Valid From'
28	DATE_LOW	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
29	DATE_HIGH	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
30	PROPOSE_FLAG	☐	CRMT_PRP_USAGE_PP	COM_BOOLEAN	CHAR	1	0	Products Used in Product Proposal
31	ORDER_CHECK	☐	CRMT_PRP_USAGE_OC	COM_BOOLEAN	CHAR	1	0	Products Used in Business Transaction Check
32	MAX_ROWS	☐	CRMT_PRP_MAX_ROWS	INT4	INT4	10	0	Maximum No. of Hits

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_LISTING_SELECT	PPR_TYPE_HIGH	CRMC_PRP_TYPES	PRP_TYPE
2	CRMT_PRP_LISTING_SELECT	PPR_TYPE_LOW	CRMC_PRP_TYPES	PRP_TYPE

History

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