R_CommodityHedgePlanExposureTP

DDL: R_COMMODITYHEDGEPLANEXPOSURETP Type: view_entity TRANSACTIONAL
68 Fields 1 Data Sources 2 Associations

CMMDTY Hedge Plan Exposure BO - TP

R_CommodityHedgePlanExposureTP is a Transactional CDS View that provides data about "CMMDTY Hedge Plan Exposure BO - TP" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlanExpsrComposite) and exposes 68 fields with key field CommodityHedgePlanExposureUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlanExpsrComposite I_CmmdtyHdgPlanExpsrComposite from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CmmdtyHdgPlanExpsrComposite _CommodityHedgePlanExpsrLstVer $projection.CommodityHedgePlanExposureID = _CommodityHedgePlanExpsrLstVer.CommodityHedgePlanExposureID and _CommodityHedgePlanExpsrLstVer.CmmdtyHdgPlnExpsrIsLtstVersion = 'X'
[1..*] R_CmmdtyHdgPlnExpsrVersionTP _ExposureVersion

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CMMDTY Hedge Plan Exposure BO - TP view
ObjectModel.representativeKey CommodityHedgePlanExposureUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CommodityPlanExposure view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
CmmdtyHdgPlnExposureParentUUID CmmdtyHdgPlnExposureParentUUID UUID
CmmdtyHedgePlanExposureHashKey CmmdtyHedgePlanExposureHashKey Semantic Hash Key
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgPlnExpsrBusinessArea CmmdtyHdgPlnExpsrBusinessArea Business Area
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
CmmdtyHdgPlanExposurePortfolio CmmdtyHdgPlanExposurePortfolio Portfolio
CmmdtyHdgPlnExpsrProfitCenter CmmdtyHdgPlnExpsrProfitCenter Profit Center
CmmdtyHdgPlnExposureCostCenter CmmdtyHdgPlnExposureCostCenter Cost Center
CmmdtyHedgePlanExposurePlant CmmdtyHedgePlanExposurePlant Plant
CmmdtyHedgePlanExposureItemID CmmdtyHedgePlanExposureItemID Exposure Item ID
CmmdtyHdgPlnExpsrIsAcctgRlvt CmmdtyHdgPlnExpsrIsAcctgRlvt Hedge Accounting Relevance
CmmdtyHdgPlnExposureRemarkNote CmmdtyHdgPlnExposureRemarkNote Remark
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHdgPlanExposureCategory CmmdtyHdgPlanExposureCategory Exposure Category
CmmdtyHdgPlnExpsrDelivStrtDate CmmdtyHdgPlnExpsrDelivStrtDate Delivery Start Date
CmmdtyHdgPlnExpsrDelivEndDate CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
PlanningDataUUID PlanningDataUUID UUID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureLogHandle CmmdtyHdgPlanExposureLogHandle Log Handle
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus Status
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrVersionText
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrIsToBeIgnored CmmdtyHdgPlnExpsrIsToBeIgnored
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime Time Stamp
CmmdtyHdgPlnExpsrChgDocumentID CmmdtyHdgPlnExpsrChgDocumentID
PhysicalCommodity PhysicalCommodity
ControllingArea ControllingArea Controlling Area
CmmdtyHdgPlnExpsrStatusCritlty CmmdtyHdgPlnExpsrStatusCritlty
CmmdtyHdgIsPrcgInDelivPeriod CmmdtyHdgIsPrcgInDelivPeriod
CmmdtyHdgPlnExpsrIsLtstVersion CmmdtyHdgPlnExpsrIsLtstVersion
CmmdtyHdgPlnExpsrVersIsHidden CmmdtyHdgPlnExpsrVersIsHidden
_CmmdtyHdgPlanExpsrStatus _CmmdtyHdgPlanExpsrStatus
_CmmdtyHdgPlngDataDirection _CmmdtyHdgPlngDataDirection
_MarketIdentCode _MarketIdentCode
_DrvtvContrSpec _DrvtvContrSpec
_BusinessArea _BusinessArea
_Portfolio _Portfolio
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_DeliveryCategory _DeliveryCategory
HedgingAreaUUID _CmHdgPlnExpsrHdggArLastRel HedgingAreaUUID UUID
_CmmdtyHdgPlanExpsrUserText _CmmdtyHdgPlanExpsrUserText
_CompanyCodeText _CompanyCodeText
_PlantText _PlantText
_CmHdgPlnExpsrHdggArLastRel _CmHdgPlnExpsrHdggArLastRel
_HedgeBookText _HedgeBookText
_ExposureVersion _ExposureVersion
_CmmdtyHdgPlnExpsrPlngDtaText _CmmdtyHdgPlnExpsrPlngDtaText
_HedgeBook _HedgeBook

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 R_CommodityHedgePlanExposureTP.
-- 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.

CREATE VIEW R_CommodityHedgePlanExposureTP AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  cast( concat( concat( ltrim(CmmdtyHedgePlanExposureVersion,'0'), '/'), ltrim( _CommodityHedgePlanExpsrLstVer.CmmdtyHedgePlanExposureVersion, '0') ) as abap.char( 7 ) ) AS CmmdtyHdgPlnExpsrVersionText,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrIsToBeIgnored,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDateTime,
  CmmdtyHdgPlnExpsrChgDocumentID,
  PhysicalCommodity,
  ControllingArea,
  CmmdtyHdgPlnExpsrStatusCritlty,
  CmmdtyHdgIsPrcgInDelivPeriod,
  CmmdtyHdgPlnExpsrIsLtstVersion,
  CmmdtyHdgPlnExpsrVersIsHidden,
  _CmHdgPlnExpsrHdggArLastRel.HedgingAreaUUID AS HedgingAreaUUID
FROM I_CmmdtyHdgPlanExpsrComposite
LEFT OUTER JOIN I_CmmdtyHdgPlanExpsrComposite AS _CommodityHedgePlanExpsrLstVer ON CommodityHedgePlanExposureID = _CommodityHedgePlanExpsrLstVer.CommodityHedgePlanExposureID AND _CommodityHedgePlanExpsrLstVer.CmmdtyHdgPlnExpsrIsLtstVersion = 'X'  -- association [0..1]
LEFT OUTER JOIN R_CmmdtyHdgPlnExpsrVersionTP AS _ExposureVersion ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More