R_FINTRANSALTERNATIVECONDITION

CDS View

Transaction Alternative Condition

R_FINTRANSALTERNATIVECONDITION is a CDS View in S/4HANA. Transaction Alternative Condition. It contains 9 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 9 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_FinTransAlternativeCondition view from COMPOSITE Alternative Condition
P_FinTransCapFloorCondition view from COMPOSITE Cap Floor Condition
R_FinTransCndnFmlaVarbl view from BASIC Fin. Trans. Condition: Formula Variable

Fields (9)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
ConditionItemValidityStartDate ConditionItemValidityStartDate 1
ConditionPercentageRate ConditionPercentageRate 1
FinancialInstrumentActivity FinancialInstrumentActivity 1
FinancialTransaction FinancialTransaction 1
FinancialTransactionDirection FinancialTransactionDirection 1
FinCndnFormulaVariable FinCndnFormulaVariable 1
FinConditionFormulaReference FinConditionFormulaReference 1
FinConditionItem FinConditionItem 1 
@AbapCatalog.sqlViewName: 'RFINTRSALTCON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Transaction Alternative Condition'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

define view R_FinTransAlternativeCondition 
as select from vtbafinko as AlternativeCondition{
  
  key AlternativeCondition.bukrs    as CompanyCode,
  key AlternativeCondition.rfha     as FinancialTransaction,
  key AlternativeCondition.rfhazu   as FinancialInstrumentActivity,
  key AlternativeCondition.rkondgr  as FinancialTransactionDirection,
  key AlternativeCondition.rkond    as FinConditionItem,
  key AlternativeCondition.dguel_kp as ConditionItemValidityStartDate,
  key AlternativeCondition.nstufe   as FinConditionSubItem,
  key AlternativeCondition.sformref as FinConditionFormulaReference,
  key AlternativeCondition.svarname as FinCndnFormulaVariable, 
  AlternativeCondition.pkond        as ConditionPercentageRate,
  AlternativeCondition.szsref       as InterestReference
  
}
where AlternativeCondition.rgatt is initial

Learn More