SAP ABAP Table CRMT_PRP_LIST_REP_SELECT (Selection parameters for displaying listings)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_LISTING_REPORTING (Package) Listing Reporting Functionality based on PPR Data

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_LIST_REP_SELECT	Table Relationship Diagram
Short Description	Selection parameters for displaying listings

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	REPORT	☐	CRMT_PRP_LISTING_REPORT	CRM_PRP_LISTING_REPORT	CHAR	3	0	Listing Report
2	R_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	R_HIERARCHY	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
4	R_MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
5	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	PARTNER_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
7	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
8	BUHI_TREE_SEARCH_TERM	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
9	BUHI_NODE_SEARCH_TERM	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
10	BUHI_NODE_DESCRITPTION_LONG	☐	CRMT_PRP_BPH_NODE_DESCRIPTION	CHAR255	CHAR	255	0	Description of a BP Hierarchy Node and Hierarchy Tree
11	BUHI_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
12	MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
13	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
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	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
22	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
23	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
24	R_DATE_SINGLE	☐	CRMT_PRP_R_DATE	CHAR8	CHAR	8	0	Validity Date for Listing Display
25	DATE_SINGLE	☐	CRMT_PRP_DATE	DATE	DATS	8	0	Validity date for listing display
26	R_DATE_LOW	☐	CRMT_PRP_R_DATE_FROM	CHAR8	CHAR	8	0	Radiobutton: Date 'Valid From'
27	DATE_LOW	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
28	DATE_HIGH	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
29	PROPOSE_FLAG	☐	CRMT_PRP_USAGE_PP	COM_BOOLEAN	CHAR	1	0	Products Used in Product Proposal
30	ORDER_CHECK	☐	CRMT_PRP_USAGE_OC	COM_BOOLEAN	CHAR	1	0	Products Used in Business Transaction Check
31	MAX_ROWS	☐	CRMT_PRP_MAX_ROWS	INT4	INT4	10	0	Maximum No. of Hits
32	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
33	PRD_HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
34	PRD_CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
35	PRD_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_LIST_REP_SELECT	PPR_TYPE	CRMC_PRP_TYPES	PRP_TYPE

History

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