SAP ABAP Table CRMS_PROD_AVG_RATING_H (Structure for Average Product Rating - CRM MW - mBDoc)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ WEC-APP-CI-REV (Application Component) Web Channel Reviews & Ratings
     ⤷ CRM_WEC_RATING (Package) Web Channel: Product Ratings and Review

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_PROD_AVG_RATING_H	Table Relationship Diagram
Short Description	Structure for Average Product Rating - CRM MW - mBDoc

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	Table to store the average value of Object rating
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	AVG_RATING_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
4	OBJECT_TYPE	☐	CRM_OBJECT_TYPE	CRM_OBJEC_TYPE	CHAR	20	0	Object Type ID	*
5	OBJECT_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
6	CATALOG_ID	☐	CRM_CATALOG_ID	CRM_CATALOG_ID	CHAR	32	0	Catalog ID
7	APPLICATION_ID	☐	CRM_SHOP_ID	CRM_RATING_SHOP_ID	CHAR	40	0	Shop ID
8	NO_OF_RATINGS	☐	CRM_RATING	CRM_RATING	INT4	10	0	Rating Value
9	SUM_OF_RATINGS	☐	CRM_RATING_SUM	CRM_RATING_SUM	INT4	10	0	Sum of Ratings
10	AVG_OF_RATINGS	☐	CRM_AVERAGE	CRM_AVERAGE	DEC	5	2	Calculated Average Rating Value
11	UPDATE_TYPE	☐	UPDATE_TYPE	UPDATE_TYPE	CHAR	1	0	Type of Change

History

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