I_ServiceContractCube

Service Contract - Cube | view: ISERVCONTRCUBE | 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 Revenue Amount in Company Code 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
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
BusinessPartnerFullName null
NmbrOfExpiredSrvcContracts null
NmbrOfExpiredSrvcContrCurWeek null
NmbrOfExpiredSrvcContrNextWeek null
NmbrOfExpiredSrvcContrIn2Weeks null
NmbrOfExpiredSrvcContrIn3Weeks null
IsExpired null
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • I_SERVICECONTRACTCUBE.MANDT == TVTW.MANDT
  • I_SERVICECONTRACTCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SERVICECONTRACTCUBE.MANDT == TSPA.MANDT
  • I_SERVICECONTRACTCUBE.DIVISION == TSPA.SPART
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
Business Trans. Cat. I_SERVICECONTRACTCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_SERVICECONTRACTCUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTCUBE.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Country/Region
  • Client
  • I_SERVICECONTRACTCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_SERVICECONTRACTCUBE.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • I_SERVICECONTRACTCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_SERVICECONTRACTCUBE.MANDT == T005S.MANDT
  • I_SERVICECONTRACTCUBE.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • I_SERVICECONTRACTCUBE.MANDT == TCURC.MANDT
  • I_SERVICECONTRACTCUBE.TRANSACTIONCURRENCY == TCURC.WAERS