P_CommodityHedgeExposureAtDate

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 P_CommodityHedgeExposureAtDate.
-- 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.
-- Parameters: P_EVALUATION_DATE : abap.dats

CREATE VIEW P_CommodityHedgeExposureAtDate AS
SELECT
  Exp.CommodityHedgePlanExposureUUID AS CommodityHedgePlanExposureUUID,
  Exp.CmmdtyHdgPlnExposureParentUUID AS CmmdtyHdgPlnExposureParentUUID,
  Exp.CmmdtyHedgePlanExposureHashKey AS CmmdtyHedgePlanExposureHashKey,
  Exp.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  Exp.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  Exp.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  Exp.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  Exp.CmmdtyHdgPlnExpsrHedgingArea AS CmmdtyHdgPlnExpsrHedgingArea,
  Exp.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  Exp.CmmdtyHdgPlnExpsrPerdStartDate AS CmmdtyHdgPlnExpsrPerdStartDate,
  cast( right(Exp.CmmdtyHdgPlnExpsrPerdStartDate, 4) as abap.int4 ) AS CmmdtyHdgExpsrPerdStrtMonthDay,
  Exp.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  Exp.CmmdtyHdgPlnExpsrBusinessArea AS CmmdtyHdgPlnExpsrBusinessArea,
  Exp.CmmdtyHdgPlnExpsrValidFromDate AS CmmdtyHdgPlnExpsrValidFromDate,
  Exp.CmmdtyHdgPlanExposurePortfolio AS CmmdtyHdgPlanExposurePortfolio,
  Exp.CmmdtyHdgPlnExpsrProfitCenter AS CmmdtyHdgPlnExpsrProfitCenter,
  Exp.CmmdtyHdgPlnExposureCostCenter AS CmmdtyHdgPlnExposureCostCenter,
  Exp.CmmdtyHedgePlanExposurePlant AS CmmdtyHedgePlanExposurePlant,
  Exp.CmmdtyHedgePlanExposureItemID AS CmmdtyHedgePlanExposureItemID,
  Exp.CmmdtyHdgPlnExpsrIsAcctgRlvt AS CmmdtyHdgPlnExpsrIsAcctgRlvt,
  Exp.CmmdtyHdgPlnExposureRemarkNote AS CmmdtyHdgPlnExposureRemarkNote,
  Exp.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  Exp.CmmdtyHdgPlanExposureCategory AS CmmdtyHdgPlanExposureCategory,
  Exp.CmmdtyHdgPlnExpsrDelivStrtDate AS CmmdtyHdgPlnExpsrDelivStrtDate,
  Exp.CmmdtyHdgPlnExpsrDelivEndDate AS CmmdtyHdgPlnExpsrDelivEndDate,
  Exp.CmmdtyHdgPlnExpsrDelivPerdText AS CmmdtyHdgPlnExpsrDelivPerdText,
  Exp.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  Exp.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  Exp.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  Exp.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  Exp.PlanningDataUUID AS PlanningDataUUID,
  Exp.CmmdtyHedgePlnExposureQuantity AS CmmdtyHedgePlnExposureQuantity,
  Exp.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  Exp.CmmdtyHdgPlanExposureLogHandle AS CmmdtyHdgPlanExposureLogHandle,
  Exp.CmmdtyHedgePlanExposureStatus AS CmmdtyHedgePlanExposureStatus,
  Exp.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  Exp.CmmdtyHdgPlnExpsrStsChgReason AS CmmdtyHdgPlnExpsrStsChgReason,
  Exp.CmmdtyHdgPlnExpsrCreatedByUser AS CmmdtyHdgPlnExpsrCreatedByUser,
  Exp.CmmdtyHdgPlnExpsrCrtnDateTime AS CmmdtyHdgPlnExpsrCrtnDateTime,
  Exp.CmmdtyHdgPlnExpsrLastChgdByUsr AS CmmdtyHdgPlnExpsrLastChgdByUsr,
  Exp.CmmdtyHdgPlnExpsrChgDateTime AS CmmdtyHdgPlnExpsrChgDateTime
FROM I_CommodityHedgeExposureDetail AS Exp
;