I_CmmdtyHdgCkptPeriodComposite

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_CmmdtyHdgCkptPeriodComposite.
-- 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: ICMMHDGCPTPERDCM

CREATE VIEW I_CmmdtyHdgCkptPeriodComposite AS
SELECT
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgUtilznHedgedAbsltQty,
  CmmdtyHdgUtilznTgtQtaMgmtQty,
  CmmdtyHdgUtilznHdgAcctgQty,
  CmmdtyHdgUtilznHdgFreeStndgQty,
  CmmdtyHdgUtilznTgtQtaAcctgQty,
  CommodityOverHedgeCriticality,
  CommodityHedgePercentageUnit,
  case when CmmdtyHedgePlnExposureQuantity <> 0 then case when CmmdtyHdgUtilznHdgAcctgQty <> 0 then round( division(CmmdtyHdgUtilznHdgAcctgQty * 100, CmmdtyHedgePlnExposureQuantity, 4 ), _PercentUnitOfMeasure.UnitOfMeasureNumberOfDecimals ) else cast(0 as abap.dec(18,3)) end else cast(0 as abap.dec(18,3)) end as CmmdtyHdgUtilznTgtQtaAcctgPct AS dec183endasCmmdtyHdgUtilznTgtQtaAcctgPct
FROM I_CommodityHedgeCockpitPeriod
LEFT OUTER JOIN I_UnitOfMeasure AS _PercentUnitOfMeasure ON CommodityHedgePercentageUnit = _PercentUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgBookCompleteDetail AS _HedgeBook ON CmmdtyHdgPlanExposureHedgeBook = _HedgeBook.CommodityHedgeBookIdentifier  -- association [0..1]
;