C_SitnSrvcContrExpiryDetails

Situation handling for contracts | view: CSTINSRVCEXP | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceContract Transaction ID
Column Name Description
💲 Currency (TransactionCurrency):
ExprgSrvcContrNetAmount null
Column Name Description
Column Name Description
ServiceContractEndDate Changed On
Column Name Description
Column Name Description Domain name
ServiceContractUUID GUID of a CRM Order Object SYSUUID
ServiceContractCombinedKey Situation Handling Combined Keys CHAR21
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
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
SrvcContrIsAlertEnabled null
ServiceDocumentItem null
NrOfValdtyDaysOfExprgSrvcContr null
NmbrOfValdtyDaysOfSrvcContr Days Before Expiry of Quotation INT4
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • C_SITNSRVCCONTREXPIRYDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == TSPA.MANDT
  • C_SITNSRVCCONTREXPIRYDETAILS.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • C_SITNSRVCCONTREXPIRYDETAILS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == BUT000.CLIENT
Address key assignment to users
  • Sales Employee User ID
  • Client
  • C_SITNSRVCCONTREXPIRYDETAILS.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == USR02.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
  • C_SITNSRVCCONTREXPIRYDETAILS.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. C_SITNSRVCCONTREXPIRYDETAILS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Client
  • Service Team
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == BUT000.CLIENT
  • C_SITNSRVCCONTREXPIRYDETAILS.SERVICETEAM == BUT000.PARTNER
Currency
  • Currency
  • Client
  • C_SITNSRVCCONTREXPIRYDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SITNSRVCCONTREXPIRYDETAILS.MANDT == TCURC.MANDT