R_FinTransCndnScFmlaVarblTP

DDL: R_FINTRANSCNDNSCFMLAVARBLTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT
15 Fields 1 Data Sources 1 Associations

Fin Trans Cndn Scale Formula - TP

R_FinTransCndnScFmlaVarblTP is a Transactional CDS View that provides data about "Fin Trans Cndn Scale Formula - TP" in SAP S/4HANA. It reads from 1 data source (I_FinTransCndnFmlaVarbl) and exposes 15 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, ConditionItemValidityStartDate. 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 Cndn Scale Formula - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

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 ConditionItemValidityStartDate I_FinTransCndnFmlaVarbl ConditionItemValidityStartDate
KEY FinConditionItem Scale FinConditionItem
KEY FinancialConditionScaleItem I_FinTransCndnFmlaVarbl FinConditionItem
KEY FinConditionFormulaReference I_FinTransCndnFmlaVarbl FinConditionFormulaReference
KEY FinCndnFormulaVariable I_FinTransCndnFmlaVarbl FinCndnFormulaVariable
ConditionPercentageRate I_FinTransCndnFmlaVarbl ConditionPercentageRate
InterestReference I_FinTransCndnFmlaVarbl InterestReference
FinancialInstrProductCategory I_FinTransCndnFmlaVarbl FinancialInstrProductCategory
_FinancialTransaction _FinancialTransaction
_ConditionScale _ConditionScale
_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_FinTransCndnScFmlaVarblTP.
-- 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_FinTransCndnScFmlaVarblTP AS
SELECT
  FormulaVariable.CompanyCode AS CompanyCode,
  FormulaVariable.FinancialTransaction AS FinancialTransaction,
  FormulaVariable.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  FormulaVariable.FinancialTransactionDirection AS FinancialTransactionDirection,
  FormulaVariable.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  Scale.FinConditionItem AS FinConditionItem,
  FormulaVariable.FinConditionItem AS FinancialConditionScaleItem,
  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