C_ServiceOrderQuery

DDL: C_SERVICEORDERQUERY Type: view CONSUMPTION
24 Fields 1 Data Sources

Service Order - Query

C_ServiceOrderQuery is a Consumption CDS View that provides data about "Service Order - Query" in SAP S/4HANA. It reads from 1 data source (I_ServiceOrderCube_2) and exposes 24 fields.

SAP Help Documentation

CategoryService Monitoring and Analytics
StatusLife cycle status of service order
Corresponding DataSourceCSRVCORDQRY
Purpose
This CDS view belongs to Order to Cash Dashboard that is available with SAP Analytics Cloud content. The view provides the prerequisites for answering questions about service orders at header level. Examples of business questions include the following: How many open service orders of the top sold-to party, sales organization, or sale office are there? What's the aggregated net value of incoming service orders in the current quarter? Who are the top customers by net value of incoming service orders? How many open service orders were there in the past month? How many incoming service orders for my sales organizations are there in the current month?

Prerequisites
Users who want to use this CDS view need to access it via another CDS view (privileged mode). The query is built on top of the cube view Service Order - Cube ( I_ServiceOrderCube_2 ).

Structure
Object Types This view relates to the following SAP object types: ServiceOrder . Main Input Parameter The main input parameter is: P_DisplayCurrency : This parameter is used to specify the target currency for currency conversion. Measures and Attributes The following table explains the most important measures and attributes in the view: Attribute Description SERVICEORDER Transaction ID SERVICEORDERSTATUS Life cycle status of service order SOLDTOPARTY Sold-to party of service order NETAMOUNTINDISPLAYCURRENCY Net value in display currency NUMBEROFINCOMINGSERVICEORDERS Number of service orders that have been created in a specific month NUMBEROFOPENSERVICEORDERS Number of service orders that don't have the status Completed in a specific month SRVCORDCREATIONMONTH Calendar month in which a service order was created SRVCORDCREATIONQUARTER Calendar quarter in which a service order was created SALESORGANIZATION Sales organization

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_ServiceOrderCube_2 ServiceOrderQuery from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Order - Query view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CSRVCORDQRY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view
OData.publish true view

Fields (24)

KeyFieldSource TableSource FieldDescription
ServiceObjectType ServiceObjectType Object Type
ServiceOrder ServiceOrder Transaction ID
ServiceOrderDescription ServiceOrderDescription
ServiceOrderStatus ServiceOrderStatus
ServiceDocumentType ServiceDocumentType Transaction Type
RefBusinessSolutionOrder RefBusinessSolutionOrder
SoldToParty SoldToParty Sold-to Party
RequestedServiceEndDate RequestedServiceEndDate
ServiceDocumentCreationDate ServiceDocumentCreationDate
SrvcOrdCreationQuarter SrvcOrdCreationQuarter
SrvcOrdCreationMonth SrvcOrdCreationMonth
SrvcOrdCreationYear SrvcOrdCreationYear
ServiceDocumentPriority ServiceDocumentPriority
ServiceDocumentHasError ServiceDocumentHasError
ServiceDocumentIsOpen ServiceDocumentIsOpen
DisplayCurrency
NumberOfIncomingServiceOrders NumberOfIncomingServiceOrders
NumberOfOpenServiceOrders NumberOfOpenServiceOrders
TransactionCurrency TransactionCurrency Transaction Currency
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ServiceOrderQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_ServiceOrderQuery AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceOrderDescription,
  ServiceOrderStatus,
  ServiceDocumentType,
  RefBusinessSolutionOrder,
  SoldToParty,
  RequestedServiceEndDate,
  ServiceDocumentCreationDate,
  SrvcOrdCreationQuarter,
  SrvcOrdCreationMonth,
  SrvcOrdCreationYear,
  ServiceDocumentPriority,
  ServiceDocumentHasError,
  ServiceDocumentIsOpen,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  NumberOfIncomingServiceOrders,
  NumberOfOpenServiceOrders,
  TransactionCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup
FROM I_ServiceOrderCube_2 AS ServiceOrderQuery
;

Learn More