P_ServiceDocItemFuncLoc

Function location text for service document item | view: PSRVCDOCFUNLOC | 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
ActualServiceDuration Confirmed Duration
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
EquipmentName Description of technical object TEXT40
MaterialName Material Description TEXT40
ProductName Product Description TEXT40
FuncLocBasedMaterial null
FuncLocBasedMaterialText Description of technical object TEXT40
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • P_SERVICEDOCITEMFUNCLOC.MANDT == TVTW.MANDT
  • P_SERVICEDOCITEMFUNCLOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SERVICEDOCITEMFUNCLOC.MANDT == TSPA.MANDT
  • P_SERVICEDOCITEMFUNCLOC.DIVISION == TSPA.SPART
Equipment Number
  • Equipment Number
  • Client
  • P_SERVICEDOCITEMFUNCLOC.EQUIPMENT == EQUI.EQUNR
  • P_SERVICEDOCITEMFUNCLOC.MANDT == EQUI.MANDT
Material Number
  • Material Number
  • Client
  • P_SERVICEDOCITEMFUNCLOC.PRODUCTID == MARA.MATNR
  • P_SERVICEDOCITEMFUNCLOC.MANDT == MARA.MANDT
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client
Business Trans. Cat. P_SERVICEDOCITEMFUNCLOC.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Business Transaction Type
  • Business Transaction Type
  • Client