I_TrsyScrtyClScrtyAccountFlow

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_TrsyScrtyClScrtyAccountFlow.
-- 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: ITRSYSCRTYCLFLOW

CREATE VIEW I_TrsyScrtyClScrtyAccountFlow AS
SELECT
  cast(trst_clasflo.claspos_guid as ftr_gen_sec_cl_secacct_pos preserving type) AS TrsyScrtyClScrtyAcctPosUUID,
  cast(trst_clasflo.os_guid as ftr_gen_sec_cl_secacct_flow preserving type) AS TrsyScrtyClScrtyAcctFlowUUID,
  trst_clasflo.apertage AS NumberOfCalculationDays,
  trst_clasflo.atage AS NumberOfDays,
  trst_clasflo.coupon_date AS SecurityCouponDate,
  cast(trst_clasflo.coupon_sign as ftr_gen_coupon_delivery preserving type) AS SecurityCouponDelivery,
  trst_clasflo.payment_date AS PaymentDate,
  trst_clasflo.rahabki AS HouseBank,
  trst_clasflo.rahktid AS HouseBankAccount,
  cast(trst_clasflo.sberfima as ftr_gen_sbewfima preserving type) AS CashFlowCalculationCategory,
  cast(trst_clasflo.sexclvon as ftr_gen_vvsexclvon preserving type) AS CalcPeriodStartDateIsExclusive,
  cast(trst_clasflo.sflat as ftr_gen_vvsflat preserving type) AS AccruedInterestIsContained,
  trst_clasflo.sfult AS DueDateIsMonthEnd,
  trst_clasflo.skalidwt AS InterestDaysCalendar,
  cast(trst_clasflo.skoart as ftr_cndn_condition_type preserving type ) AS FinConditionConditionType,
  cast(trst_clasflo.spaexcl as ftr_gen_tfmspaexcl preserving type) AS PeriodStartDateIsExclusive,
  cast( trst_clasflo.spault as ftr_gen_tfmspault preserving type) AS PeriodStartDateIsMonthEnd,
  cast(trst_clasflo.speincl as ftr_gen_tfmspeincl preserving type) AS PeriodEndDateIsInclusive,
  cast( trst_clasflo.speult as ftr_gen_tfmspeult preserving type ) AS PeriodEndDateIsMonthEnd,
  trst_clasflo.sstckkz AS AccruedInterestMethod,
  cast(trst_clasflo.sstcktg as ftr_gen_sstcktg preserving type) AS AccruedInterestCalcMethod,
  trst_clasflo.stgbasis AS InterestBaseDaysMethod,
  trst_clasflo.sultbis AS CalcPeriodEndDateIsMonthEnd,
  trst_clasflo.sultvon AS CalcPeriodStartDateIsMonthEnd,
  trst_clasflo.svult AS CalculationDateIsMonthEnd,
  cast(trst_clasflo.trd_bustransid as ftr_gen_business_transaction preserving type) AS TreasuryBusinessTransaction,
  trst_clasflo.trd_flownr AS TreasuryTransactionFlow
FROM trst_clasflo
LEFT OUTER JOIN I_TrsyScrtyClScrtyAccountPos AS _TrsyScrtyClScrtyAccountPos ON TrsyScrtyClScrtyAcctPosUUID = _TrsyScrtyClScrtyAccountPos.TrsyScrtyClScrtyAcctPosUUID  -- association [0..1]
;