P_ServiceContractItemCube

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 P_ServiceContractItemCube.
-- 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.
-- SQL view name: PSRVCONTRIEMCUBE

CREATE VIEW P_ServiceContractItemCube AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceContract,
  ServiceDocumentItem AS ServiceContractItem,
  ServiceDocumentType AS ServiceContractType,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  ServiceDocumentItemCharUUID AS ServiceContractItemCharUUID,
  ServiceDocumentItemObjectType AS ServiceContractItemObjectType,
  ServiceDocumentItemDescription AS ServiceContractItemDescription,
  ServiceDocumentType,
  TransactionCurrency,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  PurchaseOrderByCustomer,
  _ServiceContract.ServiceDocumentStatus AS ServiceContractStatus,
  ServiceTeam,
  ResponsibleEmployee,
  ServiceEmployee,
  ContactPerson,
  ShipToParty,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  Product,
  RefInHouseRepairIsExisting,
  _ServiceContract.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  ServiceDocumentItemIsQuotation,
  _ServiceContract.ServiceDocumentTemplateType AS ServiceDocumentTemplateType,
  ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceDocumentItemIsOpen,
  ServiceDocumentItemNetAmount,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SoldToParty,
  ServiceOrganization,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  _ExpiringCalendarMonth.CalendarMonth AS CalendarMonth,
  cast (1 as abap.int4) AS NrOfExprgServiceContractItems,
  dats_add_months( _CurrentDate.FirstDayOfMonthDate,4,'FAIL') AS ActualProcessingEndDate,
  _ServiceContract._ServiceDocumentStatus AS _ServiceDocumentStatus,
  _ServiceContract._SrvcDocLifecycleStatus AS _SrvcDocLifecycleStatus,
  _ExpiringCalendarMonth._CalendarMonth AS _CalendarMonth
FROM P_ServiceContractItemDateConv
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _ServiceContract ON ServiceObjectType = _ServiceContract.ServiceObjectType AND ServiceContract = _ServiceContract.ServiceDocument  -- association [1]
LEFT OUTER JOIN I_CalendarDate AS _ExpiringCalendarMonth ON ServiceContractItemEndDate = _ExpiringCalendarMonth.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CurrentDate ON _CurrentDate.CalendarDate = $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType  -- association [0..1]
;