I_FinTransOverallView

DDL: I_FINTRANSOVERALLVIEW SQL: IFINTRANOVALL Type: view COMPOSITE

Financial Transaction Overall

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

2 data source(s) 32 fields

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity CurrentActivity inner
I_FinancialTransaction FinancialTransaction from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_FinTransAttribute _Attribute $projection.CompanyCode = _Attribute.CompanyCode and $projection.FinancialTransaction = _Attribute.FinancialTransaction
[1..1] I_FinTransAdditionalAttribute _AdditionalAttribute $projection.CompanyCode = _AdditionalAttribute.CompanyCode and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction
[1..*] I_FinTransMainFlow _MainFlow $projection.CompanyCode = _MainFlow.CompanyCode and $projection.FinancialTransaction = _MainFlow.FinancialTransaction
[0..*] I_FinTransAdditionalFlow _AdditionalFlow $projection.CompanyCode = _AdditionalFlow.CompanyCode and $projection.FinancialTransaction = _AdditionalFlow.FinancialTransaction
[1..*] I_FinTransInterestCondition _InterestCondition $projection.CompanyCode = _InterestCondition.CompanyCode and $projection.FinancialTransaction = _InterestCondition.FinancialTransaction
[0..*] I_FinTransInterestAdjmtCndn _AdjustmentCondition $projection.CompanyCode = _AdjustmentCondition.CompanyCode and $projection.FinancialTransaction = _AdjustmentCondition.FinancialTransaction
[0..*] I_FinTransRepaymentCndn _RepaymentCondition $projection.CompanyCode = _RepaymentCondition.CompanyCode and $projection.FinancialTransaction = _RepaymentCondition.FinancialTransaction
[0..*] I_FinTransAccumulatingCndn _AccumulatingCondition $projection.CompanyCode = _AccumulatingCondition.CompanyCode and $projection.FinancialTransaction = _AccumulatingCondition.FinancialTransaction
[0..*] I_FinTransAccruedIntrstCndn _AccruedCondition $projection.CompanyCode = _AccruedCondition.CompanyCode and $projection.FinancialTransaction = _AccruedCondition.FinancialTransaction

Annotations (12)

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransaction CompanyCode
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory
FinancialInstrumentActivity I_FinTransActivity FinancialInstrumentActivity
FinancialInstrumentStatus I_FinancialTransaction FinancialInstrumentStatus
Counterparty I_FinancialTransaction Counterparty
FinTransActyConclusionDate I_FinTransActivity FinTransActyConclusionDate
FinTransActyConclusionTime I_FinTransActivity FinTransActyConclusionTime
FinTransActyConclusionTimeZone I_FinTransActivity FinTransActyConclusionTimeZone
FinInstrExternalReference I_FinTransActivity FinInstrExternalReference
MarketIdentifierCode I_FinancialTransaction MarketIdentifierCode
Trader I_FinTransActivity Trader
FinancialInstrContactPerson I_FinTransActivity FinancialInstrContactPerson
CreatedByUser I_FinancialTransaction CreatedByUser
FinTransCreationDate I_FinancialTransaction FinTransCreationDate
FinTransCreationTime I_FinancialTransaction FinTransCreationTime
LastChangedByUser I_FinancialTransaction LastChangedByUser
LastChangeDate I_FinancialTransaction LastChangeDate
FinInstrumentLastChangedTime I_FinancialTransaction FinInstrumentLastChangedTime
FinancialInstrumentProductType I_FinancialTransaction FinancialInstrumentProductType
FinancialInstrTransactionType I_FinancialTransaction FinancialInstrTransactionType
TradeLegalBasis TradeIdentifier TradeLegalBasis
ExternalTradeIdentifier TradeIdentifier ExternalTradeIdentifier
_Attribute _Attribute
_AdditionalAttribute _AdditionalAttribute
_MainFlow _MainFlow
_AdditionalFlow _AdditionalFlow
_InterestCondition _InterestCondition
_AdjustmentCondition _AdjustmentCondition
_RepaymentCondition _RepaymentCondition
_AccumulatingCondition _AccumulatingCondition
_AccruedCondition _AccruedCondition 
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.sqlViewName: 'IFINTRANOVALL'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Overall'
@ObjectModel.representativeKey: 'FinancialTransaction'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE

