C_CmmdtyHdgPlnExpsrVersionTP

DDL: C_CMMDTYHDGPLNEXPSRVERSIONTP Type: view_entity CONSUMPTION
58 Fields 1 Data Sources 1 Associations

CMMDTY Plan Exposure Version Projection

C_CmmdtyHdgPlnExpsrVersionTP is a Consumption CDS View that provides data about "CMMDTY Plan Exposure Version Projection" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgPlnExpsrVersionTP) and exposes 58 fields with key field CommodityHedgePlanExposureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgPlnExpsrVersionTP R_CmmdtyHdgPlnExpsrVersionTP projection

Associations (1)

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

Annotations (7)

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

Fields (58)

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
char60
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
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus Status
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrVersionText CmmdtyHdgPlnExpsrVersionText
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrVersChgDteTme CmmdtyHdgPlnExpsrVersChgDteTme Time Stamp
CmmdtyHdgPlnExpsrStatusCritlty CmmdtyHdgPlnExpsrStatusCritlty
ControllingArea ControllingArea Controlling Area
PhysicalCommodity PhysicalCommodity
CmmdtyHdgPlnExpsrCoCodeText _CompanyCodeText CompanyCodeName Company Name
CmmdtyHdgPlanExposurePlantText _PlantText PlantName Plant Name
PlngDataDeliveryCategoryTextlocalized
CmmdtyHdgExpsrCrtedByUserText _CmmdtyHdgPlanExpsrUserText CmmdtyHdgExpsrCrtedByUserText
CmmdtyHdgExpsrChgdByUserText _CmmdtyHdgPlanExpsrUserText CmmdtyHdgExpsrChgdByUserText
PlanningDataIdentifier _CmmdtyHdgPlnExpsrPlngDtaText PlanningDataIdentifier Planning Data ID
CmmdtyHdgPlnExpsrHedgeBookTextlocalized
HedgingAreaUUID HedgingAreaUUID UUID
HedgingAreaText _CmHdgPlnExpsrHdggArLastRel HedgingAreaText Hdg Area Description
CmmdtyHdgPlnExpsrChgDocumentID CmmdtyHdgPlnExpsrChgDocumentID
_CmmdtyHdgPlanExpsrChgDoc _CmmdtyHdgPlanExpsrChgDoc
_PlantText _PlantText
_CompanyCodeText _CompanyCodeText
_HedgeBook _HedgeBook
_HedgeBookText _HedgeBookText

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_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 C_CmmdtyHdgPlnExpsrVersionTP AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  virtual CmmdtyHdgPlnExpsrDelivPerdText : abap.char( 60 ) AS char60,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrVersionText,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrVersChgDteTme,
  CmmdtyHdgPlnExpsrStatusCritlty,
  ControllingArea,
  PhysicalCommodity,
  _CompanyCodeText.CompanyCodeName AS CmmdtyHdgPlnExpsrCoCodeText,
  _PlantText.PlantName AS CmmdtyHdgPlanExposurePlantText,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized,
  _CmmdtyHdgPlanExpsrUserText.CmmdtyHdgExpsrCrtedByUserText AS CmmdtyHdgExpsrCrtedByUserText,
  _CmmdtyHdgPlanExpsrUserText.CmmdtyHdgExpsrChgdByUserText AS CmmdtyHdgExpsrChgdByUserText,
  _CmmdtyHdgPlnExpsrPlngDtaText.PlanningDataIdentifier AS PlanningDataIdentifier,
  _HedgeBookText.CmmdtyHdgPlnExpsrHedgeBookText : localized AS CmmdtyHdgPlnExpsrHedgeBookTextlocalized,
  HedgingAreaUUID,
  _CmHdgPlnExpsrHdggArLastRel.HedgingAreaText AS HedgingAreaText,
  CmmdtyHdgPlnExpsrChgDocumentID
FROM R_CmmdtyHdgPlnExpsrVersionTP
LEFT OUTER JOIN C_CmmdtyHdgPlanExpsrChangeDoc AS _CmmdtyHdgPlanExpsrChgDoc ON CmmdtyHdgPlnExpsrChgDocumentID = _CmmdtyHdgPlanExpsrChgDoc.ChangeDocObject  -- association [0..*]
;

Learn More