C_ServiceOrderIssueQuery

Service Order Issues | view: CSRVCORDISSUEQ | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMD_BRELVONAI, CRMD_BRELVONAE, CRMD_BRELVONAE
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
CustMgmtIssue Issue in Service Transaction Show values
SrvcConfIssue Service Confirmation Issue Show values
Column Name Description
💲 Currency (TransactionCurrency):
SrvcOrdGrossAmount Gross Order Value in PO Currency
Column Name Description
Column Name Description
RequestedServiceStartDate Requested Start Date of Service
RequestedServiceEndDate Requested End Date of Service
PlannedServiceStartDate Planned Start Date of Service
PlannedServiceEndDate Planned End Date of Service
SrvcDocItemSLADueByDate SLA Due By
ServiceFirstResponseByDate First Response Due Date
Column Name Description
CustMgmtIssue Issue in Service Transaction Show values
SrvcConfIssue Service Confirmation Issue Show values
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemHasError Error Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
ServiceDocItemBillingStatus Billing Status Show values
SrvcDocItemTransferStatus Transfer Status Show values
Column Name Description Domain name
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceOrganization Service Organization HROBJEC_14
ResponseProfile Response Profile CRM_SRV_ESCAL
ServiceProfile Service Profile CRM_SRV_SERWI
RefBusinessSolutionOrder ID of a Reference Solution Order for Analytics CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in a Reference Solution Order for Analytics CRMS4_NUMBER_INT
TotalNumberOfIssues Total Number of Issues
Master Data Relations Join Conditions
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • C_SERVICEORDERISSUEQUERY.BILLINGBLOCKREASON == TVFS.FAKSP
  • C_SERVICEORDERISSUEQUERY.MANDT == TVFS.MANDT
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_SERVICEORDERISSUEQUERY.MANDT == BUT000.CLIENT
  • C_SERVICEORDERISSUEQUERY.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • C_SERVICEORDERISSUEQUERY.MANDT == TVTW.MANDT
  • C_SERVICEORDERISSUEQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SERVICEORDERISSUEQUERY.MANDT == TSPA.MANDT
  • C_SERVICEORDERISSUEQUERY.DIVISION == TSPA.SPART
Industry Sector
  • Industry Sector
  • Client
  • C_SERVICEORDERISSUEQUERY.INDUSTRY == T016.BRSCH
  • C_SERVICEORDERISSUEQUERY.MANDT == T016.MANDT
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • Client
  • C_SERVICEORDERISSUEQUERY.[column in domain "LAND1"] == T005S.LAND1
  • C_SERVICEORDERISSUEQUERY.REGION == T005S.BLAND
  • C_SERVICEORDERISSUEQUERY.MANDT == T005S.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • C_SERVICEORDERISSUEQUERY.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_SERVICEORDERISSUEQUERY.MANDT == BUT000.CLIENT
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • C_SERVICEORDERISSUEQUERY.MANDT == TVAG.MANDT
  • C_SERVICEORDERISSUEQUERY.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
Problem Category
  • Client
  • Problem Category
Business Transaction Type
  • Business Transaction Type
  • Client
Executing Service Employee
  • Executing Service Employee
  • Client
  • C_SERVICEORDERISSUEQUERY.SERVICEEMPLOYEE == BUT000.PARTNER
  • C_SERVICEORDERISSUEQUERY.MANDT == BUT000.CLIENT
Business Trans. Cat. C_SERVICEORDERISSUEQUERY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Risk
  • Client
Service Team
  • Service Team
  • Client
  • C_SERVICEORDERISSUEQUERY.SERVICETEAM == BUT000.PARTNER
  • C_SERVICEORDERISSUEQUERY.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • C_SERVICEORDERISSUEQUERY.SOLDTOPARTY == BUT000.PARTNER
  • C_SERVICEORDERISSUEQUERY.MANDT == BUT000.CLIENT
Sold-To Party Country or Region
  • Sold-To Party Country or Region
  • Client
  • C_SERVICEORDERISSUEQUERY.SOLDTOPARTYCOUNTRY == T005.LAND1
  • C_SERVICEORDERISSUEQUERY.MANDT == T005.MANDT
Sold-To Party Region
  • Sold-To Party Country or Region
  • Sold-To Party Region
  • Client
  • C_SERVICEORDERISSUEQUERY.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • C_SERVICEORDERISSUEQUERY.SOLDTOPARTYREGION == T005S.BLAND
  • C_SERVICEORDERISSUEQUERY.MANDT == T005S.MANDT
Currency
  • Currency
  • Client
  • C_SERVICEORDERISSUEQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SERVICEORDERISSUEQUERY.MANDT == TCURC.MANDT