Customer Service  

Technical Name: 0CRM_FSC1_Q0001

Template Name: 0TPLB_0CRM_FSC1_Q0001_V01_FS

Use

This query is based on the CRM Common InfoCube for Fact Sheet (0CRM_FSC1). It shows the following key figures:

·         SLA-Compliance

·         Requested-By-Date Compliance

·         Net Value of Complaints

·         Number of Complaint Items

·         Average Net Value per Complaint Item

·         Net Value of Returns

·         Number of Return Items

·         Average Net Value per Return Item

These key figures are shown for the last four quarters (including the current quarter). In addition, there is another column with the total values for the mentioned key figures.

The query view 0CRM_SOLDTO_Q0001_V01 is based on this query and is identical to it.

 

Free Characteristics

InfoObject	Description
0CRM_SOLDTO	Sold-to Party. This filter value is filled by portal framework

Variables Used

Variable	Description
0CQUART	Current Calendar Quarter. This restricts the InfoObject 0CALQUARTER

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0CALQUARTER	Restricted using the variable (0CQUART) to: Current Quarter – 3 Current Quarter – 2 Current Quarter -1 Current Quarter Including the Total Column