I_CmHdgExpsrLtstRelByValidFrom

DDL: I_CMHDGEXPSRLTSTRELBYVALIDFROM SQL: ICMMEXPLSTRLDVF Type: view COMPOSITE
6 Fields 1 Data Sources

Exposure Last Release By Valid From

I_CmHdgExpsrLtstRelByValidFrom is a Composite CDS View that provides data about "Exposure Last Release By Valid From" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHedgeReleasedExposure) and exposes 6 fields with key fields CommodityHedgePlanExposureID, CmmdtyHdgPlnExpsrValidFromDate.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHedgeReleasedExposure I_CmmdtyHedgeReleasedExposure from

Parameters (1)

NameTypeDefault
P_EvalDate dats

Annotations (11)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
KEY CmmdtyHdgPlnExpsrValidFromDate
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
PhysicalCommodity 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_CmHdgExpsrLtstRelByValidFrom.
-- 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: ICMMEXPLSTRLDVF
-- Parameters: P_EvalDate : dats

CREATE VIEW I_CmHdgExpsrLtstRelByValidFrom AS
SELECT
  CommodityHedgePlanExposureID,
  max( CmmdtyHdgPlnExpsrValidFromDate) AS CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgBookAuthznGroup,
  PhysicalCommodity
FROM I_CmmdtyHedgeReleasedExposure
;

Learn More