I_TrdgContrPlannedQtyDets

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_TrdgContrPlannedQtyDets.
-- 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: IPLANNEDQTYDETS

CREATE VIEW I_TrdgContrPlannedQtyDets AS
SELECT
  nomtk AS NominationNumber,
  nomit AS NominationItem,
  case when _add_contr.menge <> 0 then _add_contr.docnr else nom_item.tcnum end as ContractNum AS tcnumendasContractNum,
  case when _add_contr.menge <> 0 then _add_contr.docitm else nom_item.tcitm end as TradingContractItem AS tcitmendasTradingContractItem,
  nom_item.quickconf AS QuickConfirm,
  nom_item.unit_i AS TrdgContractItemUnitOfMeasure,
  case when _add_contr.menge <> 0 then _add_contr.menge else nom_item.menge end as ACMTotalPlannedQuantity AS mengeendasACMTotalPlannedQuantity,
  nom_item.actualqty AS ACMMntnPrcgNominationActualQty,
  nom_item.actualuom AS ACMApplicationDataUoM,
  nom_item.ilock AS ACMIsNominationConfirmed
FROM oijnomi AS nom_item
LEFT OUTER JOIN /accgo/t_scp_ac AS _add_contr ON nom_item.nomtk = _add_contr.nomtk AND nom_item.nomit = _add_contr.nomit  -- association [0..*]
;