I_FinTransCurrentActivity

DDL: I_FINTRANSCURRENTACTIVITY SQL: IFTRCURRENTACT Type: view COMPOSITE Package: FTTR_CORE

Financial Transaction Current Activity

I_FinTransCurrentActivity is a Composite CDS View that provides data about "Financial Transaction Current Activity" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, I_FinancialTransaction) and exposes 53 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity. Part of development package FTTR_CORE.

2 data source(s) 53 fields

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity Activity from
I_FinancialTransaction Transaction inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFTRCURRENTACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Current Activity view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransActivity CompanyCode
KEY FinancialTransaction I_FinTransActivity FinancialTransaction
KEY FinancialInstrumentActivity I_FinTransActivity FinancialInstrumentActivity
FinancialInstrActivityCategory I_FinTransActivity FinancialInstrActivityCategory
TermEndDate I_FinTransActivity TermEndDate
TermEndDateIsInclusive I_FinTransActivity TermEndDateIsInclusive
FinTransNoticeDate I_FinTransActivity FinTransNoticeDate
FinTransActyConclusionDate I_FinTransActivity FinTransActyConclusionDate
FinTransActyConclusionTime I_FinTransActivity FinTransActyConclusionTime
FinTransActyConclusionTimeZone I_FinTransActivity FinTransActyConclusionTimeZone
FinTransRolloverDate I_FinTransActivity FinTransRolloverDate
FinTransExerciseDate I_FinTransActivity FinTransExerciseDate Exercise Date
FinTransOrderValidityEndDate I_FinTransActivity FinTransOrderValidityEndDate
FinTransFixingDate I_FinTransActivity FinTransFixingDate
ForeignExchangeFixingReference I_FinTransActivity ForeignExchangeFixingReference
Trader I_FinTransActivity Trader
FinancialInstrContactPerson I_FinTransActivity FinancialInstrContactPerson
FinInstrExternalReference I_FinTransActivity FinInstrExternalReference
TreasuryReversalReason I_FinTransActivity TreasuryReversalReason
FinTransConfirmationStatus I_FinTransActivity FinTransConfirmationStatus
FinTransConfirmationDate I_FinTransActivity FinTransConfirmationDate
FinTransConfirmedByUser I_FinTransActivity FinTransConfirmedByUser Confirmed By User
FinTransCntrconfStatus I_FinTransActivity FinTransCntrconfStatus
FinTransCntrconfDate I_FinTransActivity FinTransCntrconfDate
FinTransCntrconfCreatedByUser I_FinTransActivity FinTransCntrconfCreatedByUser Conterconfirmed By User
LeadingCurrency I_FinTransActivity LeadingCurrency
FollowingCurrency I_FinTransActivity FollowingCurrency
ExchangeRate I_FinTransActivity ExchangeRate
SpotExchangeRate I_FinTransActivity SpotExchangeRate
SwapExchangeRate I_FinTransActivity SwapExchangeRate
EffectiveInterestRate I_FinTransActivity EffectiveInterestRate
EffectiveInterestMethod I_FinTransActivity EffectiveInterestMethod
LetterOfCredit I_FinTransActivity LetterOfCredit
TreasuryApplicant I_FinTransActivity TreasuryApplicant
TreasuryBeneficiary I_FinTransActivity TreasuryBeneficiary
TrsyMnllyEnteredBnfcyName I_FinTransActivity TrsyMnllyEnteredBnfcyName
TrsyMnllyEnteredApplcntName I_FinTransActivity TrsyMnllyEnteredApplcntName
TreasuryAdvisingBank I_FinTransActivity TreasuryAdvisingBank
TreasuryIssuingBank I_FinTransActivity TreasuryIssuingBank
_CompanyCode I_FinTransActivity _CompanyCode
_FinTrans I_FinTransActivity _FinTrans
_ActivityCategory I_FinTransActivity _ActivityCategory
_TimeZone I_FinTransActivity _TimeZone
_FixRef I_FinTransActivity _FixRef
_RevReason I_FinTransActivity _RevReason
_ConfStatus I_FinTransActivity _ConfStatus
_CntrconfStatus I_FinTransActivity _CntrconfStatus
_LeadingCurrency I_FinTransActivity _LeadingCurrency
_FollowingCurrency I_FinTransActivity _FollowingCurrency
_ApplicantBP I_FinTransActivity _ApplicantBP
_BeneficiaryBP I_FinTransActivity _BeneficiaryBP
_AdvisingBankBP I_FinTransActivity _AdvisingBankBP
_IssuingBankBP I_FinTransActivity _IssuingBankBP 
@AbapCatalog.sqlViewName: 'IFTRCURRENTACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Current Activity'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true // For C1-Release

