Show TOC

Complaint Query Locate this document in the navigation structure

Query Query: /CRMBW/CMPT_C01_Q0001

 

This query provides you with an overview of complaints in service. The query contains a full set of all characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Complaints.

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.

This query is based on the InfoProvider /CRMBW/CMPT_C01.

Note Note

For the categorization of complaints, a maximum of five schemas are available that each have ten categories. In the Complaint Query, only four of these categories are taken into account as standard (see Free Characteristics). If you want to evaluate other categories within reports that are based on this query, you need to extend the query with the corresponding categories.

End of the note.

To use this query, you must activate the business function SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB).

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Complaint (COMPLAINT)

Characteristic Characteristic

Application Server

/CRMBW/APPLS

Application server (/CRMBW/V_APPLS)

Characteristic Characteristic

Logical System

/CRMBW/LOGSYS

Source system (/CRMBW/V_LOGSY)

Characteristic Characteristic

Selection ID

/CRMBW/SELID

Selection ID (/CRMBW/V_SELID)

Characteristic Characteristic

User Name

/CRMBW/UNAME

Current User (/CRMBW/V_UNAME)
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Category 1

/CRMBW/CATL11

Characteristic Characteristic

Category 2

/CRMBW/CATL21

Characteristic Characteristic

Category 3

/CRMBW/CATL31

Characteristic Characteristic

Category 4

/CRMBW/CATL41
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Day (Posting Date)

0CALDAY

Characteristic Characteristic

Week (Posting Date)

0CALWEEK

Characteristic Characteristic

Month (Posting Date)

0CALMONTH

Characteristic Characteristic

Quarter (Posting Date)

0CALQUARTER

Characteristic Characteristic

Year (Posting Date)

0CALYEAR

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

Characteristic Characteristic

Service Organization

/CRMBW/SRV_ORG

Characteristic Characteristic

Responsible Service Org. Unit

/CRMBW/SRV_RES

Characteristic Characteristic

Complaint

/CRMBW/CMPT_GU

Characteristic Characteristic

Complaint ID

/CRMBW/CMPT_ID

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

Characteristic Characteristic

Country

/CRMBW/COUNTRY

Characteristic Characteristic

Region

/CRMBW/REGION

Characteristic Characteristic

Customer Group

/CRMBW/CUST_GR

Characteristic Characteristic

Category ID

/CRMBW/CAT_ID

Characteristic Characteristic

Coherent Cat. - Aspect ID

/CRMBW/ASPID

Characteristic Characteristic

Installed Base

/CRMBW/IBASE

Characteristic Characteristic

Installed Base: Component (Instance)

/CRMBW/INSTANC

Characteristic Characteristic

Product

/CRMBW/PROD_GU

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Reference Product

/CRMBW/GUID_OB

Characteristic Characteristic

Product Name Entered

/CRMBW/PRD_NAM

Characteristic Characteristic

Product Type

/CRMBW/PROD_TP

Characteristic Characteristic

Product Group

/CRMBW/PRD_GRP

Characteristic Characteristic

Product Group 1

/CRMBW/PRD_GR1

Characteristic Characteristic

Product Group 2

/CRMBW/PRD_GR2

Characteristic Characteristic

Product Group 3

/CRMBW/PRD_GR3

Characteristic Characteristic

Product Group 4

/CRMBW/PRD_GR4

Characteristic Characteristic

Product Group 5

/CRMBW/PRD_GR5

Characteristic Characteristic

Status

/CRMBW/CMP_STC

Characteristic Characteristic

Warranty

/CRMBW/WART_GU

Characteristic Characteristic

Warranty ID

/CRMBW/WART_ID

Characteristic Characteristic

Accounting Indicator

/CRMBW/AC_INDI
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Credit Memo Net Value Items

/CRMBW/CM_NV_I

—

Key Figure Key Figure

Credit Memo Net Value Service Items

/CRMBW/CM_NV_SRV_I

—

Key Figure Key Figure

Credit Memo Net Value Sales Items

/CRMBW/CM_NV_SLS_I

—

Key Figure Key Figure

Debit Memo Net Value Items

/CRMBW/DM_NV_I

—

Key Figure Key Figure

Debit Memo Net Value Service Items

/CRMBW/DM_NV_SRV_I

