C_CmmdtyHdgPlnExpsrHedgeBookVH

DDL: C_CMMDTYHDGPLNEXPSRHEDGEBOOKVH SQL: CCMMEXPSRHBVH Type: view CONSUMPTION
4 Fields 1 Data Sources 5 OData Services 6 Fiori Apps

Commodity Hedge Plan Exposure Hedge Book

C_CmmdtyHdgPlnExpsrHedgeBookVH is a Consumption CDS View that provides data about "Commodity Hedge Plan Exposure Hedge Book" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlnExpsrHedgeBook) and exposes 4 fields with key field CmmdtyHdgPlanExposureHedgeBook. It is exposed through 5 OData services (UI_CMMDTYHDGCNTRDEALREQ, UI_CMMDTYHDGDDSGNTNREQUEST, UI_CMMDTYHDGMIGRATIONREQ, ...). It is used in 6 Fiori applications: Observe and Monitor Deal Requests, Manage Commodity Counter Deal Request, Manage Commodity Dedesignation Request, ....

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlnExpsrHedgeBook I_CmmdtyHdgPlnExpsrHedgeBook from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCMMEXPSRHBVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.representativeKey CmmdtyHdgPlanExposureHedgeBook view
Consumption.ranked true view
Search.searchable true view
EndUserText.label Commodity Hedge Plan Exposure Hedge Book view

OData Services (5)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGCNTRDEALREQ UI_CMMDTYHDGCNTRDEALREQ V2 C1 NOT_RELEASED
UI_CMMDTYHDGDDSGNTNREQUEST UI_CMMDTYHDGDDSGNTNREQUEST V2 C1 NOT_RELEASED
UI_CMMDTYHDGMIGRATIONREQ UI_CMMDTYHDGMIGRATIONREQ V2 C1 NOT_RELEASED
UI_CMMDTYHDGRCLASSFCTNREQ UI_CMMDTYHDGRCLASSFCTNREQ V2 C1 NOT_RELEASED
UI_CMMDTYHDGREQOVERVIEW UI_CMMDTYHDGREQOVERVIEW V2 C1 NOT_RELEASED

Fiori Apps (6)

App IDApp NameTypeDescription
F5655 Observe and Monitor Deal Requests Transactional
F5659 Manage Commodity Counter Deal Request Transactional
F5660 Manage Commodity Dedesignation Request Transactional
F5666 Manage Hedge Constellations Tasklist Transactional
F5667 Manage Reclassification Request Transactional
F5668 Manage Migration Request Transactional

Observe and Monitor Deal Requests

Business Role: Trading Manager - Commodity Derivative Orders

With this Fiori app (ID F5655), you can track and see the details of all requests created in Commodity Price Risk Hedge Accounting.

Manage Commodity Counter Deal Request

Business Role: Commodity Risk Manager - Hedge Accounting

With this Fiori app (ID F5659), counter deal requests can be created for non-hedge accounting trades causing gross or net over-hedges, and for freestanding trades.

Manage Commodity Dedesignation Request

Business Role: Commodity Risk Manager - Hedge Accounting

With this Fiori app (ID F5666), you can create dedesignation requests for financial commodity trades of selected exposures. You can use this app to do the following: Create and process dedesignation requests to resolve over-hedge situations of selected exposures Decide, whether you want to follow the system"s proposal on the OCI handling (OCI freeze or immediate reclassification) Decide, whether you want to follow the system"s proposal on the counterdeal creation Analyze the over-hedge situation before and after the assignment of trades to be dedesignated

Manage Hedge Constellations Tasklist

Business Role: Commodity Risk Manager - Hedge Accounting

With this Fiori app (ID F5666), you can manage tasks as part of the change process that were created automatically or manually for certain reasons and due to inconsistencies.

Manage Reclassification Request

Business Role: Commodity Risk Manager - Hedge Accounting

With this Fiori app (ID F5667), you can create and manage commodity reclassification requests. During a hedging relationship, a dedesignation request can be applied where you can specify, how the OCI shall be handled: Immediate reclassification or OCI Freeze. At the end of the pricing period, (latest at payment date) the hedging relationship is dedesignated automatically (planned dedesignation). After a dedesignation and before the basis adjustment, it can be required (e.g due to a decreased exposure) to reclassify the frozen OCI for one or more assigned financial trades to P/L. For this, reclassification requests can be created automatically (via report) or manually in the app Manage Commodity Reclassification Requests: Manual reclassifications can be initiated from the app Manage Commodity Reclassification Requests. Manual reclassification requests are only possible for settled financial trades where the exposure quantiy decreased after the exposure"s pricing period. The same is true if there was a comprehensive loss in the hedging relationship where the OCI is frozen, and where the loss will unlikely be compensated by the profit made from the produced goods. The user can select and deselect final candidates to be reclassified. Reclassification requests can be automatically created for net dedesignated trades even before the end of the exposure"s pricing period. Both, automatically and manually created reclassification requests, can contain one or multiple financial trades. Trades that are taken into account are always completely reclassified. Continuous reclassifications are automatically created with the report Create Reclassification Requests. Trades determined by the report can be reclassified as proposed. It is not possible, to select or deselect single trades. Instead, you can cancel an entire reclassification request and re-entered it as a manual reclassification request.

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlnExpsrHedgeBookText _HedgeBookText CmmdtyHdgPlnExpsrHedgeBookText Hedge Book Description
DerivativeContrSpecName _DCSIDText DerivativeContrSpecName
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup

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_CmmdtyHdgPlnExpsrHedgeBookVH.
-- 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: CCMMEXPSRHBVH

CREATE VIEW C_CmmdtyHdgPlnExpsrHedgeBookVH AS
SELECT
  CmmdtyHdgPlanExposureHedgeBook,
  _HedgeBookText.CmmdtyHdgPlnExpsrHedgeBookText AS CmmdtyHdgPlnExpsrHedgeBookText,
  _DCSIDText.DerivativeContrSpecName AS DerivativeContrSpecName,
  CmmdtyHdgBookAuthznGroup
FROM I_CmmdtyHdgPlnExpsrHedgeBook
;

Learn More