I_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 I_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: IFINTRANSCNDN

CREATE VIEW I_FinTransCondition AS
SELECT
  Condition.CompanyCode AS CompanyCode,
  Condition.FinancialTransaction AS FinancialTransaction,
  Condition.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  Condition.FinancialTransactionDirection AS FinancialTransactionDirection,
  Condition.FinConditionItem AS FinConditionItem,
  Condition.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  Condition.FinConditionSubItem AS FinConditionSubItem,
  Condition.FinInstrConditionLogicGroup AS FinInstrConditionLogicGroup,
  Condition.TreasuryContractType AS TreasuryContractType,
  Condition.FinConditionConditionCategory AS FinConditionConditionCategory,
  Condition.FinConditionConditionType AS FinConditionConditionType,
  Parallel.FinCndnHasParallelInterest AS FinCndnHasParallelInterest,
  Condition.FinConditionInterestCategory AS FinConditionInterestCategory,
  case when Condition.FinConditionInterestCategory <> '06' and Condition.FinConditionInterestCategory <> '07' then Condition.InterestReference end as InterestReference AS InterestReferenceendasInterestReference,
  Condition.FinConditionRpaytPercentRate AS FinConditionRpaytPercentRate,
  Condition.FinConditionRpaytCurrency AS FinConditionRpaytCurrency,
  Condition.FinConditionHasSingleDateEntry AS FinConditionHasSingleDateEntry,
  case when Condition.FinConditionConditionCategory <> '21' then Condition.CalculationDate end as CalculationDate AS CalculationDateendasCalculationDate,
  case when Condition.FinConditionConditionCategory <> '21' then Condition.DueDate end as DueDate AS DueDateendasDueDate,
  Condition.FinConditionFactoryCalendar1 AS FinConditionFactoryCalendar1,
  Condition.FinConditionFactoryCalendar2 AS FinConditionFactoryCalendar2,
  Condition.FinConditionFactoryCalendar3 AS FinConditionFactoryCalendar3,
  Condition.FinConditionFactoryCalendar4 AS FinConditionFactoryCalendar4,
  Condition.FinConditionFactoryCalendar5 AS FinConditionFactoryCalendar5,
  Condition.ExponentialIntrstSettlmtFrqcy AS ExponentialIntrstSettlmtFrqcy,
  Variable.ConditionPercentageRate AS InterestMarkupMarkdownValue,
  Condition.InterestFirstPeriodRate AS InterestFirstPeriodRate,
  Condition.AverageIntrstRateWeightingCat AS AverageIntrstRateWeightingCat,
  Condition.AverageIntrstRateRndngCategory AS AverageIntrstRateRndngCategory,
  Condition.AverageIntrstRateRndngDecimals AS AverageIntrstRateRndngDecimals,
  Condition.AverageInterestRateSpreadValue AS AverageInterestRateSpreadValue,
  Condition.AvgIntrstRateHasUsedUpperLimit AS AvgIntrstRateHasUsedUpperLimit,
  Condition.AverageInterestUpperLimitRate AS AverageInterestUpperLimitRate,
  Condition.AvgIntrstRateHasUsedLowerLimit AS AvgIntrstRateHasUsedLowerLimit,
  Condition.AverageInterestLowerLimitRate AS AverageInterestLowerLimitRate,
  Condition.AverageIntrstRateResetCalcEvt AS AverageIntrstRateResetCalcEvt,
  Condition.FinCndnRateFactorRndngCategory AS FinCndnRateFactorRndngCategory,
  Condition.FinCndnRateFactorRndngDecimals AS FinCndnRateFactorRndngDecimals,
  Condition.FinCndnFactorRoundingCategory AS FinCndnFactorRoundingCategory,
  Condition.FinCndnFactorRoundingDecimals AS FinCndnFactorRoundingDecimals,
  Condition.FinCndnBaseFactorRndngCategory AS FinCndnBaseFactorRndngCategory,
  Condition.FinCndnBaseFactorRndngDecimals AS FinCndnBaseFactorRndngDecimals,
  Condition.FinCndnAmountRoundingCategory AS FinCndnAmountRoundingCategory,
  Condition.FinCndnAmountRoundingUnit AS FinCndnAmountRoundingUnit,
  Condition.RndngBaseUntAmtInCndnItmCrcy AS RndngBaseUntAmtInCndnItmCrcy,
  Condition.FinConditionIntrstBaseAmount AS FinConditionIntrstBaseAmount,
  Condition.FinCndnProcessingSequenceValue AS FinCndnProcessingSequenceValue,
  Condition.FinCndnCrsRefcdAccmlnCndnGrp AS FinCndnCrsRefcdAccmlnCndnGrp,
  Condition.FinCndnPaytDateWrkgDayShft AS FinCndnPaytDateWrkgDayShft,
  Condition.FinCndnRateFixingLockoutPeriod AS FinCndnRateFixingLockoutPeriod
