R_FinTransUndrlgMainIntrstCndn

DDL: R_FINTRANSUNDRLGMAININTRSTCNDN SQL: RFINTRSUNDINTC Type: view BASIC Package: FTTR_CORE
11 Fields 1 Data Sources

Fin Trans Undrlg Main Interest Condition

R_FinTransUndrlgMainIntrstCndn is a Basic CDS View that provides data about "Fin Trans Undrlg Main Interest Condition" in SAP S/4HANA. It reads from 1 data source (vtifinko) and exposes 11 fields with key fields OptionUnderlyingTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem, ConditionItemValidityStartDate. Part of development package FTTR_CORE.

Data Sources (1)

SourceAliasJoin Type
vtifinko UnderlyingCondition from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RFINTRSUNDINTC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fin Trans Undrlg Main Interest Condition view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OptionUnderlyingTransaction
KEY FinancialInstrumentActivity vtifinko rfhazu Activity
KEY FinancialTransactionDirection vtifinko rkondgr Direction
KEY FinConditionItem vtifinko rkond Condition
KEY ConditionItemValidityStartDate vtifinko dguel_kp Item Eff. From
KEY FinConditionSubItem vtifinko nstufe Level Number
ConditionPercentageRate vtifinko pkond Percentage Rate
InterestReference vtifinko szsref Ref.int.rate
InterestCalculationMethod vtifinko szbmeth Int.calc.method
FinInstrConditionLogicGroup
InterestMarkupMarkdownValue UnderlyingAlternativeCondition ConditionPercentageRate

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_FinTransUndrlgMainIntrstCndn.
-- 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: RFINTRSUNDINTC

CREATE VIEW R_FinTransUndrlgMainIntrstCndn AS
SELECT
  cast( UnderlyingCondition.rfha as option_underlying_transaction preserving type ) AS OptionUnderlyingTransaction,
  UnderlyingCondition.rfhazu AS FinancialInstrumentActivity,
  UnderlyingCondition.rkondgr AS FinancialTransactionDirection,
  UnderlyingCondition.rkond AS FinConditionItem,
  UnderlyingCondition.dguel_kp AS ConditionItemValidityStartDate,
  UnderlyingCondition.nstufe AS FinConditionSubItem,
  UnderlyingCondition.pkond AS ConditionPercentageRate,
  UnderlyingCondition.szsref AS InterestReference,
  UnderlyingCondition.szbmeth AS InterestCalculationMethod,
  cast( UnderlyingCondition.logic_rkond as ftr_instr_cndn_logic_group preserving type ) AS FinInstrConditionLogicGroup,
  UnderlyingAlternativeCondition.ConditionPercentageRate AS InterestMarkupMarkdownValue
FROM vtifinko AS UnderlyingCondition
;

Learn More