C_CmmdtyHedgeCockpitOverview

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 C_CmmdtyHedgeCockpitOverview.
-- 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: CCMMHDGCKPTOVW

CREATE VIEW C_CmmdtyHedgeCockpitOverview AS
SELECT
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgUtilznTgtQtaMgmtQty,
  CmmdtyHdgUtilznHdgAcctgQty,
  CmmdtyHdgUtilznHedgedAbsltQty,
  CmmdtyHdgUtilznHdgFreeStndgQty,
  CmmdtyHdgUtilznTgtQtaAcctgQty,
  CommodityOverHedgeCriticality,
  CommodityHedgePercentageUnit,
  CmmdtyHedgeUtilznHedgedPercent,
  CmmdtyHedgeUtilznTgtQtaMgmtPct,
  CmmdtyHdgUtilznTgtQtaAcctgPct,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _DerivativeContractSpecText.DerivativeContrSpecName AS DerivativeContrSpecName,
  _DirectionText.PlanningDataDirectionText AS PlanningDataDirectionText
FROM I_CmmdtyHdgCkptYearComposite
;