@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
define view I_FinTransCurrentActivity 
// restrict selection from I_FinTransActivity to last active activity

  as select from I_FinTransActivity as Activity
  inner join I_FinancialTransaction as Transaction on  Activity.CompanyCode                 = Transaction.CompanyCode
                                                   and Activity.FinancialTransaction        = Transaction.FinancialTransaction
                                                   and Activity.FinancialInstrumentActivity = Transaction.FinInstrLastActiveActivity

{
// exposed fields (same as with I_FinTransActivity)

  @ObjectModel.foreignKey.association: '_CompanyCode'
  key Activity.CompanyCode,
  @ObjectModel.foreignKey.association: '_FinTrans'
  key Activity.FinancialTransaction,
  key Activity.FinancialInstrumentActivity,
  @ObjectModel.foreignKey.association: '_ActivityCategory'
  Activity.FinancialInstrActivityCategory,
  Activity.TermEndDate,
  Activity.TermEndDateIsInclusive,
  Activity.FinTransNoticeDate,
  Activity.FinTransActyConclusionDate,
  Activity.FinTransActyConclusionTime,
  @ObjectModel.foreignKey.association: '_TimeZone'
  Activity.FinTransActyConclusionTimeZone,
  Activity.FinTransRolloverDate,
  @EndUserText.label: 'Exercise Date'
  @EndUserText.quickInfo: 'Exercise Date'
  Activity.FinTransExerciseDate,
  Activity.FinTransOrderValidityEndDate,
  Activity.FinTransFixingDate,
  @ObjectModel.foreignKey.association: '_FixRef'
  Activity.ForeignExchangeFixingReference,
  Activity.Trader,
  Activity.FinancialInstrContactPerson,
  Activity.FinInstrExternalReference,
  @ObjectModel.foreignKey.association: '_RevReason'
  Activity.TreasuryReversalReason,
  @ObjectModel.foreignKey.association: '_ConfStatus'
  Activity.FinTransConfirmationStatus,
  Activity.FinTransConfirmationDate,
  @EndUserText.label: 'Confirmed By User'
  Activity.FinTransConfirmedByUser,
  @ObjectModel.foreignKey.association: '_CntrconfStatus'
  Activity.FinTransCntrconfStatus,
  Activity.FinTransCntrconfDate,
  @EndUserText.label: 'Conterconfirmed By User'
  Activity.FinTransCntrconfCreatedByUser,
  @ObjectModel.foreignKey.association: '_LeadingCurrency'
  @Semantics.currencyCode: true
  Activity.LeadingCurrency,
  @ObjectModel.foreignKey.association: '_FollowingCurrency'
  @Semantics.currencyCode: true
  Activity.FollowingCurrency,
  Activity.ExchangeRate,
  Activity.SpotExchangeRate,
  Activity.SwapExchangeRate,
  Activity.EffectiveInterestRate,
  Activity.EffectiveInterestMethod,
  Activity.LetterOfCredit,
  @ObjectModel.foreignKey.association: '_ApplicantBP'
  Activity.TreasuryApplicant,
  @ObjectModel.foreignKey.association: '_BeneficiaryBP'
  Activity.TreasuryBeneficiary,
  Activity.TrsyMnllyEnteredBnfcyName,
  Activity.TrsyMnllyEnteredApplcntName,
  @ObjectModel.foreignKey.association: '_AdvisingBankBP'
  Activity.TreasuryAdvisingBank,
  @ObjectModel.foreignKey.association: '_IssuingBankBP'
  Activity.TreasuryIssuingBank,
// exposed dimensions (same as within I_FinTransActivity)

  Activity._CompanyCode,
  Activity._FinTrans,
  Activity._ActivityCategory,
  Activity._TimeZone,
  Activity._FixRef,
  Activity._RevReason,
  Activity._ConfStatus,
  Activity._CntrconfStatus,
  Activity._LeadingCurrency,
  Activity._FollowingCurrency,
  Activity._ApplicantBP,
  Activity._BeneficiaryBP,
  Activity._AdvisingBankBP,
  Activity._IssuingBankBP
}

Learn More