P_DELIVDATECALCU

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_DELIVDATECALCU.
-- 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: PDELIVDATECALCU
-- Parameters: P_Date : sydatum

CREATE VIEW P_DELIVDATECALCU AS
SELECT
  _PurgDocSchedline.PurchasingDocument AS PurchasingDocument,
  _PurgDocSchedline.PurchasingDocumentItem AS PurchasingDocumentItem,
  _PurgDocSchedline.SupplierConfirmationCategory AS SupplierConfirmationCategory,
  _PurgDocSchedline.ScheduleLine AS ScheduleLine,
  _PurgDocSchedline.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _PurgDocSchedline.OrderedQuantity AS OrderedQuantity,
  _PurgDocSchedline.BalanceQuantity AS BalanceQuantity,
  _PurgDocSchedline.Supplier AS Supplier,
  _PurgDocSchedline._Supplier AS _Supplier,
  dats_days_between($parameters.P_Date, _PurgDocSchedline.ScheduleLineDeliveryDate) AS DurationToNextStatusInDays,
  7-cast(_CalendarDate.WeekDay as abap.int8) AS weekday1,
  _CalendarDate.WeekDay AS WeekDay,
  $parameters.P_Date AS dates,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  Plant
FROM P_PurgDocSchedline AS _PurgDocSchedline
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = $parameters.P_Date  -- association [1..1]
;