R_FINTRANSCONTRACTACTIVITY

CDS View

Financial Transaction Contract Activity

R_FINTRANSCONTRACTACTIVITY is a CDS View in S/4HANA. Financial Transaction Contract Activity. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinTransContractActivity view inner COMPOSITE Financial Transaction Contract Activity 
@AbapCatalog.sqlViewName: 'RFTRCONTRACTACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY 
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Contract Activity'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
define view R_FinTransContractActivity 
  as select from vtbfhazu as Activity
  inner join I_FinancialinstrProductType as Product on Activity.sgsart = Product.FinancialInstrumentProductType
{
// exposed fields

  key Activity.bukrs   as CompanyCode,
  key Activity.rfha    as FinancialTransaction,
  max(Activity.rfhazu) as FinancialInstrumentActivity
}
// depending on Product Category according Processing Category has to be used

where    (    Activity.sfgzustt = '10' 
          and (   Product.FinancialInstrProductCategory = '510'
               or Product.FinancialInstrProductCategory = '520'
               or Product.FinancialInstrProductCategory = '530'
               or Product.FinancialInstrProductCategory = '540'
               or Product.FinancialInstrProductCategory = '550'
               or Product.FinancialInstrProductCategory = '560'
               or Product.FinancialInstrProductCategory = '570'
               or Product.FinancialInstrProductCategory = '580'
               or Product.FinancialInstrProductCategory = '740'
               or Product.FinancialInstrProductCategory = '770'
               or Product.FinancialInstrProductCategory = '790' ) )
      or (     Activity.sfgzustt = '20' 
           and Product.FinancialInstrProductCategory <> '510'
           and Product.FinancialInstrProductCategory <> '520'
           and Product.FinancialInstrProductCategory <> '530'
           and Product.FinancialInstrProductCategory <> '540'
           and Product.FinancialInstrProductCategory <> '550'
           and Product.FinancialInstrProductCategory <> '560'
           and Product.FinancialInstrProductCategory <> '570'
           and Product.FinancialInstrProductCategory <> '580'
           and Product.FinancialInstrProductCategory <> '740'
           and Product.FinancialInstrProductCategory <> '770'
           and Product.FinancialInstrProductCategory <> '790' )
group by Activity.bukrs, Activity.rfha, Activity.rfhazu

Learn More