I_CmmdtyHdgSpecExpsrDealDetail

DDL: I_CMMDTYHDGSPECEXPSRDEALDETAIL SQL: IEXPSRDEALDETAIL Type: view COMPOSITE
11 Fields 2 Associations

Deal details with respect to exposure

I_CmmdtyHdgSpecExpsrDealDetail is a Composite CDS View that provides data about "Deal details with respect to exposure" in SAP S/4HANA. It has 2 associations to related views.

Parameters (1)

NameTypeDefault
P_CommodityHedgePlanExposureID cmm_exposure_id

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CommodityHedgeTransaction _Transaction $projection.CompanyCode = _Transaction.FinTransactionCompanyCode and $projection.CmmdtyHedgeConstellationDeal = _Transaction.FinTransactionDealIdentifier
[0..1] I_CmmdtyHdgHdggArClfnIndicator _HedgeClassInd _Transaction.HdggArHedgingClassification = _HedgeClassInd.HdggArHedgingClassification

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEXPSRDEALDETAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Deal details with respect to exposure view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure
KEY CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal
CompanyCode CompanyCode Receiver Company Code
HdggArHedgingClassification _Transaction HdggArHedgingClassification Hedging Classificatn
FinancialInstrumentProductType _Transaction FinancialInstrumentProductType
CmmdtyHdgCnstltnIntCompanyCode I_CmmdtyHdgConstellationDetail CmmdtyHdgCnstltnIntCompanyCode
CmmdtyHdgCnstltnIntDealNumber I_CmmdtyHdgConstellationDetail CmmdtyHdgCnstltnIntDealNumber
CmmdtyHdgCnstltnMirrorCoCode I_CmmdtyHdgConstellationDetail CmmdtyHdgCnstltnMirrorCoCode
CmmdtyHdgCnstltnMirrorDealID I_CmmdtyHdgConstellationDetail CmmdtyHdgCnstltnMirrorDealID
_Transaction _Transaction
_HedgeClassInd _HedgeClassInd

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 I_CmmdtyHdgSpecExpsrDealDetail.
-- 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: IEXPSRDEALDETAIL
-- Parameters: P_CommodityHedgePlanExposureID : cmm_exposure_id

CREATE VIEW I_CmmdtyHdgSpecExpsrDealDetail AS
SELECT
  CmmdtyHdgConstellationExposure,
  CmmdtyHedgeConstellationDeal,
  CompanyCode,
  _Transaction.HdggArHedgingClassification AS HdggArHedgingClassification,
  _Transaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_CmmdtyHdgConstellationDetail.CmmdtyHdgCnstltnIntCompanyCode AS CmmdtyHdgCnstltnIntCompanyCode,
  I_CmmdtyHdgConstellationDetail.CmmdtyHdgCnstltnIntDealNumber AS CmmdtyHdgCnstltnIntDealNumber,
  I_CmmdtyHdgConstellationDetail.CmmdtyHdgCnstltnMirrorCoCode AS CmmdtyHdgCnstltnMirrorCoCode,
  I_CmmdtyHdgConstellationDetail.CmmdtyHdgCnstltnMirrorDealID AS CmmdtyHdgCnstltnMirrorDealID
LEFT OUTER JOIN I_CommodityHedgeTransaction AS _Transaction ON CompanyCode = _Transaction.FinTransactionCompanyCode AND CmmdtyHedgeConstellationDeal = _Transaction.FinTransactionDealIdentifier  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgHdggArClfnIndicator AS _HedgeClassInd ON _Transaction.HdggArHedgingClassification = _HedgeClassInd.HdggArHedgingClassification  -- association [0..1]
;

Learn More