C_ServiceContractIssueQry

Analytical Query For Service Contract Issues | view: CSRVCCONTRISSQRY | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType Business Trans. Cat.
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
CustMgmtIssue Issue in Service Transaction Show values
BillingRequestItem Billing Request Item No
Column Name Description
💲 Currency (TransactionCurrency):
ServiceContractItemNetAmount Net Value
ServiceContractItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 UOM for Auto Renewal Period (SrvcContrItemRnwlDurationUnit):
SrvcContrItemRnwlDuration Unit for Auto Renewal Period
📏 UOM for Contract Extension (SrvcContrItemExtnDurationUnit):
SrvcContrItemExtensionDuration Unit for Contract Extension
Column Name Description
ServiceContractItemStartDate Start Date of Service Contract Item
ServiceContractItemEndDate End Date of Service Contract Item
BillgReqItemBillingDate Created On
Column Name Description
CustMgmtIssue Issue in Service Transaction Show values
ServiceContractItemStatus Life Cycle Status Show values
ServiceContractItemHasError Error Status Show values
ServiceContractItemIsReleased Release Status Show values
ServiceContractItemIsCanceled Cancellation Status Show values
ServiceDocItemBillingStatus Billing Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
BillgReqItemBillingStatus Settlement Status of Billing Request Line 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
BillingBlockReason Business Partner: Billing Block Reason FAKSP
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
Customer Contact Person
  • Customer Contact Person
  • Client
  • C_SERVICECONTRACTISSUEQRY.CONTACTPERSON == BUT000.PARTNER
  • C_SERVICECONTRACTISSUEQRY.MANDT == BUT000.CLIENT
Distribution Channel
  • Client
  • Distribution Channel
  • C_SERVICECONTRACTISSUEQRY.MANDT == TVTW.MANDT
  • C_SERVICECONTRACTISSUEQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SERVICECONTRACTISSUEQRY.MANDT == TSPA.MANDT
  • C_SERVICECONTRACTISSUEQRY.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • C_SERVICECONTRACTISSUEQRY.MANDT == BUT000.CLIENT
  • C_SERVICECONTRACTISSUEQRY.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • C_SERVICECONTRACTISSUEQRY.MANDT == TVAG.MANDT
  • C_SERVICECONTRACTISSUEQRY.SERVICECONTRACTITMCANCLNREASON == TVAG.ABGRU
Business Transaction Type
  • Client
  • Business Transaction Type
Sold-To Party
  • Client
  • Sold-To Party
  • C_SERVICECONTRACTISSUEQRY.MANDT == BUT000.CLIENT
  • C_SERVICECONTRACTISSUEQRY.SOLDTOPARTY == BUT000.PARTNER
Sold-To Party Country or Region
  • Client
  • Sold-To Party Country or Region
  • C_SERVICECONTRACTISSUEQRY.MANDT == T005.MANDT
  • C_SERVICECONTRACTISSUEQRY.SOLDTOPARTYCOUNTRY == T005.LAND1
Sold-To Party Region
  • Client
  • Sold-To Party Country or Region
  • Sold-To Party Region
  • C_SERVICECONTRACTISSUEQRY.MANDT == T005S.MANDT
  • C_SERVICECONTRACTISSUEQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • C_SERVICECONTRACTISSUEQRY.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • C_SERVICECONTRACTISSUEQRY.MANDT == TCURC.MANDT
  • C_SERVICECONTRACTISSUEQRY.TRANSACTIONCURRENCY == TCURC.WAERS