I_FinancialTransactionStdVH

DDL: I_FINANCIALTRANSACTIONSTDVH SQL: IFTRFT__VH Type: view COMPOSITE Package: FTTR_CORE

FinancialTransaction

I_FinancialTransactionStdVH is a Composite CDS View that provides data about "FinancialTransaction" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 17 fields with key fields FinancialTransaction, CompanyCode. It has 2 associations to related views. Part of development package FTTR_CORE.

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction I_FinancialTransaction from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedBy $projection.CreatedByUser = _CreatedBy.ContactCardID
[0..1] I_UserContactCard _LastChangedBy $projection.LastChangedByUser = _LastChangedBy.ContactCardID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFTRFT__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FinancialTransaction view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label FinancialTransaction view
Consumption.ranked true view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FinancialTransaction FinancialTransaction
KEY CompanyCode CompanyCode
FinancialInstrTransactionType FinancialInstrTransactionType
FinancialInstrumentProductType FinancialInstrumentProductType
Counterparty Counterparty
CreatedByUser CreatedByUser
CreatedByUserDescription _CreatedBy FullName Created By
FinTransCreationDate FinTransCreationDate
LastChangedByUser LastChangedByUser
LastChangedByUserDescription _LastChangedBy FullName Last Changed By
LastChangeDate LastChangeDate
FinancialInstrumentStatus FinancialInstrumentStatus
Portfolio Portfolio
SecurityAccount SecurityAccount
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy
_CompanyCode _CompanyCode
//GENERATED:001:E6ExH29r7jUzzJ}fF{7DBm

@AbapCatalog.sqlViewName: 'IFTRFT__VH'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'FinancialTransaction'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.modelingPattern: #VALUE_HELP_PROVIDER
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY]

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'FinancialTransaction'
@Consumption.ranked: true
@Search.searchable: true
@AccessControl.privilegedAssociations: [ '_CreatedBy','_LastChangedBy' ]
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_FinancialTransactionStdVH
  as select from I_FinancialTransaction
  association [0..1] to I_UserContactCard as _CreatedBy     on $projection.CreatedByUser = _CreatedBy.ContactCardID
  association [0..1] to I_UserContactCard as _LastChangedBy on $projection.LastChangedByUser = _LastChangedBy.ContactCardID
{

      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
      @UI.lineItem.importance: #HIGH
  key FinancialTransaction,

      @Consumption.valueHelpDefinition: [{entity:{
                                                    name:    'I_CompanyCodeStdVH',
                                                    element: 'CompanyCode'
                                                 }
      }]
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @UI.lineItem.importance: #HIGH
  key CompanyCode,

      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @Consumption.valueHelpDefinition: [{entity:{
                                                    name:    'I_FinancialInstrTransType',
                                                    element: 'FinancialInstrTransactionType'
                                                 }
      }]
      @UI.lineItem.importance: #HIGH
      FinancialInstrTransactionType,

      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @Consumption.valueHelpDefinition: [{entity:{
                                                      name:     'I_FinancialinstrProductType',
                                                      element:  'FinancialInstrumentProductType'
                                                  }
      }]
      @UI.lineItem.importance: #HIGH
      FinancialInstrumentProductType,

      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @Consumption.valueHelpDefinition: [{entity:{
                                                      name:     'I_FinTransacCounterPartyStdVH',
                                                      element:  'BusinessPartner'
                                                  }
      }]
      Counterparty,

      @Consumption.hidden: true
      CreatedByUser,
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'Created By'
      @Semantics.text: true
      _CreatedBy.FullName     as CreatedByUserDescription,
      @Consumption.filter: {selectionType: #INTERVAL}
      FinTransCreationDate,
      @Consumption.hidden: true
      LastChangedByUser,
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'Last Changed By'
      @Semantics.text: true
      _LastChangedBy.FullName as LastChangedByUserDescription,
      @Consumption.filter: {selectionType: #INTERVAL}
      LastChangeDate,
      @Consumption.valueHelpDefinition: [{entity:{
                                                      name:     'I_FinInstrumentStatus',
                                                      element:  'FinancialInstrumentStatus'
                                                  }
      }]
      FinancialInstrumentStatus,
      @Consumption.valueHelpDefinition: [{entity:{
                                                  name:     'I_TreasuryPortfolio',
                                                  element:  'Portfolio'
                                              }
      }]
      Portfolio,
      @Consumption.hidden: true
      SecurityAccount,

      @Consumption.hidden: true
      _CreatedBy,
      @Consumption.hidden: true
      _LastChangedBy,
      @Consumption.hidden: true
      _CompanyCode
}