I_ServiceContractIssueCube

Cube For Service Contract Issues | view: ISRVCONTRISSUEC | TRAN | 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 null
ServiceContractItemEndDate null
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
ServiceContractUUID GUID of a CRM Order Object SYSUUID
ServiceContrItemStartDateTime Contract Start date DEC15
ServiceContrItemEndDateTime Contract End Date DEC15
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
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
  • Client
  • Customer Contact Person
  • I_SERVICECONTRACTISSUECUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTISSUECUBE.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_SERVICECONTRACTISSUECUBE.MANDT == TVTW.MANDT
  • I_SERVICECONTRACTISSUECUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SERVICECONTRACTISSUECUBE.MANDT == TSPA.MANDT
  • I_SERVICECONTRACTISSUECUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • I_SERVICECONTRACTISSUECUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTISSUECUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
  • I_SERVICECONTRACTISSUECUBE.MANDT == CRMC_ITEM_TYPE.CLIENT
  • I_SERVICECONTRACTISSUECUBE.SERVICECONTRACTITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • I_SERVICECONTRACTISSUECUBE.MANDT == TVAG.MANDT
  • I_SERVICECONTRACTISSUECUBE.SERVICECONTRACTITMCANCLNREASON == TVAG.ABGRU
Business Transaction Type
  • Client
  • Business Transaction Type
Sold-To Party
  • Client
  • Sold-To Party
  • I_SERVICECONTRACTISSUECUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTISSUECUBE.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • I_SERVICECONTRACTISSUECUBE.MANDT == T005.MANDT
  • I_SERVICECONTRACTISSUECUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • I_SERVICECONTRACTISSUECUBE.MANDT == T005S.MANDT
  • I_SERVICECONTRACTISSUECUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_SERVICECONTRACTISSUECUBE.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • I_SERVICECONTRACTISSUECUBE.MANDT == TCURC.MANDT
  • I_SERVICECONTRACTISSUECUBE.TRANSACTIONCURRENCY == TCURC.WAERS