I_ServiceOrderCube_2

DDL: I_SERVICEORDERCUBE_2 Type: view COMPOSITE
69 Fields 1 Data Sources 1 Associations

Service Order - Cube

I_ServiceOrderCube_2 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_ServiceOrderCube_2 is a Composite CDS View (Cube) that provides data about "Service Order - Cube" in SAP S/4HANA. It reads from 1 data source (P_ServiceOrderDataCube) and exposes 69 fields with key fields ServiceObjectType, ServiceOrder. It has 1 association to related views.

SAP Help Documentation

CategoryService Monitoring and Analytics
Data CategoryCube
StatusLife cycle status
Purpose
Service Order - Cube ( I_ServiceOrderCube_2 ) is a successor of the CDS view Service Order - Cube ( I_ServiceOrderCube ). It has an improved design from the architecture perspective and provides the prerequisites for answering questions about relevant aspects of service orders and service confirmations. Examples of business questions are the following: Which fixed price service orders have a requested end date in the past? Which resource-related service orders haven’t been completed yet? Which service orders of a particular sold-to party are still unassigned? How many high-priority service orders of a certain sales organization have open confirmations? What is the net value of the service orders that have confirmed items? What is the requested end date of open service orders with very high priority? Which service orders with open confirmations contain errors? Which service orders and service contracts are related to a specific solution order?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRM_ORD_OP Authorization Object CRM Order – Own Documents CRM_SEO Authorization Object CRM Order – Business Object Service Order CRM_ORD_PR Authorization Object CRM Order – Business Transaction Type CRMS4_SLSO Sales Organizational Units of Service Transactions CRM_ORD_OE Authorization Object CRM Order – Allowed Organ. Units

Structure
Object Types This view relates to the following SAP object types: ServiceOrder ServiceConfirmation Attributes The following are some important attributes in this CDS view: Attribute Description ServiceOrder Transaction ID ServiceOrderStatus Life cycle status SrvcOrdHasConfdItem Number of confirmed service order items SoldToParty Sold-to party SalesOrganization Sales organization ServiceDocumentHasError Error status RequestedServiceEndDate Requested end date NumberOfOverdueServiceOrders Number of service orders, which are not completed and which have a requested end date in the past as of the current date NmbrOfIncompleteServiceOrders Number of incomplete service orders RefBusinessSolutionOrder Reference to a solution order ID

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentCRM-S4-ANA-CDS
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>Service Order - Cube (I_ServiceOrderCube_2) is a successor of the CDS view Service Order - Cube (I_ServiceOrderCube). It has an improved design from the architecture perspective and provides the prerequisites for answering questions about relevant aspects of service orders and service confirmations. Examples of business questions are the following:</p> <ul> <li><p>Which fixed price service orders have a requested end date in the past?</p></li> <li><p>Which resource-related service orders haven’t been completed yet?</p></li> <li><p>Which service orders of a particular sold-to party are still unassigned?</p></li> <li><p>How many high-priority service orders of a certain sales organization have open confirmations?</p></li> <li><p>What is the net value of the service orders that have confirmed items?</p></li> <li><p>What is the requested end date of open service orders with very high priority?</p></li> <li><p>Which service orders with open confirmations contain errors?</p></li> <li><p>Which service orders and service contracts are related to a specific solution order?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_ServiceOrderDataCube P_ServiceOrderDataCube from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocument _ServiceDocumentExt $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceOrder = _ServiceDocumentExt.ServiceOrder

Annotations (16)

