I_CmmdtyHdgPlanExpsrComposite

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_CmmdtyHdgPlanExpsrComposite.
-- 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: ICMMHDGPLNEXPSR

CREATE VIEW I_CmmdtyHdgPlanExpsrComposite AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDateTime,
  ControllingArea,
  PhysicalCommodity,
  CmmdtyHdgPlnExpsrIsLtstVersion,
  bintohex( PlanningDataUUID ) AS CmmdtyHdgPlnExpsrPlanningData,
  bintohex( CommodityHedgePlanExposureUUID ) AS CmmdtyHdgPlnExpsrChgDocumentID,
  substring( cast( cast( CmmdtyHedgePlanExposureVersion as abap.int4 ) - 1 as abap.char( 11 ) ) , 1, 6 ) AS CmmdtyHdgPlnExpsrPrevVersion,
  $session.system_date AS CurrentDate,
  CmmdtyHdgIsPrcgInDelivPeriod
FROM I_CommodityHedgePlanExposure
LEFT OUTER JOIN I_CmmdtyHdgPlanExposureStatus AS _CmmdtyHdgPlanExpsrStatus ON CmmdtyHedgePlanExposureStatus = _CmmdtyHdgPlanExpsrStatus.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlngDataDirection AS _CmmdtyHdgPlngDataDirection ON CmmdtyHdgPlanExposureDirection = _CmmdtyHdgPlngDataDirection.PlanningDataDirection  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCodeText ON CmmdtyHdgPlnExpsrCompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentCode ON CmmdtyHdgPlanExpsrMktIDCode = _MarketIdentCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DrvtvContrSpec ON CmmdtyHedgePlanExposureDCSID = _DrvtvContrSpec.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON CmmdtyHdgPlnExpsrBusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CmmdtyHdgPlanExposurePortfolio = _Portfolio.Portfolio AND CmmdtyHdgPlnExpsrCompanyCode = _Portfolio.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON CmmdtyHdgPlnExpsrProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CmmdtyHdgPlnExposureCostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON CmmdtyHedgePlanExposurePlant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlnExpsrHedgeBookT AS _HedgeBookText ON CmmdtyHdgPlanExposureHedgeBook = _HedgeBookText.CmmdtyHdgPlanExposureHedgeBook  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgPlnExposureUserText AS _CmmdtyHdgPlanExpsrUserText ON CommodityHedgePlanExposureUUID = _CmmdtyHdgPlanExpsrUserText.CommodityHedgePlanExposureUUID AND _CmmdtyHdgPlanExpsrUserText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyHdgPlngDataComposite AS _CmmdtyHdgPlnExpsrPlngDtaText ON PlanningDataUUID = _CmmdtyHdgPlnExpsrPlngDtaText.PlanningDataUUID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlngDtaDelivCat AS _DeliveryCategory ON CmmdtyHdgPlnExpsrDelivPerdType = _DeliveryCategory.PlanningDataDeliveryCategory  -- association [0..1]
LEFT OUTER JOIN I_CmHdgPlnExpsrHdggArLastRel AS _CmHdgPlnExpsrHdggArLastRel ON CommodityHedgePlanExposureUUID = _CmHdgPlnExpsrHdggArLastRel.CommodityHedgePlanExposureUUID  -- association [1..1]
;