I_SrvcOrdPlndEndDateSituation

Planned End Date Is After Due Date | view: ISRVPLDSIT | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_I, USR21, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
ServiceDocumentItemUUID GUID of a CRM Order Object
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ServiceDocItemCreatedByUser User that Created the Transaction UNAME
SrvcDocItemSLADueByDateTime Due By TZNTSTMPS
PlannedServiceEndDateTime Service Planned To Date TZNTSTMPS
NrOfDaysAftSrvcOrdItmDueDate null
SalesGroup Sales group VKGRP
SalesGroupOrgUnitID Sales Group HROBJEC_14
SalesOffice Sales office VKBUR
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == TVTW.MANDT
  • I_SRVCORDPLNDENDDATESITUATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == TSPA.MANDT
  • I_SRVCORDPLNDENDDATESITUATION.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • I_SRVCORDPLNDENDDATESITUATION.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == BUT000.CLIENT
Address key assignment to users
  • User ID
  • Client
  • I_SRVCORDPLNDENDDATESITUATION.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == USR02.MANDT
Item Category
  • Client
  • Item Category
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == CRMC_ITEM_TYPE.CLIENT
  • I_SRVCORDPLNDENDDATESITUATION.SERVICEDOCITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE
Business Transaction Type
  • Business Transaction Type
  • Client
  • I_SRVCORDPLNDENDDATESITUATION.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_SRVCORDPLNDENDDATESITUATION.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. I_SRVCORDPLNDENDDATESITUATION.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY