R_FinTransDistributorFlow

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,
  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 */
;