C_ServiceDocItemAnalyticsQry

Analytics Query for Srvc Trans. Item | view: CSERVDOCITANAQRY | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMS4D_REFOBJ, EQUI, EQKT, EQUZ, IFLOT, MARA, MAKT, MAKT
Column Name Description
ServiceObjectType FK Business Trans. Cat.
SalesOrganization Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
SalesOffice Sales office
SalesGroup Sales group
ProductExternalID null
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ProductName Description of technical object TEXT40
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
NmbrOfServiceConfItems null
ServiceOrderAvgLeadTimeInHours null
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == TVTW.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SERVICEDOCITEMANALYTICSQRY.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.DIVISION == TSPA.SPART
  • C_SERVICEDOCITEMANALYTICSQRY.ORGUNITDIVISION == TSPA.SPART
Equipment Number
  • Client
  • Equipment Number
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == EQUI.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.EQUIPMENT == EQUI.EQUNR
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == TVTW.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SERVICEDOCITEMANALYTICSQRY.ORGUNITDISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.DIVISION == TSPA.SPART
  • C_SERVICEDOCITEMANALYTICSQRY.ORGUNITDIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == MARA.MANDT
  • C_SERVICEDOCITEMANALYTICSQRY.PRODUCTID == MARA.MATNR
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == CRMC_PROC_TYPE.CLIENT
  • C_SERVICEDOCITEMANALYTICSQRY.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • C_SERVICEDOCITEMANALYTICSQRY.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. C_SERVICEDOCITEMANALYTICSQRY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
  • C_SERVICEDOCITEMANALYTICSQRY.MANDT == CRMC_PROC_TYPE.CLIENT
  • C_SERVICEDOCITEMANALYTICSQRY.SERVICEORDERTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • C_SERVICEDOCITEMANALYTICSQRY.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE