I_ServiceContractPeriodicCube

Service Contract Cube with Periodic Data | view: ISERVCCONTRPERD | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, FINSC_LEDGER, PROJ, T000, HRRP_FSV_DIR, USR21, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, USR05, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
Column Name Description
💲 Currency Key (Currency):
ServiceDocNetAmount null
TotalSrvcContrValueInDC Total Net Value of Document in Document Currency
AnnualSrvcContrValueInDC null
SrvcContrProfitabilityInDC null
TotalSrvcContrCostAmtInCc null
TotalSrvcContrRevnAmtInCc null
YTDSrvcContrCostInDC null
YTDSrvcContrRevnAmtInDC null
YTDSrvcContrPrftMarginAmtInDC null
Column Name Description
Column Name Description
ServiceContractStartDate Created On
ServiceContractEndDate Changed On
CreationDate Creation Date
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceContractUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractStartDateTime Contract Start date DEC15
ServiceContractEndDateTime Contract End Date DEC15
CalendarQuarter Calendar Quarter NUM1
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
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
BusinessPartnerFullName null
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • I_SERVICECONTRACTPERIODICCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_SERVICECONTRACTPERIODICCUBE.DIVISION == TSPA.SPART
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == TSPA.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • I_SERVICECONTRACTPERIODICCUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == BUT000.CLIENT
Business Transaction Type
  • Client
  • Business Transaction Type
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_SERVICECONTRACTPERIODICCUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. I_SERVICECONTRACTPERIODICCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • I_SERVICECONTRACTPERIODICCUBE.SOLDTOPARTY == BUT000.PARTNER
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == T005.MANDT
  • I_SERVICECONTRACTPERIODICCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • I_SERVICECONTRACTPERIODICCUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == T005S.MANDT
  • I_SERVICECONTRACTPERIODICCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Currency
  • Client
  • I_SERVICECONTRACTPERIODICCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SERVICECONTRACTPERIODICCUBE.MANDT == TCURC.MANDT