P_ServiceContractDataCube

Service Contract Cube | view: PSRVCCONTRCUBE | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
Column Name Description
Column Name Description
ServiceContractStartDate Created On
ServiceContractEndDate Changed On
ShiftedCalendarDate null
FirstDayOfMonthDate First Day of Month Date
LastDayOfMonthDate null
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
ServiceContractStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceContractUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ServiceContractStartDateTime Contract Start date DEC15
ServiceContractEndDateTime Contract End Date DEC15
NmbrOfExpiredSrvcContracts null
NmbrOfExpiredSrvcContrCurWeek null
NmbrOfExpiredSrvcContrNextWeek null
NmbrOfExpiredSrvcContrIn2Weeks null
NmbrOfExpiredSrvcContrIn3Weeks null
IsExpired null
NumberOfDays null
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • P_SERVICECONTRACTDATACUBE.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACUBE.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • P_SERVICECONTRACTDATACUBE.MANDT == TVTW.MANDT
  • P_SERVICECONTRACTDATACUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SERVICECONTRACTDATACUBE.MANDT == TSPA.MANDT
  • P_SERVICECONTRACTDATACUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_SERVICECONTRACTDATACUBE.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SERVICECONTRACTDATACUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACUBE.MANDT == CRMC_PROC_TYPE.CLIENT
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SERVICECONTRACTDATACUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACUBE.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. P_SERVICECONTRACTDATACUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Client
  • Service Team
  • P_SERVICECONTRACTDATACUBE.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACUBE.SERVICETEAM == BUT000.PARTNER
Ship-To Party
  • Ship-To Party
  • Client
  • P_SERVICECONTRACTDATACUBE.SHIPTOPARTY == BUT000.PARTNER
  • P_SERVICECONTRACTDATACUBE.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • P_SERVICECONTRACTDATACUBE.SOLDTOPARTY == BUT000.PARTNER
  • P_SERVICECONTRACTDATACUBE.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • P_SERVICECONTRACTDATACUBE.MANDT == T005.MANDT
  • P_SERVICECONTRACTDATACUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • P_SERVICECONTRACTDATACUBE.MANDT == T005S.MANDT
  • P_SERVICECONTRACTDATACUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • P_SERVICECONTRACTDATACUBE.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • P_SERVICECONTRACTDATACUBE.MANDT == TCURC.MANDT
  • P_SERVICECONTRACTDATACUBE.TRANSACTIONCURRENCY == TCURC.WAERS