I_FinTransAttribute

DDL: I_FINTRANSATTRIBUTE SQL: IFINTRANSATTR Type: view COMPOSITE

Financial Transaction Attribute

I_FinTransAttribute is a Composite CDS View that provides data about "Financial Transaction Attribute" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, I_FinancialTransaction) and exposes 14 fields with key fields CompanyCode, FinancialTransaction. It has 2 associations to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity CurrentActivity inner
I_FinancialTransaction FinancialTransaction from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FinTransOverallView _FinancialTransaction $projection.CompanyCode = _FinancialTransaction.CompanyCode and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction
[1..1] I_FinTransAdditionalAttribute _AdditionalAttribute $projection.CompanyCode = _AdditionalAttribute.CompanyCode and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction

Annotations (11)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFINTRANSATTR view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Attribute view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransaction CompanyCode
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory
FinTransTermCategory I_FinTransActivity FinTransTermCategory
TermStartDate I_FinancialTransaction TermStartDate
FinTransNoticeDate I_FinTransActivity FinTransNoticeDate
FinTransRolloverDate I_FinTransActivity FinTransRolloverDate
TermEndDate I_FinTransActivity TermEndDate
FinTransTermStartEndInclusive I_FinTransActivity FinTransTermStartEndInclusive
FinTransNoticePeriod I_FinancialTransaction FinTransNoticePeriod
FinTransNoticePeriodUnit I_FinancialTransaction FinTransNoticePeriodUnit
FinTransRoundingCategory I_FinancialTransaction FinTransRoundingCategory
_FinancialTransaction _FinancialTransaction
_AdditionalAttribute _AdditionalAttribute 
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.sqlViewName: 'IFINTRANSATTR'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Attribute'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE

define view I_FinTransAttribute
  as select from I_FinancialTransaction as FinancialTransaction
    inner join   I_FinTransActivity     as CurrentActivity on  FinancialTransaction.CompanyCode                = CurrentActivity.CompanyCode
                                                           and FinancialTransaction.FinancialTransaction       = CurrentActivity.FinancialTransaction
                                                           and FinancialTransaction.FinInstrLastActiveActivity = CurrentActivity.FinancialInstrumentActivity

  association [1..1] to I_FinTransOverallView         as _FinancialTransaction on  $projection.CompanyCode          = _FinancialTransaction.CompanyCode
                                                                               and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction
  association [1..1] to I_FinTransAdditionalAttribute as _AdditionalAttribute  on  $projection.CompanyCode          = _AdditionalAttribute.CompanyCode
                                                                               and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction
{
  key  FinancialTransaction.CompanyCode,
  key  FinancialTransaction.FinancialTransaction,
       FinancialTransaction.FinancialInstrProductCategory,
       CurrentActivity.FinTransTermCategory,
       FinancialTransaction.TermStartDate,
       CurrentActivity.FinTransNoticeDate,
       CurrentActivity.FinTransRolloverDate,
       CurrentActivity.TermEndDate,
       CurrentActivity.FinTransTermStartEndInclusive,
       FinancialTransaction.FinTransNoticePeriod,
       FinancialTransaction.FinTransNoticePeriodUnit,
       FinancialTransaction.FinTransRoundingCategory,

       _FinancialTransaction,
       _AdditionalAttribute
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION",
"I_FINTRANSACTIVITY"
],
"ASSOCIATED":
[
"I_FINTRANSADDITIONALATTRIBUTE",
"I_FINTRANSOVERALLVIEW"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More