I_ServiceOrderItemCube

Cube for Service Order Item | view: ISRVCORDITMCUBE | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocumentCreationDate Created On
ServiceDocItemCreationDate Created On
RequestedServiceStartDate null
RequestedServiceEndDate null
ServiceFirstResponseByDate null
SrvcDocItemSLADueByDate null
PlannedServiceStartDate null
PlannedServiceEndDate null
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemHasError Error Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
Column Name Description Domain name
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
SrvcOrdItmByReqdStrtWkNmbr null
SrvcOrdItmByReqdEndWkNmbr null
SrvcOrdItmByPlndStrtWkNmbr null
SrvcOrdItmByPlndEndWkNmbr null
SrvcOrdItmBy1stRspWkNmbr null
SrvcOrdItmByToDoWkNmbr null
NmbrOfIncompleteServiceOrders null
NumberOfOverdueServiceOrders null
NmbrOfSrvcOrdItmsByReqdStrtWk null
NmbrOfSrvcOrdItmsByReqdEndWk null
NmbrOfSrvcOrdItmsByPlndStrtWk null
NmbrOfSrvcOrdItmsByPlndEndWk null
NmbrOfSrvcOrdItmsBy1stRspWk null
NmbrOfSrvcOrdItmsByDueByWk null
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceOrganization Service Organization HROBJEC_14
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ReferenceObjectID Material Number MATNR
SrvcRefObjName Description of technical object TEXT40
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_SERVICEORDERITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERITEMCUBE.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_SERVICEORDERITEMCUBE.MANDT == TVTW.MANDT
  • I_SERVICEORDERITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SERVICEORDERITEMCUBE.MANDT == TSPA.MANDT
  • I_SERVICEORDERITEMCUBE.DIVISION == TSPA.SPART
Equipment Number
  • Client
  • Equipment Number
  • I_SERVICEORDERITEMCUBE.MANDT == EQUI.MANDT
  • I_SERVICEORDERITEMCUBE.EQUIPMENT == EQUI.EQUNR
Employee Responsible
  • Client
  • Employee Responsible
  • I_SERVICEORDERITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERITEMCUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Activity Priority
  • Client
  • Activity Priority
  • Activity Priority
  • I_SERVICEORDERITEMCUBE.MANDT == SCPRIO.CLIENT
  • I_SERVICEORDERITEMCUBE.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
  • I_SERVICEORDERITEMCUBE.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
Activity Priority
  • Client
  • Activity Priority
  • Activity Priority
  • I_SERVICEORDERITEMCUBE.MANDT == SCPRIO.CLIENT
  • I_SERVICEORDERITEMCUBE.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
  • I_SERVICEORDERITEMCUBE.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. I_SERVICEORDERITEMCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Client
  • Ship-To Party
  • I_SERVICEORDERITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERITEMCUBE.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • I_SERVICEORDERITEMCUBE.MANDT == BUT000.CLIENT
  • I_SERVICEORDERITEMCUBE.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • I_SERVICEORDERITEMCUBE.MANDT == TCURC.MANDT
  • I_SERVICEORDERITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS