Show TOC

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

Query Query: /CRMBW/SVO_V01_Q0001

 

This query provides you with an overview of service orders. 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 Service Orders (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 that each have ten categories are available for the categorization of service orders. In the Service Order 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

Report Area

/CRMBW/REPORTA

Service Order (SERVICEORDER_VDM)

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:ServiceSchema1Category1UUID

Characteristic Characteristic

Category 2

/CRMBW/CATL21 - SAP HANA VDM Feld:ServiceSchema1Category2UUID

Characteristic Characteristic

Category 3

/CRMBW/CATL31 - SAP HANA VDM Feld:ServiceSchema1Category3UUID

Characteristic Characteristic

Category 4

/CRMBW/CATL41 - SAP HANA VDM Feld:ServiceSchema1Category4UUID

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Currency

/CRMBW/CURNCY

SAP HANA VDM Field: TransactionCurrency

Characteristic Characteristic

Service Order

/CRMBW/SRV_ORD

SAP HANA VDM Field: ServiceOrderUUID

Characteristic Characteristic

Service Order ID

/CRMBW/SVORDID

SAP HANA VDM Field: ServiceOrder

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

SAP HANA VDM Field: PostingDate

Characteristic Characteristic

Created On

/CRMBW/CREA_AT

SAP HANA VDM Field: CreationDate

Characteristic Characteristic

Changed On

/CRMBW/CHA_AT

SAP HANA VDM Field: LastChangedDate

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

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

Installed Base

/CRMBW/IBASE

SAP HANA VDM Field: InstalledBase

Characteristic Characteristic

Installed Base: Component (Instance)

/CRMBW/INSTANC

SAP HANA VDM Field: InstalledBaseComponent

Characteristic Characteristic

Reference Product

/CRMBW/GUID_OB

SAP HANA VDM Field: ReferenceObjectOrProductUUID

Characteristic Characteristic

Reference Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: ReferenceObjectOrProduct

Characteristic Characteristic

Activity Category

/CRMBW/ACT_CAT

SAP HANA VDM Field: CRMActivityCategory

Characteristic Characteristic

Status

/CRMBW/SVO_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Accounting Indicator

/CRMBW/AC_INDI

SAP HANA VDM Field: AccountingIndicatorCode

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 Header (Document Currency)

/CRMBW/GASVOHD

GrossAmount_E

Key Figure Key Figure

Gross Value of Service Orders (Document Currency)

/CRMBW/GASVODC

SAP HANA VDM Field: SrvcOrdGrossAmount_E

Key Figure Key Figure

Gross Value of Unplanned Service Confirmations (Doc. Curr.)

/CRMBW/UPSCGVD

SAP HANA VDM Field: UnplndSrvcConfGrossAmount_E

Key Figure Key Figure

Gross Value Header

/CRMBW/GVH_DC

SAP HANA VDM Field: GrossAmountInDisplayCrcy_E

Key Figure Key Figure

Gross Value of Service Orders

/CRMBW/GVSVODC

SAP HANA VDM Field: SrvcOrdGrossAmtInDisplayCrcy_E

Key Figure Key Figure

Gross Value of Unplanned Service Confirmations

/CRMBW/GVAL_UD

SAP HANA VDM Field: UnplndSrvcConfAmtInDspCrcy_E

Key Figure Key Figure

Gross Value of Service Orders and Unplanned Service Confirm.

/CRMBW/GVAL_UC

SAP HANA VDM Field: SrvcOrdUnplndCnfAmtInDspCrcy_E

Key Figure Key Figure

Average Gross Value of Service Orders and Unplanned Service Confirmations

CRMBW_AOSOAUSRVC

Gross Value of Service Orders and Unplanned Service Confirmations (/CRMBW/GVAL_UC) / (Number of Service Orders (/CRMBW/NO_SRVO) Plus Number of Unplanned Service Confirmations (/CRMBW/NO_USVC))

Key Figure Key Figure

No. of Service Orders

/CRMBW/NO_SRVO

SAP HANA VDM Field: NumberOfServiceOrders

Key Figure Key Figure

No. of Unplanned Service Confirmations

/CRMBW/NO_USVC

SAP HANA VDM Field: NmbrOfUnplndSrvcConfirmations

Key Figure Key Figure

No. of Service Orders and Unplanned Service Confirmations

/CRMBW/SRV_UPC

SAP HANA VDM Field: NmbrOfSrvcOrdAndUnplndSrvcConf

Key Figure Key Figure

No. of Open Service Orders

/CRMBW/OP_SRVO

SAP HANA VDM Field: NumberOfOpenServiceOrders

Key Figure Key Figure

Completion Rate % (Service Order)

CRMBW_CPRSRVO

Number of Open Service Orders (/CRMBW/OP_SRVO) / Number of Service Orders (/CRMBW/NO_SRVO) * 100

Key Figure Key Figure

No. of Service Confirmations

/CRMBW/NO_SVCO

SAP HANA VDM Field: NumberOfServiceConfirmations

Key Figure Key Figure

No. of Open Service Confirmations

/CRMBW/OP_SRVC

SAP HANA VDM Field: NmbrOfOpenServiceConfirmations

Key Figure Key Figure

Completion Rate % (Service Confirmation)

CRMBW_CPRSVO

Number of Open Service Confirmations (/CRMBW/OP_SRVC) / Number of Service Confirmations (/CRMBW/NO_SVCO) * 100

Key Figure Key Figure

No. of Open Service Orders and Service Confirmations

/CRMBW/OP_SROC

SAP HANA VDM Field: NumberOfOpenSrvcOrdAndSrvcConf

Key Figure Key Figure

Service Order Lead Time

/CRMBW/SRVD_LC

SAP HANA VDM Field: ServiceOrderDuration

Key Figure Key Figure

Average Service Order Lead Time

CRMBW_ASRVOLT

Lead Time for Service Order (/CRMBW/SRVD_LC) / (Number of Service Orders (/CRMBW/NO_SRVO) Plus Number of Service Confirmations (/CRMBW/NO_SVCO))

Key Figure Key Figure

No. of Closed Service Orders This Month

/CRMBW_NO_SCCM

SAP HANA VDM Field: CurMonthNumberOfClosedSrvcOrd

Key Figure Key Figure

No. of New Service Orders This Month

/CRMBW/N_SCRCM

SAP HANA VDM Field: CurMonthNumberOfCrtedSrvcOrd

Key Figure Key Figure

No. of Open Service Orders Created Prior to This Month

/CRMBW/N_SCRPM

SAP HANA VDM Field: LastMonthNmbrCrtedOpenSrvcOrd

Key Figure Key Figure

Closure Rate This Month

CRMBW_CLRTM

Number of Closed Service Orders This Month (CRMBW/NO_SCCM) / (Number of New Service Orders This Month Plus Number of Open Service Orders Created Prior to This Month (CRMBW/N_SCRPM)) * 100