I_CmmdtyHdgCnstltnTaskList

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_CmmdtyHdgCnstltnTaskList.
-- 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.

CREATE VIEW I_CmmdtyHdgCnstltnTaskList AS
SELECT
  hc_wl_uuid AS ConstellationTaskListUUID,
  hc_worklist_id AS CnstltnTaskListIdentifier,
  hc_uuid AS CmmdtyHedgeConstellationUUID,
  hc_reproc_reason AS CnstltnTskListReprocgReason,
  hc_reproc_status AS CnstltnTskListReprocgStatus,
  hc_reproc_stschng_reason AS CnstltnTskListReprocgStsChgRsn,
  hc_wl_remark AS CnstltnTaskListRemarkNote,
  origin AS ConstellationTaskListOrigin,
  process AS CnstltnTskListIsProcRequired,
  company_code AS CnstltnTaskListCompanyCode,
  deal_id AS CnstltnTaskListDealIdentifier,
  case when hc_reproc_status <> 'ICHC6' then _HedgeConstellation[ CmmdtyHedgeCnstltnRecordType = '2' ].CompanyCode else case when _HdgConstellationVersion[ CmmdtyHedgeCnstltnRecordType = '2' ].CompanyCode is not null and _HdgConstellationVersion[ CmmdtyHedgeCnstltnRecordType = '2' ].CompanyCode is not initial then _HdgConstellationVersion[ CmmdtyHedgeCnstltnRecordType = '2' ].CompanyCode else _HedgeConstellation[ CmmdtyHedgeCnstltnRecordType = '2' ].CompanyCode end end as CompanyCode AS CompanyCodeendendasCompanyCode,
  amount AS ConstellationTaskListAmount,
  currency AS ConstellationTaskListCurrency,
  counterparty AS CnstltnTaskListCounterparty,
  portfolio AS ConstellationTaskListPortfolio,
  hedge_class AS CnstltnTskListHdggClassfctn,
  late_dsgntn_date AS CnstltnTskListLateDsgntnDate,
  portfolio_ori AS FinancialTransactionPortfolio,
  hedge_class_ori AS FinTransHedgingClassification,
  log_handle AS ConstellationTaskListLogHandle,
  created_by AS CnstltnTaskListCreatedByUser,
  created_at AS CnstltnTskListCreationDateTime,
  changed_by AS CnstltnTskListLastChgdByUser,
  changed_at AS CnstltnTskListLastChgdDateTime,
  local_last_change_datetime AS LocalLastChangeDateTime
FROM cmmt_hc_wl
LEFT OUTER JOIN I_CmmdtyHdgConstellationDetail AS _HedgeConstellation ON CmmdtyHedgeConstellationUUID = _HedgeConstellation.CmmdtyHedgeConstellationUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgCnstltnVersDetail AS _HdgConstellationVersion ON ConstellationTaskListUUID = _HdgConstellationVersion.ConstellationTaskListUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgReqFXHedgeRequest AS _FXHedgeRequest ON CmmdtyHdgCnstltnFrgnExchHdgReq = _FXHedgeRequest.HedgeRequestIdentifier  -- association [0..1]
LEFT OUTER JOIN I_CommodityHedgePlanExposure AS _Exposure ON CmmdtyHdgConstellationExposure = _Exposure.CommodityHedgePlanExposureID AND CmmdtyHdgCnstltnExpsrVersion = _Exposure.CmmdtyHedgePlanExposureVersion  -- association [0..1]
;