C_CmmdtyHdgPlnExpsrCoCodeVH

DDL: C_CMMDTYHDGPLNEXPSRCOCODEVH SQL: CCMMHDHEXPCOCDVH Type: view CONSUMPTION

Exposure Company Code

C_CmmdtyHdgPlnExpsrCoCodeVH is a Consumption CDS View that provides data about "Exposure Company Code" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 3 fields with key field CompanyCode. 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_CompanyCode I_CompanyCode from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CCMMHDHEXPCOCDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
EndUserText.label Exposure Company Code view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true 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 (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area

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_CmmdtyHdgPlnExpsrCoCodeVH.
-- 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: CCMMHDHEXPCOCDVH

CREATE VIEW C_CmmdtyHdgPlnExpsrCoCodeVH AS
SELECT
  CompanyCode,
  CompanyCodeName,
  ControllingArea
FROM I_CompanyCode
;