I_ServiceContractCube_2

Service Contract - Cube | view: ISRVCCONTRCUBE2 | TRAN | Extraction: Not supported | Component: S4CRM: Analytics

Tables used: SCAL_TT_DATE, CRMS4D_SERV_H

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (3)
Other (18)
🔗 Relations (12)

Column Name	Description
ServiceObjectType FK	Business Trans. Cat.
ServiceContract	Transaction ID

Column Name	Description
💲 Currency Key (DisplayCurrency):
ServiceDocNetAmount	null

Column Name	Description

Column Name	Description
ServiceContractStartDate	Created On
ServiceContractEndDate	Changed On
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
ServiceDocumentDescription	Transaction Description	CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder	Reference Solution Order ID	CRM_OBJECT_ID
PurchaseOrderByCustomer	Sold-To Party's External Reference Number
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

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