I_CmmdtyHedgeTransactionFlow

DDL: I_CMMDTYHEDGETRANSACTIONFLOW SQL: ICMMDTYHDGFLOW Type: view BASIC
19 Fields 1 Data Sources

Financial Transaction flow details

I_CmmdtyHedgeTransactionFlow is a Basic CDS View that provides data about "Financial Transaction flow details" in SAP S/4HANA. It reads from 1 data source (vtbfhapo) and exposes 19 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate.

Data Sources (1)

SourceAliasJoin Type
vtbfhapo FinTransflow from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYHDGFLOW view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Financial Transaction flow details view
VDM.viewType #BASIC view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionCompanyCode vtbfhapo bukrs Value
KEY FinTransactionDealIdentifier vtbfhapo rfha Transaction
KEY FinancialInstrumentActivity vtbfhapo rfhazu Activity
KEY FinTransFlowNumber vtbfhapo rfhazb Flow
KEY FinTransCreationDate vtbfhapo dcrdat Entry Date
KEY FinTransFlowCreationTime vtbfhapo tcrtim Entry Time
FinTransactionPricingStartDate vtbfhapo dbervon CalculationFrom
FinTransactionPricingEndDate vtbfhapo dberbis Calculation To
LastChangeDate vtbfhapo dupdat Changed On
FinTransFlowPaytAmt vtbfhapo bzbetr Payment Amnt in PyC
FinTransFlowPaytAmtCrcy vtbfhapo wzbetr Payment Currency
UnitOfMeasure vtbfhapo unit_of_measure Unit of Measure
Quantity vtbfhapo quantity Value
FinTransacTradedPriceAmount vtbfhapo contract_price Price
FinTransTradedPriceCrcyUnit vtbfhapo price_curr_unit Currency Unit
FinancialTransactionDCSID vtbfhapo dcsid DCSID
FinTransPositionCrcyCnvrsnRate
FinTransCatFlwAndCndnsVal vtbfhapo sbktyp Category
FinTransFlowIntrstRateFixDate vtbfhapo dzfest Int.Fixing Date

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_CmmdtyHedgeTransactionFlow.
-- 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: ICMMDTYHDGFLOW

CREATE VIEW I_CmmdtyHedgeTransactionFlow AS
SELECT
  FinTransflow.bukrs AS FinTransactionCompanyCode,
  FinTransflow.rfha AS FinTransactionDealIdentifier,
  FinTransflow.rfhazu AS FinancialInstrumentActivity,
  FinTransflow.rfhazb AS FinTransFlowNumber,
  FinTransflow.dcrdat AS FinTransCreationDate,
  FinTransflow.tcrtim AS FinTransFlowCreationTime,
  FinTransflow.dbervon AS FinTransactionPricingStartDate,
  FinTransflow.dberbis AS FinTransactionPricingEndDate,
  FinTransflow.dupdat AS LastChangeDate,
  FinTransflow.bzbetr AS FinTransFlowPaytAmt,
  FinTransflow.wzbetr AS FinTransFlowPaytAmtCrcy,
  FinTransflow.unit_of_measure AS UnitOfMeasure,
  FinTransflow.quantity AS Quantity,
  FinTransflow.contract_price AS FinTransacTradedPriceAmount,
  FinTransflow.price_curr_unit AS FinTransTradedPriceCrcyUnit,
  FinTransflow.dcsid AS FinancialTransactionDCSID,
  cast(FinTransflow.kzwkurs as ftr_crcy_cnvrsn_rate preserving type) AS FinTransPositionCrcyCnvrsnRate,
  FinTransflow.sbktyp AS FinTransCatFlwAndCndnsVal,
  FinTransflow.dzfest AS FinTransFlowIntrstRateFixDate
FROM vtbfhapo AS FinTransflow
;

Learn More