P_FinTransactionActivity

DDL: P_FINTRANSACTIONACTIVITY SQL: PFINTRANSACT Type: view COMPOSITE Package: FTR_IRM_CORE

Financial Transaction Activity

P_FinTransactionActivity is a Composite CDS View that provides data about "Financial Transaction Activity" in SAP S/4HANA. It reads from 2 data sources (vtbfha, vtbfhazu) and exposes 11 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, TreasuryFinancialObject. It has 1 association to related views. Part of development package FTR_IRM_CORE.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
vtbfha Transaction inner
vtbfhazu TransactionHistory from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRANSACT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfhazu bukrs
KEY FinancialTransaction vtbfhazu rfha
KEY FinancialInstrumentActivity vtbfhazu rfhazu
KEY TreasuryFinancialObject vtbfha objnr
FinancialInstrProductCategory vtbfha sanlf
FinInstrTransactionCategory vtbfha sfgtyp
FinancialInstrumentStatus vtbfha saktiv
Trader vtbfhazu rdealer
TermStartDate vtbfha dblfz
TermEndDate vtbfhazu delfz
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'PFINTRANSACT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true 
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B
@VDM.private:true
define view P_FinTransactionActivity
  as select from vtbfhazu as TransactionHistory
    inner join   vtbfha   as Transaction on  Transaction.bukrs   = TransactionHistory.bukrs
                                         and Transaction.rfha    = TransactionHistory.rfha
                                         and Transaction.rfhazul = TransactionHistory.rfhazu
  association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key TransactionHistory.bukrs                                               as CompanyCode,
  key TransactionHistory.rfha                                                as FinancialTransaction,
  key TransactionHistory.rfhazu                                              as FinancialInstrumentActivity,
  key Transaction.objnr                                                      as TreasuryFinancialObject,
      Transaction.sanlf                                                      as FinancialInstrProductCategory,
      Transaction.sfgtyp                                                     as FinInstrTransactionCategory,
      Transaction.saktiv                                                     as FinancialInstrumentStatus,

      TransactionHistory.rdealer                                             as Trader,
      Transaction.dblfz                                                      as TermStartDate,
      TransactionHistory.delfz                                               as TermEndDate,
      //      TransactionHistory.rdealer                                             as Trader,


      _CompanyCode
}

where
  //Security

     Transaction.sanlf = '020'
  or Transaction.sanlf = '040'
  or Transaction.sanlf = '042'
  or Transaction.sanlf = '060'
  or Transaction.sanlf = '070'
  //Money market

  or Transaction.sanlf = '510'
  or Transaction.sanlf = '520'
  or Transaction.sanlf = '530'
  or Transaction.sanlf = '540'
  or Transaction.sanlf = '550'
  or Transaction.sanlf = '580'
  //for IRS

  or Transaction.sanlf = '620'

Learn More