FROM R_FinTransCashFlowActivity AS Activity
INNER JOIN R_FinTransCondition AS Condition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_FinTransCondition AS Scale ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinTransCndnFmlaVarbl AS Variable ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_FinTransHasParallelCondition AS Parallel ON /* join condition not captured in parsed metadata */
INNER JOIN R_FinTransActiveActivity AS FinTransActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransActivity AS _Activity ON CompanyCode = _Activity.CompanyCode AND FinancialTransaction = _Activity.FinancialTransaction AND FinancialInstrumentActivity = _Activity.FinancialInstrumentActivity  -- association [0..1]
LEFT OUTER JOIN I_FinTransactionDirection AS _Direction ON FinancialTransactionDirection = _Direction.FinancialTransactionDirection  -- association [0..1]
LEFT OUTER JOIN I_TreasuryContractType AS _ContractType ON TreasuryContractType = _ContractType.TreasuryContractType  -- association [0..1]
LEFT OUTER JOIN I_FinCndnConditionCategory AS _ConditionCategory ON FinConditionConditionCategory = _ConditionCategory.FinConditionConditionCategory  -- association [0..1]
LEFT OUTER JOIN I_FinCndnConditionType AS _ConditionType ON TreasuryContractType = _ConditionType.TreasuryContractType AND FinConditionConditionType = _ConditionType.FinConditionConditionType  -- association [0..1]
LEFT OUTER JOIN I_FinCndnInterestCategory AS _InterestCategory ON FinConditionInterestCategory = _InterestCategory.FinConditionInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_ReferenceInterestRate AS _ReferenceInterestRate ON InterestReference = _ReferenceInterestRate.ReferenceInterestRate  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FixCurrency ON FinConditionFixedAmountCrcy = _FixCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RepaymentCurrency ON FinConditionRpaytCurrency = _RepaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar1 ON FinConditionFactoryCalendar1 = _Calendar1.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar2 ON FinConditionFactoryCalendar2 = _Calendar2.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar3 ON FinConditionFactoryCalendar3 = _Calendar3.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar4 ON FinConditionFactoryCalendar4 = _Calendar4.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar5 ON FinConditionFactoryCalendar5 = _Calendar5.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FinTransCndnSingleDate AS _SingleDate ON CompanyCode = _SingleDate.CompanyCode AND FinancialTransaction = _SingleDate.FinancialTransaction AND FinancialInstrumentActivity = _SingleDate.FinancialInstrumentActivity AND FinancialTransactionDirection = _SingleDate.FinancialTransactionDirection AND FinConditionItem = _SingleDate.FinConditionItem AND ConditionItemValidityStartDate = _SingleDate.ConditionItemValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_FinTransCndnFmlaVarbl AS _FormulaVariable ON CompanyCode = _FormulaVariable.CompanyCode AND FinancialTransaction = _FormulaVariable.FinancialTransaction AND FinancialInstrumentActivity = _FormulaVariable.FinancialInstrumentActivity AND FinancialTransactionDirection = _FormulaVariable.FinancialTransactionDirection AND FinConditionItem = _FormulaVariable.FinConditionItem AND ConditionItemValidityStartDate = _FormulaVariable.ConditionItemValidityStartDate AND _FormulaVariable.FinConditionFormulaReference <> '0003'  -- association [0..*]
LEFT OUTER JOIN I_FinTransCndnScale AS _Scale ON CompanyCode = _Scale.CompanyCode AND FinancialTransaction = _Scale.FinancialTransaction AND FinancialInstrumentActivity = _Scale.FinancialInstrumentActivity AND FinancialTransactionDirection = _Scale.FinancialTransactionDirection AND FinInstrConditionLogicGroup = _Scale.FinInstrConditionLogicGroup AND ConditionItemValidityStartDate = _Scale.ConditionItemValidityStartDate  -- association [0..*]
;