R_CmmdtyHdgPlnExpsrVersionTP

DDL: R_CMMDTYHDGPLNEXPSRVERSIONTP Type: view_entity TRANSACTIONAL Package: FIN_CMM_CMDTY_PLAN_EXPOSURE
64 Fields 1 Data Sources 1 Associations

CMMDTY Hedge Plan Exposure Versions - TP

R_CmmdtyHdgPlnExpsrVersionTP is a Transactional CDS View that provides data about "CMMDTY Hedge Plan Exposure Versions - TP" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlanExpsrComposite) and exposes 64 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views. Part of development package FIN_CMM_CMDTY_PLAN_EXPOSURE.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlanExpsrComposite I_CmmdtyHdgPlanExpsrComposite from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CMMDTY Hedge Plan Exposure Versions - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (64)

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
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
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
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDocumentID CmmdtyHdgPlnExpsrChgDocumentID
CmmdtyHdgPlnExpsrStatusCritlty CmmdtyHdgPlnExpsrStatusCritlty
CmmdtyHdgPlnExpsrVersChgDteTme CmmdtyHdgPlnExpsrChgDateTime Time Stamp
ControllingArea ControllingArea Controlling Area
PhysicalCommodity PhysicalCommodity
HedgingAreaUUID _CmHdgPlnExpsrHdggArLastRel HedgingAreaUUID UUID
_CompanyCodeText _CompanyCodeText
_PlantText _PlantText
_CmHdgPlnExpsrHdggArLastRel _CmHdgPlnExpsrHdggArLastRel
_CmmdtyHdgPlnExpsrPlngDtaText _CmmdtyHdgPlnExpsrPlngDtaText
_Exposure _Exposure
_HedgeBook _HedgeBook
_HedgeBookText _HedgeBookText
_CmmdtyHdgPlanExpsrStatus _CmmdtyHdgPlanExpsrStatus
_CmmdtyHdgPlngDataDirection _CmmdtyHdgPlngDataDirection
_MarketIdentCode _MarketIdentCode
_DrvtvContrSpec _DrvtvContrSpec
_BusinessArea _BusinessArea
_Portfolio _Portfolio
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_CmmdtyHdgPlanExpsrUserText _CmmdtyHdgPlanExpsrUserText
_DeliveryCategory _DeliveryCategory

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_CmmdtyHdgPlnExpsrVersionTP.
-- 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_CmmdtyHdgPlnExpsrVersionTP 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,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrDelivPerdText,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  cast( concat( concat( ltrim(CmmdtyHedgePlanExposureVersion,'0'), '/'), ltrim( _CommodityHedgePlanExpsrLstVer.CmmdtyHedgePlanExposureVersion, '0') ) as abap.char( 7 ) ) AS CmmdtyHdgPlnExpsrVersionText,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDocumentID,
  CmmdtyHdgPlnExpsrStatusCritlty,
  CmmdtyHdgPlnExpsrChgDateTime AS CmmdtyHdgPlnExpsrVersChgDteTme,
  ControllingArea,
  PhysicalCommodity,
  _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]
;

Learn More