P_SrvcTransactionIssueItemC004

View for items with issue C001/C004 - No Final Confirmation | view: PSRVCISSITMC004 | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI
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
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
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
  • Client
  • Business Partner: Billing Block Reason
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == TVFS.MANDT
  • P_SRVCTRANSACTIONISSUEITEMC004.BILLINGBLOCKREASON == TVFS.FAKSP
Customer Contact Person
  • Client
  • Customer Contact Person
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUEITEMC004.CONTACTPERSON == BUT000.PARTNER
Country/Region
  • Country/Region
  • Country/Region
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.COUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.SOLDTOPARTYCOUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == T005.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == TVTW.MANDT
  • P_SRVCTRANSACTIONISSUEITEMC004.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.DIVISION == TSPA.SPART
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == TSPA.MANDT
Industry Sector
  • Industry Sector
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.INDUSTRY == T016.BRSCH
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == T016.MANDT
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • P_SRVCTRANSACTIONISSUEITEMC004.[column in domain "LAND1"] == T005S.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == T005S.MANDT
  • P_SRVCTRANSACTIONISSUEITEMC004.REGION == T005S.BLAND
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUEITEMC004.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Cancellation Reason Code
  • Cancellation Reason Code
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == TVAG.MANDT
Problem Category
  • Client
  • Problem Category
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == CRMC_SRQM_PRBCAT.CLIENT
  • P_SRVCTRANSACTIONISSUEITEMC004.SERVICEDOCUMENTPROBLEMCATEGORY == CRMC_SRQM_PRBCAT.PROBLEM_CATEGORY
Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == CRMC_PROC_TYPE.CLIENT
Executing Service Employee
  • Client
  • Executing Service Employee
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUEITEMC004.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SRVCTRANSACTIONISSUEITEMC004.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Client
  • Risk
Service Team
  • Client
  • Service Team
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == BUT000.CLIENT
  • P_SRVCTRANSACTIONISSUEITEMC004.SERVICETEAM == BUT000.PARTNER
Sold-To Party
  • Sold-To Party
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.SOLDTOPARTY == BUT000.PARTNER
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Country/Region
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.COUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.SOLDTOPARTYCOUNTRY == T005.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Country/Region
  • Region (State, Province, County)
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.COUNTRY == T005S.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • P_SRVCTRANSACTIONISSUEITEMC004.SOLDTOPARTYREGION == T005S.BLAND
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == T005S.MANDT
Currency
  • Currency
  • Client
  • P_SRVCTRANSACTIONISSUEITEMC004.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SRVCTRANSACTIONISSUEITEMC004.MANDT == TCURC.MANDT