P_SchedLineGIQty

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_SchedLineGIQty.
-- 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: PSCHGIQTY

CREATE VIEW P_SchedLineGIQty AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  ScheduleLine,
  Material,
  Supplier,
  Plant,
  RequirementDate,
  Reservation,
  ReservationItem,
  _GdsIssQtyAggrgn.TotalGIPerPO AS TotalGIPerPO,
  _SubcontrgOrdsSchedLines.CummulativeSheduleQuantity AS CummulativeSheduleQuantity,
  cast( case when _SubcontrgOrdsSchedLines.CummulativeSheduleQuantity is null and _GdsIssQtyAggrgn.TotalGIPerPO is null then cast (0 as bdmng) when _GdsIssQtyAggrgn.TotalGIPerPO is null then (0 - _SubcontrgOrdsSchedLines.CummulativeSheduleQuantity) else (_GdsIssQtyAggrgn.TotalGIPerPO - coalesce( _SubcontrgOrdsSchedLines.CummulativeSheduleQuantity, 0 ) ) end as abap.quan(13,3)) as GIDonePerScheduleLineQty AS quan133asGIDonePerScheduleLineQty
FROM I_SubcontractingComponent
LEFT OUTER JOIN P_GdsIssQtyAggrgn AS _GdsIssQtyAggrgn ON _GdsIssQtyAggrgn.PurchasingDocument = PurchasingDocument AND _GdsIssQtyAggrgn.PurchasingDocumentItem = PurchasingDocumentItem AND _GdsIssQtyAggrgn.Material = Material AND _GdsIssQtyAggrgn.Supplier = Supplier AND _GdsIssQtyAggrgn.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN P_SubcontrgOrdsSchedLines AS _SubcontrgOrdsSchedLines ON _SubcontrgOrdsSchedLines.PurchasingDocument = PurchasingDocument AND _SubcontrgOrdsSchedLines.PurchasingDocumentItem = PurchasingDocumentItem AND _SubcontrgOrdsSchedLines.ScheduleLine = ScheduleLine AND _SubcontrgOrdsSchedLines.Material = Material AND _SubcontrgOrdsSchedLines.Supplier = Supplier AND _SubcontrgOrdsSchedLines.Plant = Plant AND _SubcontrgOrdsSchedLines.RequirementDate = RequirementDate AND _SubcontrgOrdsSchedLines.Reservation = Reservation AND _SubcontrgOrdsSchedLines.ReservationItem = ReservationItem  -- association [1..1]
;