I_CmHdgPlnExpsrHdggArLastRel

DDL: I_CMHDGPLNEXPSRHDGGARLASTREL Type: view COMPOSITE
9 Fields 1 Data Sources 1 Associations

Last Version Hedging Area

I_CmHdgPlnExpsrHdggArLastRel is a Composite CDS View that provides data about "Last Version Hedging Area" in SAP S/4HANA. It reads from 1 data source (I_CmHdgPlnExpsrHdggArReldBfr) and exposes 9 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmHdgPlnExpsrHdggArReldBfr I_CmHdgPlnExpsrHdggArReldBfr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmmdtyHdgHdggAreaComposite _HedgingAreaDetails $projection.CmmdtyHdgPlnExpsrHedgingArea = _HedgingAreaDetails.HedgingAreaIdentification and $projection.HdggAreaMaximumValidFromDate = _HedgingAreaDetails.HedgingAreaValidFromDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMHGPNEXHDARLR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Last Version Hedging Area view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea Hedging Area
HdggAreaMaximumValidFromDate HdggAreaMaximumValidFromDate
HedgingAreaUUID _HedgingAreaDetails HedgingAreaUUID UUID
HedgingAreaText _HedgingAreaDetails HedgingAreaText Hdg Area Description
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup

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_CmHdgPlnExpsrHdggArLastRel.
-- 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.

CREATE VIEW I_CmHdgPlnExpsrHdggArLastRel AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExpsrHedgingArea,
  HdggAreaMaximumValidFromDate,
  _HedgingAreaDetails.HedgingAreaUUID AS HedgingAreaUUID,
  _HedgingAreaDetails.HedgingAreaText AS HedgingAreaText,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup
FROM I_CmHdgPlnExpsrHdggArReldBfr
LEFT OUTER JOIN I_CmmdtyHdgHdggAreaComposite AS _HedgingAreaDetails ON CmmdtyHdgPlnExpsrHedgingArea = _HedgingAreaDetails.HedgingAreaIdentification AND HdggAreaMaximumValidFromDate = _HedgingAreaDetails.HedgingAreaValidFromDate  -- association [1..1]
;

Learn More