I_FinTransCndnFmlaVarbl

DDL: I_FINTRANSCNDNFMLAVARBL SQL: IFINTRANSCNDNVAR Type: view COMPOSITE Package: FTTR_CORE
16 Fields 2 Data Sources 5 Associations

Fin Trans Condition Formula Variable

I_FinTransCndnFmlaVarbl (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FinTransCndnFmlaVarbl is a Composite CDS View that provides data about "Fin Trans Condition Formula Variable" in SAP S/4HANA. It reads from 2 data sources (R_FinTransCashFlowActivity, R_FinTransCndnFmlaVarbl) and exposes 16 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It has 5 associations to related views. Part of development package FTTR_CORE.

SAP Help Documentation

CategoryFinancial Transaction Data
Data CategoryComposite
StatusReleased
Purpose
This CDS view provides detailed information for formula-based conditions (the Interest Category field is filled with the value 04 ( Formula )). This CDS view provides the prerequisites for answering the following business questions: What are the variables of the formula reference? What is the percentage rate of the condition item?

Prerequisites
Users who want to use this CDS view must have a role with the following restriction types set to read access: Company Code/Product Type/Financial Transaction Type Company Code/Securities Account Company Code/Portfolio These restriction types are edited in the Maintain Business Roles app.

Structure
The main filters are as follows: Company Code Financial Transaction Financial Instrument Activity Measures and attributes Some important measures and attributes are: Company Code Financial Transaction Transaction Activity Direction of Transaction Condition Condition Item Valid From Formula Reference Variable Name Percentage rate for condition items Reference Interest Rate

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides detailed information for formula-based conditions (the Interest Category field is filled with the value 04 (Formula)).</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What are the variables of the formula reference?</p> </li> <li> <p>What is the percentage rate of the condition item?</p> </li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
R_FinTransCashFlowActivity Activity from
R_FinTransCndnFmlaVarbl FormulaVariable inner

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction
[0..1] I_FinTransActivity _Activity $projection.CompanyCode = _Activity.CompanyCode and $projection.FinancialTransaction = _Activity.FinancialTransaction and $projection.FinancialInstrumentActivity = _Activity.FinancialInstrumentActivity
[0..1] I_FinTransactionDirection _Direction $projection.FinancialTransactionDirection = _Direction.FinancialTransactionDirection
[0..1] I_ReferenceInterestRate _ReferenceInterestRate $projection.InterestReference = _ReferenceInterestRate.ReferenceInterestRate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSCNDNVAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fin Trans Condition Formula Variable view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode R_FinTransCndnFmlaVarbl CompanyCode Receiver Company Code
KEY FinancialTransaction R_FinTransCndnFmlaVarbl FinancialTransaction Financial Transaction
KEY FinancialInstrumentActivity R_FinTransCndnFmlaVarbl FinancialInstrumentActivity Transaction Activity
KEY FinancialTransactionDirection R_FinTransCndnFmlaVarbl FinancialTransactionDirection Direction of Transaction
KEY FinConditionItem R_FinTransCndnFmlaVarbl FinConditionItem Condition
KEY ConditionItemValidityStartDate R_FinTransCndnFmlaVarbl ConditionItemValidityStartDate Condition Item Effective From
KEY FinConditionFormulaReference R_FinTransCndnFmlaVarbl FinConditionFormulaReference Formula Reference
KEY FinCndnFormulaVariable R_FinTransCndnFmlaVarbl FinCndnFormulaVariable Variable Name
FinancialInstrProductCategory _FinTrans FinancialInstrProductCategory Financial Instrument Product Category
ConditionPercentageRate R_FinTransCndnFmlaVarbl ConditionPercentageRate Percentage rate for condition items
InterestReference R_FinTransCndnFmlaVarbl InterestReference Reference Interest Rate
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_Activity _Activity
_Direction _Direction
_ReferenceInterestRate _ReferenceInterestRate

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_FinTransCndnFmlaVarbl.
-- 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: IFINTRANSCNDNVAR

CREATE VIEW I_FinTransCndnFmlaVarbl 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,
  _FinTrans.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FormulaVariable.ConditionPercentageRate AS ConditionPercentageRate,
  FormulaVariable.InterestReference AS InterestReference
FROM R_FinTransCashFlowActivity AS Activity
INNER JOIN R_FinTransCndnFmlaVarbl AS FormulaVariable 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_ReferenceInterestRate AS _ReferenceInterestRate ON InterestReference = _ReferenceInterestRate.ReferenceInterestRate  -- association [0..1]
;

Learn More