I_CmmdtyHdgExpsrRelByDteCmpst

DDL: I_CMMDTYHDGEXPSRRELBYDTECMPST SQL: ICMMEXPLTRELDTEC Type: view COMPOSITE
29 Fields 1 Data Sources 1 Associations

Exposure Latest Release By Date

I_CmmdtyHdgExpsrRelByDteCmpst is a Composite CDS View that provides data about "Exposure Latest Release By Date" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgExpsrLtstRelByDate) and exposes 29 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgExpsrLtstRelByDate I_CmmdtyHdgExpsrLtstRelByDate from

Parameters (1)

NameTypeDefault
P_EvalDate dats

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmmdtyHedgeReleasedExposure _ReleasedExposure $projection.CommodityHedgePlanExposureID = _ReleasedExposure.CommodityHedgePlanExposureID and $projection.CmmdtyHdgPlnExpsrLastDateTime = _ReleasedExposure.CmmdtyHdgPlnExpsrChgDateTime

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMMEXPLTRELDTEC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Exposure Latest Release By Date view

Fields (29)

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

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_CmmdtyHdgExpsrRelByDteCmpst.
-- 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: ICMMEXPLTRELDTEC
-- Parameters: P_EvalDate : dats

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

Learn More