C_ServiceOrderAnalyticsQry

Service Order Analytics Query | view: CSERVORDANAQRY | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_REFOBJ, CRMD_BRELVONAE, BUT000, TVTWT, TSPAT, TVTA, TVGRT, TVBVK, TVKBT, TVKO, TVKOT, SCPRIO, SCPRIOT, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, TVKOV, TVKBZ
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
Column Name Description
💲 Currency Key (DisplayCurrency):
ServiceDocNetAmount null
Column Name Description
Column Name Description
Column Name Description
ServiceDocumentHasError Error Status Show values
ServiceOrderStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
SrvcRefObjIsMainObject Main Reference Object Show values
Column Name Description Domain name
ServiceOrderTypeName Description TEXT40
ServiceDocumentHasErrorName Short Text for Fixed Values
ServiceOrderDescription Transaction Description
SoldToPartyName null
RefBusinessSolutionOrder Reference Solution Order ID
ServiceDocumentPriorityName Description
ServiceOrderStatusName Short Text for Fixed Values
SrvcOrdHasConfdItem null
SrvcOrdHasConfdItemName Short Text for Fixed Values
NmbrOfIncompleteServiceOrders null
NumberOfOverdueServiceOrders null
SalesOrganization Sales Organization VKORG
SalesOrganizationName Sales Organization Description
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
DistributionChannelName Distribution Channel Description
DivisionName Division Description
SalesOffice Sales office VKBUR
SalesOfficeName Sales Office Description
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroup Sales group VKGRP
SalesGroupName Sales Group Description
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
SerialNumber Serial Number GERNR
FunctionalLocation Functional Location TPLNR
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_SERVICEORDERANALYTICSQRY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERANALYTICSQRY.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_SERVICEORDERANALYTICSQRY.MANDT == TVTW.MANDT
  • C_SERVICEORDERANALYTICSQRY.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SERVICEORDERANALYTICSQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_SERVICEORDERANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SERVICEORDERANALYTICSQRY.ORGUNITDIVISION == TSPA.SPART
  • C_SERVICEORDERANALYTICSQRY.DIVISION == TSPA.SPART
Equipment Number
  • Client
  • Equipment Number
  • C_SERVICEORDERANALYTICSQRY.MANDT == EQUI.MANDT
  • C_SERVICEORDERANALYTICSQRY.EQUIPMENT == EQUI.EQUNR
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_SERVICEORDERANALYTICSQRY.MANDT == TVTW.MANDT
  • C_SERVICEORDERANALYTICSQRY.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SERVICEORDERANALYTICSQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_SERVICEORDERANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SERVICEORDERANALYTICSQRY.ORGUNITDIVISION == TSPA.SPART
  • C_SERVICEORDERANALYTICSQRY.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • C_SERVICEORDERANALYTICSQRY.MANDT == MARA.MANDT
  • C_SERVICEORDERANALYTICSQRY.PRODUCTID == MARA.MATNR
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • C_SERVICEORDERANALYTICSQRY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERANALYTICSQRY.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_SERVICEORDERANALYTICSQRY.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • C_SERVICEORDERANALYTICSQRY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERANALYTICSQRY.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_SERVICEORDERANALYTICSQRY.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Activity Priority
  • Client
  • Activity Priority
  • C_SERVICEORDERANALYTICSQRY.MANDT == SCPRIO.CLIENT
  • C_SERVICEORDERANALYTICSQRY.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
Business Trans. Cat. C_SERVICEORDERANALYTICSQRY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
Sold-To Party
  • Client
  • Sold-To Party
  • C_SERVICEORDERANALYTICSQRY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERANALYTICSQRY.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • C_SERVICEORDERANALYTICSQRY.MANDT == TCURC.MANDT
  • C_SERVICEORDERANALYTICSQRY.TRANSACTIONCURRENCY == TCURC.WAERS