A_FinTransIntrstRateInstr

DDL: A_FINTRANSINTRSTRATEINSTR Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_TM_FT_API

Interest Rate Instrument

A_FinTransIntrstRateInstr is a Consumption CDS View that provides data about "Interest Rate Instrument" in SAP S/4HANA. It reads from 1 data source (R_FinancialTransactionTP) and exposes 28 fields with key fields CompanyCode, FinancialTransaction. It has 5 associations to related views. It is exposed through 1 OData service (API_FINTRANSINTRSTRATEINSTR). Part of development package RAP_FIN_TRM_TM_FT_API.

Data Sources (1)

SourceAliasJoin Type
R_FinancialTransactionTP R_FinancialTransactionTP projection

Associations (5)

CardinalityTargetAliasCondition
[1..*] A_IntrstRateInstrIntrstCndn _InterestCondition $projection.CompanyCode = _InterestCondition.CompanyCode and $projection.FinancialTransaction = _InterestCondition.FinancialTransaction
[0..*] A_IntrstRateInstrAdjmtCndn _AdjustmentCondition $projection.CompanyCode = _AdjustmentCondition.CompanyCode and $projection.FinancialTransaction = _AdjustmentCondition.FinancialTransaction
[0..*] A_IntrstRateInstrRpaytCndn _RepaymentCondition $projection.CompanyCode = _RepaymentCondition.CompanyCode and $projection.FinancialTransaction = _RepaymentCondition.FinancialTransaction
[0..*] A_IntrstRateInstrAccmlnCndn _AccumulatingCondition $projection.CompanyCode = _AccumulatingCondition.CompanyCode and $projection.FinancialTransaction = _AccumulatingCondition.FinancialTransaction
[0..*] A_IntrstRateInstrAccruedCndn _AccruedCondition $projection.CompanyCode = _AccruedCondition.CompanyCode and $projection.FinancialTransaction = _AccruedCondition.FinancialTransaction

Annotations (9)

NameValueLevelField
EndUserText.label Interest Rate Instrument view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
OData.entityType.name FinTransIntrstRateInstr_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_FINTRANSINTRSTRATEINSTR API_FINTRANSINTRSTRATEINSTR V4 C2 Deprecated

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FinancialTransaction FinancialTransaction
FinancialInstrumentActivity FinancialInstrumentActivity
FinancialInstrumentStatus FinancialInstrumentStatus
Counterparty Counterparty
FinTransActyConclusionDate FinTransActyConclusionDate
FinTransActyConclusionTime FinTransActyConclusionTime
FinTransActyConclusionTimeZone FinTransActyConclusionTimeZone
FinInstrExternalReference FinInstrExternalReference
MarketIdentifierCode MarketIdentifierCode
Trader Trader
FinancialInstrContactPerson FinancialInstrContactPerson
CreatedByUser CreatedByUser
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrTransactionType FinancialInstrTransactionType
TradeLegalBasis TradeLegalBasis
ExternalTradeIdentifier ExternalTradeIdentifier
ClassificationOfFinInstr ClassificationOfFinInstr
_InterestCondition _InterestCondition
_AdjustmentCondition _AdjustmentCondition
_RepaymentCondition _RepaymentCondition
_AccumulatingCondition _AccumulatingCondition
_AccruedCondition _AccruedCondition
@EndUserText.label: 'Interest Rate Instrument'
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel:{
    usageType : {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
}
@VDM.viewType:#CONSUMPTION
//@ObjectModel.representativeKey: 'FinancialTransaction'

@OData.entityType.name: 'FinTransIntrstRateInstr_Type'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define root view entity A_FinTransIntrstRateInstr
  provider contract transactional_query
  as projection on R_FinancialTransactionTP

  association [1..*] to A_IntrstRateInstrIntrstCndn as _InterestCondition     on  $projection.CompanyCode          = _InterestCondition.CompanyCode
                                                                              and $projection.FinancialTransaction = _InterestCondition.FinancialTransaction
  association [0..*] to A_IntrstRateInstrAdjmtCndn  as _AdjustmentCondition   on  $projection.CompanyCode          = _AdjustmentCondition.CompanyCode
                                                                              and $projection.FinancialTransaction = _AdjustmentCondition.FinancialTransaction
  association [0..*] to A_IntrstRateInstrRpaytCndn  as _RepaymentCondition    on  $projection.CompanyCode          = _RepaymentCondition.CompanyCode
                                                                              and $projection.FinancialTransaction = _RepaymentCondition.FinancialTransaction
  association [0..*] to A_IntrstRateInstrAccmlnCndn as _AccumulatingCondition on  $projection.CompanyCode          = _AccumulatingCondition.CompanyCode
                                                                              and $projection.FinancialTransaction = _AccumulatingCondition.FinancialTransaction
  association [0..*] to A_IntrstRateInstrAccruedCndn as _AccruedCondition     on  $projection.CompanyCode          = _AccruedCondition.CompanyCode
                                                                              and $projection.FinancialTransaction = _AccruedCondition.FinancialTransaction

{
 
  key  CompanyCode,
  key  FinancialTransaction,
       FinancialInstrumentActivity,
       FinancialInstrumentStatus,
       Counterparty,
       FinTransActyConclusionDate,
       FinTransActyConclusionTime,
       FinTransActyConclusionTimeZone,
       FinInstrExternalReference,
       MarketIdentifierCode,
       Trader,
       FinancialInstrContactPerson,
       CreatedByUser,
       FinTransCreationDate,
       FinTransCreationTime,
       LastChangedByUser,
       LastChangeDate,
       FinInstrumentLastChangedTime,
       FinancialInstrumentProductType,
       FinancialInstrTransactionType,
       TradeLegalBasis,
       ExternalTradeIdentifier,
       ClassificationOfFinInstr,
       

       _Attribute           : redirected to composition child A_IntrstRateInstrAttrib,
       _AdditionalAttribute : redirected to composition child A_IntrstRateInstrAddlAttrib,
       _MainFlow            : redirected to composition child A_IntrstRateInstrMainFlow,
       _AdditionalFlow      : redirected to composition child A_IntrstRateInstrAddlFlw,
       _InterestCondition,
       _AdjustmentCondition,
       _RepaymentCondition,
       _AccumulatingCondition,
       _AccruedCondition

}
where
  FinancialInstrProductCategory = '550'