C_CmmdtyHdgPlanExpsrQuery

DDL: C_CMMDTYHDGPLANEXPSRQUERY SQL: CCMMHDGPLNEXPRSQ Type: view CONSUMPTION
41 Fields 1 Data Sources

Commodity Hedge Plan Exposure - Query

C_CmmdtyHdgPlanExpsrQuery is a Consumption CDS View that provides data about "Commodity Hedge Plan Exposure - Query" in SAP S/4HANA. It reads from 1 data source (C_CmmdtyHedgePlanExposureCube) and exposes 41 fields with key fields CommodityHedgePlanExposureUUID, CmmdtyHdgPlnExpsrCompanyCode, CmmdtyHedgePlanExposureDCSID.

Data Sources (1)

SourceAliasJoin Type
C_CmmdtyHedgePlanExposureCube C_CmmdtyHedgePlanExposureCube from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CCMMHDGPLNEXPRSQ view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Commodity Hedge Plan Exposure - Query view
Analytics.query true view
OData.publish true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
UI.headerInfo.typeName Commodity view
UI.headerInfo.typeNamePlural Commodity view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID Plan Exposure UUID
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company
KEY CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHdgPlnExposureParentUUID CmmdtyHdgPlnExposureParentUUID UUID
CmmdtyHedgePlanExposureHashKey CmmdtyHedgePlanExposureHashKey Semantic Hash Key
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrPerdStartYear CmmdtyHdgPlnExpsrPerdStartYear Delivery Period Start Year
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Delivery Period
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgPlnExpsrBusinessArea CmmdtyHdgPlnExpsrBusinessArea Business Area
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
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 Plan Exposure Quantity
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Version No.
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureLogHandle CmmdtyHdgPlanExposureLogHandle Log Handle
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus Status
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime Time Stamp
ControllingArea ControllingArea Controlling Area
PhysicalCommodity PhysicalCommodity

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_CmmdtyHdgPlanExpsrQuery.
-- 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: CCMMHDGPLNEXPRSQ

CREATE VIEW C_CmmdtyHdgPlanExpsrQuery AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPerdStartYear,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDateTime,
  ControllingArea,
  PhysicalCommodity
FROM C_CmmdtyHedgePlanExposureCube
;

Learn More