P_CmmdtyHdgExpsrDtePosSelect

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_CmmdtyHdgExpsrDtePosSelect.
-- 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: PEXPPOSSEL
-- Parameters: P_EvalDate : cds_evaluation_date, P_CompanyCode : bukrs, P_ConsumptionType : cmm_vlogp_consumptiontype

CREATE VIEW P_CmmdtyHdgExpsrDtePosSelect AS
SELECT
  exp.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  exp.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  exp.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  exp.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  exp.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  exp.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  expVrsn.FactoryCalendar AS FactoryCalendar,
  expVrsn.CmmdtyHdgNmbrOfWrkDayPrcgPerd AS CmmdtyHdgNmbrOfWrkDayPrcgPerd,
  exp.CmmdtyHdgPlnExpsrValidFromDate AS CmmdtyHdgPlnExpsrValidFromDate,
  exp.PhysicalCommodity AS PhysicalCommodity,
  exp.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  exp.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  exp.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  exp.CmmdtyHedgePlnExposureQuantity AS CmmdtyHedgePlnExposureQuantity,
  exp.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  exp.CmmdtyHdgPlanExposurePortfolio AS CmmdtyHdgPlanExposurePortfolio,
  expVrsn.CmmdtyHdgExpsrPrcgPerdEndDate AS CmmdtyHdgExpsrPrcgPerdEndDate,
  exp._CompanyCode AS _CompanyCode,
  $parameters.P_ConsumptionType AS ConsumptionType,
  $parameters.P_EvalDate AS EvaluationDate
FROM I_CommodityHedgePlanExposure AS exp
INNER JOIN P_CmmdtyHedgeFactoryCalendar ON /* join condition not captured in parsed metadata */
;