P_ServiceOrderDataCube

Service Order Data Cube | view: PSERVORDDCUBE | Extraction: Not supported | Component: S4CRM: Analytics

Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_REFOBJ, CRMD_BRELVONAE

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (2)
☰ Categorical (6)
Other (20)
🔗 Relations (13)

Column Name	Description
ServiceObjectType FK	Business Trans. Cat.
ServiceOrder	Transaction ID

Column Name	Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount	Total Net Value of Document in Document Currency

Column Name	Description

Column Name	Description
RequestedServiceEndDate	Changed On
ServiceDocumentCreationDate	Created On

Column Name	Description
ServiceOrderStatus	Life Cycle Status	Show values
ServiceDocumentTemplateType	Template Type of CRM Transaction	Show values
ServiceDocumentHasError	Error Status	Show values
ServiceDocumentIsOpen	Status "Open"	Show values
ServiceReferenceObjectType	Object Type for Reference Object in Subject Set	Show values
SrvcRefObjIsMainObject	Main Reference Object	Show values

Column Name	Description	Domain name
ServiceOrderDescription	Transaction Description	CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder	Reference Solution Order ID	CRM_OBJECT_ID
PurchaseOrderByCustomer	Sold-To Party's External Reference Number	TEXT35
SalesOrganizationOrgUnitID	Sales Organization ID	HROBJEC_14
SalesOfficeOrgUnitID	Sales Office	HROBJEC_14
SalesGroupOrgUnitID	Sales Group	HROBJEC_14
ServiceOrganization	Service Organization	HROBJEC_14
SalesOrganization	Sales Organization	VKORG
SalesOffice	Sales office	VKBUR
SalesGroup	Sales group	VKGRP
SrvcOrdCreationQuarter	Calendar Quarter	NUM1
SrvcOrdCreationMonth	Calendar Month	NUM2
SrvcOrdCreationYear	Calendar Year	NUM4
NmbrOfIncompleteServiceOrders	null
NumberOfIncomingServiceOrders	null
NumberOfOpenServiceOrders	null
NumberOfOverdueServiceOrders	null
SrvcOrdHasConfdItem	null
SerialNumber	Serial Number	GERNR
FunctionalLocation	Functional Location	TPLNR

Master Data Relations	Join Conditions
Customer Contact Person Client Customer Contact Person	`P_SERVICEORDERDATACUBE.MANDT == BUT000.CLIENT` `P_SERVICEORDERDATACUBE.CONTACTPERSON == BUT000.PARTNER`
Distribution Channel Client Distribution Channel	`P_SERVICEORDERDATACUBE.MANDT == TVTW.MANDT` `P_SERVICEORDERDATACUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Client Division	`P_SERVICEORDERDATACUBE.MANDT == TSPA.MANDT` `P_SERVICEORDERDATACUBE.DIVISION == TSPA.SPART`
Equipment Number Client Equipment Number	`P_SERVICEORDERDATACUBE.MANDT == EQUI.MANDT` `P_SERVICEORDERDATACUBE.EQUIPMENT == EQUI.EQUNR`
Material Number Client Material Number	`P_SERVICEORDERDATACUBE.MANDT == MARA.MANDT` `P_SERVICEORDERDATACUBE.PRODUCTID == MARA.MATNR`
Employee Responsible Client Employee Responsible	`P_SERVICEORDERDATACUBE.MANDT == BUT000.CLIENT` `P_SERVICEORDERDATACUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER`
Activity Priority Client Activity Priority	`P_SERVICEORDERDATACUBE.MANDT == SCPRIO.CLIENT` `P_SERVICEORDERDATACUBE.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY`
Business Transaction Type Client Business Transaction Type	`P_SERVICEORDERDATACUBE.MANDT == CRMC_PROC_TYPE.CLIENT` `P_SERVICEORDERDATACUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Executing Service Employee Client Executing Service Employee	`P_SERVICEORDERDATACUBE.MANDT == BUT000.CLIENT` `P_SERVICEORDERDATACUBE.SERVICEEMPLOYEE == BUT000.PARTNER`
Business Trans. Cat.	`P_SERVICEORDERDATACUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Service Team Client Service Team	`P_SERVICEORDERDATACUBE.MANDT == BUT000.CLIENT` `P_SERVICEORDERDATACUBE.SERVICETEAM == BUT000.PARTNER`
Sold-To Party Client Sold-To Party	`P_SERVICEORDERDATACUBE.MANDT == BUT000.CLIENT` `P_SERVICEORDERDATACUBE.SOLDTOPARTY == BUT000.PARTNER`
Currency Client Currency	`P_SERVICEORDERDATACUBE.MANDT == TCURC.MANDT` `P_SERVICEORDERDATACUBE.TRANSACTIONCURRENCY == TCURC.WAERS`