Show TOC

Complaint Query (VDM-Based) Locate this document in the navigation structure

Query Query: /CRMBW/CMPT_V01_Q0001

 

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

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports Based on SAP HANA VDM

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

Note Note

For the categorization of complaints, a maximum of five schemas are available that each have ten categories. In the Complaint Query (VDM-Based), 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 functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting Based on SAP HANA VDM (CRM_ANA_VDM) .

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Category 1

/CRMBW/CATL11 - SAP HANA VDM Feld: ComplaintSchema1Category1UUID

Characteristic Characteristic

Category 2

/CRMBW/CATL21 - SAP HANA VDM Feld: ComplaintSchema1Category2UUID

Characteristic Characteristic

Category 3

/CRMBW/CATL31 - SAP HANA VDM Feld: ComplaintSchema1Category3UUID

Characteristic Characteristic

Category 4

/CRMBW/CATL41 - SAP HANA VDM Feld: ComplaintSchema1Category4UUID

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Day (Posting Date)

/CRMBW/CALDAY

SAP HANA VDM Field: PostingDate

Characteristic Characteristic

Week (Posting Date)

/CRMBW/CALYWEE

SAP HANA VDM Field: PostingDateYearWeek

Characteristic Characteristic

Month (Posting Date)

/CRMBW/CALYMON

SAP HANA VDM Field: PostingDateYearMonth

Characteristic Characteristic

Quarter (Posting Date)

/CRMBW/CALYQTR

SAP HANA VDM Field: PostingDateYearQuarter

Characteristic Characteristic

Year (Posting Date)

/CRMBW/CALYEAR

SAP HANA VDM Field: PostingDateYear

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

SAP HANA VDM Field: SalesOrganization

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

SAP HANA VDM Field: DistributionChannel

Characteristic Characteristic

Service Organization

/CRMBW/SRV_ORG

SAP HANA VDM Field: ServiceOrganization

Characteristic Characteristic

Responsible Service Org. Unit

/CRMBW/SRV_RES

SAP HANA VDM Field: ResponsibleServiceOrganization

Characteristic Characteristic

Complaint

/CRMBW/CMPT_GU

SAP HANA VDM Field: ComplaintUUID

Characteristic Characteristic

Complaint ID

/CRMBW/CMPT_ID

SAP HANA VDM Field: Complaint

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

SAP HANA VDM Field: ServicePriority

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

SAP HANA VDM Field: SoldToParty

Characteristic Characteristic

Country

/CRMBW/COUNTRY

SAP HANA VDM Field: SoldToPartyCountry

Characteristic Characteristic

Region

/CRMBW/REGION

SAP HANA VDM Field: SoldToPartyRegion

Characteristic Characteristic

Customer Group

/CRMBW/CUST_GR

SAP HANA VDM Field: CustomerGroup

Characteristic Characteristic

Category ID

/CRMBW/CATID

SAP HANA VDM Field: ServiceCategory

Characteristic Characteristic

Coherent Cat. - Aspect ID

/CRMBW/ASPID

SAP HANA VDM Field: ServiceCategorySchema

Characteristic Characteristic

Installed Base

/CRMBW/IBASE

SAP HANA VDM Field: InstalledBase

Characteristic Characteristic

Installed Base: Component (Instance)

/CRMBW/INSTANC

SAP HANA VDM Field: InstalledBaseComponent

Characteristic Characteristic

Product

/CRMBW/PROD_GU

SAP HANA VDM Field: ProductUUID

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: Product

Characteristic Characteristic

Reference Product

/CRMBW/GUID_OB

SAP HANA VDM Field: ReferenceObjectOrProductUUID

Characteristic Characteristic

Product Name Entered

/CRMBW/PRD_NAM

SAP HANA VDM Field: ReferenceObjectOrProduct

Characteristic Characteristic

Product Type

/CRMBW/PROD_TP

SAP HANA VDM Field: ProductType

Characteristic Characteristic

