Show TOC

Request for Change Query (Based on SAP HANA VDM) Locate this document in the navigation structure

Query Query: /CRMBW/SVO_V01_Q0002

 

This query provides you with an overview of requests for change 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 Requests for Change (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/SVO_V01.

Note Note

A maximum of five schemas are available that each have ten categories for the categorization of requests for change in service. In the Request for Change Query (Based on SAP HANA VDM), only eight 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

Report Area

/CRMBW/REPORTA

Service Request (REQUESTFORCHANGE_VDM)

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Subject Category 1

/CRMBW/CATL11 - SAP HANA VDM Feld: ServiceSchema1Category1UUID

Characteristic Characteristic

Reason Category 1

/CRMBW/CATL12 - SAP HANA VDM Feld: ServiceSchema2Category1UUID

Characteristic Characteristic

Subject Category 2

/CRMBW/CATL21 - SAP HANA VDM Feld: ServiceSchema1Category2UUID

Characteristic Characteristic

Reason Category 2

/CRMBW/CATL22 - SAP HANA VDM Feld: ServiceSchema2Category2UUID

Characteristic Characteristic

Subject Category 3

/CRMBW/CATL31 - SAP HANA VDM Feld: ServiceSchema1Category3UUID

Characteristic Characteristic

Reason Category 3

/CRMBW/CATL32 - SAP HANA VDM Feld: ServiceSchema2Category3UUID

Characteristic Characteristic

Subject Category 4

/CRMBW/CATL41 - SAP HANA VDM Feld: ServiceSchema1Category4UUID

Characteristic Characteristic

Reason Category 4

/CRMBW/CATL42 - SAP HANA VDM Feld: ServiceSchema2Category4UUID
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Request for Change

/CRMBW/SRV_ORD

SAP HANA VDM Field: ServiceOrderUUID

Characteristic Characteristic

Request for Change ID

/CRMBW/SVORDID

SAP HANA VDM Field: ServiceOrder

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

Currency

/CRMBW/CURNCY

SAP HANA VDM Field: TransactionCurrency

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

Posting Date

/CRMBW/POSTING

SAP HANA VDM Field: PostingDate

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

Service Team

/CRMBW/SRV_TM

SAP HANA VDM Field: ServiceTeam

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

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

Object/Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: ReferenceObjectOrProduct

Characteristic Characteristic

Object/Product

/CRMBW/GUID_OB

SAP HANA VDM Field: ReferenceObjectOrProductUUID

Characteristic Characteristic

Status

/CRMBW/SVO_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Change Category

/CRMBW/CHG_CAT

SAP HANA VDM Field: ServiceChangeCategory

Characteristic Characteristic

Recommended Priority

/CRMBW/REC_PRI

SAP HANA VDM Field: RecommendedServicePriority

Characteristic Characteristic

Impact

/CRMBW/IMPACT

SAP HANA VDM Field: ServiceImpact

Characteristic Characteristic

Urgency

/CRMBW/URGENCY

SAP HANA VDM Field: ServiceUrgency

Characteristic Characteristic

Risk

/CRMBW/RISK

SAP HANA VDM Field: ServiceRisk

Characteristic Characteristic

Escalation Level

/CRMBW/ESCALAT

SAP HANA VDM Field: ServiceEscalationLevel

Characteristic Characteristic

Company Code

/CRMBW/ICBD_CC

SAP HANA VDM Field: CompanyCode

Characteristic Characteristic

Logical System

/CRMBW/ICBD_LS

SAP HANA VDM Field: LogicalSystem

Characteristic Characteristic

Activity Category

/CRMBW/ACT_CAT

SAP HANA VDM Field: CRMActivityCategory

Characteristic Characteristic

Service Contract ID

/CRMBW/SRVCONT

SAP HANA VDM Field: ServiceContract

Characteristic Characteristic

Category ID

/CRMBW/CATID

SAP HANA VDM Field: ServiceCategory

Characteristic Characteristic

Coherent Cat. - Aspect ID

/CRMBW/ASPID

SAP HANA VDM Field: ServiceCategorySchema
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Gross Value of Requests for Change (Document Currency)

/CRMBW/GASVOHD

SAP HANA VDM Field: GrossAmount_E

Key Figure Key Figure

Gross Value of Requests for Change

/CRMBW/GVH_DC

SAP HANA VDM Field: GrossAmountInDisplayCrcy_E

Key Figure Key Figure

Number of Requests for Change with Status: Waiting for Approval

/CRMBW/NO_RFCP

SAP HANA VDM Field: NumberOfPendingReqForChg

Key Figure Key Figure

No. of Rejected Requests for Change

/CRMBW/NO_RFCR

SAP HANA VDM Field: NumberOfRejectedReqForChg

Key Figure Key Figure

Number of Closed Requests for Change

/CRMBW/NO_RFCC

SAP HANA VDM Field: NumberOfClosedReqForChg

Key Figure Key Figure

No. of Requests for Change

/CRMBW/NO_RFC

SAP HANA VDM Field: NumberOfRequestsForChange

Key Figure Key Figure

No. of Open Requests for Change

/CRMBW/NO_RFCO

SAP HANA VDM Field: NumberOfOpenReqForChg

Key Figure Key Figure

Percentage of Open Requests for Change

CRMBW_POORFC_VDM

Number of Open Requests for Change (CRMBW/NO_RFCO) / Number of Requests for Change (/CRMBW/NO_RFC) * 100

Key Figure Key Figure

No. of Approved Requests for Change

CRMBW_NO_RFCA

SAP HANA VDM Field: NumberOfApprovedReqForChg

Key Figure Key Figure

Percentage of Approved Requests for Change

CRMBW_POARFC_VDM

Number of Approved Requests for Change (CRMBW/NO_RFCA) / Number of Approved Requests for Change (/CRMBW/NO_RFCA) plus Number of Rejected Requests for Change (/CRMBW/NO_RFCR) * 100

Key Figure Key Figure

0-7 Days

/CRMBW/NO_RFCL

SAP HANA VDM Field: LastWkNumberOfCreatedReqForChg

Key Figure Key Figure

Closure Rate

CRMBW_CRRFC_VDM

Number of Closed Requests for Change (/CRMBW/NO_RFCC) / Number of Requests for Change (/CRMBW/NO_RFC) * 100

Key Figure Key Figure

Average Work Duration

CRMBW_RFCAWD_VDM

Work Duration (/CRMBW/W_DURA) / Number of Requests for Change (/CRMBW/NO_RFC))

