I_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 I_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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_ServiceContractItemCube AS
SELECT
  ServiceObjectType,
  ServiceContract,
  ServiceContractItem,
  ServiceContractItemDescription,
  ServiceContractType,
  RefBusinessSolutionOrderItem,
  Product,
  ServiceContractItemStatus,
  ServiceDocumentItemIsOpen,
  TransactionCurrency,
  CalendarMonth,
  PurchaseOrderByCustomer,
  cast(:P_DisplayCurrency as currency) AS DisplayCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ServiceOrganization,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  SoldToParty,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ShipToParty,
  RefBusinessSolutionOrder,
  NrOfExprgServiceContractItems,
  ActualProcessingEndDate,
  ServiceContrItemEndDateTime,
  CurrentDateTime,
  cast(cast(cast(concat(ActualProcessingEndDate, '000000') as abap.numc(15)) as abap.dec(15,0)) as tzntstmps preserving type) AS StartOfMonthDateTime
FROM P_ServiceContractItemCube
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceContract = _ServiceDocItemExt.ServiceOrderItem AND ServiceContractItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;