P_CmmdtyHdgFXFinTransFlow

DDL: P_CMMDTYHDGFXFINTRANSFLOW Type: view COMPOSITE
24 Fields 2 Data Sources 1 Associations

P_CmmdtyHdgFXFinTransFlow is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (vtbfha, I_CmmdtyFinTransactionFlow) and exposes 24 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
vtbfha fha from
I_CmmdtyFinTransactionFlow fhapo inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DerivativeContrSpec _DCS _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCMMFXFINTRNSFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfha bukrs Value
KEY FinancialTransaction vtbfha rfha Transaction
KEY FinancialInstrumentActivity I_CmmdtyFinTransactionFlow FinancialInstrumentActivity Activity
KEY FinTransFlowNumber I_CmmdtyFinTransactionFlow FinTransFlowNumber Flow
KEY FinTransCreationDate I_CmmdtyFinTransactionFlow FinTransCreationDate Entry Date
KEY FinTransFlowCreationTime I_CmmdtyFinTransactionFlow FinTransFlowCreationTime Entry Time
FinTransFlowPaymentDate I_CmmdtyFinTransactionFlow FinTransFlowPaymentDate Payment Date
FinTransactionPricingStartDate I_CmmdtyFinTransactionFlow FinTransactionPricingStartDate CalculationFrom
FinTransactionPricingEndDate I_CmmdtyFinTransactionFlow FinTransactionPricingEndDate Calculation To
TermEndDate vtbfha delfz Term End
FinTransHedgingClassification vtbfha hedge_class Hedging Classificatn
FinTransOnBehalfOfCompany vtbfha behalf_of_company On Behalf of CoCode
FinTransacTradedPriceAmount I_CmmdtyFinTransactionFlow FinTransacTradedPriceAmount Price
FinTransTradedPriceCrcyUnit I_CmmdtyFinTransactionFlow FinTransTradedPriceCrcyUnit Currency Unit
FinancialTransactionDirection I_CmmdtyFinTransactionFlow FinancialTransactionDirection Direction
DerivativeContrSpecification I_CmmdtyFinTransactionFlow DerivativeContrSpecification DCS ID
MarketIdentifierCode I_CmmdtyFinTransactionFlow MarketIdentifierCode MIC
Quantity I_CmmdtyFinTransactionFlow Quantity Value
UnitOfMeasure I_CmmdtyFinTransactionFlow UnitOfMeasure Unit Protected Qty
CommodityPriceExposureUnit I_CmmdtyFinTransactionFlow CommodityPriceExposureUnit Unit of Measure
FinancialTransactionAmount I_CmmdtyFinTransactionFlow FinancialTransactionAmount Payment Amnt in PyC
FinTransFlowPaytAmtCrcy I_CmmdtyFinTransactionFlow FinTransFlowPaytAmtCrcy Payment Currency
FinTransFlowIntrstRateFixDate I_CmmdtyFinTransactionFlow FinTransFlowIntrstRateFixDate Int.Fixing Date
_DCS _DCS

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_CmmdtyHdgFXFinTransFlow.
-- 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_CmmdtyHdgFXFinTransFlow AS
SELECT
  fha.bukrs AS CompanyCode,
  fha.rfha AS FinancialTransaction,
  fhapo.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  fhapo.FinTransFlowNumber AS FinTransFlowNumber,
  fhapo.FinTransCreationDate AS FinTransCreationDate,
  fhapo.FinTransFlowCreationTime AS FinTransFlowCreationTime,
  fhapo.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  fhapo.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  fhapo.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  fha.delfz AS TermEndDate,
  fha.hedge_class AS FinTransHedgingClassification,
  fha.behalf_of_company AS FinTransOnBehalfOfCompany,
  fhapo.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  fhapo.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  fhapo.FinancialTransactionDirection AS FinancialTransactionDirection,
  fhapo.DerivativeContrSpecification AS DerivativeContrSpecification,
  fhapo.MarketIdentifierCode AS MarketIdentifierCode,
  fhapo.Quantity AS Quantity,
  fhapo.UnitOfMeasure AS UnitOfMeasure,
  fhapo.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  fhapo.FinancialTransactionAmount AS FinancialTransactionAmount,
  fhapo.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  fhapo.FinTransFlowIntrstRateFixDate AS FinTransFlowIntrstRateFixDate
FROM vtbfha AS fha
INNER JOIN I_CmmdtyFinTransactionFlow AS fhapo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DerivativeContrSpec AS _DCS ON _DCS.DerivativeContrSpecification = DerivativeContrSpecification  -- association [0..1]
;

Learn More