C_ServiceOrderQuery

Service Order - Query | view: CSRVCORDQRY | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
Column Name Description
💲 null (DisplayCurrency):
NetAmountInDisplayCurrency null
Column Name Description
Column Name Description
RequestedServiceEndDate Changed On
ServiceDocumentCreationDate Created On
Column Name Description
ServiceOrderStatus Life Cycle Status Show values
ServiceDocumentHasError Error Status Show values
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceOrder Transaction ID CRM_OBJECT_ID
ServiceOrderDescription Transaction Description CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
SrvcOrdCreationQuarter Calendar Quarter NUM1
SrvcOrdCreationMonth Calendar Month NUM2
SrvcOrdCreationYear Calendar Year NUM4
NumberOfIncomingServiceOrders null
NumberOfOpenServiceOrders null
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • C_SERVICEORDERQUERY.MANDT == TVTW.MANDT
  • C_SERVICEORDERQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SERVICEORDERQUERY.MANDT == TSPA.MANDT
  • C_SERVICEORDERQUERY.DIVISION == TSPA.SPART
Activity Priority
  • Activity Priority
  • Client
  • C_SERVICEORDERQUERY.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
  • C_SERVICEORDERQUERY.MANDT == SCPRIO.CLIENT
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. C_SERVICEORDERQUERY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • C_SERVICEORDERQUERY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERQUERY.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Currency
  • Client
  • C_SERVICEORDERQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SERVICEORDERQUERY.MANDT == TCURC.MANDT