P_ServiceDocItemAvgDuration

Average Duration Of Service Trans. Items | view: PSERVITMAVGDUR | 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
📏 Time Unit for Confirmed Duration (ActualServiceDurationUnit):
ActualServiceDuration Confirmed Duration
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
FuncLocBasedMaterial Material Number MATNR
FuncLocBasedMaterialText null
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • P_SERVICEDOCITEMAVGDURATION.MANDT == TVTW.MANDT
  • P_SERVICEDOCITEMAVGDURATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SERVICEDOCITEMAVGDURATION.MANDT == TSPA.MANDT
  • P_SERVICEDOCITEMAVGDURATION.DIVISION == TSPA.SPART
Equipment Number
  • Equipment Number
  • Client
  • P_SERVICEDOCITEMAVGDURATION.EQUIPMENT == EQUI.EQUNR
  • P_SERVICEDOCITEMAVGDURATION.MANDT == EQUI.MANDT
Material Number
  • Material Number
  • Client
  • P_SERVICEDOCITEMAVGDURATION.PRODUCTID == MARA.MATNR
  • P_SERVICEDOCITEMAVGDURATION.MANDT == MARA.MANDT
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SERVICEDOCITEMAVGDURATION.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATION.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATION.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. P_SERVICEDOCITEMAVGDURATION.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SERVICEDOCITEMAVGDURATION.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATION.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SERVICEDOCITEMAVGDURATION.MANDT == CRMC_PROC_TYPE.CLIENT