Product Group

/CRMBW/PRD_GRP

SAP HANA VDM Field: ProductGroup

Characteristic Characteristic

Product Group 1

/CRMBW/PRD_GR1

SAP HANA VDM Field: ProductGroup1

Characteristic Characteristic

Product Group 2

/CRMBW/PRD_GR2

SAP HANA VDM Field: ProductGroup2

Characteristic Characteristic

Product Group 3

/CRMBW/PRD_GR3

SAP HANA VDM Field: ProductGroup3

Characteristic Characteristic

Product Group 4

/CRMBW/PRD_GR4

SAP HANA VDM Field: ProductGroup4

Characteristic Characteristic

Product Group 5

/CRMBW/PRD_GR5

SAP HANA VDM Field: ProductGroup5

Characteristic Characteristic

Status

/CRMBW/CMP_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Warranty

/CRMBW/WART_GU

SAP HANA VDM Field: WarrantyUUID

Characteristic Characteristic

Warranty ID

/CRMBW/WART_ID

SAP HANA VDM Field: Warranty

Characteristic Characteristic

Accounting Indicator

/CRMBW/AC_INDI

SAP HANA VDM Field: AccountingIndicatorCode

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Credit Memo Net Value Items

/CRMBW/CM_NV_I

SAP HANA VDM Field: CrdtMemoNetAmtInDisplayCrcy_E

Key Figure Key Figure

Credit Memo Net Value Service Items

/CRMBW/CM_NV_SRV_I

SAP HANA VDM Field: SrvcCrdtMemoNetAmtInDspCrcy_E

Key Figure Key Figure

Credit Memo Net Value Sales Items

/CRMBW/CM_NV_SLS_I

SAP HANA VDM Field: SalesCrdtMemoNetAmtInDspCrcy_E

Key Figure Key Figure

Debit Memo Net Value Items

/CRMBW/DM_NV_I

SAP HANA VDM Field: DebitMemoNetAmtInDisplayCrcy_E

Key Figure Key Figure

Debit Memo Net Value Service Items

/CRMBW/DM_NV_SRV_I

SAP HANA VDM Field: SrvcDebitMemoNetAmtInDspCrcy_E

Key Figure Key Figure

Debit Memo Net Value Sales Items

/CRMBW/DM_NV_SLS_I

SAP HANA VDM Field: SlsDebitMemoNetAmtInDspCrcy_E

Key Figure Key Figure

Replacement Net Value Items

/CRMBW/RE_NV_I

SAP HANA VDM Field: ReplacementNetAmtInDspCrcy_E

Key Figure Key Figure

Sales Complaint Net Value Items

/CRMBW/SLS_CPLM_I

SAP HANA VDM Field: SalesCmplNetAmountInDspCrcy_E

Key Figure Key Figure

Service Complaint Net Value Items

/CRMBW/SRV_CPLM_I

SAP HANA VDM Field: ServiceCmplNetAmtInDspCrcy_E

Key Figure Key Figure

Net Value of Return Items

/CRMBW/NV_RI

SAP HANA VDM Field: ReturnNetAmountInDisplayCrcy_E

Key Figure Key Figure

No. of Return Items

CRMBW_NORETNI

SAP HANA VDM Field: NumberOfReturns

Key Figure Key Figure

Average Net Value of a Return Item

/CRMBW/AVG_NV_RI_V

Net Value of Return Items / Number of Return Items

Key Figure Key Figure

Net Value of Complaint Items (Service + Sales)

/CRMBW/NV_CMPI

SAP HANA VDM Field: ComplaintNetAmountInDspCrcy_E

Key Figure Key Figure

No. of Complaint Items (Service)

CRMBW_NOCIS

SAP HANA VDM Field: NumberOfComplaintServiceItems

Key Figure Key Figure

No. of Complaint Items (Sales)

CRMBW_NOCISA

SAP HANA VDM Field: NumberOfComplaintSalesItems

Key Figure Key Figure

