I_ServiceContractFinDataCube

Service Contract Financial Data Cube | view: ISERVCONTRFINCBE | 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

🔑 Keys (2)
💰 Amounts (9)
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (22)
🔗 Relations (9)

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
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
ServiceOrganization	Service Organization	HROBJEC_14
CalendarYear	Calendar Year	NUM4
CalendarWeek	Calendar Week	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarMonth	Calendar Month	NUM2
NmbrOfExpiredSrvcContracts	null
NmbrOfExpiredSrvcContrCurWeek	null
NmbrOfExpiredSrvcContrNextWeek	null
NmbrOfExpiredSrvcContrIn2Weeks	null
NmbrOfExpiredSrvcContrIn3Weeks	null
IsExpired	null

Master Data Relations	Join Conditions
Distribution Channel Client Distribution Channel	`I_SERVICECONTRACTFINDATACUBE.MANDT == TVTW.MANDT` `I_SERVICECONTRACTFINDATACUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Division Client	`I_SERVICECONTRACTFINDATACUBE.DIVISION == TSPA.SPART` `I_SERVICECONTRACTFINDATACUBE.MANDT == TSPA.MANDT`
Employee Responsible Client Employee Responsible	`I_SERVICECONTRACTFINDATACUBE.MANDT == BUT000.CLIENT` `I_SERVICECONTRACTFINDATACUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER`
Business Transaction Type Business Transaction Type Client	`I_SERVICECONTRACTFINDATACUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE` `I_SERVICECONTRACTFINDATACUBE.MANDT == CRMC_PROC_TYPE.CLIENT`
Business Trans. Cat.	`I_SERVICECONTRACTFINDATACUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Sold-To Party Sold-To Party Client	`I_SERVICECONTRACTFINDATACUBE.SOLDTOPARTY == BUT000.PARTNER` `I_SERVICECONTRACTFINDATACUBE.MANDT == BUT000.CLIENT`
Country/Region Client Country/Region	`I_SERVICECONTRACTFINDATACUBE.MANDT == T005.MANDT` `I_SERVICECONTRACTFINDATACUBE.SOLDTOPARTYCOUNTRY == T005.LAND1`
Region (State, Province, County) Region (State, Province, County) Client Country/Region	`I_SERVICECONTRACTFINDATACUBE.SOLDTOPARTYREGION == T005S.BLAND` `I_SERVICECONTRACTFINDATACUBE.MANDT == T005S.MANDT` `I_SERVICECONTRACTFINDATACUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1`
Currency Currency Client	`I_SERVICECONTRACTFINDATACUBE.TRANSACTIONCURRENCY == TCURC.WAERS` `I_SERVICECONTRACTFINDATACUBE.MANDT == TCURC.MANDT`