I_FINANCIALTRANSACTION

CDS View

Financial Transaction

I_FINANCIALTRANSACTION is a CDS View in S/4HANA. Financial Transaction. It contains 45 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
I_CmmdtyHdgCnstltnTransOvw view_entity inner COMPOSITE Commodity Hedge Constellation Overview
I_FinancialTransactionStdVH view from COMPOSITE FinancialTransaction
I_FinancialTransactionVH view from COMPOSITE Financial Transaction Value Help
I_FinTransActivityCategory view from BASIC Financial Transaction Activity Category
I_FinTransAdditionalAttribute view from COMPOSITE Financial Trans Additional Attribute
I_FinTransAttribute view from COMPOSITE Financial Transaction Attribute
I_FinTransCurrentActivity view inner COMPOSITE Financial Transaction Current Activity
I_FinTransOverallView view from COMPOSITE Financial Transaction Overall
I_Ftr_Cl_Key_Date_Utilization view inner COMPOSITE Facility Utilization by Key Date
I_Ftr_Cl_Utilize view inner COMPOSITE Facility Utilization With Contract Info
P_CmmdtyHedgeSwapCounterDeal view from BASIC
P_CommodityHedgeSwap view from COMPOSITE
P_FinancialTransactionManage view from COMPOSITE Manage Financial Transactions
P_FinTransFinancialObjectData view from COMPOSITE
P_FINTRANSINTCOND view left_outer COMPOSITE
P_FinTransIntrstRateInstr view from COMPOSITE
P_FinTransOpenFlowBusVol view inner COMPOSITE
P_FXOptionTransBusVol view inner COMPOSITE
P_TFTRANSCASHFLOW view from COMPOSITE
P_TFTRANSFEECOND view left_outer COMPOSITE
R_FinTransSecurityPaytFlow view inner BASIC Fin Trans Security Payment Flow
R_FinTransSecurityQuantityFlow view inner BASIC Fin Trans Security Quantity Flow

Fields (45)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 5
KEY Counterparty Counterparty 6
KEY FinancialTransaction FinancialTransaction 5
BusinessPlace BusinessPlace 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
FinancialInstrCharacteristic FinancialInstrCharacteristic 1
FinancialInstrProductCategory FinancialInstrProductCategory 7
FinancialInstrTransactionType FinancialInstrTransactionType 8
FinancialInstrumentAssignment FinancialInstrumentAssignment 1
FinancialInstrumentGuarantor FinancialInstrumentGuarantor 1
FinancialInstrumentProductType FinancialInstrumentProductType 8
FinancialInstrumentReference FinancialInstrumentReference 1
FinancialInstrumentStatus FinancialInstrumentStatus 2
FinInstrumentIncomingCurrency FinInstrumentIncomingCurrency 1
FinInstrumentLastChangedTime FinInstrumentLastChangedTime 1
FinInstrumentOutgoingCurrency FinInstrumentOutgoingCurrency 1
FinTransAuthorizationGroup FinTransAuthorizationGroup 1
FinTransCreationDate FinTransCreationDate 1
FinTransCreationTime FinTransCreationTime 1
FinTransGeneralValuationClass FinTransGeneralValuationClass 1
FinTransIsRiskMitigating FinTransIsRiskMitigating 1
FinTransNoticePeriod FinTransNoticePeriod 1
FinTransNoticePeriodUnit FinTransNoticePeriodUnit 1
FinTransRoundingCategory FinTransRoundingCategory 1
FunctionalArea FunctionalArea 1
Fund Fund 1
GrantID GrantID 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MarketIdentifierCode MarketIdentifierCode 1
Portfolio Portfolio 5
ProfitCenter ProfitCenter 1
SecurityAccount SecurityAccount 1
TermStartDate TermStartDate 1
TransactionCurrency TransactionCurrency 3
TreasuryFacility TreasuryFacility 1
TreasuryFacilityCompanyCode TreasuryFacilityCompanyCode 1
TreasuryFinanceProject TreasuryFinanceProject 1
TrsyPosCustomDiffntnTerm1 TrsyPosCustomDiffntnTerm1 1
TrsyPosCustomDiffntnTerm2 TrsyPosCustomDiffntnTerm2 1
TrsyPosCustomDiffntnTerm3 TrsyPosCustomDiffntnTerm3 1
TrsyPosCustomDiffntnTerm4 TrsyPosCustomDiffntnTerm4 1
TrsyPosCustomDiffntnTerm5 TrsyPosCustomDiffntnTerm5 1
WBSElementInternalID WBSElementInternalID 1
// harmonized annotations

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFINTRAN'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION /* dataExtraction.enabled: true} */
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction'
@ObjectModel.representativeKey: 'FinancialTransaction'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true // For C1-Release

