C_ExpiringSrvcContrDetails

Expiring Service Contract Details | view: CEXPSRVCCONTR | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
Column Name Description
💲 Currency Key (DisplayCurrency):
ServiceDocNetAmount null
ExprgSrvcContrNetAmount null
Column Name Description
Column Name Description
ServiceContractStartDate null
ServiceContractEndDate null
Column Name Description
ServiceContractStatus Life Cycle Status Show values
ServiceDocumentStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractStatusName Short Text for Fixed Values DDTEXT
SoldToPartyName null
ShipToPartyName null
RefBusinessSolutionOrder Reference Solution Order ID
NmbrOfExpiredSrvcContracts null
NmbrOfExpiredSrvcContrCurWeek null
NmbrOfExpiredSrvcContrNextWeek null
NmbrOfExpiredSrvcContrIn2Weeks null
IsExpired null
NmbrOfServiceContracts null
Issue Values for Domains: Single Value/Lower Limit DOMVAL
IssueName Short Text for Fixed Values DDTEXT
SalesOrganization Sales Organization VKORG
SalesOrganizationName Sales Organization Description TEXT20
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SalesOffice Sales office VKBUR
SalesOfficeName Sales Office Description TEXT20
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroup Sales group VKGRP
SalesGroupName Sales Group Description TEXT20
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Master Data Relations Join Conditions
Customer Contact Person
  • Customer Contact Person
  • Client
  • C_EXPIRINGSRVCCONTRDETAILS.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == BUT000.CLIENT
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == TVTW.MANDT
  • C_EXPIRINGSRVCCONTRDETAILS.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_EXPIRINGSRVCCONTRDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Division
  • Client
  • C_EXPIRINGSRVCCONTRDETAILS.DIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRDETAILS.ORGUNITDIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == TSPA.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == TVTW.MANDT
  • C_EXPIRINGSRVCCONTRDETAILS.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_EXPIRINGSRVCCONTRDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Division
  • Client
  • C_EXPIRINGSRVCCONTRDETAILS.DIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRDETAILS.ORGUNITDIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == TSPA.MANDT
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRDETAILS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_EXPIRINGSRVCCONTRDETAILS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRDETAILS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_EXPIRINGSRVCCONTRDETAILS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. C_EXPIRINGSRVCCONTRDETAILS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Ship-To Party
  • Client
  • C_EXPIRINGSRVCCONTRDETAILS.SHIPTOPARTY == BUT000.PARTNER
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • C_EXPIRINGSRVCCONTRDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRDETAILS.SOLDTOPARTY == BUT000.PARTNER