SAP ABAP Table CRMS_OBJECT_REVIEW (Structure for product reviews)

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_OBJECT_REVIEW	Table Relationship Diagram
Short Description	Structure for product reviews

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	REVIEW_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
2	RATING_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
3	REVIEW_TITLE	☐	CRM_RATING_OBJECT_ID	CRM_OBJECT_RATING_ID	CHAR	40	0	Object ID
4	PROS	☐	CRM_REVIEW_PROS		CHAR	132	0	Review Pros
5	CONS	☐	CRM_REVIEW_CONS		CHAR	132	0	Review Cons
6	LOCATION	☐	CRM_LOCATION	CRM_REVIEW_LOCATION	CHAR	61	0	CRM Location
7	STATUS	☐	CRM_APPROVED	CRM_REVIEW_STATUS	CHAR	1	0	CRM Approved
8	OBJECT_TYPE	☐	CRM_OBJECT_TYPE	CRM_OBJEC_TYPE	CHAR	20	0	Object Type ID	*
9	OBJECT_GUID	☐	CRM_RATING_GUID32	CRM_RATING_GUID	CHAR	32	0	Rating GUID
10	APPLICATION_ID	☐	CRM_SHOP_ID	CRM_RATING_SHOP_ID	CHAR	40	0	Shop ID
11	CATALOG_ID	☐	CRM_CATALOG_ID	CRM_CATALOG_ID	CHAR	32	0	Catalog ID
12	RATING_VALUE	☐	CRM_RATING	CRM_RATING	INT4	10	0	Rating Value
13	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
14	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
15	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
16	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By

History

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