Key Figure Key Figure

Average Total Duration

CRMBW_RFCATD_VDM

Total Duration (/CRMBW/TW_DURA) / Number of Requests for Change (CRMBW/NO_RFC)

Key Figure Key Figure

Total Duration

/CRMBW/TW_DURA

SAP HANA VDM Field: TotalWorkDuration

Key Figure Key Figure

Work Duration

/CRMBW/W_DURA

SAP HANA VDM Field: WorkDuration

Key Figure Key Figure

Number of Requests for Change Within Requested End

/CRMBW/NO_RFCE

SAP HANA VDM Field: NmbrOfMetReqdEndReqForChg

Key Figure Key Figure

Percentage of Requests for Change Within Requested End

CRMBW_PORFCWRE_VDM

Number of Requests for Change Within Requested End (/CRMBW/NO_RFCE) / Number of Requests for Change (/CRMBW/NO_RFC) * 100

Key Figure Key Figure

Number of Requests for Change Outside Requested End

/CRMBW/NO_RFC3

SAP HANA VDM Field: NmbrOfNotMetReqdEndReqForChg

Key Figure Key Figure

Percentage of Requests for Change Outside Requested End

CRMBW_PORFCORE_VDM

Number of Requests for Change Outside Requested End (/CRMBW/NO_RFC3) / Number of Requests for Change (/CRMBW/NO_RFC) * 100

Key Figure Key Figure

No. of Escalated Requests for Change (Escalation Level 1)

/CRMBW/NO_RFC1

SAP HANA VDM Field: Level1NmbrOfEscalatedReqForChg

Key Figure Key Figure

No. of Escalated Requests for Change (Escalation Level 2)

/CRMBW/NO_RFC2

SAP HANA VDM Field: Level2NmbrOfEscalatedReqForChg

Key Figure Key Figure

No. of Requests for Change Outside Reaction Time

/CRMBW/NO_RFCT

SAP HANA VDM Field: NmbrOfNotMetReactnTmeReqForChg

Key Figure Key Figure

Reaction Time Adherence Rate

CRMBW_RFCRTAR_VDM

Number of Requests for Change Outside Reaction Time (/CRMBW/NO_RFCT) / Number of Open Requests for Change (/CRMBW/NO_RFCO) * 100