C_ExpiringSrvcContrItmDetails

Expiring Service Contract Item Details | view: CEXPSRVCCONTRITM | 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
ExprgSrvcContrItemNetAmount null
Column Name Description
Column Name Description
ServiceContractItemStartDate null
ServiceContractItemEndDate null
Column Name Description
ServiceDocumentItemIsOpen Status "Open" Show values
Issue Issue Show values
Column Name Description Domain name
ServiceContractItemDescription Product Description
ServiceContractItemStatus Life Cycle Status
ServiceContractStatusName Short Text for Fixed Values DDTEXT
SoldToPartyName null
ShipToPartyName null
RefBusinessSolutionOrder Reference Solution Order ID
NrOfExprgSrvcContrItmInCurMnth null
NrOfExprgSrvcContrItmNextMonth null
NrOfExprgSrvcContrItmIn2Months null
NrOfExprgSrvcContrItmIn3Months null
MonthsUntilExpiration null
NrOfExprgServiceContractItems null
IssueName Short Text for Fixed Values
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesOfficeName Sales Office Description TEXT20
SalesGroup Sales group VKGRP
SalesGroupName Sales Group Description TEXT20
ServiceOrganization Service Organization HROBJEC_14
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRITMDETAILS.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == TVTW.MANDT
  • C_EXPIRINGSRVCCONTRITMDETAILS.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_EXPIRINGSRVCCONTRITMDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == TSPA.MANDT
  • C_EXPIRINGSRVCCONTRITMDETAILS.ORGUNITDIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRITMDETAILS.DIVISION == TSPA.SPART
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == TVTW.MANDT
  • C_EXPIRINGSRVCCONTRITMDETAILS.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_EXPIRINGSRVCCONTRITMDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == TSPA.MANDT
  • C_EXPIRINGSRVCCONTRITMDETAILS.ORGUNITDIVISION == TSPA.SPART
  • C_EXPIRINGSRVCCONTRITMDETAILS.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • C_EXPIRINGSRVCCONTRITMDETAILS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == BUT000.CLIENT
Business Transaction Type
  • Client
  • Business Transaction Type
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == CRMC_PROC_TYPE.CLIENT
  • C_EXPIRINGSRVCCONTRITMDETAILS.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. C_EXPIRINGSRVCCONTRITMDETAILS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Client
  • Ship-To Party
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRITMDETAILS.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • C_EXPIRINGSRVCCONTRITMDETAILS.MANDT == BUT000.CLIENT
  • C_EXPIRINGSRVCCONTRITMDETAILS.SOLDTOPARTY == BUT000.PARTNER