SAP ABAP Table CRMD_AVERAGE_H (Table to store the average value of Object rating)

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	TRANSP	Transparent table
Transparent table	CRMD_AVERAGE_H	Table Relationship Diagram
Short Description	Table to store the average value of Object rating

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	AVG_RATING_GUID	☑	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
3	OBJECT_TYPE	☐	CRM_OBJECT_TYPE	CRM_OBJEC_TYPE	CHAR	20	0	Object Type ID	*
4	OBJECT_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
5	CATALOG_ID	☐	CRM_CATALOG_ID	CRM_CATALOG_ID	CHAR	32	0	Catalog ID
6	APPLICATION_ID	☐	CRM_SHOP_ID	CRM_RATING_SHOP_ID	CHAR	40	0	Shop ID
7	NO_OF_RATINGS	☐	CRM_RATING	CRM_RATING	INT4	10	0	Rating Value
8	SUM_OF_RATINGS	☐	CRM_RATING_SUM	CRM_RATING_SUM	INT4	10	0	Sum of Ratings
9	AVG_OF_RATINGS	☐	CRM_AVERAGE	CRM_AVERAGE	DEC	5	2	Calculated Average Rating Value

History

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