define view I_FinTransOverallView
  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
    left outer to one join P_FinTransSglExtTrdIdentifier as TradeIdentifier on  FinancialTransaction.CompanyCode          = TradeIdentifier.CompanyCode
                                                                            and FinancialTransaction.FinancialTransaction = TradeIdentifier.FinancialTransaction

  association [1..1] to I_FinTransAttribute           as _Attribute             on  $projection.CompanyCode          = _Attribute.CompanyCode
                                                                                and $projection.FinancialTransaction = _Attribute.FinancialTransaction
  association [1..1] to I_FinTransAdditionalAttribute as _AdditionalAttribute   on  $projection.CompanyCode          = _AdditionalAttribute.CompanyCode
                                                                                and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction
  association [1..*] to I_FinTransMainFlow            as _MainFlow              on  $projection.CompanyCode          = _MainFlow.CompanyCode
                                                                                and $projection.FinancialTransaction = _MainFlow.FinancialTransaction
  association [0..*] to I_FinTransAdditionalFlow      as _AdditionalFlow        on  $projection.CompanyCode          = _AdditionalFlow.CompanyCode
                                                                                and $projection.FinancialTransaction = _AdditionalFlow.FinancialTransaction
  association [1..*] to I_FinTransInterestCondition   as _InterestCondition     on  $projection.CompanyCode          = _InterestCondition.CompanyCode
                                                                                and $projection.FinancialTransaction = _InterestCondition.FinancialTransaction
  association [0..*] to I_FinTransInterestAdjmtCndn   as _AdjustmentCondition   on  $projection.CompanyCode          = _AdjustmentCondition.CompanyCode
                                                                                and $projection.FinancialTransaction = _AdjustmentCondition.FinancialTransaction
  association [0..*] to I_FinTransRepaymentCndn       as _RepaymentCondition    on  $projection.CompanyCode          = _RepaymentCondition.CompanyCode
                                                                                and $projection.FinancialTransaction = _RepaymentCondition.FinancialTransaction
  association [0..*] to I_FinTransAccumulatingCndn    as _AccumulatingCondition on  $projection.CompanyCode          = _AccumulatingCondition.CompanyCode
                                                                                and $projection.FinancialTransaction = _AccumulatingCondition.FinancialTransaction
  association [0..*] to I_FinTransAccruedIntrstCndn   as _AccruedCondition      on  $projection.CompanyCode          = _AccruedCondition.CompanyCode
                                                                                and $projection.FinancialTransaction = _AccruedCondition.FinancialTransaction

{
  key  FinancialTransaction.CompanyCode,
  key  FinancialTransaction.FinancialTransaction,
       FinancialTransaction.FinancialInstrProductCategory,
       CurrentActivity.FinancialInstrumentActivity,
       FinancialTransaction.FinancialInstrumentStatus,
       FinancialTransaction.Counterparty,
       CurrentActivity.FinTransActyConclusionDate,
       CurrentActivity.FinTransActyConclusionTime,
       CurrentActivity.FinTransActyConclusionTimeZone,
       CurrentActivity.FinInstrExternalReference,
       FinancialTransaction.MarketIdentifierCode,
       CurrentActivity.Trader,
       CurrentActivity.FinancialInstrContactPerson,
       FinancialTransaction.CreatedByUser,
       FinancialTransaction.FinTransCreationDate,
       FinancialTransaction.FinTransCreationTime,
       FinancialTransaction.LastChangedByUser,
       FinancialTransaction.LastChangeDate,
       FinancialTransaction.FinInstrumentLastChangedTime,
       FinancialTransaction.FinancialInstrumentProductType,
       FinancialTransaction.FinancialInstrTransactionType,
       TradeIdentifier.TradeLegalBasis,
       TradeIdentifier.ExternalTradeIdentifier,

       _Attribute,
       _AdditionalAttribute,
       _MainFlow,
       _AdditionalFlow,
       _InterestCondition,
       _AdjustmentCondition,
       _RepaymentCondition,
       _AccumulatingCondition,
       _AccruedCondition
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION",
"I_FINTRANSACTIVITY",
"P_FINTRANSSGLEXTTRDIDENTIFIER"
],
"ASSOCIATED":
[
"I_FINTRANSACCRUEDINTRSTCNDN",
"I_FINTRANSACCUMULATINGCNDN",
"I_FINTRANSADDITIONALATTRIBUTE",
"I_FINTRANSADDITIONALFLOW",
"I_FINTRANSATTRIBUTE",
"I_FINTRANSINTERESTADJMTCNDN",
"I_FINTRANSINTERESTCONDITION",
"I_FINTRANSMAINFLOW",
"I_FINTRANSREPAYMENTCNDN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More