P_CalcDeliveryDate

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_CalcDeliveryDate.
-- 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: PCALCDELDATE
-- Parameters: P_Date : sydatum

CREATE VIEW P_CalcDeliveryDate AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  DeliveryDate,
  OpenQuantity,
  dats_days_between($parameters.P_Date, DeliveryDate) AS DurationToNextStatusInDays,
  DATS_ADD_DAYS(_CalendarDate.FirstDayOfWeekDate,-1,'NULL') AS weekstart,
  DATS_ADD_DAYS(_CalendarDate.FirstDayOfWeekDate,5,'NULL') AS weekend,
  DATS_ADD_DAYS(_CalendarDate.FirstDayOfWeekDate,12,'NULL') AS secweekend,
  cast(cast(_CalendarDate.CalendarWeek as abap.int1( 3 )) - 1 as abap.char( 12 )) AS calweek,
  7-cast(_CalendarDate.WeekDay as abap.int8) AS weekday1,
  14-cast(_CalendarDate.WeekDay as abap.int8) AS weekday2,
  28-cast(_CalendarDate.WeekDay as abap.int8) AS weekday4,
  $parameters.P_Date AS dates,
  DATS_ADD_DAYS(_CalendarDate.FirstDayOfWeekDate,-1,'NULL') AS weekday5,
  PurchaseRequisitionType,
  Plant,
  PurchasingOrganization,
  PurchasingGroup
FROM P_PurchaseRequisitionItemMntr
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = $parameters.P_Date  -- association [1..1]
;