@VDM.viewType: #BASIC
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]

define view I_FinancialTransaction
  as select from vtbfha as FinancialTransactionTable

// dimensions, containing for example text fields

  association [1..1] to I_CompanyCode                  as _CompanyCode              on  $projection.CompanyCode                    = _CompanyCode.CompanyCode

  association [0..1] to I_TreasuryContractType         as _ContractType             on  $projection.TreasuryContractType           = _ContractType.TreasuryContractType

  association [0..1] to I_FinancialInstrProdCat        as _FinancialInstrProdCat    on  $projection.FinancialInstrProductCategory  = _FinancialInstrProdCat.FinancialInstrProductCategory

  association [0..1] to I_FinancialinstrProductType    as _FinancialInstrProdType   on  $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType

  association [0..1] to I_FinInstrTransCat             as _FinInstrTransCat         on  $projection.FinancialInstrProductCategory  = _FinInstrTransCat.FinancialInstrProductCategory
                                                                                    and $projection.FinInstrTransactionCategory    = _FinInstrTransCat.FinInstrTransactionCategory

  association [1..1] to I_FinancialInstrTransType      as _FinancialInstrTransType  on  $projection.FinancialInstrTransactionType  = _FinancialInstrTransType.FinancialInstrTransactionType
                                                                                    and $projection.FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType

  association [0..1] to I_FinTransProcgCategory        as _ProcessingCategory       on  $projection.FinancialInstrProductCategory  = _ProcessingCategory.FinancialInstrProductCategory
                                                                                    and $projection.FinInstrTransactionCategory    = _ProcessingCategory.FinInstrTransactionCategory
                                                                                    and $projection.FinTransProcessingCategory     = _ProcessingCategory.FinTransProcessingCategory

  association [0..1] to I_FinTransNoticePeriodUnit     as _NoticePeriodUnit         on  $projection.FinTransNoticePeriodUnit       = _NoticePeriodUnit.FinTransNoticePeriodUnit
  
  association [0..1] to I_FactoryCalendar              as _Calendar                 on $projection.FinTransFactoryCalendar1        = _Calendar.FactoryCalendar

  association [0..1] to I_FactoryCalendar              as _Calendar2                on $projection.FinTransFactoryCalendar2        = _Calendar2.FactoryCalendar

  association [1..1] to I_BusinessPartner              as _Counterparty             on $projection.Counterparty                    = _Counterparty.BusinessPartner

  association [0..1] to I_BusinessPartner              as _Guarantor                on $projection.FinancialInstrumentGuarantor    = _Guarantor.BusinessPartner

  association [0..1] to I_TreasuryPortfolio            as _Portfolio                on  $projection.CompanyCode                    = _Portfolio.CompanyCode
                                                                                    and $projection.Portfolio                      = _Portfolio.Portfolio

  association [0..1] to I_FinancialInstrAssignment     as _Assignment               on  $projection.FinancialInstrumentAssignment  = _Assignment.FinancialInstrumentAssignment

  association [0..1] to I_FinancialInstrReference      as _Reference                on  $projection.FinancialInstrumentReference   = _Reference.FinancialInstrumentReference

  association [0..1] to I_FinancialInstrCharacteristic as _Characteristics          on  $projection.FinancialInstrCharacteristic   = _Characteristics.FinancialInstrCharacteristic

  association [0..1] to I_Financialinstrvaluationclass as _ValuationClass           on  $projection.TreasuryValuationClass         = _ValuationClass.FinancialInstrValuationClass

  association [0..1] to I_BusinessArea                 as _BusinessArea             on  $projection.BusinessArea                   = _BusinessArea.BusinessArea

  association [0..1] to I_ControllingArea              as _ControllingArea          on  $projection.ControllingArea                = _ControllingArea.ControllingArea

  association [0..*] to I_CostCenter                   as _CostCenter               on  $projection.CompanyCode                    = _CostCenter.ControllingArea
                                                                                    and $projection.CostCenter                     = _CostCenter.CostCenter
  association [0..*] to I_CostCenter                   as _CostCenter_2             on  $projection.ControllingArea                = _CostCenter_2.ControllingArea
                                                                                    and $projection.CostCenter                     = _CostCenter_2.CostCenter

  association [0..1] to I_TreasuryHedgingClassfctn     as _TreasuryHedgingClassfctn on  $projection.HedgingClassification          = _TreasuryHedgingClassfctn.HedgingClassification

  association [0..*] to I_ProfitCenter                 as _ProfitCenter             on  $projection.CompanyCode                    = _ProfitCenter.ControllingArea
                                                                                    and $projection.ProfitCenter                   = _ProfitCenter.ProfitCenter
  association [0..*] to I_ProfitCenter                 as _ProfitCenter_2           on  $projection.ControllingArea                = _ProfitCenter_2.ControllingArea
                                                                                    and $projection.ProfitCenter                   = _ProfitCenter_2.ProfitCenter

  association [0..1] to I_WBSElementBasicData          as _WBSElement               on  $projection.WBSElementInternalID           = _WBSElement.WBSElementInternalID
  
  // view not C1-released

  //  association        to I_WBSElement                          as _WBSElement                  on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID


  association [0..1] to I_CompanyCode                  as _FacilityCompanyCode      on  $projection.TreasuryFacilityCompanyCode    = _FacilityCompanyCode.CompanyCode

  association [0..1] to I_FinInstrumentStatus          as _Status                   on  $projection.FinancialInstrumentStatus      = _Status.FinancialInstrumentStatus

  association [0..1] to I_FinTransReleaseStatus        as _ReleaseStatus            on  $projection.FinTransReleaseStatus          = _ReleaseStatus.FinTransReleaseStatus

  association [0..1] to I_Currency                     as _Currency                 on  $projection.TransactionCurrency            = _Currency.Currency

  association [0..1] to I_Currency                     as _OutgoingCurrency         on  $projection.FinInstrumentOutgoingCurrency  = _OutgoingCurrency.Currency

  association [0..1] to I_Currency                     as _IncomingCurrency         on  $projection.FinInstrumentIncomingCurrency  = _IncomingCurrency.Currency

  association [0..1] to I_Currency                     as _TradedCurrency           on  $projection.TradedCurrency                 = _TradedCurrency.Currency

  association [0..1] to I_SecurityClass                as _SecurityClass            on  $projection.SecurityClass                  = _SecurityClass.SecurityClass

  association [0..1] to I_SecurityAccount              as _SecurityAccount          on  $projection.SecurityAccount                = _SecurityAccount.SecurityAccount
                                                                                    and $projection.CompanyCode                    = _SecurityAccount.CompanyCode

  association [0..1] to I_TreasuryPositionAccount      as _FuturesAccount           on  $projection.CompanyCode                    = _FuturesAccount.CompanyCode
                                                                                    and $projection.FuturesAccount                 = _FuturesAccount.TreasuryPositionAccount

  association [0..1] to I_FinTransCntrlClrgOption      as _CentralClearingOption    on  $projection.FinTransCentralClearingOption  = _CentralClearingOption.FinTransCentralClearingOption

  association [0..1] to I_FinTransCntrlClrgStatus      as _CentralClearingStatus    on  $projection.FinTransCentralClearingStatus  = _CentralClearingStatus.FinTransCentralClearingStatus

  association [0..*] to I_CentralClearingAccount       as _CentralClearingAccount   on  $projection.CompanyCode                    = _CentralClearingAccount.CompanyCode
                                                                                    and $projection.CentralClearingAccount         = _CentralClearingAccount.CentralClearingAccount

