I_ServiceContractFinDataCube

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_ServiceContractFinDataCube.
-- 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_ServiceContractFinDataCube AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceContract,
  ServiceDocumentCharUUID AS ServiceContractUUID,
  ServiceDocumentDescription,
  ServiceDocumentType,
  ServiceDocumentStatus,
  ServiceContractStartDate,
  ServiceContractEndDate,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  TransactionCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  _SoldToParty.BusinessPartnerFullName AS BusinessPartnerFullName,
  ServiceOrganization,
  ResponsibleEmployee,
  _NonPeriodicFinData.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(:P_DisplayCurrency as currency) AS Currency,
  cast( '' as calendaryear) AS CalendarYear,
  cast( '' as calendarweek) AS CalendarWeek,
  cast( '1' as calendarquarter) AS CalendarQuarter,
  cast( '01' as calendarmonth) AS CalendarMonth,
  cast( case when ServiceContractEndDate < $session.system_date then cast (1 as abap.int4) else cast(0 as abap.int4) end as abap.int4) as NmbrOfExpiredSrvcContracts AS int4asNmbrOfExpiredSrvcContracts,
  cast( case when ServiceContractEndDate >= $session.system_date and ServiceContractEndDate <= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,6,'FAIL') then cast (1 as abap.int4) end as abap.int4 ) as NmbrOfExpiredSrvcContrCurWeek AS int4asNmbrOfExpiredSrvcContrCurWeek,
  cast( case when ServiceContractEndDate >= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,7,'FAIL') and ServiceContractEndDate <= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,13,'FAIL') then cast (1 as abap.int4) end as abap.int4 ) as NmbrOfExpiredSrvcContrNextWeek AS int4asNmbrOfExpiredSrvcContrNextWeek,
  cast( case when ServiceContractEndDate >= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,14,'FAIL') and ServiceContractEndDate <= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,20,'FAIL') then cast (1 as abap.int4) end as abap.int4 ) as NmbrOfExpiredSrvcContrIn2Weeks AS int4asNmbrOfExpiredSrvcContrIn2Weeks,
  cast( case when ServiceContractEndDate >= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,21,'FAIL') and ServiceContractEndDate <= DATS_ADD_DAYS( _CurrentDate.FirstDayOfWeekDate,27,'FAIL') then cast (1 as abap.int4) end as abap.int4 ) as NmbrOfExpiredSrvcContrIn3Weeks AS int4asNmbrOfExpiredSrvcContrIn3Weeks
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN P_SrvcContrFinSum AS _NonPeriodicFinData ON ServiceContract = _NonPeriodicFinData.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 I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceContract = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;