SAP ABAP Table CRMT_PRP_IL_ADV_SEARCH (GENIL: Advanced search structure for PPR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_IL (Package) GenIL/BOL Classes for PPR Application

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_IL_ADV_SEARCH	Table Relationship Diagram
Short Description	GENIL: Advanced search structure for PPR

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	PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
2	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	CRMC_PRP_TYPES
3	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
4	PRP_EXCLUSION_H	☐	CRMT_PRP_EXCLUSION_IL	CRM_PRP_BOOLEAN	CHAR	1	0	Exclusion set/not set
5	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
6	VALIDITY	☐	CRMT_PRP_VALIDITY_DATE	DATUM	DATS	8	0	PPR: Validity date
7	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
8	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
9	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
10	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
11	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
12	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	BUHI_NODE_SEARCH	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
14	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
15	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
16	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
17	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
18	CREATED_BY	☐	CRMT_PRP_CREATE_UPNAME	UNAME	CHAR	12	0	Name of the user who created the PPR
19	CREATED_AT	☐	CRMT_PRP_CREATED_AT_DATE	DATUM	DATS	8	0	PPR: Date on which user created PPR
20	CHANGED_BY	☐	CRMT_PRP_LAST_CHANGE_UPNAME	UNAME	CHAR	12	0	Name of the user who changed the PPR
21	CHANGED_AT	☐	CRMT_PRP_CHANGED_AT_DATE	DATUM	DATS	8	0	PPR: Date on which user changed PPR
22	VALIDFORALL	☐	CRMT_PRP_VALIDFORALL_IL	CRM_PRP_VALIDFORALL	CHAR	1	0	Valid for All Products/Accounts
23	OBJECT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_IL_ADV_SEARCH	PRP_TYPE	CRMC_PRP_TYPES	PRP_TYPE	KEY	1	CN

History

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