NameValueLevelField
EndUserText.label Service Order - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISERVORDCUBE2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Business Trans. Cat.
KEY ServiceOrder ServiceOrder Transaction ID
ServiceOrderDescription ServiceOrderDescription Transaction Description
ServiceOrderStatus ServiceOrderStatus Life Cycle Status
ServiceDocumentType ServiceDocumentType Business Transaction Type
RefBusinessSolutionOrder RefBusinessSolutionOrder Reference Solution Order ID
SoldToParty SoldToParty Sold-to Party
ResponsibleEmployee ResponsibleEmployee Employee Responsible
ContactPersonBusinessPartnerId ContactPerson Customer Contact Person
RequestedServiceEndDate RequestedServiceEndDate Requested End Date of Service
ServiceDocumentCreationDate ServiceDocumentCreationDate Created On
SrvcOrdCreationQuarter SrvcOrdCreationQuarter Calendar Quarter
SrvcOrdCreationMonth SrvcOrdCreationMonth Calendar Month
SrvcOrdCreationYear SrvcOrdCreationYear Calendar Year
ServiceDocumentPriority ServiceDocumentPriority Activity Priority
ServiceDocumentHasError ServiceDocumentHasError Error Status
ServiceDocNetAmount ServiceDocNetAmount Total Net Value of Document in Document Currency
NumberOfIncomingServiceOrders NumberOfIncomingServiceOrders
NumberOfOpenServiceOrders NumberOfOpenServiceOrders Number of open Service Orders
TransactionCurrency TransactionCurrency Transaction Currency
PurchaseOrderByCustomer PurchaseOrderByCustomer Sold-To Party's External Reference Number
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization ID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
ServiceOrganization ServiceOrganization Service Organization
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
NmbrOfIncompleteServiceOrders NmbrOfIncompleteServiceOrders
NumberOfOverdueServiceOrders NumberOfOverdueServiceOrders
SrvcOrdHasConfdItem SrvcOrdHasConfdItem
ServiceDocumentIsOpen ServiceDocumentIsOpen Status "Open"
ServiceReferenceObjectType ServiceReferenceObjectType Object Type for Reference Object in Subject Set
SrvcRefObjIsMainObject SrvcRefObjIsMainObject Main Reference Object
ProductID ProductID Material Number
SerialNumber SerialNumber Serial Number
Equipment Equipment Equipment Number
FunctionalLocation FunctionalLocation Functional Location
RespyMgmtServiceTeam RespyMgmtServiceTeam Service Team (Responsibility Management)
RespyMgmtServiceTeamDesc RespyMgmtServiceTeamDesc Line With Length 79 for Infotype 1002
TeamName TeamName Name
_ServiceDocumentIsOpen _ServiceDocumentIsOpen
_ServiceObjType _ServiceObjType
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_ServiceDocumentType _ServiceDocumentType
_ServiceDocumentPriority _ServiceDocumentPriority
_SoldToParty _SoldToParty
_RespEmployee _RespEmployee
_ContactPerson _ContactPerson
_ServiceDocHasError _ServiceDocHasError
_SrvcOrdConfStatus _SrvcOrdConfStatus
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_DistributionChannel _DistributionChannel
_Division _Division
_TransactionCurrency _TransactionCurrency
_Period _Period
_ServiceDocRefObj _ServiceDocRefObj
_ServiceTeamHeader _ServiceTeamHeader

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 I_ServiceOrderCube_2.
-- 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.

CREATE VIEW I_ServiceOrderCube_2 AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceOrderDescription,
  ServiceOrderStatus,
  ServiceDocumentType,
  RefBusinessSolutionOrder,
  SoldToParty,
  ResponsibleEmployee,
  ContactPerson AS ContactPersonBusinessPartnerId,
  RequestedServiceEndDate,
  ServiceDocumentCreationDate,
  SrvcOrdCreationQuarter,
  SrvcOrdCreationMonth,
  SrvcOrdCreationYear,
  ServiceDocumentPriority,
  ServiceDocumentHasError,
  ServiceDocNetAmount,
  NumberOfIncomingServiceOrders,
  NumberOfOpenServiceOrders,
  TransactionCurrency,
  PurchaseOrderByCustomer,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  NmbrOfIncompleteServiceOrders,
  NumberOfOverdueServiceOrders,
  SrvcOrdHasConfdItem,
  ServiceDocumentIsOpen,
  ServiceReferenceObjectType,
  SrvcRefObjIsMainObject,
  ProductID,
  SerialNumber,
  Equipment,
  FunctionalLocation,
  RespyMgmtServiceTeam,
  RespyMgmtServiceTeamDesc,
  TeamName
FROM P_ServiceOrderDataCube
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceOrder = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;

Learn More