I_SchedglineWithDraft

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_SchedglineWithDraft.
-- 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: ISCHEDGLINEWD

CREATE VIEW I_SchedglineWithDraft AS
SELECT
  Document.SchedulingAgreement AS SchedulingAgreement,
  Document.SchedulingAgreementItem AS SchedulingAgreementItem,
  Document.ScheduleLine AS ScheduleLine,
  Document.ScheduleLine AS ScheduleLineForEdit,
  Document.DelivDateCategory AS DelivDateCategory,
  Document.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  Document.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  Document.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  Document.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  Document.ScheduleLineOpenQuantity AS ScheduleLineOpenQuantity,
  _SchedgAgrmtTransientField.CumulativeScheduleQuantity AS CumulativeScheduleQuantity,
  _SchedgAgrmtTransientField.PreviousCumulativeQuantity AS PreviousCumulativeQuantity,
  _SchedgAgrmtTransientField.FirmTradeZoneInDays AS FirmTradeZoneInDays,
  _SchedgAgrmtTransientField.CreationDescription AS CreationDescription,
  Document.ScheduleLineIsFixed AS ScheduleLineIsFixed,
  Document.NoOfRemindersOfScheduleLine AS NoOfRemindersOfScheduleLine,
  Document.PrevDelivQtyOfScheduleLine AS PrevDelivQtyOfScheduleLine,
  Document.SourceOfCreation AS SourceOfCreation,
  _SchedgagrmthdrWithDraft.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  _SchedgAgrmtItmWithDraft.SchedLineSemiFirmOrderInDays AS SchedLineSemiFirmOrderInDays,
  _SchedgAgrmtItmWithDraft.ScheduleLineFirmOrderInDays AS ScheduleLineFirmOrderInDays,
  _SchedgAgrmtItmWithDraft.SchedAgrmtCumQtyReconcileDate AS SchedAgrmtCumQtyReconcileDate,
  _SchedgAgrmtItmWithDraft.ItemLastTransmissionDate AS ItemLastTransmissionDate,
  _SchedgAgrmtItmWithDraft.OrderQuantityUnit AS OrderQuantityUnit,
  _SchedgAgrmtItmWithDraft.SchedAgrmtAgreedCumQty AS SchedAgrmtAgreedCumQty
FROM I_Schedgline AS Document
LEFT OUTER JOIN I_SchedgagrmthdrWithDraft AS _SchedgagrmthdrWithDraft ON _SchedgagrmthdrWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtItmWithDraft AS _SchedgAgrmtItmWithDraft ON _SchedgAgrmtItmWithDraft.SchedulingAgreement = SchedulingAgreement AND _SchedgAgrmtItmWithDraft.SchedulingAgreementItem = SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN I_Scheduleline_Cumscheqty AS _CumulativeScheduleQuantity ON _CumulativeScheduleQuantity.PurchasingDocument = SchedulingAgreement AND _CumulativeScheduleQuantity.PurchasingDocumentItem = SchedulingAgreementItem AND _CumulativeScheduleQuantity.ScheduleLine = ScheduleLine AND _CumulativeScheduleQuantity.ScheduleLineDeliveryDate <= ScheduleLineDeliveryDate AND _CumulativeScheduleQuantity.ScheduleLineDeliveryTime <= ScheduleLineDeliveryTime  -- association [0..1]
LEFT OUTER JOIN I_Schedgagrmtlinestranfields AS _SchedgAgrmtTransientField ON SchedulingAgreement = _SchedgAgrmtTransientField.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtTransientField.SchedulingAgreementItem AND ScheduleLine = _SchedgAgrmtTransientField.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtSubcontrgCompTP AS _SchedgAgrmtSubcontrgCompTP ON SchedulingAgreement = _SchedgAgrmtSubcontrgCompTP.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtSubcontrgCompTP.SchedulingAgreementItem AND ScheduleLine = _SchedgAgrmtSubcontrgCompTP.ScheduleLine  -- association [0..*]
;