I_ServiceOrderIssueCube

Cube for service order issues | view: ISRVCORDISSUEC | TRAN | 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.
ServiceDocument 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 null
RequestedServiceEndDate null
PlannedServiceStartDate null
PlannedServiceEndDate null
SrvcDocItemSLADueByDate null
ServiceFirstResponseByDate null
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
ServiceDocItemBillingStatus Billing Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
SrvcDocItemTransferStatus Transfer Status Show values
Column Name Description Domain name
ResponseProfile Response Profile CRM_SRV_ESCAL
ServiceProfile Service Profile CRM_SRV_SERWI
ServiceOrganization Service Organization HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ResponsibleEmployeeUserID User ID XUBNAME
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
PlannedServiceStartDateTime Service Planned From Date TZNTSTMPS
PlannedServiceEndDateTime Service Planned To Date TZNTSTMPS
SrvcDocItemSLADueByDateTime Due By TZNTSTMPS
ServiceFirstResponseByDateTime First Response By TZNTSTMPS
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
  • I_SERVICEORDERISSUECUBE.BILLINGBLOCKREASON == TVFS.FAKSP
  • I_SERVICEORDERISSUECUBE.MANDT == TVFS.MANDT
Customer Contact Person
  • Customer Contact Person
  • Client
  • I_SERVICEORDERISSUECUBE.CONTACTPERSON == BUT000.PARTNER
  • I_SERVICEORDERISSUECUBE.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Sold-To Party Country or Region
  • Client
  • I_SERVICEORDERISSUECUBE.COUNTRY == T005.LAND1
  • I_SERVICEORDERISSUECUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_SERVICEORDERISSUECUBE.MANDT == T005.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_SERVICEORDERISSUECUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SERVICEORDERISSUECUBE.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_SERVICEORDERISSUECUBE.DIVISION == TSPA.SPART
  • I_SERVICEORDERISSUECUBE.MANDT == TSPA.MANDT
Industry Sector
  • Client
  • Industry Sector
  • I_SERVICEORDERISSUECUBE.MANDT == T016.MANDT
  • I_SERVICEORDERISSUECUBE.INDUSTRY == T016.BRSCH
Region (State, Province, County)
  • Region (State, Province, County)
  • ?
  • Client
  • I_SERVICEORDERISSUECUBE.REGION == T005S.BLAND
  • I_SERVICEORDERISSUECUBE.[column in domain "LAND1"] == T005S.LAND1
  • I_SERVICEORDERISSUECUBE.MANDT == T005S.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • I_SERVICEORDERISSUECUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SERVICEORDERISSUECUBE.MANDT == BUT000.CLIENT
Cancellation Reason Code
  • Cancellation Reason Code
  • Client
  • I_SERVICEORDERISSUECUBE.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
  • I_SERVICEORDERISSUECUBE.MANDT == TVAG.MANDT
Problem Category
  • Problem Category
  • Client
Business Transaction Type
  • Business Transaction Type
  • Client
Executing Service Employee
  • Executing Service Employee
  • Client
  • I_SERVICEORDERISSUECUBE.SERVICEEMPLOYEE == BUT000.PARTNER
  • I_SERVICEORDERISSUECUBE.MANDT == BUT000.CLIENT
Business Trans. Cat. I_SERVICEORDERISSUECUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Risk
  • Client
Service Team
  • Client
  • Service Team
  • I_SERVICEORDERISSUECUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERISSUECUBE.SERVICETEAM == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • I_SERVICEORDERISSUECUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERISSUECUBE.SOLDTOPARTY == BUT000.PARTNER
Sold-To Party Country or Region
  • Country/Region
  • Sold-To Party Country or Region
  • Client
  • I_SERVICEORDERISSUECUBE.COUNTRY == T005.LAND1
  • I_SERVICEORDERISSUECUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_SERVICEORDERISSUECUBE.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region
  • Sold-To Party Country or Region
  • Client
  • I_SERVICEORDERISSUECUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_SERVICEORDERISSUECUBE.COUNTRY == T005S.LAND1
  • I_SERVICEORDERISSUECUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_SERVICEORDERISSUECUBE.MANDT == T005S.MANDT
Currency
  • Currency
  • Client
  • I_SERVICEORDERISSUECUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SERVICEORDERISSUECUBE.MANDT == TCURC.MANDT