—

Key Figure Key Figure

Debit Memo Net Value Sales Items

/CRMBW/DM_NV_SLS_I

—

Key Figure Key Figure

Replacement Net Value Items

/CRMBW/RE_NV_I

—

Key Figure Key Figure

Sales Complaint Net Value Items

/CRMBW/SLS_CPLM_I

—

Key Figure Key Figure

Service Complaint Net Value Items

/CRMBW/SRV_CPLM_I

—

Key Figure Key Figure

Net Value of Return Items

/CRMBW/NV_RI

—

Key Figure Key Figure

No. of Return Items

CRMBW_NORETNI

—

Key Figure Key Figure

Average Net Value of a Return Item

/CRMBW/AVG_NV_RI

Net value of return items / number of return items

Key Figure Key Figure

Net Value of Complaint Items (Service + Sales)

/CRMBW/NV_CMPI

—

Key Figure Key Figure

No. of Complaint Items (Service)

CRMBW_NOCIS

—

Key Figure Key Figure

No. of Complaint Items (Sales)

CRMBW_NOCISA

—

Key Figure Key Figure

No. of Complaint Items (Service + Sales)

CRMBW_NOCISS

Number of complaint items (service) plus number of complaint items (sales)

Key Figure Key Figure

Average Net Value of a Complaint Item

/CRMBW/AVG_NV_CMPI

Net value of complaint items (service and sales) / number of complaint items (service and sales)

Key Figure Key Figure

No. of Complaints

/CRMBW/NUM_OF

—

Key Figure Key Figure

Net Value of Complaint Items (Service + Sales) (Doc. Curr.)

CRMBW_NVOCI

—

Key Figure Key Figure

Average Net Value of a Complaint Item (Doc. Curr.)

CRMBW_ANVOACI

Net value of complaint items (service and sales) / number of complaint items (service and sales)

Key Figure Key Figure

Gross Value (Document Currency)

/CRMBW/GROSS_V_DC

—

Key Figure Key Figure

No. of Service Credit Memo Items

CRMBW_NOSCMI

—

Key Figure Key Figure

No. of Sales Credit Memo Items

CRMBW_NOSACMI

—

Key Figure Key Figure

No. of Service Debit Memo Items

CRMBW_NOSDMI

—

Key Figure Key Figure

No. of Sales Debit Memo Items

CRMBW_NOSADMI

—

Key Figure Key Figure

No. of Replacement Items

CRMBW_NOREPI

—

Key Figure Key Figure

No. of Return Items

CRMBW_NORETNI

—

Key Figure Key Figure

Net Value of Return Items (Document Currency)

CRMBW_NVORI

—

Key Figure Key Figure

Average Net Value of a Return Item (Doc. Curr.)

CRMBW_ANVOARI

Net value of return items (document currency) / number of return items

Key Figure Key Figure

Service Complaint Net Value Items (Document Currency)

CRMBW_SCNVI

—

Key Figure Key Figure

Sales Complaint Net Value Items (Document Currency)

CRMBW_SACNVI

—

Key Figure Key Figure

Credit Memo Net Value Items (Document Currency)

CRMBW_CMNVI

—

Key Figure Key Figure

Credit Memo Net Value Service Items (Document Currency)

CRMBW_CMNVSI

—

Key Figure Key Figure

Credit Memo Net Value Sales Items (Document Currency)

CRMBW_CMNVSAI

—

Key Figure Key Figure

Debit Memo Net Value Items (Document Currency)

CRMBW_DMNVI

—

Key Figure Key Figure

Debit Memo Net Value Service Items (Document Currency)

CRMBW_DMNVSI

—

Key Figure Key Figure

Debit Memo Net Value Sales Items (Document Currency)

CRMBW_DMNVSAI

—

Key Figure Key Figure

Replacement Net Value Items (Document Currency)

CRMBW_REPNVI

—

Key Figure Key Figure

Gross Value of Complaint Items

/CRMBW/GROSS_V

—

Key Figure Key Figure

No. of Complaint Warranties

/CRMBW/N_CMPTW

—

Key Figure Key Figure

Complaint Item Ratio Covered by Warranty

CRMBW_CIRCBW

Number of complaint warranties / number of complaint items (service and sales)