P_TFTRANSCASHFLOW

DDL: P_TFTRANSCASHFLOW SQL: PTFTRANSCF Type: view COMPOSITE Package: FTR_TRADE_FINANCE_CORE
11 Fields 3 Data Sources

Nominal and Fee Flow for Trade Finance Transaction

P_TFTRANSCASHFLOW is a Composite CDS View that provides data about "Nominal and Fee Flow for Trade Finance Transaction" in SAP S/4HANA. It reads from 3 data sources (I_FinancialTransaction, vtbfhazu, I_FinancialTransacCashFlow) and exposes 11 fields with key fields CompanyCode, FinancialTransaction. Part of development package FTR_TRADE_FINANCE_CORE.

Data Sources (3)

SourceAliasJoin Type
I_FinancialTransaction FinancialTransaction from
vtbfhazu TransactionActivity left_outer
I_FinancialTransacCashFlow TransactionCashFlow left_outer

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PTFTRANSCF view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransacCashFlow CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinancialTransacCashFlow FinancialTransaction Transaction
FinancialInstrProductCategory I_FinancialTransacCashFlow FinancialInstrProductCategory
FinancialInstrumentProductType I_FinancialTransacCashFlow FinancialInstrumentProductType Product Type
FinInstrTransactionCategory I_FinancialTransacCashFlow FinInstrTransactionCategory Transaction Cat
FinancialInstrTransactionType I_FinancialTransacCashFlow FinancialInstrTransactionType
Counterparty I_FinancialTransacCashFlow Counterparty Supplier
CashFlowCalculationCategory I_FinancialTransacCashFlow CashFlowCalculationCategory
TransactionCurrency I_FinancialTransaction TransactionCurrency Transaction Currency
NominalCurrency I_FinancialTransacCashFlow NominalCurrency
DifferentiationPortfolio I_FinancialTransacCashFlow DifferentiationPortfolio

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_TFTRANSCASHFLOW.
-- 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: PTFTRANSCF
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_TFTRANSCASHFLOW AS
SELECT
  TransactionCashFlow.CompanyCode AS CompanyCode,
  TransactionCashFlow.FinancialTransaction AS FinancialTransaction,
  TransactionCashFlow.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  TransactionCashFlow.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  TransactionCashFlow.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  TransactionCashFlow.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  TransactionCashFlow.Counterparty AS Counterparty,
  TransactionCashFlow.CashFlowCalculationCategory AS CashFlowCalculationCategory,
  FinancialTransaction.TransactionCurrency AS TransactionCurrency,
  TransactionCashFlow.NominalCurrency AS NominalCurrency,
  TransactionCashFlow.DifferentiationPortfolio AS DifferentiationPortfolio
FROM I_FinancialTransaction AS FinancialTransaction
LEFT OUTER JOIN vtbfhazu AS TransactionActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialTransacCashFlow AS TransactionCashFlow ON /* join condition not captured in parsed metadata */
;

Learn More