P_FinTransIntrstRateInstr

DDL: P_FINTRANSINTRSTRATEINSTR SQL: PFINTRANIRI Type: view COMPOSITE

P_FinTransIntrstRateInstr is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 44 fields with key fields CompanyCode, FinancialTransaction.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction I_FinancialTransaction from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRANIRI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FinancialTransaction FinancialTransaction
TreasuryFinancialObject TreasuryFinancialObject
CreatedByUser CreatedByUser
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
TreasuryContractType TreasuryContractType
FinancialInstrProductCategory FinancialInstrProductCategory
FinancialInstrumentProductType FinancialInstrumentProductType
FinInstrTransactionCategory FinInstrTransactionCategory
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransProcessingCategory FinTransProcessingCategory
TermStartDate TermStartDate
TermStartDateIsInclusive TermStartDateIsInclusive
FinTransNoticePeriod FinTransNoticePeriod
FinTransNoticePeriodUnit FinTransNoticePeriodUnit
FinTransFactoryCalendar1 FinTransFactoryCalendar1
FinTransFactoryCalendar2 FinTransFactoryCalendar2
Counterparty Counterparty
FinancialInstrumentGuarantor FinancialInstrumentGuarantor
Portfolio Portfolio
TreasuryFinanceProject TreasuryFinanceProject
FinancialInstrumentAssignment FinancialInstrumentAssignment
FinancialInstrumentReference FinancialInstrumentReference
FinancialInstrCharacteristic FinancialInstrCharacteristic
TreasuryValuationClass TreasuryValuationClass
BusinessArea BusinessArea
CostCenter CostCenter
HedgingClassification HedgingClassification
ProfitCenter ProfitCenter
WBSElementInternalID WBSElementInternalID
TreasuryFacilityCompanyCode TreasuryFacilityCompanyCode
TreasuryFacility TreasuryFacility
FinancialInstrumentStatus FinancialInstrumentStatus
FinTransReleaseStatus FinTransReleaseStatus
TransactionCurrency TransactionCurrency
FinInstrLastActiveActivity FinInstrLastActiveActivity
FinTransIsRiskMitigating FinTransIsRiskMitigating
TermEndDate TermEndDate
FinTransIntrstHndlgAtRollover _CurrentActivity FinTransIntrstHndlgAtRollover
RolloverDfrrdIntrstPyoutDte _CurrentActivity RolloverDfrrdIntrstPyoutDte 
@AbapCatalog.sqlViewName: 'PFINTRANIRI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_FinTransIntrstRateInstr
  as select from I_FinancialTransaction

{

 key  CompanyCode,
 key  FinancialTransaction,

      TreasuryFinancialObject,
      CreatedByUser,
      FinTransCreationDate,
      FinTransCreationTime,
      LastChangedByUser,
      LastChangeDate,
      FinInstrumentLastChangedTime,
      TreasuryContractType,
      FinancialInstrProductCategory,
      FinancialInstrumentProductType,
      FinInstrTransactionCategory,
      FinancialInstrTransactionType,
      FinTransProcessingCategory,
      TermStartDate,
      TermStartDateIsInclusive,
      FinTransNoticePeriod,
      FinTransNoticePeriodUnit,
      FinTransFactoryCalendar1,
      FinTransFactoryCalendar2,
      Counterparty,
      FinancialInstrumentGuarantor,
      Portfolio,
      TreasuryFinanceProject,
      FinancialInstrumentAssignment,
      FinancialInstrumentReference,
      FinancialInstrCharacteristic,
      TreasuryValuationClass,
      BusinessArea,
      CostCenter,
      HedgingClassification,
      ProfitCenter,
      WBSElementInternalID,
      TreasuryFacilityCompanyCode,
      TreasuryFacility,
      FinancialInstrumentStatus,
      FinTransReleaseStatus,
      TransactionCurrency,
      FinInstrLastActiveActivity,
      FinTransIsRiskMitigating,
      TermEndDate,

      _CurrentActivity.FinTransIntrstHndlgAtRollover,
      _CurrentActivity.RolloverDfrrdIntrstPyoutDte

}
where FinancialInstrProductCategory = '550'

Learn More