I_CmmdtyHdgTransFlowNotFixed

DDL: I_CMMDTYHDGTRANSFLOWNOTFIXED Type: view BASIC
15 Fields 1 Data Sources

Cmdty Fin Transaction Flows Unfixed

I_CmmdtyHdgTransFlowNotFixed is a Basic CDS View that provides data about "Cmdty Fin Transaction Flows Unfixed" in SAP S/4HANA. It reads from 1 data source (vtbfhapo_unfixed) and exposes 15 fields with key fields CompanyCode, CmmdtyHedgeConstellationDeal, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate.

Data Sources (1)

SourceAliasJoin Type
vtbfhapo_unfixed fhapo_unfixed from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMTOCTRNSFLUNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cmdty Fin Transaction Flows Unfixed view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfhapo_unfixed bukrs Value
KEY CmmdtyHedgeConstellationDeal vtbfhapo_unfixed rfha Transaction
KEY FinancialInstrumentActivity vtbfhapo_unfixed rfhazu Activity
KEY FinTransFlowNumber vtbfhapo_unfixed rfhazb Flow
KEY FinTransCreationDate vtbfhapo_unfixed dcrdat Entry Date
LastChangeDate vtbfhapo_unfixed dupdat Changed On
FinTransFlowPaytAmt vtbfhapo_unfixed bzbetr Payment Amnt in PyC
FinTransFlowPaytAmtCrcy vtbfhapo_unfixed wzbetr Payment Currency
FinTransacTradedPriceAmount
FinancialTransactionDCSID vtbfhapo_unfixed dcsid DCSID
CmmdtyHdgCalcdTradeCurrency
FinTransPositionCrcyCnvrsnRate
UnitOfMeasure vtbfhapo_unfixed unit_of_measure Unit of Measure
Quantity vtbfhapo_unfixed quantity Value
FinTransFlowCategory vtbfhapo_unfixed sbktyp Category

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_CmmdtyHdgTransFlowNotFixed.
-- 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 I_CmmdtyHdgTransFlowNotFixed AS
SELECT
  fhapo_unfixed.bukrs AS CompanyCode,
  fhapo_unfixed.rfha AS CmmdtyHedgeConstellationDeal,
  fhapo_unfixed.rfhazu AS FinancialInstrumentActivity,
  fhapo_unfixed.rfhazb AS FinTransFlowNumber,
  fhapo_unfixed.dcrdat AS FinTransCreationDate,
  fhapo_unfixed.dupdat AS LastChangeDate,
  fhapo_unfixed.bzbetr AS FinTransFlowPaytAmt,
  fhapo_unfixed.wzbetr AS FinTransFlowPaytAmtCrcy,
  cast(fhapo_unfixed.contract_price as tb_bzbetr ) AS FinTransacTradedPriceAmount,
  fhapo_unfixed.dcsid AS FinancialTransactionDCSID,
  cast( fhapo_unfixed.price_curr_unit as tb_wzbetr ) AS CmmdtyHdgCalcdTradeCurrency,
  cast(fhapo_unfixed.kzwkurs as ftr_crcy_cnvrsn_rate preserving type) AS FinTransPositionCrcyCnvrsnRate,
  fhapo_unfixed.unit_of_measure AS UnitOfMeasure,
  fhapo_unfixed.quantity AS Quantity,
  fhapo_unfixed.sbktyp AS FinTransFlowCategory
FROM vtbfhapo_unfixed AS fhapo_unfixed
;

Learn More