// associations according to VDM


  association [0..*] to I_FinTransContractActivity  as _ContractActivity            on  $projection.CompanyCode                    = _ContractActivity.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _ContractActivity.FinancialTransaction

  //for performance reason instead of using I_FinTransCurrentActivity directly access to I_FinTransActivity 

  association [0..1] to I_FinTransActivity          as _CurrentActivity             on  $projection.CompanyCode                    = _CurrentActivity.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _CurrentActivity.FinancialTransaction
                                                                                    and $projection.FinInstrLastActiveActivity     = _CurrentActivity.FinancialInstrumentActivity

  association [0..1] to I_FinTransSecurity          as _Security                    on  $projection.CompanyCode                    = _Security.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _Security.FinancialTransaction

  association [0..*] to I_FinTransInterest          as _Interest                    on  $projection.CompanyCode                    = _Interest.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _Interest.FinancialTransaction

  association [0..*] to I_FinTransNominal           as _Nominal                     on  $projection.CompanyCode                    = _Nominal.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _Nominal.FinancialTransaction

  association [0..*] to I_FinTransActivity          as _TabActivity                 on  $projection.CompanyCode                    = _TabActivity.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _TabActivity.FinancialTransaction
                   
  association [0..*] to I_FinTransFlow              as _TabFlow                     on  $projection.CompanyCode                    = _TabFlow.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _TabFlow.FinancialTransaction

  association [0..*] to I_FinTransCondition         as _TabCondition                on  $projection.CompanyCode                    = _TabCondition.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _TabCondition.FinancialTransaction


