SAP ABAP View CRMV_PRP_PROD_I (Simple product references and buying contract references)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_PRODUCTS (Package) Partner/Product Ranges (PPRs): Products

Basic Data

View Type	D	Database View
Database View	CRMV_PRP_PROD_I
Short Description	Simple product references and buying contract references
Root table	CRMM_PRP_PROD_I	Partner/Product Range Item-Product Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMM_PRP_PROD_I	CRMM_PRP_PROD_I
2	CRMM_PRP_PRBC_I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMM_PRP_PROD_I	CLIENT	JL	EQ				0	0
2	CRMM_PRP_PRBC_I	CLIENT	JR	EQ			AND	0	0
3	CRMM_PRP_PROD_I	GUID	JL	EQ				0	0
4	CRMM_PRP_PRBC_I	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMM_PRP_PROD_I	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMM_PRP_PROD_I	GUID		☐	CRMT_PRP_GUID	☐	Internal, Unique Identifier for PPR Objects
3	TYPE	CRMM_PRP_PROD_I	TYPE		☐	CRMT_PRP_REFERENCE_TYPE	☐	Reference Type of the PPR
4	PRODUCT_REF_GUID	CRMM_PRP_PROD_I	PRODUCT_REF_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
5	PARENT_GUID	CRMM_PRP_PROD_I	PARENT_GUID		☐	CRMT_PRP_GUID	☐	Internal, Unique Identifier for PPR Objects
6	VALID_FROM	CRMM_PRP_PROD_I	VALID_FROM		☐	COMT_VALID_FROM	☐	Valid From (Time Stamp)
7	VALID_TO	CRMM_PRP_PROD_I	VALID_TO		☐	COMT_VALID_TO	☐	Valid To (Time Stamp)
8	UPNAME	CRMM_PRP_PROD_I	UPNAME		☐	COMT_UPNAME	☐	Name of the User Who Last Changed the Set
9	HISTEX	CRMM_PRP_PROD_I	HISTEX		☐	COMT_HISTEX	☐	History Exists
10	BC_PRODUCT_DESCR	CRMM_PRP_PRBC_I	BC_PRODUCT_DESCR		☐	COMT_PRSHTEXTX	☐	Product Description
11	BC_CAT_ID	CRMM_PRP_PRBC_I	BC_CAT_ID		☐	CHAR20	☐	Char 20
12	BC_CAT_ITEM_ID	CRMM_PRP_PRBC_I	BC_CAT_ITEM_ID		☐	CHAR40	☐	Character field of length 40
13	BC_SUPPL_PROD_ID	CRMM_PRP_PRBC_I	BC_SUPPL_PROD_ID		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner
14	CATEGORY_GUID	CRMM_PRP_PRBC_I	CATEGORY_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20100421
SAP Release Created in	20C