I_REFERENCEINTERESTRATEVAL

CDS View

Reference Interest Rate Value

I_REFERENCEINTERESTRATEVAL is a CDS View in S/4HANA. Reference Interest Rate Value. It contains 4 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 4 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EffectiveInterestRate view from COMPOSITE Effective Interest Rate
I_MktDataRefIntrstRateCube view from COMPOSITE Reference IR - Cube
I_RefInterestRateHistory view inner COMPOSITE Reference Interest Rate History
P_IRM_IR_Effective_Date view from COMPOSITE
P_IRM_IR_Pre_Effective_Date view left_outer COMPOSITE
P_IRM_REFINT_HIST_KEYDATE view left_outer COMPOSITE
P_MDRefInt view left_outer COMPOSITE
P_MDRefIntCalDate view left_outer COMPOSITE
P_PreEffectiveInterestRate view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ReferenceInterestRate ReferenceInterestRate 6
_ReferenceInterestRate _ReferenceInterestRate 5
EffectiveDate EffectiveDate 2
EffectiveInterestRate EffectiveInterestRate 5 
@AbapCatalog.sqlViewName: 'IREFIRVAL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'ReferenceInterestRate',
    usageType: {
        dataClass:  #MIXED,
        serviceQuality: #D,
        sizeCategory: #L
    },
    supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
    modelingPattern: [ #ANALYTICAL_DIMENSION ]
}
@Metadata.ignorePropagatedAnnotations: true // For C1-Release 

@AbapCatalog.preserveKey:true
@EndUserText.label: 'Reference Interest Rate Value'
define view I_ReferenceInterestRateVal
  as select from t056p as ReferenceInterestRate
  association [1..1] to I_ReferenceInterestRate as _ReferenceInterestRate on $projection.ReferenceInterestRate = _ReferenceInterestRate.ReferenceInterestRate
{
  @ObjectModel.foreignKey.association: '_ReferenceInterestRate'
  key ReferenceInterestRate.referenz as ReferenceInterestRate,
  @Semantics.businessDate.from:true
  key cast(left(cast(99999999 - cast(cast(ReferenceInterestRate.datab as abap.numc(8)) as abap.dec(8)) as abap.char(13) ) ,8) as abap.dats) as EffectiveDate,
  ReferenceInterestRate.zsoll    as EffectiveInterestRate,
  
  _ReferenceInterestRate
}

Learn More