I_CmmdtyFinTransFlowUnfixed

DDL: I_CMMDTYFINTRANSFLOWUNFIXED Type: view BASIC Package: FIN_CMM_CMDTY_VDM
24 Fields 1 Data Sources

Cmdty Fin Transaction Flows Unfixed

I_CmmdtyFinTransFlowUnfixed 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 24 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate. Part of development package FIN_CMM_CMDTY_VDM.

Data Sources (1)

SourceAliasJoin Type
vtbfhapo_unfixed fhapo_unfixed from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMFINTRNSFLUNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B 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 (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfhapo_unfixed bukrs Value
KEY FinancialTransaction vtbfhapo_unfixed rfha Transaction
KEY FinancialInstrumentActivity vtbfhapo_unfixed rfhazu Activity
KEY FinTransFlowNumber vtbfhapo_unfixed rfhazb Flow
KEY FinTransCreationDate vtbfhapo_unfixed dcrdat Entry Date
KEY FinTransFlowCreationTime vtbfhapo_unfixed tcrtim Entry Time
FinTransFlowPaymentDate vtbfhapo_unfixed dzterm Payment Date
FinTransactionPricingStartDate vtbfhapo_unfixed dbervon CalculationFrom
FinTransactionPricingEndDate vtbfhapo_unfixed dberbis Calculation To
FinTransacTradedPriceAmount vtbfhapo_unfixed contract_price Price
FinTransTradedPriceCrcyUnit vtbfhapo_unfixed price_curr_unit Currency Unit
FinancialTransactionDirection vtbfhapo_unfixed rkondgr Direction
DerivativeContrSpecification vtbfhapo_unfixed dcsid DCSID
MarketIdentifierCode vtbfhapo_unfixed mic MIC
Quantity vtbfhapo_unfixed quantity Value
UnitOfMeasure vtbfhapo_unfixed unit_of_measure Unit of Measure
CommodityPriceExposureUnit vtbfhapo_unfixed price_uom Unit of Measure
FinancialTransactionAmount vtbfhapo_unfixed bzbetr Payment Amnt in PyC
FinTransFlowPaytAmtCrcy vtbfhapo_unfixed wzbetr Payment Currency
FinTransFlowCategory vtbfhapo_unfixed sbktyp Category
FinTransFlowIntrstRateFixDate vtbfhapo_unfixed dzfest Int.Fixing Date
FinancialTransactionFlowUUID vtbfhapo_unfixed flowuuid Flow UUID
FinTransReferenceFlowUUID vtbfhapo_unfixed ref_flowuuid Reference UUID
LastChangeDate vtbfhapo_unfixed dupdat Changed On

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_CmmdtyFinTransFlowUnfixed.
-- 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_CmmdtyFinTransFlowUnfixed AS
SELECT
  fhapo_unfixed.bukrs AS CompanyCode,
  fhapo_unfixed.rfha AS FinancialTransaction,
  fhapo_unfixed.rfhazu AS FinancialInstrumentActivity,
  fhapo_unfixed.rfhazb AS FinTransFlowNumber,
  fhapo_unfixed.dcrdat AS FinTransCreationDate,
  fhapo_unfixed.tcrtim AS FinTransFlowCreationTime,
  fhapo_unfixed.dzterm AS FinTransFlowPaymentDate,
  fhapo_unfixed.dbervon AS FinTransactionPricingStartDate,
  fhapo_unfixed.dberbis AS FinTransactionPricingEndDate,
  fhapo_unfixed.contract_price AS FinTransacTradedPriceAmount,
  fhapo_unfixed.price_curr_unit AS FinTransTradedPriceCrcyUnit,
  fhapo_unfixed.rkondgr AS FinancialTransactionDirection,
  fhapo_unfixed.dcsid AS DerivativeContrSpecification,
  fhapo_unfixed.mic AS MarketIdentifierCode,
  fhapo_unfixed.quantity AS Quantity,
  fhapo_unfixed.unit_of_measure AS UnitOfMeasure,
  fhapo_unfixed.price_uom AS CommodityPriceExposureUnit,
  fhapo_unfixed.bzbetr AS FinancialTransactionAmount,
  fhapo_unfixed.wzbetr AS FinTransFlowPaytAmtCrcy,
  fhapo_unfixed.sbktyp AS FinTransFlowCategory,
  fhapo_unfixed.dzfest AS FinTransFlowIntrstRateFixDate,
  fhapo_unfixed.flowuuid AS FinancialTransactionFlowUUID,
  fhapo_unfixed.ref_flowuuid AS FinTransReferenceFlowUUID,
  fhapo_unfixed.dupdat AS LastChangeDate
FROM vtbfhapo_unfixed AS fhapo_unfixed
;

Learn More