C_CmmdtyHdgCntrdealRequestTP

DDL: C_CMMDTYHDGCNTRDEALREQUESTTP Type: view_entity CONSUMPTION Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
54 Fields 1 Data Sources 1 Associations 1 OData Services

Counter Deal Request Consumption

C_CmmdtyHdgCntrdealRequestTP is a Consumption CDS View that provides data about "Counter Deal Request Consumption" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgCntrdealRequestTP) and exposes 54 fields with key field CounterdealRequestUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_CMMDTYHDGCNTRDEALREQ). Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgCntrdealRequestTP R_CmmdtyHdgCntrdealRequestTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CmmdtyHdgCntrdealReqChgDoc _CounterdealReqChgDoc $projection.CounterdealReqChangeDocumentID = _CounterdealReqChgDoc.ChangeDocObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Counter Deal Request Consumption view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGCNTRDEALREQ UI_CMMDTYHDGCNTRDEALREQ V2 C1 NOT_RELEASED

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CounterdealRequestUUID CounterdealRequestUUID
CounterdealRequestIdentifier CounterdealRequestIdentifier
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
DedesignationRequestUUID DedesignationRequestUUID
CounterdealRequestDate CounterdealRequestDate
CounterdealRequestRemarkNote CounterdealRequestRemarkNote
CounterdealRequestLogHandle CounterdealRequestLogHandle
CntrdealReqIsApplLogAvailable CntrdealReqIsApplLogAvailable
CounterdealRequestStatus CounterdealRequestStatus
CntrdealReqStatusChangeReason CntrdealReqStatusChangeReason
CntrdealReqStatusCriticality CntrdealReqStatusCriticality
CntrdealReqCreationDateTime CntrdealReqCreationDateTime
CntrdealRequestCreatedByUser CntrdealRequestCreatedByUser
CntrdealReqCreatedByUserText _CntrdealReqUserText CntrdealReqCreatedByUserText
CntrdealReqLastChangedByUser CntrdealReqLastChangedByUser
CntrdealReqLastChgdByUserText _CntrdealReqUserText CntrdealReqLastChgdByUserText
CntrdealReqLastChangedDateTime CntrdealReqLastChangedDateTime
CounterdealReqChangeDocumentID CounterdealReqChangeDocumentID
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgPlnExpsrCoCodeText _CompanyCode CompanyCodeName 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
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
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
CmmdtyHdgPlnExposureRemarkNote CmmdtyHdgPlnExposureRemarkNote Remark
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
CntrdealDdsgntnRequestIsHidden CntrdealDdsgntnRequestIsHidden
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
DedesignationRequestIdentifier _DedesignationRequest DedesignationRequestIdentifier
char132
int1
char132
char132
char132
int1
char132
int1
_CompanyCode _CompanyCode
_Exposure _Exposure
CmmdtyHedgeBookDescriptionlocalized
DerivativeContrSpecNamelocalized
PlngDataDeliveryCategoryTextlocalized
_CounterdealReqChgDoc _CounterdealReqChgDoc

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_CmmdtyHdgCntrdealRequestTP.
-- 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_CmmdtyHdgCntrdealRequestTP AS
SELECT
  CounterdealRequestUUID,
  CounterdealRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  DedesignationRequestUUID,
  CounterdealRequestDate,
  CounterdealRequestRemarkNote,
  CounterdealRequestLogHandle,
  CntrdealReqIsApplLogAvailable,
  CounterdealRequestStatus,
  CntrdealReqStatusChangeReason,
  CntrdealReqStatusCriticality,
  CntrdealReqCreationDateTime,
  CntrdealRequestCreatedByUser,
  _CntrdealReqUserText.CntrdealReqCreatedByUserText AS CntrdealReqCreatedByUserText,
  CntrdealReqLastChangedByUser,
  _CntrdealReqUserText.CntrdealReqLastChgdByUserText AS CntrdealReqLastChgdByUserText,
  CntrdealReqLastChangedDateTime,
  CounterdealReqChangeDocumentID,
  LocalLastChangeDateTime,
  CmmdtyHdgPlnExpsrCompanyCode,
  _CompanyCode.CompanyCodeName AS CmmdtyHdgPlnExpsrCoCodeText,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExposureRemarkNote,
  CmmdtyHdgPlnExpsrValidFromDate,
  CntrdealDdsgntnRequestIsHidden,
  CmmdtyHedgePlanExposureVersion,
  _DedesignationRequest.DedesignationRequestIdentifier AS DedesignationRequestIdentifier,
  virtual CntrdealReqBeforeOverHedgeText : abap.char( 132 ) AS char132,
  virtual CntrdealBfrOvrHedgeCriticality : abap.int1 AS int1,
  _Exposure._HedgeBook._CmmdtyHdgBookText.CmmdtyHedgeBookDescription : localized AS CmmdtyHedgeBookDescriptionlocalized,
  _DrvtvContrSpec._Text.DerivativeContrSpecName : localized AS DerivativeContrSpecNamelocalized,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized
FROM R_CmmdtyHdgCntrdealRequestTP
LEFT OUTER JOIN C_CmmdtyHdgCntrdealReqChgDoc AS _CounterdealReqChgDoc ON CounterdealReqChangeDocumentID = _CounterdealReqChgDoc.ChangeDocObject  -- association [0..*]
;

Learn More