I_TrdgContrItemCancQty

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_TrdgContrItemCancQty.
-- 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: ITRCONITMCANCQTY

CREATE VIEW I_TrdgContrItemCancQty AS
SELECT
  CancQty.tkonn AS ContractNum,
  CancQty.tposn AS TradingContractItem,
  CancQty.obligation_id AS ACMObligationID,
  CancQtyPlot.canc_plot_id AS ACMPricingLotCancellationID,
  case when CancQty.cancl_typ = 'X' then CancQtyPlot.tradeqty else 0 end as TrdgContrItemClosedQty AS tradeqtyelse0endasTrdgContrItemClosedQty,
  CancQtyPlot.cancl_unit AS TrdgContractItemUnitOfMeasure
FROM /accgo/t_canc_cc AS CancQty
INNER JOIN /accgo/t_canc_pl AS CancQtyPlot ON /* join condition not captured in parsed metadata */
;