C_CmmdtyHedgePlanExposureCube

DDL: C_CMMDTYHEDGEPLANEXPOSURECUBE SQL: CCMMHDGPLNEXPSRC Type: view CONSUMPTION
48 Fields 2 Data Sources 5 Associations

Commodity Hedge Plan Exposure - Cube

C_CmmdtyHedgePlanExposureCube is a Consumption CDS View (Cube) that provides data about "Commodity Hedge Plan Exposure - Cube" in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyHdgExpsrLtstRelCmpst, I_CmmdtyHdgPlanExpsrComposite) and exposes 48 fields with key field CommodityHedgePlanExposureUUID. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CmmdtyHdgExpsrLtstRelCmpst _ReldVersion inner
I_CmmdtyHdgPlanExpsrComposite I_CmmdtyHdgPlanExpsrComposite from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CmmdtyHdgPlnExpsrIDDimension _ExposureID $projection.CommodityHedgePlanExposureUUID = _ExposureID.CommodityHedgePlanExposureUUID
[0..1] I_CompanyCode _CompanyCode $projection.CmmdtyHdgPlnExpsrCompanyCode = _CompanyCode.CompanyCode
[0..1] I_CmmdtyHdgDrvtvContrSpecCmpst _DerivativeContrSpec $projection.CmmdtyHedgePlanExposureDCSID = _DerivativeContrSpec.DerivativeContrSpecification
[0..1] I_CmmdtyHdgPlnExpsrHdgBookDimn _HedgeBooks $projection.CmmdtyHdgPlanExposureHedgeBook = _HedgeBooks.CmmdtyHdgPlanExposureHedgeBook
[0..1] I_CmmdtyHdgBookCompleteDetail _HedgeBookDetails $projection.CmmdtyHdgPlanExposureHedgeBook = _HedgeBookDetails.CommodityHedgeBookIdentifier

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCMMHDGPLNEXPSRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Commodity Hedge Plan Exposure - Cube view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.internalName #LOCAL view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID I_CmmdtyHdgPlanExpsrComposite CommodityHedgePlanExposureUUID UUID
CmmdtyHdgPlnExpsrCompanyCode I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgPlnExposureParentUUID I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExposureParentUUID UUID
CmmdtyHedgePlanExposureHashKey I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposureHashKey Semantic Hash Key
CmmdtyHedgePlanExposureDCSID I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlnExpsrHedgingArea I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgPlanExposureHedgeBook I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgBookAuthznGroup _HedgeBook CmmdtyHdgBookAuthznGroup
CmmdtyHdgPlnExpsrPerdStartDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrDelivStrtDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrDelivStrtDate Delivery Start Date
CmmdtyHdgPlnExpsrPerdStartYear
CmmdtyHdgPlnExpsrDelivPerdText I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrPeriodClass I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgPlnExpsrBusinessArea I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrBusinessArea Business Area
CmmdtyHdgPlnExpsrValidFromDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
CmmdtyHdgPlanExposurePortfolio I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExposurePortfolio Portfolio
CmmdtyHdgPlnExpsrProfitCenter I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrProfitCenter Profit Center
CmmdtyHdgPlnExposureCostCenter I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExposureCostCenter Cost Center
CmmdtyHedgePlanExposurePlant I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposurePlant Plant
CmmdtyHedgePlanExposureItemID I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposureItemID Exposure Item ID
CmmdtyHdgPlnExpsrIsAcctgRlvt I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrIsAcctgRlvt Hedge Accounting Relevance
CmmdtyHdgPlnExposureRemarkNote I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExposureRemarkNote Remark
CommodityHedgePlanExposureID I_CmmdtyHdgPlanExpsrComposite CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHdgPlanExposureCategory I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExposureCategory Exposure Category
CmmdtyHdgPlnExpsrDelivEndDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrPrcgStartDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
PlanningDataUUID I_CmmdtyHdgPlanExpsrComposite PlanningDataUUID UUID
CmmdtyHedgePlnExposureQuantity I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureLogHandle I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlanExposureLogHandle Log Handle
CmmdtyHedgePlanExposureStatus I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposureStatus Status
CmmdtyHedgePlanExposureVersion I_CmmdtyHdgPlanExpsrComposite CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrStsChgReason I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrCreatedByUser I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDateTime I_CmmdtyHdgPlanExpsrComposite CmmdtyHdgPlnExpsrChgDateTime Time Stamp
ControllingArea I_CmmdtyHdgPlanExpsrComposite ControllingArea Controlling Area
PhysicalCommodity I_CmmdtyHdgPlanExpsrComposite PhysicalCommodity
DerivativeContrSpecName
_ExposureID _ExposureID
_CompanyCode _CompanyCode
_DerivativeContrSpec _DerivativeContrSpec
_HedgeBooks _HedgeBooks
_HedgeBookDetails _HedgeBookDetails

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 C_CmmdtyHedgePlanExposureCube.
-- 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: CCMMHDGPLNEXPSRC

