C_SrvcOrdItmWthSrvcContrQ

Service Orders - Flexible Analysis | view: CSRVORDWTCONTRQ | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMS4D_REFOBJ, EQUI, EQUZ, IFLOT
Column Name Description
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 null (DisplayCurrency):
ServiceContractItemNetAmount null
SrvcOrdItmWthContrRefNetAmt null
SrvcOrdItmWthoutContrRefNetAmt null
SrvcOrdItmWthContrRefBlldAmt null
SrvcOrdWthoutContrRefBlldAmt null
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceOrderItemQuantityUnit):
ServiceOrderItemQuantity CRM: Order Quantity
Column Name Description
ServiceContractItemStartDate null
ServiceContractItemEndDate null
Column Name Description
ServiceOrderItemStatus Life Cycle Status Show values
ServiceContrItemBillingStatus Billing Status Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
Column Name Description Domain name
ServiceOrderItemProduct Product Number MATNR
ServiceContract Transaction ID CRM_OBJECT_ID
ServiceContractItem Shortened Item Number in Document CRMS4_NUMBER_INT
ServiceContractItemProduct Product Number MATNR
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
NmbrOfFUPServiceOrderItems null
NrOfSrvcOrdItmsWthoutContrRef null
ServiceContractItemIsActive null
FunctionalLocation Functional Location TPLNR
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.DIVISION == TSPA.SPART
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == TSPA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.EQUIPMENT == EQUI.EQUNR
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == EQUI.MANDT
Equipment category
  • Client
  • Equipment category
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T370T.MANDT
  • C_SRVCORDITMWTHSRVCCONTRQ.EQUIPMENTCATEGORY == T370T.EQTYP
Functional location category
  • Client
  • Functional location category
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T370F.MANDT
  • C_SRVCORDITMWTHSRVCCONTRQ.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
Industry Sector
  • Industry Sector
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.INDUSTRY == T016.BRSCH
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T016.MANDT
Material Number
  • Client
  • Material Number
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == MARA.MANDT
  • C_SRVCORDITMWTHSRVCCONTRQ.MATERIAL == MARA.MATNR
Employee Responsible
  • Employee Responsible
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == BUT000.CLIENT
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T006.MANDT
  • C_SRVCORDITMWTHSRVCCONTRQ.SERVICEORDERITEMQUANTITYUNIT == T006.MSEHI
Sold-To Party
  • Sold-To Party
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.SOLDTOPARTY == BUT000.PARTNER
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.SOLDTOPARTYCOUNTRY == T005.LAND1
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.SOLDTOPARTYREGION == T005S.BLAND
  • C_SRVCORDITMWTHSRVCCONTRQ.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T005S.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • C_SRVCORDITMWTHSRVCCONTRQ.TECHNICALOBJECTTYPE == T370K.EQART
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == T370K.MANDT
Currency
  • Client
  • Currency
  • C_SRVCORDITMWTHSRVCCONTRQ.MANDT == TCURC.MANDT
  • C_SRVCORDITMWTHSRVCCONTRQ.TRANSACTIONCURRENCY == TCURC.WAERS