I_ServiceContractItemCube

Service Contract Item - Cube | view: ISRVCCONTRITMCB | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
Column Name Description
💲 Currency Key (DisplayCurrency):
ServiceDocumentItemNetAmount null
Column Name Description
Column Name Description
ServiceContractItemStartDate null
ServiceContractItemEndDate null
Column Name Description
ServiceContractItemStatus Life Cycle Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceContractItemDescription Product Description CRM_PRSHTEXT40_DB
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
PurchaseOrderByCustomer Sold-To Party's External Reference Number
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceOrganization Service Organization HROBJEC_14
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
NrOfExprgSrvcContrItmInCurMnth null
NrOfExprgSrvcContrItmNextMonth null
NrOfExprgSrvcContrItmIn2Months null
NrOfExprgSrvcContrItmIn3Months null
MonthsUntilExpiration null
Master Data Relations Join Conditions
Customer Contact Person
  • Customer Contact Person
  • Client
  • I_SERVICECONTRACTITEMCUBE.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
  • I_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
Distribution Channel
  • Distribution Channel
  • Client
  • I_SERVICECONTRACTITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SERVICECONTRACTITEMCUBE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_SERVICECONTRACTITEMCUBE.MANDT == TSPA.MANDT
  • I_SERVICECONTRACTITEMCUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • I_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTITEMCUBE.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Business Transaction Type
  • Client
Business Trans. Cat. I_SERVICECONTRACTITEMCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Client
  • Ship-To Party
  • I_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICECONTRACTITEMCUBE.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Sold-To Party
  • Client
  • I_SERVICECONTRACTITEMCUBE.SOLDTOPARTY == BUT000.PARTNER
  • I_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
Currency
  • Currency
  • Client
  • I_SERVICECONTRACTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SERVICECONTRACTITEMCUBE.MANDT == TCURC.MANDT