I_CmmdtyHdgPlnExpsrHdgBookDimn

DDL: I_CMMDTYHDGPLNEXPSRHDGBOOKDIMN SQL: ICMMEXPSRHBDIMN Type: view COMPOSITE Package: FIN_CMM_CMDTY_PLAN_EXPOSURE
2 Fields 1 Data Sources 1 Associations

Commodity Hdg Exposure Hedge Book - Text

I_CmmdtyHdgPlnExpsrHdgBookDimn is a Composite CDS View (Dimension) that provides data about "Commodity Hdg Exposure Hedge Book - Text" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlnExpsrHedgeBook) and exposes 2 fields with key field CmmdtyHdgPlanExposureHedgeBook. It has 1 association to related views. Part of development package FIN_CMM_CMDTY_PLAN_EXPOSURE.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlnExpsrHedgeBook I_CmmdtyHdgPlnExpsrHedgeBook from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CmmdtyHdgPlnExpsrHedgeBookT _Text $projection.CmmdtyHdgPlanExposureHedgeBook = _Text.CmmdtyHdgPlanExposureHedgeBook

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICMMEXPSRHBDIMN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commodity Hdg Exposure Hedge Book - Text view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey CmmdtyHdgPlanExposureHedgeBook view
ObjectModel.resultSet.sizeCategory #XS view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
_Text _Text

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_CmmdtyHdgPlnExpsrHdgBookDimn.
-- 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: ICMMEXPSRHBDIMN

CREATE VIEW I_CmmdtyHdgPlnExpsrHdgBookDimn AS
SELECT
  CmmdtyHdgPlanExposureHedgeBook
FROM I_CmmdtyHdgPlnExpsrHedgeBook
LEFT OUTER JOIN I_CmmdtyHdgPlnExpsrHedgeBookT AS _Text ON CmmdtyHdgPlanExposureHedgeBook = _Text.CmmdtyHdgPlanExposureHedgeBook  -- association [0..*]
;

Learn More