C_CmmdtyHedgeRequestsOverview

DDL: C_CMMDTYHEDGEREQUESTSOVERVIEW SQL: CCMMHDGREQOVW Type: view CONSUMPTION Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
42 Fields 1 Data Sources 1 OData Services

Commodity Hedge Requests Overview

C_CmmdtyHedgeRequestsOverview is a Consumption CDS View that provides data about "Commodity Hedge Requests Overview" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHedgeRequestOverview) and exposes 42 fields with key fields CommodityHedgeRequestUUID, CmmdtyHedgeRequestIdentifier. It is exposed through 1 OData service (UI_CMMDTYHDGREQOVERVIEW). Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHedgeRequestOverview I_CmmdtyHedgeRequestOverview from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCMMHDGREQOVW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
EndUserText.label Commodity Hedge Requests Overview view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGREQOVERVIEW UI_CMMDTYHDGREQOVERVIEW V2 C1 NOT_RELEASED

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgeRequestUUID CommodityHedgeRequestUUID
KEY CmmdtyHedgeRequestIdentifier CmmdtyHedgeRequestIdentifier
CommodityHedgeRequestStatus CommodityHedgeRequestStatus
CmmdtyHdgReqStatusCriticality CmmdtyHdgReqStatusCriticality
CmmdtyHdgRequestCreatedByUser CmmdtyHdgRequestCreatedByUser
CmmdtyHdgReqCreatedByUserText CmmdtyHdgReqCreatedByUserText
CmmdtyHdgReqCreationDateTime CmmdtyHdgReqCreationDateTime
CmmdtyHdgReqLastChangedByUser CmmdtyHdgReqLastChangedByUser
CmmdtyHdgReqLastChgdByUserText CmmdtyHdgReqLastChgdByUserText
CmmdtyHdgReqLastChgdDateTime CmmdtyHdgReqLastChgdDateTime
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgPlnExpsrCoCodeText CmmdtyHdgPlnExpsrCoCodeText Company Name
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection Buy or Sell
PlanningDataDirectionText PlanningDataDirectionText
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
CommodityHedgeRequestType CommodityHedgeRequestType
CommodityHedgeRequestTypeText CommodityHedgeRequestTypeText
DerivativeContrSpecName DerivativeContrSpecName
CmmdtyHedgeBookDescription CmmdtyHedgeBookDescription
CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal
CmmdtyHdgFXHdgReqInstrCategory CmmdtyHdgFXHdgReqInstrCategory
CmmdtyHdgFXHdgRequestValueDate CmmdtyHdgFXHdgRequestValueDate
CmmdtyHdgFXHdgRequestAmount CmmdtyHdgFXHdgRequestAmount
CmmdtyHdgFXHdgRequestCurrency CmmdtyHdgFXHdgRequestCurrency
CmmdtyHdgFXHdgReqInstrCatText CmmdtyHdgFXHdgReqInstrCatText
CmmdtyHdgCnstltnIntCompanyCode CmmdtyHdgCnstltnIntCompanyCode
CompanyCodeName CompanyCodeName Company Name
CmmdtyHedgeRequestStatusText

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_CmmdtyHedgeRequestsOverview.
-- 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: CCMMHDGREQOVW

CREATE VIEW C_CmmdtyHedgeRequestsOverview AS
SELECT
  CommodityHedgeRequestUUID,
  CmmdtyHedgeRequestIdentifier,
  CommodityHedgeRequestStatus,
  CmmdtyHdgReqStatusCriticality,
  CmmdtyHdgRequestCreatedByUser,
  CmmdtyHdgReqCreatedByUserText,
  CmmdtyHdgReqCreationDateTime,
  CmmdtyHdgReqLastChangedByUser,
  CmmdtyHdgReqLastChgdByUserText,
  CmmdtyHdgReqLastChgdDateTime,
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHdgPlnExpsrCoCodeText,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExposureDirection,
  PlanningDataDirectionText,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrValidFromDate,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup,
  CommodityHedgeRequestType,
  CommodityHedgeRequestTypeText,
  DerivativeContrSpecName,
  CmmdtyHedgeBookDescription,
  CmmdtyHedgeConstellationDeal,
  CmmdtyHdgFXHdgReqInstrCategory,
  CmmdtyHdgFXHdgRequestValueDate,
  CmmdtyHdgFXHdgRequestAmount,
  CmmdtyHdgFXHdgRequestCurrency,
  CmmdtyHdgFXHdgReqInstrCatText,
  CmmdtyHdgCnstltnIntCompanyCode,
  CompanyCodeName,
  _CmmdtyHdgRequestStatusText[1:Language = $session.system_language ].CmmdtyHedgeRequestStatusText AS CmmdtyHedgeRequestStatusText
FROM I_CmmdtyHedgeRequestOverview
;

Learn More