R_FinTransCondition

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_FinTransCondition.
-- 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: RFINTRANSCNDN

CREATE VIEW R_FinTransCondition AS
SELECT
  Condition.bukrs AS CompanyCode,
  Condition.rfha AS FinancialTransaction,
  Condition.rfhazu AS FinancialInstrumentActivity,
  Condition.rkondgr AS FinancialTransactionDirection,
  Condition.rkond AS FinConditionItem,
  Condition.dguel_kp AS ConditionItemValidityStartDate,
  Condition.nstufe AS FinConditionSubItem,
  Condition.rantyp AS TreasuryContractType,
  cast( Condition.sbktyp as ftr_cndn_condition_category preserving type ) AS FinConditionConditionCategory,
  cast( Condition.skoart as ftr_cndn_condition_type preserving type ) AS FinConditionConditionType,
  Condition.szbmeth AS InterestCalculationMethod,
  case when (Condition.sbktyp = '20' or Condition.sbktyp = '15' or Condition.sbktyp = '27') then Condition.pkond end as ConditionPercentageRate AS pkondendasConditionPercentageRate,
  case when (Condition.sbktyp = '20' or Condition.sbktyp = '15' or Condition.sbktyp = '27') and ( Condition.sformref is initial or Condition.sformref = '0003' ) then Condition.szsref else '' end as InterestReference AS szsrefelseendasInterestReference,
  case when (Condition.sbktyp = '12' or Condition.sbktyp = '13' or Condition.sbktyp = '14') then Condition.bbasis end as FinConditionRpaytBaseAmount AS bbasisendasFinConditionRpaytBaseAmount,
  Condition.dvalut AS CalculationDate,
  cast( Condition.avgstage as ftr_cndn_calc_dte_shft_days preserving type ) AS FinCndnCalcDteShftNrOfDays,
  Condition.dfaell AS DueDate,
  cast( Condition.sfmeth as ftr_cndn_due_date_update_meth preserving type ) AS FinCndnDueDteUpdateMethod,
  cast( Condition.sfult as due_dte_as_end_date_month_end preserving type ) AS DueDateIsAsEndDateMonthEnd,
  cast( Condition.sfwerk as ftr_cndn_due_date_wrk_day_sft preserving type ) AS FinCndnDueDteWrkgDayShft,
  Condition.afgstage AS FinCndnDueDteShftNrOfDays,
  cast( Condition.skalid as ftr_cndn_factory_calendar1 preserving type ) AS FinConditionFactoryCalendar1,
  cast( Condition.skalid2 as ftr_cndn_factory_calendar2 preserving type ) AS FinConditionFactoryCalendar2,
  cast( Condition.skalid3 as ftr_cndn_factory_calendar3 preserving type ) AS FinConditionFactoryCalendar3,
  cast( Condition.skalid4 as ftr_cndn_factory_calendar4 preserving type ) AS FinConditionFactoryCalendar4,
  cast( Condition.skalid5 as ftr_cndn_factory_calendar5 preserving type ) AS FinConditionFactoryCalendar5,
  Condition.bugrenz AS FinCndnScaleLowerLimitAmount,
  Condition.bogrenz AS FinCndnScaleUpperLimitAmount,
  Condition.bugrenz AS FinCndnItemLowerLimitAmount,
  Condition.bogrenz AS FinCndnItemUpperLimitAmount,
  Condition.ammrhyzv AS ExponentialIntrstSettlmtFrqcy,
  Condition.skalidwt AS IntrstCalcMethFactoryCalendar,
  Condition.ppayment AS FinancialConditionPaymentRate,
  Condition.pkond1stper AS InterestFirstPeriodRate,
  Condition.savgweight AS AverageIntrstRateWeightingCat,
  Condition.sroundavginterest AS AverageIntrstRateRndngCategory,
  Condition.rounddecavginterest AS AverageIntrstRateRndngDecimals,
  Condition.pavgspread AS AverageInterestRateSpreadValue,
  Condition.javgcap AS AvgIntrstRateHasUsedUpperLimit,
  Condition.pavgcap AS AverageInterestUpperLimitRate,
  Condition.javgfloor AS AvgIntrstRateHasUsedLowerLimit,
  Condition.pavgfloor AS AverageInterestLowerLimitRate,
  Condition.sfactorreset AS AverageIntrstRateResetCalcEvt,
  Condition.sroundratefactor AS FinCndnRateFactorRndngCategory,
  Condition.rounddecratefactor AS FinCndnRateFactorRndngDecimals,
  Condition.sroundfactor AS FinCndnFactorRoundingCategory,
  Condition.rounddecfactor AS FinCndnFactorRoundingDecimals,
  Condition.sroundbasefactor AS FinCndnBaseFactorRndngCategory,
  Condition.rounddecbasefactor AS FinCndnBaseFactorRndngDecimals,
  Condition.sround AS FinCndnAmountRoundingCategory,
  Condition.broundunit AS FinCndnAmountRoundingUnit,
  Condition.bbasisunit AS RndngBaseUntAmtInCndnItmCrcy,
  Condition.sbasis AS FinCndnCalcBaseReference,
  Condition.ssequence AS FinCndnProcessingSequenceValue,
  Condition.jbmonat AS FinCndnAmountTimeUnit,
  Condition.jugrenz AS FinCndnItmHasUsedLowerLimitAmt,
  Condition.jogrenz AS FinCndnItmHasUsedUpperLimitAmt,
  Condition.adgstage AS FinCndnRateFixingLockoutPeriod,
  Condition.sum_rkond AS FinCndnCrsRefcdAccmlnCndnGrp,
  cast( Condition.sfranz as tb_sfranze_new ) AS FinCndnDueDteShiftToTermEnd,
  Condition.sdwerk AS FinCndnPaytDateWrkgDayShft,
  Condition.jsofverr AS FinCndnRpaytSettlmt
FROM vtbfinko AS Condition
;