No. of Complaint Items (Service + Sales)

CRMBW_NOCISS

SAP HANA VDM Field: NumberOfComplaintItems

Key Figure Key Figure

Average Net Value of a Complaint Item

/CRMBW/AVG_NV_CMP

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

SAP HANA VDM Field: NumberOfComplaints

Key Figure Key Figure

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

CRMBW_NVOCI

SAP HANA VDM Field: ComplaintNetAmount_E

Key Figure Key Figure

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

CRMBW_ANVOACI_V

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

SAP HANA VDM Field: GrossAmount_E

Key Figure Key Figure

No. of Service Credit Memo Items

CRMBW_NOSCMI

SAP HANA VDM Field: NumberOfServiceCreditMemos

Key Figure Key Figure

No. of Sales Credit Memo Items

CRMBW_NOSACMI

SAP HANA VDM Field: NumberOfSalesCreditMemos

Key Figure Key Figure

No. of Service Debit Memo Items

CRMBW_NOSDMI

SAP HANA VDM Field: NumberOfServiceDebitMemos

Key Figure Key Figure

No. of Sales Debit Memo Items

CRMBW_NOSADMI

SAP HANA VDM Field: NumberOfSalesDebitMemos

Key Figure Key Figure

No. of Replacement Items

CRMBW_NOREPI

SAP HANA VDM Field: NumberOfReplacements

Key Figure Key Figure

No. of Return Items

CRMBW_NORETNI

SAP HANA VDM Field: NumberOfReturns

Key Figure Key Figure

Net Value of Return Items (Document Currency)

CRMBW_NVORI

SAP HANA VDM Field: ReturnNetAmount_E

Key Figure Key Figure

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

CRMBW_ANVOARI_V

Net Value of Return Items (Document Currency) / Number of Return Items

Key Figure Key Figure

Service Complaint Net Value Items (Document Currency)

CRMBW_SCNVI

SAP HANA VDM Field: ServiceComplaintNetAmount_E

Key Figure Key Figure

Sales Complaint Net Value Items (Document Currency)

CRMBW_SACNVI

SAP HANA VDM Field: SalesComplaintNetAmount_E

Key Figure Key Figure

Credit Memo Net Value Items (Document Currency)

CRMBW_CMNVI

SAP HANA VDM Field: CreditMemoNetAmount_E

Key Figure Key Figure

Credit Memo Net Value Service Items (Document Currency)

CRMBW_CMNVSI

SAP HANA VDM Field: ServiceCreditMemoNetAmount_E

Key Figure Key Figure

Credit Memo Net Value Sales Items (Document Currency)

CRMBW_CMNVSAI

SAP HANA VDM Field: SalesCreditMemoNetAmount_E

Key Figure Key Figure

Debit Memo Net Value Items (Document Currency)

CRMBW_DMNVI

SAP HANA VDM Field: DebitMemoNetAmount_E

Key Figure Key Figure

Debit Memo Net Value Service Items (Document Currency)

CRMBW_DMNVSI

SAP HANA VDM Field: ServiceDebitMemoNetAmount_E

Key Figure Key Figure

Debit Memo Net Value Sales Items (Document Currency)

CRMBW_DMNVSAI

SAP HANA VDM Field: SalesDebitMemoNetAmount_E

Key Figure Key Figure

Replacement Net Value Items (Document Currency)

CRMBW_REPNVI

SAP HANA VDM Field: ReplacementNetAmount_E

Key Figure Key Figure

Gross Value of Complaint Items

/CRMBW/GROSS_V

SAP HANA VDM Field: GrossAmountInDisplayCurrency_E

Key Figure Key Figure

No. of Complaint Warranties

/CRMBW/N_CMPTW

SAP HANA VDM Field: NumberOfComplaintWarranties

Key Figure Key Figure

Complaint Item Ratio Covered by Warranty

CRMBW_CIRCBW_V

Number of Complaint Warranties / Number of Complaint Items (Service and Sales)