P_ExprgSrvcContrItmChkRenew

To check whether an item is renewed or not | view: PEXPSRVCONTRITCR | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_I
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
Column Name Description
Column Name Description
ServiceContractItemEndDate null
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
NmbrOfValdtyDaysOfSrvcContr Days Before Expiry of Quotation INT4
ServiceContractItemIsRenewed null
SalesOrganization Sales Organization VKORG
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOffice Sales office VKBUR
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroup Sales group VKGRP
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Product Product Number MATNR
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • P_EXPRGSRVCCONTRITMCHKRENEW.MANDT == TVTW.MANDT
  • P_EXPRGSRVCCONTRITMCHKRENEW.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_EXPRGSRVCCONTRITMCHKRENEW.MANDT == TSPA.MANDT
  • P_EXPRGSRVCCONTRITMCHKRENEW.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_EXPRGSRVCCONTRITMCHKRENEW.MANDT == BUT000.CLIENT
  • P_EXPRGSRVCCONTRITMCHKRENEW.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. P_EXPRGSRVCCONTRITMCHKRENEW.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • P_EXPRGSRVCCONTRITMCHKRENEW.MANDT == BUT000.CLIENT
  • P_EXPRGSRVCCONTRITMCHKRENEW.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Currency
  • Client
  • P_EXPRGSRVCCONTRITMCHKRENEW.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_EXPRGSRVCCONTRITMCHKRENEW.MANDT == TCURC.MANDT