I_Schedgagrmtlinestranfields

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_Schedgagrmtlinestranfields.
-- 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: ISAGLINESTRANS

CREATE VIEW I_Schedgagrmtlinestranfields AS
SELECT
  I_PurgDocScheduleLine.PurchasingDocument AS SchedulingAgreement,
  I_PurgDocScheduleLine.PurchasingDocumentItem AS SchedulingAgreementItem,
  I_PurgDocScheduleLine.ScheduleLine AS ScheduleLine,
  I_PurgDocScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_PurgDocScheduleLine.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  I_PurgDocScheduleLine.SourceOfCreation AS SourceOfCreation,
  cast(_ScheduleLineCreateInd._Text[1: Language = $session.system_language].CreationDescription as abap.char( 30 )) AS CreationDescription,
  I_PurgDocScheduleLine.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  _CumulativeScheduleQuantity.ScheduleLineOpenQuantity + _CumulativeScheduleQuantity.RoughGoodsReceiptQty AS CumulativeScheduleQuantity,
  _CumulativeScheduleQuantity.PreviousCumulativeQuantity AS PreviousCumulativeQuantity,
  cast( '' as abap.char( 1 )) AS FirmTradeZoneInDays,
  cast( '' as abap.char( 1 )) AS SchedgLineZone
FROM I_PurgDocScheduleLine
LEFT OUTER JOIN I_ScheduleLineCreateInd AS _ScheduleLineCreateInd ON SourceOfCreation = _ScheduleLineCreateInd.DomainValue  -- association [1..1]
LEFT OUTER JOIN I_Scheduleline_Cumscheqty AS _CumulativeScheduleQuantity ON SchedulingAgreement = _CumulativeScheduleQuantity.PurchasingDocument AND SchedulingAgreementItem = _CumulativeScheduleQuantity.PurchasingDocumentItem AND ScheduleLine = _CumulativeScheduleQuantity.ScheduleLine AND ScheduleLineDeliveryDate >= _CumulativeScheduleQuantity.ScheduleLineDeliveryDate AND ScheduleLineDeliveryTime >= _CumulativeScheduleQuantity.ScheduleLineDeliveryTime  -- association [1..1]
;