I_TreasuryLedgerFlow

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_TreasuryLedgerFlow.
-- 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: ITRLTFLOW

CREATE VIEW I_TreasuryLedgerFlow AS
SELECT
  transaction_oid AS TreasuryLedgerTransaction,
  trlflownumber AS TreasuryLedgerFlow,
  flownumber AS TreasuryTransactionFlow,
  sourcetarget_flg AS TrsyPosTransfSourceTargetCode,
  transfer_group AS TreasuryPositionTransferGroup,
  flowtype AS TreasuryUpdateType,
  amount_factor AS TreasuryPositionTransferFactor,
  quant_cat AS TrsyPosQuantityChangeCategory,
  amount_cat AS TrsyPosAmountChangeCategory,
  cast(units as ftr_gen_quantity_in_units_l) AS QuantityInPieces,
  nominal_amt AS NominalAmountInNominalCurrency,
  nominal_org_amt AS OriglNominalAmtInNominalCrcy,
  nominal_curr AS NominalCurrency,
  posamt_idx_clean AS IndexCleanRpaytAmtInPosCrcy,
  position_amt AS AmountInPositionCurrency,
  position_curr AS PositionCurrency,
  valuation_amt AS AmountInValuationCurrency,
  valuation_curr AS ValuationCurrency,
  calculation_date AS CalculationDate,
  calc_date_incl AS CalcDateIsAsEndDateInclusive,
  due_date AS DueDate,
  calc_begin AS CalculationPeriodStartDate,
  calc_end AS CalculationPeriodEndDate,
  eff_int_rate_u AS EffectiveInterestRate,
  sched_eff_rate AS EffctvIntrstRateRdmptnSched,
  eff_int_rate_n AS NextEffectiveInterestRate,
  sched_fix AS FixedRedemptionSchedule,
  bbasis AS CalculationBasis,
  position_oid AS TreasuryPosition,
  trldate AS TreasuryPositionLedgerDate,
  subposition_oid AS TrsySubPosition
FROM trlt_flow
LEFT OUTER JOIN I_Currency AS _NominalCurrency ON NominalCurrency = _NominalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON PositionCurrency = _PositionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ValuationCurrency ON ValuationCurrency = _ValuationCurrency.Currency  -- association [0..1]
;