SAP ABAP Table CRMT_PRP_LISTING_SELECT_ALL (Selectoptions and 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_ALL	Table Relationship Diagram
Short Description	Selectoptions and 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	.INCLUDE	☐				0	0	Selection parameters for displaying listed products
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	HIERARCHY	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
9	BUHI_NODE_TEXT	☐	CRM_BU_NODE_DESCRIPTION_LONG	CRM_BU_NODE_DESCRIPTION_LONG	CHAR	201	0	Description of a Node
10	BUHI_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
11	BUHI_NODE_ID	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
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	MKT_SEG_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
15	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
16	TEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
17	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
18	DIVISION_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
19	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
20	DIS_CHANNEL_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
21	EXCLUSION	☐	CRMT_PRP_EXCL_FLAG	COM_BOOLEAN	CHAR	1	0	Display excluded products
22	PPR_TYPE_LOW	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
23	PPR_TYPE_HIGH	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
24	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
25	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
26	R_DATE_SINGLE	☐	CRMT_PRP_R_DATE	CHAR8	CHAR	8	0	Validity Date for Listing Display
27	DATE_SINGLE	☐	CRMT_PRP_DATE	DATE	DATS	8	0	Validity date for listing display
28	R_DATE_LOW	☐	CRMT_PRP_R_DATE_FROM	CHAR8	CHAR	8	0	Radiobutton: Date 'Valid From'
29	DATE_LOW	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
30	DATE_HIGH	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
31	PROPOSE_FLAG	☐	CRMT_PRP_USAGE_PP	COM_BOOLEAN	CHAR	1	0	Products Used in Product Proposal
32	ORDER_CHECK	☐	CRMT_PRP_USAGE_OC	COM_BOOLEAN	CHAR	1	0	Products Used in Business Transaction Check
33	MAX_ROWS	☐	CRMT_PRP_MAX_ROWS	INT4	INT4	10	0	Maximum No. of Hits
34	.INCLUDE	☐				0	0	Select options for displaying listed products
35	IT_SALES_ORG_RANGE	☐	CRMT_PRP_SALES_ORG_RANGE_TAB		TTYP	0	0
36	IT_DIS_CHANNEL_RANGE	☐	CRMT_PRP_DIS_CHANNEL_RANGE_TAB		TTYP	0	0
37	IT_DIVISION_RANGE	☐	CRMT_PRP_DIVISION_RANGE_TAB		TTYP	0	0
38	IT_PRP_TYPE_RANGE	☐	CRMT_PRP_TYPE_RANGE_TAB		TTYP	0	0

Foreign Keys

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

History

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