I_ServiceOrderItemCube

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_ServiceOrderItemCube.
-- 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_ServiceOrderItemCube AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentDescription,
  ServiceDocumentItemPriority,
  ServiceDocumentType,
  PostingDate,
  TransactionCurrency,
  ServiceDocumentCreationDate,
  ServiceDocumentPriority,
  ServiceDocumentStatus,
  ServiceDocumentIsOpen,
  ResponsibleEmployee,
  ContactPersonBusinessPartnerId,
  ShipToParty,
  RefBusinessSolutionOrder,
  ServiceDocumentItemStatus,
  ServiceDocumentItemHasError,
  ServiceDocumentItemIsOpen,
  ServiceDocItemCreationDate,
  ServiceDocItemCategory,
  ServiceDocumentItemNetAmount,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  RequestedServiceStartDate,
  RequestedServiceEndDate,
  ServiceFirstResponseByDate,
  SrvcDocItemSLADueByDate,
  PlannedServiceStartDate,
  PlannedServiceEndDate,
  SrvcOrdItmByReqdStrtWkNmbr,
  SrvcOrdItmByReqdEndWkNmbr,
  SrvcOrdItmByPlndStrtWkNmbr,
  SrvcOrdItmByPlndEndWkNmbr,
  SrvcOrdItmBy1stRspWkNmbr,
  SrvcOrdItmByToDoWkNmbr,
  NmbrOfIncompleteServiceOrders,
  NumberOfOverdueServiceOrders,
  case when SrvcOrdItmByReqdStrtWkNmbr between '0000' and '0106' or SrvcOrdItmByReqdStrtWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsByReqdStrtWk AS int4endasNmbrOfSrvcOrdItmsByReqdStrtWk,
  case when SrvcOrdItmByReqdEndWkNmbr between '0000' and '0106' or SrvcOrdItmByReqdEndWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsByReqdEndWk AS int4endasNmbrOfSrvcOrdItmsByReqdEndWk,
  case when SrvcOrdItmByPlndStrtWkNmbr between '0000' and '0106' or SrvcOrdItmByPlndStrtWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsByPlndStrtWk AS int4endasNmbrOfSrvcOrdItmsByPlndStrtWk,
  case when SrvcOrdItmByPlndEndWkNmbr between '0000' and '0106' or SrvcOrdItmByPlndEndWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsByPlndEndWk AS int4endasNmbrOfSrvcOrdItmsByPlndEndWk,
  case when SrvcOrdItmBy1stRspWkNmbr between '0000' and '0106' or SrvcOrdItmBy1stRspWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsBy1stRspWk AS int4endasNmbrOfSrvcOrdItmsBy1stRspWk,
  case when SrvcOrdItmByToDoWkNmbr between '0000' and '0106' or SrvcOrdItmByToDoWkNmbr = '' then cast(1 as abap.int4) end as NmbrOfSrvcOrdItmsByDueByWk AS int4endasNmbrOfSrvcOrdItmsByDueByWk,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  ServiceOrganization,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SoldToParty,
  ServiceReferenceObjectType,
  Equipment,
  ReferenceObjectID,
  SrvcRefObjName,
  RespyMgmtServiceTeam,
  RespyMgmtServiceTeamDesc,
  TeamName,
  Product
FROM P_ServiceOrderItemDataCube
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;