P_ServiceContractItemCube

Helper view for Service Contract Item Cube | view: PSRVCONTRIEMCUBE | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
Column Name Description
Column Name Description
ServiceContractItemStartDate null
ServiceContractItemEndDate null
Column Name Description
ServiceContractStatus Life Cycle Status Show values
ServiceContractItemStatus Life Cycle Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceContractItemUUID GUID of a CRM Order Object SYSUUID
ServiceContractItemCharUUID 32 Character CRM Object GUID (Converted)
ServiceContractItemDescription Product Description CRM_PRSHTEXT40_DB
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
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
NrOfExprgServiceContractItems null
NrOfExprgSrvcContrItmInCurMnth null
NrOfExprgSrvcContrItmNextMonth null
NrOfExprgSrvcContrItmIn2Months null
NrOfExprgSrvcContrItmIn3Months null
MonthsUntilExpiration null
Master Data Relations Join Conditions
Customer Contact Person
  • Customer Contact Person
  • Client
  • P_SERVICECONTRACTITEMCUBE.CONTACTPERSON == BUT000.PARTNER
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
Distribution Channel
  • Client
  • Distribution Channel
  • P_SERVICECONTRACTITEMCUBE.MANDT == TVTW.MANDT
  • P_SERVICECONTRACTITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SERVICECONTRACTITEMCUBE.MANDT == TSPA.MANDT
  • P_SERVICECONTRACTITEMCUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • P_SERVICECONTRACTITEMCUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
CRM Item Object Type P_SERVICECONTRACTITEMCUBE.SERVICECONTRACTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICECONTRACTITEMCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICECONTRACTITEMCUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTITEMCUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICECONTRACTITEMCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICECONTRACTITEMCUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICECONTRACTITEMCUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Executing Service Employee
  • Client
  • Executing Service Employee
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTITEMCUBE.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SERVICECONTRACTITEMCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Service Team
  • Client
  • P_SERVICECONTRACTITEMCUBE.SERVICETEAM == BUT000.PARTNER
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
Ship-To Party
  • Ship-To Party
  • Client
  • P_SERVICECONTRACTITEMCUBE.SHIPTOPARTY == BUT000.PARTNER
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • P_SERVICECONTRACTITEMCUBE.MANDT == BUT000.CLIENT
  • P_SERVICECONTRACTITEMCUBE.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • P_SERVICECONTRACTITEMCUBE.MANDT == TCURC.MANDT
  • P_SERVICECONTRACTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS