Archiving Ratings and Reviews
You use the archiving object WEC_RATING
to archive ratings and reviews in SAP Web Channel Experience Management.
Archiving allows for proper maintenance of records, and can improve performance when the system reads or updates database tables.
To use the archiving object WEC_RATING
, you have configured the authorization object WEC_RATING
to control user access to actions related to ratings and reviews. For more information, see Customer Interaction.
Structure
The ratings and reviews archiving object contains the following database tables that are specific to ratings and reviews:
Database Table Technical Name | Description | Comment |
| Stores reviews reported for inappropriate content | To be archived |
| Stores reviews for products | To be archived |
| Stores ratings for products | To be archived |
Note
You cannot archive entries in database table CRMD_AVERAGE_H
, which stores average ratings for products.
Using Archive Administration (transaction SARA
), you schedule archiving reports to run immediately, or as background jobs. The ratings and reviews archiving object contains the following reports:
Write (
CRM_WEC_RATING_ARCHIVE_WRITE
)This report selects ratings and reviews for archiving based on the selection criteria you specify, such as object ID, status, or creation date. To use the write report, you must create a variant. The variant allows you set attributes that you can use to modify the selection criteria that is available.
Delete (
CRM_WEC_RATING_ARCHIVE_DELETE
)This report allows you to choose an archiving session to delete the database table records archived during that session.
Read (
CRM_WEC_RATING_ARCHIVE_READ
)This report reads the data stored in the archiving files. After you execute the report, you can select criteria to specify the particular objects to be read.
Note
Archive Administration also provides access to a management tool for viewing the results of previous archiving sessions.