I_CmmdtyHedgeReleasedExposure

DDL: I_CMMDTYHEDGERELEASEDEXPOSURE SQL: ICMMHDGRELEXP Type: view COMPOSITE
29 Fields 1 Data Sources 1 Associations

Commodity Hedge Reld Exposure

I_CmmdtyHedgeReleasedExposure is a Composite CDS View that provides data about "Commodity Hedge Reld Exposure" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlanExpsrComposite) and exposes 29 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlanExpsrComposite I_CmmdtyHdgPlanExpsrComposite from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CommodityHedgeDate _Today _Today.CommodityHedgeDate = _Today.CommodityHedgeDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHDGRELEXP view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commodity Hedge Reld Exposure view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrDelivStrtDate CmmdtyHdgPlnExpsrDelivStrtDate Delivery Start Date
CmmdtyHdgPlnExpsrDelivEndDate CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrIsHidden CmmdtyHdgPlnExpsrIsToBeIgnored
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime Time Stamp
CommodityHedgeDate _Today CommodityHedgeDate
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
PhysicalCommodity PhysicalCommodity
CmmdtyHdgIsPrcgInDelivPeriod CmmdtyHdgIsPrcgInDelivPeriod

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_CmmdtyHedgeReleasedExposure.
-- 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: ICMMHDGRELEXP

CREATE VIEW I_CmmdtyHedgeReleasedExposure AS
SELECT
  CommodityHedgePlanExposureUUID,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrIsToBeIgnored AS CmmdtyHdgPlnExpsrIsHidden,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDateTime,
  _Today.CommodityHedgeDate AS CommodityHedgeDate,
  CmmdtyHdgBookAuthznGroup,
  PhysicalCommodity,
  CmmdtyHdgIsPrcgInDelivPeriod
FROM I_CmmdtyHdgPlanExpsrComposite
LEFT OUTER JOIN I_CommodityHedgeDate AS _Today ON _Today.CommodityHedgeDate = _Today.CommodityHedgeDate  -- association [0..1]
;

Learn More