I_FinancialTransacCashFlow

DDL: I_FINANCIALTRANSACCASHFLOW SQL: ITRANCASHFLOW Type: view COMPOSITE Package: FTR_IRM_CORE
44 Fields 2 Data Sources 9 Associations

Financial Transaction Cash Flows

I_FinancialTransacCashFlow is a Composite CDS View that provides data about "Financial Transaction Cash Flows" in SAP S/4HANA. It reads from 2 data sources (P_FinTransFimaCatUpdTyp, R_FinTransDistributorFlow) and exposes 44 fields with key fields BusinessTransactionDocUUID, TreasuryTransactionFlow. It has 9 associations to related views. Part of development package FTR_IRM_CORE.

Data Sources (2)

SourceAliasJoin Type
P_FinTransFimaCatUpdTyp suppflow left_outer
R_FinTransDistributorFlow trdflow from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Housebank _HouseBank $projection.CompanyCode = _HouseBank.CompanyCode and $projection.HouseBank = _HouseBank.HouseBank
[0..1] I_HouseBankAccount _HouseBankAccount $projection.CompanyCode = _HouseBankAccount.CompanyCode and $projection.HouseBank = _HouseBankAccount.HouseBank and $projection.HouseBankAccount = _HouseBankAccount.HouseBankAccount
[0..1] I_Ftr_Counterparty _Counterparty $projection.Counterparty = _Counterparty.BusinessPartner
[0..1] I_TreasuryPortfolio _Portfolio $projection.CompanyCode = _Portfolio.CompanyCode and $projection.DifferentiationPortfolio = _Portfolio.Portfolio
[1..1] I_FinancialinstrProductType _ProductType $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
[0..1] I_FinancialInstrTransType _TransactionType $projection.FinancialInstrumentProductType = _TransactionType.FinancialInstrumentProductType and $projection.FinancialInstrTransactionType = _TransactionType.FinancialInstrTransactionType
[0..1] I_SecurityAccount _SecurityAccount $projection.CompanyCode = _SecurityAccount.CompanyCode and $projection.SecurityAccount = _SecurityAccount.SecurityAccount
[0..1] I_SecurityClass _SecurityClass $projection.SecurityClass = _SecurityClass.SecurityClass

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITRANCASHFLOW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Search.searchable false view
EndUserText.label Financial Transaction Cash Flows view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY BusinessTransactionDocUUID R_FinTransDistributorFlow BusinessTransactionDocUUID DB Object ID
KEY TreasuryTransactionFlow R_FinTransDistributorFlow TreasuryTransactionFlow Flow Number
CompanyCode R_FinTransDistributorFlow CompanyCode Receiver Company Code
TreasuryUpdateType R_FinTransDistributorFlow TreasuryUpdateType Update Type
TreasuryPosAssetLiabilityCode R_FinTransDistributorFlow TreasuryPosAssetLiabilityCode
FinancialInstrumentProductType R_FinTransDistributorFlow FinancialInstrumentProductType Product Type
FinancialInstrProductCategory _ProductType FinancialInstrProductCategory
FinInstrTransactionCategory _TransactionType FinInstrTransactionCategory
FinancialInstrTransactionType R_FinTransDistributorFlow FinancialInstrTransactionType Transactn Type
FinancialInstrValuationClass R_FinTransDistributorFlow FinancialInstrValuationClass Gen. Valn Class
TreasuryValuationClass R_FinTransDistributorFlow TreasuryValuationClass Valuation Class
SecurityClass R_FinTransDistributorFlow SecurityClass Security Class
SecurityAccount R_FinTransDistributorFlow SecurityAccount Securities Acct
SecurityAccountGroup R_FinTransDistributorFlow SecurityAccountGroup Sec.AcctGrp
DifferentiationPortfolio R_FinTransDistributorFlow DifferentiationPortfolio Portfolio
Trader R_FinTransDistributorFlow Trader Trader
FinancialTransaction R_FinTransDistributorFlow FinancialTransaction Transaction
FinancialInstrumentActivity R_FinTransDistributorFlow FinancialInstrumentActivity Activity
NominalCurrency R_FinTransDistributorFlow NominalCurrency Nominal Crcy
NominalAmountInNominalCurrency R_FinTransDistributorFlow NominalAmountInNominalCurrency Nominal Amount
PositionCurrency R_FinTransDistributorFlow PositionCurrency Transaction Currency
AmountInPositionCurrency R_FinTransDistributorFlow AmountInPositionCurrency Transact.Crcy Amount
PaymentCurrency R_FinTransDistributorFlow PaymentCurrency Payment Currency
AmountInPaymentCurrency R_FinTransDistributorFlow AmountInPaymentCurrency Amount in Payment Currency
CashFlowDirection R_FinTransDistributorFlow CashFlowDirection
HouseBank R_FinTransDistributorFlow HouseBank House Bank
HouseBankAccount R_FinTransDistributorFlow HouseBankAccount House Bank Account
PaymentDate R_FinTransDistributorFlow PaymentDate Payment Date
Counterparty R_FinTransDistributorFlow Counterparty Supplier
TreasuryBusinessTransaction R_FinTransDistributorFlow TreasuryBusinessTransaction Bus. Trans. ID
FinancialInstrActivityCategory R_FinTransDistributorFlow FinancialInstrActivityCategory Activity Cat.
CalculationDate R_FinTransDistributorFlow CalculationDate Calculat. date
CalcDateIsAsEndDateInclusive R_FinTransDistributorFlow CalcDateIsAsEndDateInclusive Inclusive Ind.
FinancialTransactionDirection R_FinTransDistributorFlow FinancialTransactionDirection Direction
PaymentReason R_FinTransDistributorFlow PaymentReason Payment Reason
_ProductType _ProductType
_TransactionType _TransactionType
_SecurityAccount _SecurityAccount
_SecurityClass _SecurityClass
_CompanyCode _CompanyCode
_HouseBank _HouseBank
_HouseBankAccount _HouseBankAccount
_Portfolio _Portfolio
_Counterparty _Counterparty

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_FinancialTransacCashFlow.
-- 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: ITRANCASHFLOW

