R_FinancialTransactionTP

DDL: R_FINANCIALTRANSACTIONTP Type: view_entity TRANSACTIONAL

Financial Transaction

R_FinancialTransactionTP is a Transactional CDS View that provides data about "Financial Transaction" in SAP S/4HANA. It reads from 1 data source (I_FinTransOverallView) and exposes 32 fields with key fields CompanyCode, FinancialTransaction. It has 9 associations to related views.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_FinTransOverallView I_FinTransOverallView from

Associations (9)

CardinalityTargetAliasCondition
[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
[1..1] R_FinTransAttributeTP _Attribute
[1..1] R_FinTransAddlAttributeTP _AdditionalAttribute
[1..*] R_FinTransMainFlowTP _MainFlow
[0..*] R_FinTransAdditionalFlowTP _AdditionalFlow

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Financial Transaction view
ObjectModel.representativeKey FinancialTransaction view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FinancialTransaction FinancialTransaction
FinancialInstrProductCategory FinancialInstrProductCategory
FinancialInstrumentActivity FinancialInstrumentActivity
FinancialInstrumentStatus FinancialInstrumentStatus
Counterparty Counterparty
FinTransActyConclusionDate FinTransActyConclusionDate
FinTransActyConclusionTime FinTransActyConclusionTime
FinTransActyConclusionTimeZone FinTransActyConclusionTimeZone
FinInstrExternalReference FinInstrExternalReference
MarketIdentifierCode MarketIdentifierCode
Trader Trader
FinancialInstrContactPerson FinancialInstrContactPerson
CreatedByUser CreatedByUser
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrTransactionType FinancialInstrTransactionType
TradeLegalBasis TradeLegalBasis
ExternalTradeIdentifier ExternalTradeIdentifier
_Attribute _Attribute
_AdditionalAttribute _AdditionalAttribute
_MainFlow _MainFlow
_AdditionalFlow _AdditionalFlow
_InterestCondition _InterestCondition
_AdjustmentCondition _AdjustmentCondition
_RepaymentCondition _RepaymentCondition
_AccumulatingCondition _AccumulatingCondition
_AccruedCondition _AccruedCondition 
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:{
    usageType : {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
}
@EndUserText.label: 'Financial Transaction'
@ObjectModel.representativeKey: 'FinancialTransaction'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define root view entity R_FinancialTransactionTP
  as select from I_FinTransOverallView

  composition [1..1] of R_FinTransAttributeTP       as _Attribute

  composition [1..1] of R_FinTransAddlAttributeTP   as _AdditionalAttribute

  composition [1..*] of R_FinTransMainFlowTP        as _MainFlow

  composition [0..*] of R_FinTransAdditionalFlowTP  as _AdditionalFlow

  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  CompanyCode,
  key  FinancialTransaction,
       FinancialInstrProductCategory,
       FinancialInstrumentActivity,
       FinancialInstrumentStatus,
       Counterparty,
       FinTransActyConclusionDate,
       FinTransActyConclusionTime,
       FinTransActyConclusionTimeZone,
       FinInstrExternalReference,
       MarketIdentifierCode,
       Trader,
       FinancialInstrContactPerson,
       CreatedByUser,
       FinTransCreationDate,
       FinTransCreationTime,
       LastChangedByUser,
       LastChangeDate,
       FinInstrumentLastChangedTime,
       FinancialInstrumentProductType,
       FinancialInstrTransactionType,
       TradeLegalBasis,
       ExternalTradeIdentifier,
       
       _Attribute,
       _AdditionalAttribute,
       _MainFlow,
       _AdditionalFlow,
       _InterestCondition,
       _AdjustmentCondition,
       _RepaymentCondition,
       _AccumulatingCondition,
       _AccruedCondition
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINTRANSOVERALLVIEW"
],
"ASSOCIATED":
[
"I_FINTRANSACCRUEDINTRSTCNDN",
"I_FINTRANSACCUMULATINGCNDN",
"I_FINTRANSINTERESTADJMTCNDN",
"I_FINTRANSINTERESTCONDITION",
"I_FINTRANSREPAYMENTCNDN",
"R_FINTRANSADDITIONALFLOWTP",
"R_FINTRANSADDLATTRIBUTETP",
"R_FINTRANSATTRIBUTETP",
"R_FINTRANSMAINFLOWTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More