C_IncmpltServiceOrderQuery

Incomplete Service Order - Query | view: CINSRVCORDQRY | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
Column Name Description
💲 null (DisplayCurrency):
ServiceDocNetAmount null
Column Name Description
Column Name Description
ServiceDocumentCreationDate Created On
RequestedServiceEndDate Changed On
Column Name Description
ServiceOrderStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceDocumentHasError Error Status Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
SrvcRefObjIsMainObject Main Reference Object Show values
Column Name Description Domain name
ServiceOrderDescription Transaction Description CRM_PROCESS_DESCRIPTION
NmbrOfIncompleteServiceOrders null
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SerialNumber Serial Number GERNR
FunctionalLocation Functional Location TPLNR
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • C_INCMPLTSERVICEORDERQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_INCMPLTSERVICEORDERQUERY.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_INCMPLTSERVICEORDERQUERY.MANDT == TSPA.MANDT
  • C_INCMPLTSERVICEORDERQUERY.DIVISION == TSPA.SPART
Equipment Number
  • Equipment Number
  • Client
  • C_INCMPLTSERVICEORDERQUERY.EQUIPMENT == EQUI.EQUNR
  • C_INCMPLTSERVICEORDERQUERY.MANDT == EQUI.MANDT
Material Number
  • Client
  • Material Number
  • C_INCMPLTSERVICEORDERQUERY.MANDT == MARA.MANDT
  • C_INCMPLTSERVICEORDERQUERY.PRODUCTID == MARA.MATNR
Activity Priority
  • Client
  • Activity Priority
  • C_INCMPLTSERVICEORDERQUERY.MANDT == SCPRIO.CLIENT
  • C_INCMPLTSERVICEORDERQUERY.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. C_INCMPLTSERVICEORDERQUERY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • C_INCMPLTSERVICEORDERQUERY.MANDT == BUT000.CLIENT
  • C_INCMPLTSERVICEORDERQUERY.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • C_INCMPLTSERVICEORDERQUERY.MANDT == TCURC.MANDT
  • C_INCMPLTSERVICEORDERQUERY.TRANSACTIONCURRENCY == TCURC.WAERS