CREATE VIEW I_FinancialTransacCashFlow AS
SELECT
  trdflow.BusinessTransactionDocUUID AS BusinessTransactionDocUUID,
  trdflow.TreasuryTransactionFlow AS TreasuryTransactionFlow,
  trdflow.CompanyCode AS CompanyCode,
  trdflow.TreasuryUpdateType AS TreasuryUpdateType,
  trdflow.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  trdflow.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _ProductType.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _TransactionType.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  trdflow.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  trdflow.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  trdflow.TreasuryValuationClass AS TreasuryValuationClass,
  trdflow.SecurityClass AS SecurityClass,
  trdflow.SecurityAccount AS SecurityAccount,
  trdflow.SecurityAccountGroup AS SecurityAccountGroup,
  trdflow.DifferentiationPortfolio AS DifferentiationPortfolio,
  trdflow.Trader AS Trader,
  trdflow.FinancialTransaction AS FinancialTransaction,
  trdflow.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  trdflow.NominalCurrency AS NominalCurrency,
  trdflow.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  trdflow.PositionCurrency AS PositionCurrency,
  trdflow.AmountInPositionCurrency AS AmountInPositionCurrency,
  trdflow.PaymentCurrency AS PaymentCurrency,
  trdflow.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  trdflow.CashFlowDirection AS CashFlowDirection,
  trdflow.HouseBank AS HouseBank,
  trdflow.HouseBankAccount AS HouseBankAccount,
  trdflow.PaymentDate AS PaymentDate,
  trdflow.Counterparty AS Counterparty,
  trdflow.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  trdflow.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  trdflow.CalculationDate AS CalculationDate,
  trdflow.CalcDateIsAsEndDateInclusive AS CalcDateIsAsEndDateInclusive,
  trdflow.FinancialTransactionDirection AS FinancialTransactionDirection,
  trdflow.PaymentReason AS PaymentReason
FROM R_FinTransDistributorFlow AS trdflow
LEFT OUTER JOIN P_FinTransFimaCatUpdTyp AS suppflow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_Ftr_Counterparty AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND DifferentiationPortfolio = _Portfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _TransactionType ON FinancialInstrumentProductType = _TransactionType.FinancialInstrumentProductType AND FinancialInstrTransactionType = _TransactionType.FinancialInstrTransactionType  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON CompanyCode = _SecurityAccount.CompanyCode AND SecurityAccount = _SecurityAccount.SecurityAccount  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
;

Learn More