P_ServiceDocItemAvgDuraTime

Service Item Avg Duration Time Calc | view: PSERVITMAVGDURTM | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
SalesOrganization Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
SalesOffice Sales office
SalesGroup Sales group
Column Name Description
Column Name Description
TotalOfActualSrvcDurnInHours null
Column Name Description
Column Name Description
Column Name Description Domain name
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
FunctionalLocation Functional Location TPLNR
Material Material Number MATNR
ProductExternalID null
ProductName Description of technical object TEXT40
NmbrOfServiceConfItems null
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • P_SERVICEDOCITEMAVGDURATIME.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • P_SERVICEDOCITEMAVGDURATIME.DIVISION == TSPA.SPART
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == TSPA.MANDT
Equipment Number
  • Client
  • Equipment Number
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == EQUI.MANDT
  • P_SERVICEDOCITEMAVGDURATIME.EQUIPMENT == EQUI.EQUNR
Material Number
  • Client
  • Material Number
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == MARA.MANDT
  • P_SERVICEDOCITEMAVGDURATIME.PRODUCTID == MARA.MATNR
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICEDOCITEMAVGDURATIME.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATIME.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. P_SERVICEDOCITEMAVGDURATIME.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • P_SERVICEDOCITEMAVGDURATIME.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SERVICEDOCITEMAVGDURATIME.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATIME.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE