I_SrvcOrdItmWthSrvcContrCube

SrvcOrd Itm with SrvcContr - Cube | view: ISRVORDWTCONTR | TRAN | 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
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceContractItemNetAmount Net Value
SrvcOrdItmWthContrRefNetAmt Net Value
SrvcOrdItmWthoutContrRefNetAmt Net Value
SrvcOrdItmWthContrRefBlldAmt Invoice Value
SrvcOrdWthoutContrRefBlldAmt Invoice Value
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceOrderItemQuantityUnit):
ServiceOrderItemQuantity CRM: Order Quantity
Column Name Description
ServiceContractItemStartDate null
ServiceContractItemEndDate null
ServiceDocItemCreationDate Created On
Column Name Description
ServiceDocumentItemIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceOrderDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceOrderItemProduct Product Number
ServiceOrderItemStatus Life Cycle Status
ServiceContract Transaction ID
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractItem Shortened Item Number in Document
ServiceContractItemProduct Product Number
ServiceContrItemBillingStatus Billing Status
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
PurchaseOrderByCustomer Sold-To Party's External Reference Number
NmbrOfFUPServiceOrderItems null
NrOfSrvcOrdItmsWthoutContrRef null
ServiceContractItemIsActive null
FunctionalLocation Functional Location TPLNR
ServiceReferenceObjectType Object Type for Reference Object in Subject Set
SrvcOrdCreationQuarter Calendar Quarter NUM1
SrvcOrdCreationMonth Calendar Month NUM2
SrvcOrdCreationYear Calendar Year NUM4
CreationDateYearQuarter Year Quarter NUM5
CreationDateYearMonth Year Month NUM6
RefBusinessSolutionOrder Reference Solution Order ID
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Construction type material of the object
  • Client
  • Construction type material of the object
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == MARA.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == TVTW.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == TSPA.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.DIVISION == TSPA.SPART
Equipment Number
  • Equipment Number
  • Client
  • I_SRVCORDITMWTHSRVCCONTRCUBE.EQUIPMENT == EQUI.EQUNR
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == EQUI.MANDT
Equipment category
  • Equipment category
  • Client
  • I_SRVCORDITMWTHSRVCCONTRCUBE.EQUIPMENTCATEGORY == T370T.EQTYP
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T370T.MANDT
Functional location category
  • Functional location category
  • Client
  • I_SRVCORDITMWTHSRVCCONTRCUBE.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T370F.MANDT
Industry Sector
  • Client
  • Industry Sector
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T016.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.INDUSTRY == T016.BRSCH
Material Number
  • Material Number
  • Client
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MATERIAL == MARA.MATNR
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == MARA.MANDT
Employee Responsible
  • Client
  • Employee Responsible
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == BUT000.CLIENT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Trans. Cat. I_SRVCORDITMWTHSRVCCONTRCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T006.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.SERVICEORDERITEMQUANTITYUNIT == T006.MSEHI
Business Transaction Type
  • Client
  • Business Transaction Type
Sold-To Party
  • Client
  • Sold-To Party
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == BUT000.CLIENT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T005.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T005S.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_SRVCORDITMWTHSRVCCONTRCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_SRVCORDITMWTHSRVCCONTRCUBE.TECHNICALOBJECTTYPE == T370K.EQART
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == T370K.MANDT
Currency
  • Client
  • Currency
  • I_SRVCORDITMWTHSRVCCONTRCUBE.MANDT == TCURC.MANDT
  • I_SRVCORDITMWTHSRVCCONTRCUBE.TRANSACTIONCURRENCY == TCURC.WAERS