P_ServiceContractDataCalc

Service Contract Cube | view: PSRVCCONTRCALC | 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
CalendarDate Calendar Date
ShiftedCalendarDate null
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_SERVICECONTRACTDATACALC.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACALC.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • P_SERVICECONTRACTDATACALC.MANDT == TVTW.MANDT
  • P_SERVICECONTRACTDATACALC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SERVICECONTRACTDATACALC.MANDT == TSPA.MANDT
  • P_SERVICECONTRACTDATACALC.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_SERVICECONTRACTDATACALC.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACALC.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICECONTRACTDATACALC.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICECONTRACTDATACALC.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACALC.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICECONTRACTDATACALC.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICECONTRACTDATACALC.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTDATACALC.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. P_SERVICECONTRACTDATACALC.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Client
  • Service Team
  • P_SERVICECONTRACTDATACALC.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACALC.SERVICETEAM == BUT000.PARTNER
Ship-To Party
  • Client
  • Ship-To Party
  • P_SERVICECONTRACTDATACALC.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACALC.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • P_SERVICECONTRACTDATACALC.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTDATACALC.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • P_SERVICECONTRACTDATACALC.MANDT == T005.MANDT
  • P_SERVICECONTRACTDATACALC.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • P_SERVICECONTRACTDATACALC.MANDT == T005S.MANDT
  • P_SERVICECONTRACTDATACALC.SOLDTOPARTYREGION == T005S.BLAND
  • P_SERVICECONTRACTDATACALC.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Client
  • Currency
  • P_SERVICECONTRACTDATACALC.MANDT == TCURC.MANDT
  • P_SERVICECONTRACTDATACALC.TRANSACTIONCURRENCY == TCURC.WAERS