C_CommodityHedgeCockpitPeriod

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_CommodityHedgeCockpitPeriod.
-- 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: CCMMHDGCKPTPERD

CREATE VIEW C_CommodityHedgeCockpitPeriod AS
SELECT
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgTgtQuotaPeriodNumber,
  FinancialInstrProductCategory,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgUtilznHedgedAbsltQty,
  CmmdtyHdgUtilznTgtQtaMgmtQty,
  CmmdtyHdgUtilznHdgAcctgQty,
  CmmdtyHdgUtilznHdgFreeStndgQty,
  CmmdtyHdgUtilznTgtQtaAcctgQty,
  CommodityOverHedgeCriticality,
  CommodityHedgePercentageUnit,
  CmmdtyHedgeUtilznHedgedPercent,
  CmmdtyHedgeUtilznTgtQtaMgmtPct,
  CmmdtyHdgUtilznTgtQtaAcctgPct,
  CmmdtyHdgTgtQtaMgmtDiffQty,
  CmmdtyHdgTgtQtaAcctgDiffQty,
  CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCoCodeText,
  cast(CmmdtyHedgePlnExposureQuantity as char20) AS CmmdtyHdgPlnExpsrQuantityText,
  CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSText,
  CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlnExpsrDirectionText,
  CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlnExpsrHedgeBookText,
  CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDlvPerdYrText,
  CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdText,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _DerivativeContractSpecText.DerivativeContrSpecName AS DerivativeContrSpecName,
  _DirectionText.PlanningDataDirectionText AS PlanningDataDirectionText,
  _HedgeBookText.CmmdtyHdgPlnExpsrHedgeBookText AS CmmdtyHedgeBookDescription,
  _ProductCategoryText.FinInstrProductCategoryName AS FinInstrProductCategoryName
FROM I_CmmdtyHdgCkptPeriodComposite
LEFT OUTER JOIN I_CmmdtyHdgPlngDataDirectionT AS _DirectionText ON CmmdtyHdgPlanExposureDirection = _DirectionText.PlanningDataDirection AND _DirectionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlnExpsrHedgeBookT AS _HedgeBookText ON CmmdtyHdgPlanExposureHedgeBook = _HedgeBookText.CmmdtyHdgPlanExposureHedgeBook AND _HedgeBookText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdCatText AS _ProductCategoryText ON FinancialInstrProductCategory = _ProductCategoryText.FinancialInstrProductCategory AND _ProductCategoryText.Language = $session.system_language  -- association [0..1]
;