// should be not used anymore, instead use _CurrentActivity

  association [0..1] to I_LetterOfCredit           as _LetterOfCredit               on  $projection.CompanyCode                    = _LetterOfCredit.CompanyCode
                                                                                    and $projection.FinancialTransaction           = _LetterOfCredit.FinancialTransaction
                                                                                    and $projection.FinInstrLastActiveActivity     = _LetterOfCredit.FinancialInstrumentActivity

{
// Exposed fields


      //--[ GENERATED:012:GlBfhyJl7kY4pGd}um{aL0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key FinancialTransactionTable.bukrs                                                            as CompanyCode,
  key FinancialTransactionTable.rfha                                                             as FinancialTransaction,

      FinancialTransactionTable.objnr                                                            as TreasuryFinancialObject,

      FinancialTransactionTable.cruser                                                           as CreatedByUser,
      cast( FinancialTransactionTable.dcrdat as ftr_creation_date preserving type )              as FinTransCreationDate,
      FinancialTransactionTable.tcrtim                                                           as FinTransCreationTime,
      cast(FinancialTransactionTable.upuser as vdm_lastchangedbyuserid preserving type)          as LastChangedByUser,
      FinancialTransactionTable.dupdat                                                           as LastChangeDate,
      FinancialTransactionTable.tuptim                                                           as FinInstrumentLastChangedTime,

      @ObjectModel.foreignKey.association: '_ContractType'
      FinancialTransactionTable.rantyp                                                           as TreasuryContractType,
      @ObjectModel.foreignKey.association: '_FinancialInstrProdCat'
      cast(FinancialTransactionTable.sanlf as ftr_gen_fin_instr_prod_categ preserving type)      as FinancialInstrProductCategory,
      @ObjectModel.foreignKey.association: '_FinancialInstrProdType'
      FinancialTransactionTable.sgsart                                                           as FinancialInstrumentProductType,
      @ObjectModel.foreignKey.association: '_FinInstrTransCat'
      FinancialTransactionTable.sfgtyp                                                           as FinInstrTransactionCategory,
      @ObjectModel.foreignKey.association: '_FinancialInstrTransType'
      cast(FinancialTransactionTable.sfhaart as ftr_gen_transaction_type preserving type)        as FinancialInstrTransactionType,
      @ObjectModel.foreignKey.association: '_ProcessingCategory'
      FinancialTransactionTable.abwtyp                                                           as FinTransProcessingCategory,

      FinancialTransactionTable.dblfz                                                            as TermStartDate,
      cast(FinancialTransactionTable.sinclbe as abap_boolean preserving type )                   as TermStartDateIsInclusive,
      FinancialTransactionTable.akuend                                                           as FinTransNoticePeriod,
      @ObjectModel.foreignKey.association: '_NoticePeriodUnit'
      FinancialTransactionTable.skuend                                                           as FinTransNoticePeriodUnit,
      @ObjectModel.foreignKey.association: '_Calendar'
      FinancialTransactionTable.skalid                                                           as FinTransFactoryCalendar1,
      @EndUserText.label: 'Calendar 2'
      @EndUserText.quickInfo: 'Calendar 2'
      @ObjectModel.foreignKey.association: '_Calendar2'
      FinancialTransactionTable.skalid2                                                          as FinTransFactoryCalendar2,
      @ObjectModel.foreignKey.association: '_Counterparty'
      cast(FinancialTransactionTable.kontrh   as rkontrah_new preserving type)                   as Counterparty,
      @ObjectModel.foreignKey.association: '_Guarantor'
      FinancialTransactionTable.rgarant                                                          as FinancialInstrumentGuarantor,
      
      @ObjectModel.foreignKey.association: '_Portfolio'
      FinancialTransactionTable.rportb                                                           as Portfolio,
      FinancialTransactionTable.zuonr                                                            as TreasuryFinanceProject,
      @ObjectModel.foreignKey.association: '_Assignment'
      cast(FinancialTransactionTable.zuond    as ftr_gen_fin_instr_assignment preserving type)   as FinancialInstrumentAssignment,
      @ObjectModel.foreignKey.association: '_Reference'
      cast(FinancialTransactionTable.refer    as ftr_gen_fin_instr_internal_ref preserving type) as FinancialInstrumentReference,
      @ObjectModel.foreignKey.association: '_Characteristics'
      cast(FinancialTransactionTable.merkm    as ftr_gen_fin_instr_char preserving type)         as FinancialInstrCharacteristic,
      @ObjectModel.foreignKey.association: '_ValuationClass'
      FinancialTransactionTable.rcomvalcl                                                        as TreasuryValuationClass,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      FinancialTransactionTable.rbusa                                                            as BusinessArea,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      _CompanyCode.ControllingArea                                                               as ControllingArea,
      @ObjectModel.foreignKey.association: '_CostCenter_2'
      FinancialTransactionTable.rcntr                                                            as CostCenter,
      @ObjectModel.foreignKey.association: '_TreasuryHedgingClassfctn'
      FinancialTransactionTable.hedge_class                                                      as HedgingClassification,

      cast( FinancialTransactionTable.hedge_request_id as hedge_request_identifier preserving type )
                                                                                                 as HedgeRequestIdentifier,
      @ObjectModel.foreignKey.association: '_ProfitCenter_2'
      FinancialTransactionTable.prctr                                                            as ProfitCenter,
      @ObjectModel.foreignKey.association: '_WBSElement'
      cast(FinancialTransactionTable.ps_posid as ps_s4_pspnr preserving type )                   as WBSElementInternalID,
      @ObjectModel.foreignKey.association: '_FacilityCompanyCode'
      FinancialTransactionTable.facilitybukrs                                                    as TreasuryFacilityCompanyCode,
      FinancialTransactionTable.facilitynr                                                       as TreasuryFacility,

      @ObjectModel.foreignKey.association: '_Status'
      FinancialTransactionTable.saktiv                                                           as FinancialInstrumentStatus,
      @ObjectModel.foreignKey.association: '_ReleaseStatus'
      FinancialTransactionTable.sfrgzust                                                         as FinTransReleaseStatus,
      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode: true
      FinancialTransactionTable.wgschft                                                          as TransactionCurrency,
      @ObjectModel.foreignKey.association: '_OutgoingCurrency'
      @Semantics.currencyCode: true
      FinancialTransactionTable.wgschft1                                                         as FinInstrumentOutgoingCurrency,
      @ObjectModel.foreignKey.association: '_IncomingCurrency'
      @Semantics.currencyCode: true
      FinancialTransactionTable.wgschft2                                                         as FinInstrumentIncomingCurrency,
      @ObjectModel.foreignKey.association: '_TradedCurrency'
      @Semantics.currencyCode: true
      FinancialTransactionTable.traded_currency                                                  as TradedCurrency,
      @ObjectModel.foreignKey.association: '_SecurityClass'
      cast(FinancialTransactionTable.ranl     as ftr_gen_security_class preserving type)         as SecurityClass,
      FinancialTransactionTable.isin                                                             as SecurityClassIntlScrtyIdnNmbr,
      FinancialTransactionTable.cfi_code                                                         as ClassificationOfFinInstr,
      @ObjectModel.foreignKey.association: '_SecurityAccount'
      cast(FinancialTransactionTable.rldepo   as ftr_gen_security_account preserving type)       as SecurityAccount,
      @ObjectModel.foreignKey.association: '_FuturesAccount'
      FinancialTransactionTable.posacc                                                           as FuturesAccount,
      
      @ObjectModel.foreignKey.association: '_CentralClearingOption'
      FinancialTransactionTable.clearing_option                                                  as FinTransCentralClearingOption,
      @ObjectModel.foreignKey.association: '_CentralClearingStatus'
      FinancialTransactionTable.clearing_status                                                  as FinTransCentralClearingStatus,
      FinancialTransactionTable.clearing_date                                                    as FinTransCentralClearingDate,
      FinancialTransactionTable.clear_date_act                                                   as FinTransCntrlClrgActualDate,
      //foreign key association cannot be used as central clearing account has key UUID

      //@ObjectModel.foreignKey.association: '_CentralClearingAccount'

      FinancialTransactionTable.ext_account                                                      as CentralClearingAccount,
      FinancialTransactionTable.risk_mitigating                                                  as FinTransIsRiskMitigating,
      
//field should be not provided, this should be part of activities

      cast(FinancialTransactionTable.rfhazul as ftr_gen_fin_instr_last_act_act preserving type)  as FinInstrLastActiveActivity,
//field should be not provided, this is filled inconsistent; alternative provide end date of last activity

      FinancialTransactionTable.delfz                                                            as TermEndDate,
      
      case FinancialTransactionTable.amtinput 
        when '1' then cast ('S' as ttm_fx_buy_sell)
        when '2' then cast ('B' as ttm_fx_buy_sell) 
      end                                                                                        as TrsyTradedAmountBuySellCode,
      
      FinancialTransactionTable.fb_segment                                                       as Segment,
      FinancialTransactionTable.behalf_of_company                                                as OnBehalfOfCompany,
      
      FinancialTransactionTable.mic                                                              as MarketIdentifierCode,
      FinancialTransactionTable.srndng                                                           as FinTransRoundingCategory,
      FinancialTransactionTable.rcomvalcl                                                        as FinTransGeneralValuationClass,
      FinancialTransactionTable.fund                                                             as Fund,
      FinancialTransactionTable.grant_nbr                                                        as GrantID,
      FinancialTransactionTable.tbegru                                                           as FinTransAuthorizationGroup,
      FinancialTransactionTable.bupla                                                            as BusinessPlace,
      FinancialTransactionTable.fkber                                                            as FunctionalArea,
      FinancialTransactionTable.custom_diff_term_1                                               as TrsyPosCustomDiffntnTerm1,
      FinancialTransactionTable.custom_diff_term_2                                               as TrsyPosCustomDiffntnTerm2,
      FinancialTransactionTable.custom_diff_term_3                                               as TrsyPosCustomDiffntnTerm3,
      FinancialTransactionTable.custom_diff_term_4                                               as TrsyPosCustomDiffntnTerm4,
      FinancialTransactionTable.custom_diff_term_5                                               as TrsyPosCustomDiffntnTerm5,
      
      

//exposed dimensions, containing for example text fields

      _CompanyCode,
      _ContractType,
      _FinancialInstrProdCat,
      _FinancialInstrProdType,
      _FinInstrTransCat,
      _FinancialInstrTransType,
      _ProcessingCategory,
      _NoticePeriodUnit,
      _Calendar,
      _Calendar2,
      _Counterparty,
      _Guarantor,
      _Portfolio,
      _Assignment,
      _Reference,
      _Characteristics,
      _ValuationClass,
      _ControllingArea,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    '_CostCenter_2'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  '_CostCenter_2'
      _CostCenter,
      _CostCenter_2,
      _BusinessArea,
      _TreasuryHedgingClassfctn,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    '_ProfitCenter_2'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  '_ProfitCenter_2'
      _ProfitCenter,
      _ProfitCenter_2,
      _WBSElement,
      _FacilityCompanyCode,
      _Status,
      _ReleaseStatus,
      _Currency,
      _OutgoingCurrency,
      _IncomingCurrency,
      _TradedCurrency,
      _SecurityClass,
      _SecurityAccount,
      _FuturesAccount,
      _CentralClearingOption,
      _CentralClearingStatus,
      _CentralClearingAccount,

//exposed associations for VDM

      _ContractActivity,
      _CurrentActivity,
      _Security,
      _Interest,
      _Nominal,
      _TabActivity,
      _TabFlow,
      _TabCondition,
      
//should not be used anymore, instead use _CurrentActivity

      _LetterOfCredit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"VTBFHA"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_BUSINESSPARTNER",
"I_CENTRALCLEARINGACCOUNT",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_CURRENCY",
"I_FACTORYCALENDAR",
"I_FINANCIALINSTRASSIGNMENT",
"I_FINANCIALINSTRCHARACTERISTIC",
"I_FINANCIALINSTRPRODCAT",
"I_FINANCIALINSTRPRODUCTTYPE",
"I_FINANCIALINSTRREFERENCE",
"I_FINANCIALINSTRTRANSTYPE",
"I_FINANCIALINSTRVALUATIONCLASS",
"I_FININSTRTRANSCAT",
"I_FININSTRUMENTSTATUS",
"I_FINTRANSACTIVITY",
"I_FINTRANSCNTRLCLRGOPTION",
"I_FINTRANSCNTRLCLRGSTATUS",
"I_FINTRANSCONDITION",
"I_FINTRANSCONTRACTACTIVITY",
"I_FINTRANSFLOW",
"I_FINTRANSINTEREST",
"I_FINTRANSNOMINAL",
"I_FINTRANSNOTICEPERIODUNIT",
"I_FINTRANSPROCGCATEGORY",
"I_FINTRANSRELEASESTATUS",
"I_FINTRANSSECURITY",
"I_LETTEROFCREDIT",
"I_PROFITCENTER",
"I_SECURITYACCOUNT",
"I_SECURITYCLASS",
"I_TREASURYCONTRACTTYPE",
"I_TREASURYHEDGINGCLASSFCTN",
"I_TREASURYPORTFOLIO",
"I_TREASURYPOSITIONACCOUNT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/