P_SRVCTRANSACTIONISSUETIMESTMP

View for items with issue C001/C001 - No Confirmation | view: PSRVCISSITSTMP | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I
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
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
RefInHouseRepairIsExisting Reference to In-House Repair Exists Show values
Column Name Description Domain name
ServiceOrganization Service Organization HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
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
ResponseProfile Response Profile CRM_SRV_ESCAL
ServiceProfile Service Profile CRM_SRV_SERWI
ServiceFirstResponseByDateTime First Response By TZNTSTMPS
CurrentDate null
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
Master Data Relations Join Conditions
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • P_SRVCTRANSACTIONISSUETIMESTMP.BILLINGBLOCKREASON == TVFS.FAKSP
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == TVFS.MANDT
Customer Contact Person
  • Client
  • Customer Contact Person
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.CONTACTPERSON == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • Country/Region
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == T005.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.COUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUETIMESTMP.SOLDTOPARTYCOUNTRY == T005.LAND1
Distribution Channel
  • Distribution Channel
  • Client
  • P_SRVCTRANSACTIONISSUETIMESTMP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == TSPA.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.DIVISION == TSPA.SPART
Industry Sector
  • Client
  • Industry Sector
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == T016.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.INDUSTRY == T016.BRSCH
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == T005S.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.REGION == T005S.BLAND
  • P_SRVCTRANSACTIONISSUETIMESTMP.[column in domain "LAND1"] == T005S.LAND1
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == TVAG.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
Problem Category
  • Client
  • Problem Category
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == CRMC_SRQM_PRBCAT.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SERVICEDOCUMENTPROBLEMCATEGORY == CRMC_SRQM_PRBCAT.PROBLEM_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Executing Service Employee
  • Client
  • Executing Service Employee
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SRVCTRANSACTIONISSUETIMESTMP.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Client
  • Risk
Service Team
  • Client
  • Service Team
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SERVICETEAM == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUETIMESTMP.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • Country/Region
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == T005.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.COUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUETIMESTMP.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region
  • Country/Region
  • Region (State, Province, County)
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == T005S.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.COUNTRY == T005S.LAND1
  • P_SRVCTRANSACTIONISSUETIMESTMP.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • P_SRVCTRANSACTIONISSUETIMESTMP.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • P_SRVCTRANSACTIONISSUETIMESTMP.MANDT == TCURC.MANDT
  • P_SRVCTRANSACTIONISSUETIMESTMP.TRANSACTIONCURRENCY == TCURC.WAERS