I_FinTransCndnFmlaVarbl

Q: Which tables does I_FinTransCndnFmlaVarbl use?

I_FinTransCndnFmlaVarbl reads from 2 data source(s): R_FinTransCashFlowActivity, R_FinTransCndnFmlaVarbl.

Q: How many fields does I_FinTransCndnFmlaVarbl have?

I_FinTransCndnFmlaVarbl has 16 fields. Key fields: CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem.

DDL: I_FINTRANSCNDNFMLAVARBL SQL: IFINTRANSCNDNVAR Type: view COMPOSITE

Fin Trans Condition Formula Variable

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.

Data Sources (2)

Source	Alias	Join Type
R_FinTransCashFlowActivity	Activity	from
R_FinTransCndnFmlaVarbl	FormulaVariable	inner

Associations (5)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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	#D	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.allowExtensions	false	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view

Fields (16)

Key	Field	Source Table	Source Field
KEY	CompanyCode	R_FinTransCndnFmlaVarbl	CompanyCode
KEY	FinancialTransaction	R_FinTransCndnFmlaVarbl	FinancialTransaction
KEY	FinancialInstrumentActivity	R_FinTransCndnFmlaVarbl	FinancialInstrumentActivity
KEY	FinancialTransactionDirection	R_FinTransCndnFmlaVarbl	FinancialTransactionDirection
KEY	FinConditionItem	R_FinTransCndnFmlaVarbl	FinConditionItem
KEY	ConditionItemValidityStartDate	R_FinTransCndnFmlaVarbl	ConditionItemValidityStartDate
KEY	FinConditionFormulaReference	R_FinTransCndnFmlaVarbl	FinConditionFormulaReference
KEY	FinCndnFormulaVariable	R_FinTransCndnFmlaVarbl	FinCndnFormulaVariable
	FinancialInstrProductCategory	_FinTrans	FinancialInstrProductCategory
	ConditionPercentageRate	R_FinTransCndnFmlaVarbl	ConditionPercentageRate
	InterestReference	R_FinTransCndnFmlaVarbl	InterestReference
	_CompanyCode		_CompanyCode
	_FinTrans		_FinTrans
	_Activity		_Activity
	_Direction		_Direction
	_ReferenceInterestRate		_ReferenceInterestRate

@AbapCatalog.sqlViewName: 'IFINTRANSCNDNVAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Fin Trans Condition Formula Variable'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true // For C1-Release

@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
define view I_FinTransCndnFmlaVarbl 
  //all activities containing conditions

  as select from R_FinTransCashFlowActivity as Activity
  //all conditions of these activities (within where-condition they can be restricted)

  inner join R_FinTransCndnFmlaVarbl as FormulaVariable on Activity.CompanyCode                 = FormulaVariable.CompanyCode
                                                       and Activity.FinancialTransaction        = FormulaVariable.FinancialTransaction
                                                       and Activity.FinancialInstrumentActivity = FormulaVariable.FinancialInstrumentActivity
// dimensions, containing for example text fields

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

{
  //exposed fields

  @ObjectModel.foreignKey.association: '_CompanyCode'
  key FormulaVariable.CompanyCode                    as CompanyCode,
  @ObjectModel.foreignKey.association: '_FinTrans'
  key FormulaVariable.FinancialTransaction           as FinancialTransaction,
  @ObjectModel.foreignKey.association: '_Activity'
  key FormulaVariable.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  @ObjectModel.foreignKey.association: '_Direction'
  key FormulaVariable.FinancialTransactionDirection  as FinancialTransactionDirection,
  key FormulaVariable.FinConditionItem               as FinConditionItem,
  key FormulaVariable.ConditionItemValidityStartDate as ConditionItemValidityStartDate,
  key FormulaVariable.FinConditionFormulaReference   as FinConditionFormulaReference,
  key FormulaVariable.FinCndnFormulaVariable         as FinCndnFormulaVariable,
  _FinTrans.FinancialInstrProductCategory            as FinancialInstrProductCategory,
  FormulaVariable.ConditionPercentageRate            as ConditionPercentageRate,
  @ObjectModel.foreignKey.association: '_ReferenceInterestRate'
  FormulaVariable.InterestReference                  as InterestReference,
  
  //exposed dimensions, containing for example text fields

  _CompanyCode,
  _FinTrans,
  _Activity,
  _Direction,
  _ReferenceInterestRate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION",
"R_FINTRANSCASHFLOWACTIVITY",
"R_FINTRANSCNDNFMLAVARBL"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_FINANCIALTRANSACTION",
"I_FINTRANSACTIONDIRECTION",
"I_FINTRANSACTIVITY",
"I_REFERENCEINTERESTRATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FinTransCndnFmlaVarbl view

R_FinTransCashFlowActivity view
R_FinTransCndnFmlaVarbl view

A_IntrstRateInstrFmlaVarbl view_entity
I_FinTransCondition view