P_CmmdtyHdgFinTransCounterDeal

DDL: P_CMMDTYHDGFINTRANSCOUNTERDEAL Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_FTR
18 Fields 1 Data Sources 2 Associations

Commodity Hedging Financial Transaction CD

P_CmmdtyHdgFinTransCounterDeal is a Composite CDS View that provides data about "Commodity Hedging Financial Transaction CD" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgFinTransaction) and exposes 18 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier. It has 2 associations to related views. Part of development package FIN_CMM_CMDTY_HEDGE_FTR.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgFinTransaction I_CmmdtyHdgFinTransaction from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CommodityHedgePlanExposure _Exposure _Exposure.CommodityHedgePlanExposureUUID = _Exposure.CommodityHedgePlanExposureUUID
[1..1] I_CmmdtyHdgDdsgntnRequest _DedesingationRequest _DedesingationRequest.DedesignationRequestUUID = _DedesingationRequest.DedesignationRequestUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCMMHGFNTSCD 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 #A view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionCompanyCode FinTransactionCompanyCode
KEY FinTransactionDealIdentifier FinTransactionDealIdentifier
FinTransOnBehalfOfCompany FinTransOnBehalfOfCompany
FinTransactionObjectNumber FinTransactionObjectNumber
FinTransactionProductType FinTransactionProductType
FinTransactionCounterparty FinTransactionCounterparty
FinancialInstrTransactionType FinancialInstrTransactionType
FinancialTransactionHedgeBook FinancialTransactionHedgeBook
FinancialTransactionPortfolio FinancialTransactionPortfolio
FinTransGeneralValuationClass FinTransGeneralValuationClass
FinancialTransactionAssignment FinancialTransactionAssignment
FinTransInternalReference FinTransInternalReference
FinTransactionCharacteristic FinTransactionCharacteristic
FinTransHedgingClassification FinTransHedgingClassification Hedging Classification
FinancialTransactionDCSID _Exposure CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlnExpsrDelivPerdType _Exposure CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear _Exposure CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
DedesignationRequestCategory _DedesingationRequest DedesignationRequestCategory

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 P_CmmdtyHdgFinTransCounterDeal.
-- 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 P_CmmdtyHdgFinTransCounterDeal AS
SELECT
  FinTransactionCompanyCode,
  FinTransactionDealIdentifier,
  FinTransOnBehalfOfCompany,
  FinTransactionObjectNumber,
  FinTransactionProductType,
  FinTransactionCounterparty,
  FinancialInstrTransactionType,
  FinancialTransactionHedgeBook,
  FinancialTransactionPortfolio,
  FinTransGeneralValuationClass,
  FinancialTransactionAssignment,
  FinTransInternalReference,
  FinTransactionCharacteristic,
  FinTransHedgingClassification,
  _Exposure.CmmdtyHedgePlanExposureDCSID AS FinancialTransactionDCSID,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _DedesingationRequest.DedesignationRequestCategory AS DedesignationRequestCategory
FROM I_CmmdtyHdgFinTransaction
LEFT OUTER JOIN I_CommodityHedgePlanExposure AS _Exposure ON _Exposure.CommodityHedgePlanExposureUUID = _Exposure.CommodityHedgePlanExposureUUID  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyHdgDdsgntnRequest AS _DedesingationRequest ON _DedesingationRequest.DedesignationRequestUUID = _DedesingationRequest.DedesignationRequestUUID  -- association [1..1]
;

Learn More