C_CmmdtyHdgDdsgntnReqStatusVH

DDL: C_CMMDTYHDGDDSGNTNREQSTATUSVH Type: view_entity CONSUMPTION
2 Fields 1 Data Sources 1 Associations 2 OData Services 2 Fiori Apps

Dedesignation request status

C_CmmdtyHdgDdsgntnReqStatusVH is a Consumption CDS View that provides data about "Dedesignation request status" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgDdsgntnReqStatus) and exposes 2 fields with key field DedesignationRequestStatus. It has 1 association to related views. It is exposed through 2 OData services (UI_CMMDTYHDGCNTRDEALREQ, UI_CMMDTYHDGDDSGNTNREQUEST). It is used in 2 Fiori applications: Manage Commodity Counter Deal Request, Manage Commodity Dedesignation Request.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgDdsgntnReqStatus I_CmmdtyHdgDdsgntnReqStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CmmdtyHdgDdsgntnReqStsText _CmmdtyHdgDdsgntnReqStsText $projection.DedesignationRequestStatus = _CmmdtyHdgDdsgntnReqStsText.SystemStatus and _CmmdtyHdgDdsgntnReqStsText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.representativeKey DedesignationRequestStatus view
ObjectModel.resultSet.sizeCategory #XS view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Dedesignation request status view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGCNTRDEALREQ UI_CMMDTYHDGCNTRDEALREQ V2 C1 NOT_RELEASED
UI_CMMDTYHDGDDSGNTNREQUEST UI_CMMDTYHDGDDSGNTNREQUEST V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5659 Manage Commodity Counter Deal Request Transactional
F5660 Manage Commodity Dedesignation Request Transactional

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DedesignationRequestStatus SystemStatus
_CmmdtyHdgDdsgntnReqStsText _CmmdtyHdgDdsgntnReqStsText

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_CmmdtyHdgDdsgntnReqStatusVH.
-- 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_CmmdtyHdgDdsgntnReqStatusVH AS
SELECT
  SystemStatus AS DedesignationRequestStatus
FROM I_CmmdtyHdgDdsgntnReqStatus
LEFT OUTER JOIN I_CmmdtyHdgDdsgntnReqStsText AS _CmmdtyHdgDdsgntnReqStsText ON DedesignationRequestStatus = _CmmdtyHdgDdsgntnReqStsText.SystemStatus AND _CmmdtyHdgDdsgntnReqStsText.Language = $session.system_language  -- association [0..1]
;

Learn More