I_ServiceOrderCube

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.
-- 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 AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceOrder,
  ServiceDocumentDescription AS ServiceOrderDescription,
  ServiceDocumentStatus AS ServiceOrderStatus,
  ServiceDocumentType,
  SoldToParty,
  RequestedServiceEndDate,
  ServiceDocumentPriority,
  ServiceDocumentHasError,
  ServiceDocNetAmount,
  TransactionCurrency,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  cast( case when ServiceDocumentStatus = 'A' then cast (1 as abap.int4) when ServiceDocumentStatus = 'B' then cast (1 as abap.int4) when ServiceDocumentStatus = 'D' then cast (1 as abap.int4) end as abap.int4 ) as NmbrOfIncompleteServiceOrders AS int4asNmbrOfIncompleteServiceOrders,
  case when RequestedServiceEndDate < $session.system_date and ( ServiceDocumentStatus = 'A' or ServiceDocumentStatus = 'B' or ServiceDocumentStatus = 'D' ) then cast (1 as abap.int4) end as NumberOfOverdueServiceOrders AS int4endasNumberOfOverdueServiceOrders
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN P_SrvcOrdDistinctConfExist AS _SrvcOrdItmConfExist ON ServiceObjectType = _SrvcOrdItmConfExist.ServiceObjectType AND ServiceOrder = _SrvcOrdItmConfExist.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdConfStatus AS _SrvcOrdConfStatus ON SrvcOrdHasConfdItem = _SrvcOrdConfStatus.SrvcOrdHasConfdItem  -- association [1..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceOrder = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;