C_ServiceOrderItemQuery

DDL: C_SERVICEORDERITEMQUERY Type: view CONSUMPTION Package: CRMS4_ANALYTICS
44 Fields 1 Data Sources

Service Order Item - Query

C_ServiceOrderItemQuery is a Consumption CDS View that provides data about "Service Order Item - Query" in SAP S/4HANA. It reads from 1 data source (I_SrvcOrdItmWthSrvcContrCube) and exposes 44 fields with key fields ServiceObjectType, ServiceOrder, ServiceDocumentItem. Part of development package CRMS4_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_SrvcOrdItmWthSrvcContrCube I_SrvcOrdItmWthSrvcContrCube from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (15)

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

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceOrder ServiceOrder Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
ServiceOrderItemProduct ServiceOrderItemProduct
ServiceOrderItemStatus ServiceOrderItemStatus
ServiceDocumentItemIsOpen ServiceDocumentItemIsOpen
ServiceOrderItemQuantity ServiceOrderItemQuantity
ServiceOrderItemQuantityUnit ServiceOrderItemQuantityUnit
ServiceContract ServiceContract Transaction ID
ServiceContractItem ServiceContractItem Item Number in Doc.
ServiceContractItemProduct ServiceContractItemProduct
ServiceContrItemBillingStatus ServiceContrItemBillingStatus
ServiceContractItemStartDate ServiceContractItemStartDate
ServiceContractItemEndDate ServiceContractItemEndDate
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
NmbrOfFUPServiceOrderItems NmbrOfFUPServiceOrderItems
NrOfSrvcOrdItmsWthoutContrRef NrOfSrvcOrdItmsWthoutContrRef
DisplayCurrency
ServiceContractItemIsActive ServiceContractItemIsActive
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
ServiceReferenceObjectType ServiceReferenceObjectType
EquipmentCategory EquipmentCategory EquipCategory
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
TechnicalObjectType TechnicalObjectType Text object
Material Material Vehicle Model
SrvcOrdCreationQuarter SrvcOrdCreationQuarter
SrvcOrdCreationMonth SrvcOrdCreationMonth
SrvcOrdCreationYear SrvcOrdCreationYear
CreationDateYearQuarter CreationDateYearQuarter
CreationDateYearMonth CreationDateYearMonth
RefBusinessSolutionOrder RefBusinessSolutionOrder
SoldToParty SoldToParty Sold-to Party
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
Industry Industry Industry Sector
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId

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_ServiceOrderItemQuery.
-- 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_ServiceOrderItemQuery AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceDocumentItem,
  ServiceOrderItemProduct,
  ServiceOrderItemStatus,
  ServiceDocumentItemIsOpen,
  ServiceOrderItemQuantity,
  ServiceOrderItemQuantityUnit,
  ServiceContract,
  ServiceContractItem,
  ServiceContractItemProduct,
  ServiceContrItemBillingStatus,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ProfitCenter,
  ControllingArea,
  PurchaseOrderByCustomer,
  NmbrOfFUPServiceOrderItems,
  NrOfSrvcOrdItmsWthoutContrRef,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  ServiceContractItemIsActive,
  Equipment,
  FunctionalLocation,
  ServiceReferenceObjectType,
  EquipmentCategory,
  FunctionalLocationCategory,
  TechnicalObjectType,
  Material,
  SrvcOrdCreationQuarter,
  SrvcOrdCreationMonth,
  SrvcOrdCreationYear,
  CreationDateYearQuarter,
  CreationDateYearMonth,
  RefBusinessSolutionOrder,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  Industry,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  RespEmployeeBusinessPartnerId
FROM I_SrvcOrdItmWthSrvcContrCube
;

Learn More