I_FinTransIntrstRateAdjmt

DDL: I_FINTRANSINTRSTRATEADJMT Type: view_entity BASIC Package: FTTR_CORE

Interest Rate Adjustment

I_FinTransIntrstRateAdjmt is a Basic CDS View that provides data about "Interest Rate Adjustment" in SAP S/4HANA. It reads from 1 data source (triat) and exposes 14 fields with key fields CompanyCode, FinancialTransaction, IntrstRateAdjmtCashFlowCode, InterestRateFixingDate, ReferenceInterestRate. It has 2 associations to related views. Part of development package FTTR_CORE.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
triat InterestRateAdjustment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Interest Rate Adjustment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY FinancialTransaction
KEY IntrstRateAdjmtCashFlowCode triat cashflow_id
KEY InterestRateFixingDate triat ira_date
KEY ReferenceInterestRate triat int_reference
TreasuryInterestRateInPercent triat int_value
FinInterestRateAdjmtStatus triat regi_state
IntrstRateAdjmtEffctvFrmDate triat term_from
InterestRateAdjustmentTrigger triat ira_trigger
IntrstRateAdjmtFixedByUser triat fixer_name
IntrstRateAdjmtCreatedDate
IntrstRateAdjmtCreatedTime
_CompanyCode _CompanyCode
_FinTrans _FinTrans 
@AbapCatalog.viewEnhancementCategory: [ #NONE ]

@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Interest Rate Adjustment'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }

@VDM.viewType: #BASIC

define view entity I_FinTransIntrstRateAdjmt

  as select from triat as InterestRateAdjustment
  
  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
                                                                            
{
  key cast(substring(InterestRateAdjustment.bearer_id, 1, 4) as bukrs preserving type)    as CompanyCode,
  key cast(substring(InterestRateAdjustment.bearer_id, 5, 13) as tb_rfha preserving type) as FinancialTransaction,
  key InterestRateAdjustment.cashflow_id as IntrstRateAdjmtCashFlowCode,
  key InterestRateAdjustment.ira_date as InterestRateFixingDate,
  key InterestRateAdjustment.int_reference as ReferenceInterestRate,
  InterestRateAdjustment.int_value as TreasuryInterestRateInPercent,
  InterestRateAdjustment.regi_state as FinInterestRateAdjmtStatus,
  InterestRateAdjustment.term_from as IntrstRateAdjmtEffctvFrmDate, 
  InterestRateAdjustment.ira_trigger as InterestRateAdjustmentTrigger,
  InterestRateAdjustment.fixer_name as IntrstRateAdjmtFixedByUser,
  cast(InterestRateAdjustment.fixing_date as ftr_ira_created_date preserving type ) as IntrstRateAdjmtCreatedDate,
  cast(InterestRateAdjustment.fixing_time as ftr_ira_created_time preserving type ) as IntrstRateAdjmtCreatedTime,
  
  //association

  _CompanyCode,
  _FinTrans
}

where InterestRateAdjustment.activity_state = '01'
and InterestRateAdjustment.bearer_cat = '02'

Learn More