P_ServiceContractDataCalc

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_ServiceContractDataCalc.
-- 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 P_ServiceContractDataCalc AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceContract,
  ServiceDocumentUUID AS ServiceContractUUID,
  ServiceDocumentDescription,
  ServiceDocumentType,
  ServiceDocumentType AS ServiceContractType,
  RefBusinessSolutionOrder,
  ServiceDocumentStatus,
  ServiceDocumentStatus AS ServiceContractStatus,
  ServiceDocumentIsOpen,
  TransactionCurrency,
  PurchaseOrderByCustomer,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  ResponsibleEmployee,
  ServiceTeam,
  ContactPerson,
  ShipToParty,
  ServiceContractStartDate,
  ServiceContractEndDate,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  _CurrentDate.CalendarDate AS CalendarDate,
  dats_add_months( _CurrentDate.CalendarDate, -6, 'FAIL') AS ShiftedCalendarDate,
  dats_add_days( _CurrentDate.FirstDayOfMonthDate, -1, 'FAIL') AS LastDayOfMonthDate,
  ServiceDocNetAmount,
  case when ServiceContractEndDate < $session.system_date then cast (1 as abap.int4) end as NmbrOfExpiredSrvcContracts AS int4endasNmbrOfExpiredSrvcContracts,
  case when ServiceContractEndDate >= $session.system_date and ServiceContractEndDate <= dats_add_days( _CurrentDate.FirstDayOfWeekDate,6,'FAIL') then cast (1 as abap.int4) end as NmbrOfExpiredSrvcContrCurWeek AS int4endasNmbrOfExpiredSrvcContrCurWeek,
  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 NmbrOfExpiredSrvcContrNextWeek AS int4endasNmbrOfExpiredSrvcContrNextWeek,
  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 NmbrOfExpiredSrvcContrIn2Weeks AS int4endasNmbrOfExpiredSrvcContrIn2Weeks,
  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 NmbrOfExpiredSrvcContrIn3Weeks AS int4endasNmbrOfExpiredSrvcContrIn3Weeks,
  dats_days_between(ServiceContractStartDate,ServiceContractEndDate) AS NumberOfDays
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentStatus AS _ServiceContractStatus ON ServiceContractStatus = _ServiceContractStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CurrentDate ON _CurrentDate.CalendarDate = $session.system_date  -- association [0..1]
;