I_ServiceContractPeriodicCube

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_ServiceContractPeriodicCube.
-- 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_ServiceContractPeriodicCube AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceContract,
  ServiceDocumentCharUUID AS ServiceContractUUID,
  ServiceDocumentDescription,
  ServiceDocumentType,
  ServiceDocumentStatus,
  ServiceContractStartDate,
  ServiceContractEndDate,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  _FinanceData.CreationDate AS CreationDate,
  _FinanceData.CalendarQuarter AS CalendarQuarter,
  _FinanceData.CalendarYear AS CalendarYear,
  _FinanceData.CalendarMonth AS CalendarMonth,
  _FinanceData.CalendarWeek AS CalendarWeek,
  TransactionCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  _SoldToParty.BusinessPartnerFullName AS BusinessPartnerFullName,
  ResponsibleEmployee,
  _FinanceData.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(:P_DisplayCurrency as currency) AS Currency,
  _Contract.TotalSrvcContrValueInDC AS TotalSrvcContrValueInDC
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN P_SrvcContrFinPeriodicSum AS _FinanceData ON ServiceContract = _FinanceData.ServiceContract  -- association [0..1]
LEFT OUTER JOIN P_SrvcContrDays AS _ContractDays ON ServiceContract = _ContractDays.ServiceDocument AND ServiceObjectType = _ContractDays.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CurrentDate ON _CurrentDate.CalendarDate = $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN P_SrvcContrList AS _Contract ON ServiceContract = _Contract.ServiceContract  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceContract = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_CalendarYear AS _CalendarYear ON CalendarYear = _CalendarYear.CalendarYear  -- association [1..1]
;