I_CmmdtyHdgTrdOrdTransFlowDet

DDL: I_CMMDTYHDGTRDORDTRANSFLOWDET SQL: ITRANSFLOWDETS Type: view BASIC Package: FIN_CMM_CMDTY_HEDGE_SPEC
18 Fields 1 Data Sources

Commodity Hedge Constellation Deal Flow Details

I_CmmdtyHdgTrdOrdTransFlowDet is a Basic CDS View that provides data about "Commodity Hedge Constellation Deal Flow Details" in SAP S/4HANA. It reads from 1 data source (vtbfhapo) and exposes 18 fields with key fields CompanyCode, CmmdtyHedgeConstellationDeal, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate. Part of development package FIN_CMM_CMDTY_HEDGE_SPEC.

Data Sources (1)

SourceAliasJoin Type
vtbfhapo fhapo from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITRANSFLOWDETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Commodity Hedge Constellation Deal Flow Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfhapo bukrs Value
KEY CmmdtyHedgeConstellationDeal 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
LastChangeDate vtbfhapo dupdat Changed On
FinTransFlowPaytAmt vtbfhapo bzbetr Payment Amnt in PyC
FinTransFlowPaytAmtCrcy vtbfhapo wzbetr Payment Currency
FinTransacTradedPriceAmount
FinancialTransactionDCSID vtbfhapo dcsid DCSID
CmmdtyHdgCalcdTradeCurrency
FinTransPositionCrcyCnvrsnRate
UnitOfMeasure vtbfhapo unit_of_measure Unit of Measure
Quantity vtbfhapo quantity Value
FinTransFlowCategory vtbfhapo sbktyp Category
FinInterestRateAdjmtStatus vtbfhapo regi_state Status
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_CmmdtyHdgTrdOrdTransFlowDet.
-- 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: ITRANSFLOWDETS

CREATE VIEW I_CmmdtyHdgTrdOrdTransFlowDet AS
SELECT
  fhapo.bukrs AS CompanyCode,
  fhapo.rfha AS CmmdtyHedgeConstellationDeal,
  fhapo.rfhazu AS FinancialInstrumentActivity,
  fhapo.rfhazb AS FinTransFlowNumber,
  fhapo.dcrdat AS FinTransCreationDate,
  fhapo.tcrtim AS FinTransFlowCreationTime,
  fhapo.dupdat AS LastChangeDate,
  fhapo.bzbetr AS FinTransFlowPaytAmt,
  fhapo.wzbetr AS FinTransFlowPaytAmtCrcy,
  cast(fhapo.contract_price as tb_bzbetr ) AS FinTransacTradedPriceAmount,
  fhapo.dcsid AS FinancialTransactionDCSID,
  cast( fhapo.price_curr_unit as tb_wzbetr ) AS CmmdtyHdgCalcdTradeCurrency,
  cast(fhapo.kzwkurs as ftr_crcy_cnvrsn_rate preserving type) AS FinTransPositionCrcyCnvrsnRate,
  fhapo.unit_of_measure AS UnitOfMeasure,
  fhapo.quantity AS Quantity,
  fhapo.sbktyp AS FinTransFlowCategory,
  fhapo.regi_state AS FinInterestRateAdjmtStatus,
  fhapo.dzfest AS FinTransFlowIntrstRateFixDate
FROM vtbfhapo AS fhapo
;

Learn More