R_FinTransCndnFmlaVarblTP

DDL: R_FINTRANSCNDNFMLAVARBLTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT
14 Fields 1 Data Sources 1 Associations

Fin Trans Variable Interest Formula - TP

R_FinTransCndnFmlaVarblTP is a Transactional CDS View that provides data about "Fin Trans Variable Interest Formula - TP" in SAP S/4HANA. It reads from 1 data source (I_FinTransCndnFmlaVarbl) and exposes 14 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It has 1 association to related views. Part of development package RAP_FIN_TRM_TM_FT.

Data Sources (1)

SourceAliasJoin Type
I_FinTransCndnFmlaVarbl FormulaVariable from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_FinancialTransactionTP _FinancialTransaction $projection.CompanyCode = _FinancialTransaction.CompanyCode and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Fin Trans Variable Interest Formula - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransCndnFmlaVarbl CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinTransCndnFmlaVarbl FinancialTransaction Transaction
KEY FinancialInstrumentActivity I_FinTransCndnFmlaVarbl FinancialInstrumentActivity
KEY FinancialTransactionDirection I_FinTransCndnFmlaVarbl FinancialTransactionDirection
KEY FinConditionItem I_FinTransCndnFmlaVarbl FinConditionItem
KEY ConditionItemValidityStartDate I_FinTransCndnFmlaVarbl ConditionItemValidityStartDate
KEY FinConditionFormulaReference I_FinTransCndnFmlaVarbl FinConditionFormulaReference
KEY FinCndnFormulaVariable I_FinTransCndnFmlaVarbl FinCndnFormulaVariable
ConditionPercentageRate I_FinTransCndnFmlaVarbl ConditionPercentageRate
InterestReference I_FinTransCndnFmlaVarbl InterestReference
FinancialInstrProductCategory I_FinTransCndnFmlaVarbl FinancialInstrProductCategory
_Condition _Condition
_FinancialTransaction _FinancialTransaction
_FinTrans I_FinTransCndnFmlaVarbl _FinTrans

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_FinTransCndnFmlaVarblTP.
-- 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.

CREATE VIEW R_FinTransCndnFmlaVarblTP AS
SELECT
  FormulaVariable.CompanyCode AS CompanyCode,
  FormulaVariable.FinancialTransaction AS FinancialTransaction,
  FormulaVariable.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  FormulaVariable.FinancialTransactionDirection AS FinancialTransactionDirection,
  FormulaVariable.FinConditionItem AS FinConditionItem,
  FormulaVariable.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  FormulaVariable.FinConditionFormulaReference AS FinConditionFormulaReference,
  FormulaVariable.FinCndnFormulaVariable AS FinCndnFormulaVariable,
  FormulaVariable.ConditionPercentageRate AS ConditionPercentageRate,
  FormulaVariable.InterestReference AS InterestReference,
  FormulaVariable.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FormulaVariable._FinTrans AS _FinTrans
FROM I_FinTransCndnFmlaVarbl AS FormulaVariable
LEFT OUTER JOIN R_FinancialTransactionTP AS _FinancialTransaction ON CompanyCode = _FinancialTransaction.CompanyCode AND FinancialTransaction = _FinancialTransaction.FinancialTransaction  -- association [1..1]
;

Learn More