R_FinTransDistributorFlow

DDL: R_FINTRANSDISTRIBUTORFLOW SQL: RTRDFLOW Type: view BASIC Package: FTR_IRM_CORE
35 Fields 2 Data Sources

Reuse of distributor flows

R_FinTransDistributorFlow is a Basic CDS View that provides data about "Reuse of distributor flows" in SAP S/4HANA. It reads from 2 data sources (trdt_flow, trdt_trdbustrans) and exposes 35 fields with key fields BusinessTransactionDocUUID, TreasuryTransactionFlow. Part of development package FTR_IRM_CORE.

Data Sources (2)

SourceAliasJoin Type
trdt_flow trdflow from
trdt_trdbustrans trdtrans inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RTRDFLOW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private false view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Reuse of distributor flows view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY BusinessTransactionDocUUID trdt_flow bustrans_os_guid DB Object ID
KEY TreasuryTransactionFlow trdt_flow flow_number Flow Number
CompanyCode trdt_flow company_code Company Code
TreasuryUpdateType trdt_flow dis_flowtype Update Type
TreasuryPosAssetLiabilityCode
FinancialInstrumentProductType trdt_flow product_type Product Type
FinancialInstrTransactionType trdt_flow transaction_type Transactn Type
FinancialInstrValuationClass trdt_flow com_val_class Gen. Valn Class
TreasuryValuationClass trdt_flow valuation_class Valuation Class
SecurityClass trdt_flow security_id Security Class
SecurityAccount trdt_flow security_account Securities Acct
SecurityAccountGroup trdt_flow account_group Sec.AcctGrp
DifferentiationPortfolio trdt_flow portfolio Portfolio
Trader trdt_flow trader Trader
FinancialTransaction trdt_flow deal_number Transaction
FinancialInstrumentActivity trdt_flow rfhazu Activity
NominalCurrency trdt_flow nominal_curr Nominal Crcy
NominalAmountInNominalCurrency trdt_flow nominal_amt Nominal Amount
PositionCurrency trdt_flow position_curr Transaction Currency
AmountInPositionCurrency trdt_flow position_amt Transact.Crcy Amount
PaymentCurrency trdt_flow payment_curr Payment Crcy
AmountInPaymentCurrency trdt_flow payment_amt Payout Amount
HouseBank trdt_flow house_bank House Bank
HouseBankAccount trdt_flow house_bank_acc House Bank Acct
PaymentDate trdt_flow payment_date Pymt Date
Counterparty
TreasuryBusinessTransaction trdt_trdbustrans bustransid Bus. Trans. ID
FinancialInstrActivityCategory trdt_flow sfgzustt Activity Cat.
CalculationDate trdt_flow calculation_date Calculat. date
CalcDateIsAsEndDateInclusive trdt_flow calc_date_incl Inclusive Ind.
FinancialTransactionDirection trdt_flow rkondgr Direction
CashFlowCalculationCategory updatetype sberfima Calc. Category
TreasuryContractType producttype rantyp Contract Type
CashFlowDirection
PaymentReason trdt_flow payment_reason Reason Code

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 R_FinTransDistributorFlow.
-- 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: RTRDFLOW

CREATE VIEW R_FinTransDistributorFlow AS
SELECT
  trdflow.bustrans_os_guid AS BusinessTransactionDocUUID,
  trdflow.flow_number AS TreasuryTransactionFlow,
  trdflow.company_code AS CompanyCode,
  trdflow.dis_flowtype AS TreasuryUpdateType,
  cast(trdflow.active_passive as ftr_gen_asset_liab_indicator) AS TreasuryPosAssetLiabilityCode,
  trdflow.product_type AS FinancialInstrumentProductType,
  trdflow.transaction_type AS FinancialInstrTransactionType,
  trdflow.com_val_class AS FinancialInstrValuationClass,
  trdflow.valuation_class AS TreasuryValuationClass,
  trdflow.security_id AS SecurityClass,
  trdflow.security_account AS SecurityAccount,
  trdflow.account_group AS SecurityAccountGroup,
  trdflow.portfolio AS DifferentiationPortfolio,
  trdflow.trader AS Trader,
  trdflow.deal_number AS FinancialTransaction,
  trdflow.rfhazu AS FinancialInstrumentActivity,
  trdflow.nominal_curr AS NominalCurrency,
  trdflow.nominal_amt AS NominalAmountInNominalCurrency,
  trdflow.position_curr AS PositionCurrency,
  trdflow.position_amt AS AmountInPositionCurrency,
  trdflow.payment_curr AS PaymentCurrency,
  trdflow.payment_amt AS AmountInPaymentCurrency,
  trdflow.house_bank AS HouseBank,
  trdflow.house_bank_acc AS HouseBankAccount,
  trdflow.payment_date AS PaymentDate,
  cast( trdflow.counterparty as rkontrah_new ) AS Counterparty,
  trdtrans.bustransid AS TreasuryBusinessTransaction,
  trdflow.sfgzustt AS FinancialInstrActivityCategory,
  trdflow.calculation_date AS CalculationDate,
  trdflow.calc_date_incl AS CalcDateIsAsEndDateInclusive,
  trdflow.rkondgr AS FinancialTransactionDirection,
  updatetype.sberfima AS CashFlowCalculationCategory,
  producttype.rantyp AS TreasuryContractType,
  cast( trdflow.sign as fclm_direction ) AS CashFlowDirection,
  trdflow.payment_reason AS PaymentReason
FROM trdt_flow AS trdflow
INNER JOIN trdt_trdbustrans AS trdtrans ON /* join condition not captured in parsed metadata */
;

Learn More