SAP ABAP Table CRMT_PRP_LIST_BP (Display Listings: Listed Business Partners per Product)

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_BP	Table Relationship Diagram
Short Description	Display Listings: Listed Business Partners per Product

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	Display Listings: Listed Business Partners per Product
2	PROD_REF_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
3	BUPA_REF_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
4	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	DESCRIPTION	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
6	BUPA_REF_TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
7	PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
8	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
9	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
10	DATE_LOW	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
11	DATE_HIGH	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
12	EXCLUSION	☐	CRMT_PRP_EXCLUSION	CRM_PRP_EXCLUSION	CHAR	1	0	Indicator for the exclusion of the PPR's items
13	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
14	.INCLUDE	☐				0	0	PPR Set Type "Consumer Product Industry"
15	ASSORTMNT_FLAG	☐	ASSORTMENT_FLAG	ASSORTMENT_FLAG	CHAR	1	0	Assortment Flag
16	ASSORTMNT_FLAG_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
17	CHANGE_FLAG	☐	CHANGE_FLAG	CHANGE_FLAG	CHAR	1	0	Change Flag
18	CHANGE_FLAG_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
19	FACINGS	☐	FACINGS	FACINGS	NUMC	5	0	Number of arranged Facings
20	FACINGS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
21	DISTRIB_FLAG	☐	DISTRIBUTION_FLAG	DISTRIBUTION_FLAG	CHAR	1	0	Distribution Flag
22	DISTRIB_FLAG_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
23	MANDAT_ASSORT	☐	MANDATORY_ASSORTMENT	MANDATORY_ASSORTMENT	CHAR	1	0	Indicator: "Mandatory / Optional" Assortment
24	MANDAT_ASSORT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
25	CUST_ART_NUM	☐	CUSTOMER_ARTICLE_NUM	CUSTOMER_ARTICLE_NUM	CHAR	40	0	Customer Article Number
26	CUST_ART_NUM_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
27	LISTING_PRICE	☐	LISTING_PRICE	LISTING_PRICE	CURR	12	2	Listing Price
28	LISTING_PRICE_C	☐	LISTING_PRICE_C	WAERS	CUKY	5	0	Listing Price	TCURC
29	LISTING_PRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
30	SEQUENCE_CP	☐	SEQUENCE_CP	SEQUENCE_CP	NUMC	4	0	Sequence
31	SEQUENCE_CP_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
32	SECND_PLACEMNT	☐	SECOND_PLACEMENT	SECOND_PLACEMENT	CHAR	1	0	Second Placement
33	SECND_PLACEMNT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
34	LISTING_QUANT	☐	LISTING_QUANTITY	LISTING_QUANTITY	QUAN	15	3	Quantity of a listed product
35	LISTING_QUANT_U	☐	LISTING_QUANTITY_U	MEINS	UNIT	3	0	Quantity of a Listed Product	T006
36	LISTING_QUANT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
37	PROMO_PRICE	☐	PROMOTION_PRICE	PROMOTION_PRICE	CURR	12	2	Promotion Price
38	PROMO_PRICE_C	☐	PROMOTION_PRICE_C	WAERS	CUKY	5	0	Promotion Price	TCURC
39	PROMO_PRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
40	EDAY_LOW_PRICE	☐	EVERYDAY_LOW_PRICE	EVERYDAY_LOW_PRICE	CURR	12	2	Everyday-Low-Price
41	EDAY_LOW_PRICE_C	☐	EVERYDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday-Low-Price	TCURC
42	EDAY_LOW_PRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
43	PLACEMNT_QLTY	☐	PLACEMENT_QUALITY	PLACEMENT_QUALITY	CHAR	3	0	Quality of Placement
44	PLACEMNT_QLTY_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
45	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
46	LISTING_FEE_C	☐	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	TCURC
47	LISTING_FEE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
48	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_LIST_BP	EDAY_LOW_PRICE_C	TCURC	WAERS
2	CRMT_PRP_LIST_BP	LISTING_FEE_C	TCURC	WAERS
3	CRMT_PRP_LIST_BP	LISTING_PRICE_C	TCURC	WAERS
4	CRMT_PRP_LIST_BP	LISTING_QUANT_U	T006	MSEHI
5	CRMT_PRP_LIST_BP	PROMO_PRICE_C	TCURC	WAERS

History

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