CREATE VIEW C_CmmdtyHedgePlanExposureCube AS
SELECT
  I_CmmdtyHdgPlanExpsrComposite.CommodityHedgePlanExposureUUID AS CommodityHedgePlanExposureUUID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExposureParentUUID AS CmmdtyHdgPlnExposureParentUUID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposureHashKey AS CmmdtyHedgePlanExposureHashKey,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrHedgingArea AS CmmdtyHdgPlnExpsrHedgingArea,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _HedgeBook.CmmdtyHdgBookAuthznGroup AS CmmdtyHdgBookAuthznGroup,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrPerdStartDate AS CmmdtyHdgPlnExpsrPerdStartDate,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrDelivStrtDate AS CmmdtyHdgPlnExpsrDelivStrtDate,
  substring( CmmdtyHdgPlnExpsrPerdStartDate ,1,4 ) AS CmmdtyHdgPlnExpsrPerdStartYear,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrDelivPerdText AS CmmdtyHdgPlnExpsrDelivPerdText,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrBusinessArea AS CmmdtyHdgPlnExpsrBusinessArea,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrValidFromDate AS CmmdtyHdgPlnExpsrValidFromDate,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExposurePortfolio AS CmmdtyHdgPlanExposurePortfolio,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrProfitCenter AS CmmdtyHdgPlnExpsrProfitCenter,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExposureCostCenter AS CmmdtyHdgPlnExposureCostCenter,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposurePlant AS CmmdtyHedgePlanExposurePlant,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposureItemID AS CmmdtyHedgePlanExposureItemID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrIsAcctgRlvt AS CmmdtyHdgPlnExpsrIsAcctgRlvt,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExposureRemarkNote AS CmmdtyHdgPlnExposureRemarkNote,
  I_CmmdtyHdgPlanExpsrComposite.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExposureCategory AS CmmdtyHdgPlanExposureCategory,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrDelivEndDate AS CmmdtyHdgPlnExpsrDelivEndDate,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  I_CmmdtyHdgPlanExpsrComposite.PlanningDataUUID AS PlanningDataUUID,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlnExposureQuantity AS CmmdtyHedgePlnExposureQuantity,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlanExposureLogHandle AS CmmdtyHdgPlanExposureLogHandle,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposureStatus AS CmmdtyHedgePlanExposureStatus,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrStsChgReason AS CmmdtyHdgPlnExpsrStsChgReason,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrCreatedByUser AS CmmdtyHdgPlnExpsrCreatedByUser,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrCrtnDateTime AS CmmdtyHdgPlnExpsrCrtnDateTime,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrLastChgdByUsr AS CmmdtyHdgPlnExpsrLastChgdByUsr,
  I_CmmdtyHdgPlanExpsrComposite.CmmdtyHdgPlnExpsrChgDateTime AS CmmdtyHdgPlnExpsrChgDateTime,
  I_CmmdtyHdgPlanExpsrComposite.ControllingArea AS ControllingArea,
  I_CmmdtyHdgPlanExpsrComposite.PhysicalCommodity AS PhysicalCommodity,
  _DerivativeContrSpec._Text[1:Language = $session.system_language ].DerivativeContrSpecName AS DerivativeContrSpecName
FROM I_CmmdtyHdgPlanExpsrComposite
INNER JOIN I_CmmdtyHdgExpsrLtstRelCmpst AS _ReldVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyHdgPlnExpsrIDDimension AS _ExposureID ON CommodityHedgePlanExposureUUID = _ExposureID.CommodityHedgePlanExposureUUID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CmmdtyHdgPlnExpsrCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgDrvtvContrSpecCmpst AS _DerivativeContrSpec ON CmmdtyHedgePlanExposureDCSID = _DerivativeContrSpec.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlnExpsrHdgBookDimn AS _HedgeBooks ON CmmdtyHdgPlanExposureHedgeBook = _HedgeBooks.CmmdtyHdgPlanExposureHedgeBook  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgBookCompleteDetail AS _HedgeBookDetails ON CmmdtyHdgPlanExposureHedgeBook = _HedgeBookDetails.CommodityHedgeBookIdentifier  -- association [0..1]
;

Learn More