I_FinTransContractActivity

DDL: I_FINTRANSCONTRACTACTIVITY SQL: IFTRCONTRACTACT Type: view COMPOSITE Package: FTTR_CORE

Financial Transaction Contract Activity

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

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity Activity from
R_FinTransContractActivity Contract inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFTRCONTRACTACT 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 Contract 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 (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransActivity CompanyCode
KEY FinancialTransaction I_FinTransActivity FinancialTransaction
KEY FinancialInstrumentActivity I_FinTransActivity FinancialInstrumentActivity
FinTransActyConclusionDate I_FinTransActivity FinTransActyConclusionDate
FinTransActyConclusionTime I_FinTransActivity FinTransActyConclusionTime
FinTransActyConclusionTimeZone I_FinTransActivity FinTransActyConclusionTimeZone
ExchangeRate I_FinTransActivity ExchangeRate
_CompanyCode I_FinTransActivity _CompanyCode
_FinTrans I_FinTransActivity _FinTrans
_TimeZone I_FinTransActivity _TimeZone 
@AbapCatalog.sqlViewName: 'IFTRCONTRACTACT'
@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 Contract 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_FinTransContractActivity 
// restrict selection from I_FinTransActivity to contract activity (contract activity number is provided by private view)

  as select from I_FinTransActivity as Activity
  inner join R_FinTransContractActivity as Contract on  Activity.CompanyCode                 = Contract.CompanyCode
                                                    and Activity.FinancialTransaction        = Contract.FinancialTransaction
                                                    and Activity.FinancialInstrumentActivity = Contract.FinancialInstrumentActivity

{
// exposed fields

  @ObjectModel.foreignKey.association: '_CompanyCode'
  key Activity.CompanyCode,
  @ObjectModel.foreignKey.association: '_FinTrans'
  key Activity.FinancialTransaction,
  key Activity.FinancialInstrumentActivity,
  Activity.FinTransActyConclusionDate,
  Activity.FinTransActyConclusionTime,
  @ObjectModel.foreignKey.association: '_TimeZone'
  Activity.FinTransActyConclusionTimeZone,
  Activity.ExchangeRate,
// exposed dimensions

  Activity._CompanyCode,
  Activity._FinTrans,
  Activity._TimeZone
}

Learn More