C_CommodityHedgePlanExposureTP

DDL: C_COMMODITYHEDGEPLANEXPOSURETP Type: view_entity CONSUMPTION
72 Fields 1 Data Sources 1 Associations

Commodity Plan Exposure

C_CommodityHedgePlanExposureTP is a Consumption CDS View that provides data about "Commodity Plan Exposure" in SAP S/4HANA. It reads from 1 data source (R_CommodityHedgePlanExposureTP) and exposes 72 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CommodityHedgePlanExposureTP R_CommodityHedgePlanExposureTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CmmdtyHdgPlanExpsrChangeDoc _CmmdtyHdgPlanExpsrChgDoc $projection.CmmdtyHdgPlnExpsrChgDocumentID = _CmmdtyHdgPlanExpsrChgDoc.ChangeDocObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Commodity Plan Exposure view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (72)

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
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
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
PlanningDataUUID PlanningDataUUID UUID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureLogHandle CmmdtyHdgPlanExposureLogHandle Log Handle
CmmdtyHdgPlnExpsrIsLogAvail CmmdtyHdgPlnExpsrIsLogAvail
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus Status
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrVersionText CmmdtyHdgPlnExpsrVersionText
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrIsToBeIgnored CmmdtyHdgPlnExpsrIsToBeIgnored
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrStatusCritlty CmmdtyHdgPlnExpsrStatusCritlty
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime Time Stamp
ControllingArea ControllingArea Controlling Area
PhysicalCommodity PhysicalCommodity
CmmdtyHdgPlnExpsrVersIsHidden CmmdtyHdgPlnExpsrVersIsHidden
CmmdtyHdgPlnExpsrIsLtstVersion CmmdtyHdgPlnExpsrIsLtstVersion
CmmdtyHdgPlnExpsrCoCodeText _CompanyCodeText CompanyCodeName Company Name
CmmdtyHdgPlanExposurePlantText _PlantText PlantName Plant Name
CmmdtyHdgPlnExpsrHedgeBookTextlocalized
PlanningDataIdentifier _CmmdtyHdgPlnExpsrPlngDtaText PlanningDataIdentifier Planning Data ID
PlngDataDeliveryCategoryTextlocalized
CmmdtyHdgExpsrCrtedByUserText _CmmdtyHdgPlanExpsrUserText CmmdtyHdgExpsrCrtedByUserText
CmmdtyHdgExpsrChgdByUserText _CmmdtyHdgPlanExpsrUserText CmmdtyHdgExpsrChgdByUserText
HedgingAreaText _CmHdgPlnExpsrHdggArLastRel HedgingAreaText Hdg Area Description
int1
char132
CmmdtyHdgPlnExpsrChgDocumentID CmmdtyHdgPlnExpsrChgDocumentID
HedgingAreaUUID HedgingAreaUUID UUID
_CmmdtyHdgPlanExpsrChgDoc _CmmdtyHdgPlanExpsrChgDoc
_HedgeBook _HedgeBook
_CmmdtyHdgPlanExpsrStatus _CmmdtyHdgPlanExpsrStatus
_CmmdtyHdgPlngDataDirection _CmmdtyHdgPlngDataDirection
_MarketIdentCode _MarketIdentCode
_DrvtvContrSpec _DrvtvContrSpec
_BusinessArea _BusinessArea
_Portfolio _Portfolio
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_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 C_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 C_CommodityHedgePlanExposureTP AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHdgPlnExpsrIsLogAvail,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrVersionText,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrIsToBeIgnored,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrStatusCritlty,
  CmmdtyHdgPlnExpsrChgDateTime,
  ControllingArea,
  PhysicalCommodity,
  CmmdtyHdgPlnExpsrVersIsHidden,
  CmmdtyHdgPlnExpsrIsLtstVersion,
  _CompanyCodeText.CompanyCodeName AS CmmdtyHdgPlnExpsrCoCodeText,
  _PlantText.PlantName AS CmmdtyHdgPlanExposurePlantText,
  _HedgeBookText.CmmdtyHdgPlnExpsrHedgeBookText : localized AS CmmdtyHdgPlnExpsrHedgeBookTextlocalized,
  _CmmdtyHdgPlnExpsrPlngDtaText.PlanningDataIdentifier AS PlanningDataIdentifier,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized,
  _CmmdtyHdgPlanExpsrUserText.CmmdtyHdgExpsrCrtedByUserText AS CmmdtyHdgExpsrCrtedByUserText,
  _CmmdtyHdgPlanExpsrUserText.CmmdtyHdgExpsrChgdByUserText AS CmmdtyHdgExpsrChgdByUserText,
  _CmHdgPlnExpsrHdggArLastRel.HedgingAreaText AS HedgingAreaText,
  virtual CmmdtyHdgPlnExpsrQtyCritlty : abap.int1 AS int1,
  virtual CmmdtyHdgPlnExpsrDiffQtyText : abap.char( 132 ) AS char132,
  CmmdtyHdgPlnExpsrChgDocumentID,
  HedgingAreaUUID
FROM R_CommodityHedgePlanExposureTP
LEFT OUTER JOIN C_CmmdtyHdgPlanExpsrChangeDoc AS _CmmdtyHdgPlanExpsrChgDoc ON CmmdtyHdgPlnExpsrChgDocumentID = _CmmdtyHdgPlanExpsrChgDoc.ChangeDocObject  -- association [0..*]
;

Learn More