I_FinancialTransaction
Financial Transaction
I_FinancialTransaction is a Basic CDS View (Dimension) that provides data about "Financial Transaction" in SAP S/4HANA. It reads from 1 data source (vtbfha) and exposes 119 fields with key fields CompanyCode, FinancialTransaction. It has 47 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| vtbfha | FinancialTransactionTable | from |
Associations (47)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..1] | I_TreasuryContractType | _ContractType | $projection.TreasuryContractType = _ContractType.TreasuryContractType |
| [0..1] | I_FinancialInstrProdCat | _FinancialInstrProdCat | $projection.FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory |
| [0..1] | I_FinancialinstrProductType | _FinancialInstrProdType | $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType |
| [0..1] | I_FinInstrTransCat | _FinInstrTransCat | $projection.FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory |
| [1..1] | I_FinancialInstrTransType | _FinancialInstrTransType | $projection.FinancialInstrTransactionType = _FinancialInstrTransType.FinancialInstrTransactionType and $projection.FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType |
| [0..1] | I_FinTransProcgCategory | _ProcessingCategory | $projection.FinancialInstrProductCategory = _ProcessingCategory.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _ProcessingCategory.FinInstrTransactionCategory and $projection.FinTransProcessingCategory = _ProcessingCategory.FinTransProcessingCategory |
| [0..1] | I_FinTransNoticePeriodUnit | _NoticePeriodUnit | $projection.FinTransNoticePeriodUnit = _NoticePeriodUnit.FinTransNoticePeriodUnit |
| [0..1] | I_FactoryCalendar | _Calendar | $projection.FinTransFactoryCalendar1 = _Calendar.FactoryCalendar |
| [0..1] | I_FactoryCalendar | _Calendar2 | $projection.FinTransFactoryCalendar2 = _Calendar2.FactoryCalendar |
| [1..1] | I_BusinessPartner | _Counterparty | $projection.Counterparty = _Counterparty.BusinessPartner |
| [0..1] | I_BusinessPartner | _Guarantor | $projection.FinancialInstrumentGuarantor = _Guarantor.BusinessPartner |
| [0..1] | I_TreasuryPortfolio | _Portfolio | $projection.CompanyCode = _Portfolio.CompanyCode and $projection.Portfolio = _Portfolio.Portfolio |
| [0..1] | I_FinancialInstrAssignment | _Assignment | $projection.FinancialInstrumentAssignment = _Assignment.FinancialInstrumentAssignment |
| [0..1] | I_FinancialInstrReference | _Reference | $projection.FinancialInstrumentReference = _Reference.FinancialInstrumentReference |
| [0..1] | I_FinancialInstrCharacteristic | _Characteristics | $projection.FinancialInstrCharacteristic = _Characteristics.FinancialInstrCharacteristic |
| [0..1] | I_Financialinstrvaluationclass | _ValuationClass | $projection.TreasuryValuationClass = _ValuationClass.FinancialInstrValuationClass |
| [0..1] | I_BusinessArea | _BusinessArea | $projection.BusinessArea = _BusinessArea.BusinessArea |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..*] | I_CostCenter | _CostCenter | $projection.CompanyCode = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter |
| [0..*] | I_CostCenter | _CostCenter_2 | $projection.ControllingArea = _CostCenter_2.ControllingArea and $projection.CostCenter = _CostCenter_2.CostCenter |
| [0..1] | I_TreasuryHedgingClassfctn | _TreasuryHedgingClassfctn | $projection.HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification |
| [0..*] | I_ProfitCenter | _ProfitCenter | $projection.CompanyCode = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter |
| [0..*] | I_ProfitCenter | _ProfitCenter_2 | $projection.ControllingArea = _ProfitCenter_2.ControllingArea and $projection.ProfitCenter = _ProfitCenter_2.ProfitCenter |
| [0..1] | I_WBSElementBasicData | _WBSElement | $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID |
| [0..1] | I_CompanyCode | _FacilityCompanyCode | $projection.TreasuryFacilityCompanyCode = _FacilityCompanyCode.CompanyCode |
| [0..1] | I_FinInstrumentStatus | _Status | $projection.FinancialInstrumentStatus = _Status.FinancialInstrumentStatus |
| [0..1] | I_FinTransReleaseStatus | _ReleaseStatus | $projection.FinTransReleaseStatus = _ReleaseStatus.FinTransReleaseStatus |
| [0..1] | I_Currency | _Currency | $projection.TransactionCurrency = _Currency.Currency |
| [0..1] | I_Currency | _OutgoingCurrency | $projection.FinInstrumentOutgoingCurrency = _OutgoingCurrency.Currency |
| [0..1] | I_Currency | _IncomingCurrency | $projection.FinInstrumentIncomingCurrency = _IncomingCurrency.Currency |
| [0..1] | I_Currency | _TradedCurrency | $projection.TradedCurrency = _TradedCurrency.Currency |
| [0..1] | I_SecurityClass | _SecurityClass | $projection.SecurityClass = _SecurityClass.SecurityClass |
| [0..1] | I_SecurityAccount | _SecurityAccount | $projection.SecurityAccount = _SecurityAccount.SecurityAccount and $projection.CompanyCode = _SecurityAccount.CompanyCode |
| [0..1] | I_TreasuryPositionAccount | _FuturesAccount | $projection.CompanyCode = _FuturesAccount.CompanyCode and $projection.FuturesAccount = _FuturesAccount.TreasuryPositionAccount |
| [0..1] | I_FinTransCntrlClrgOption | _CentralClearingOption | $projection.FinTransCentralClearingOption = _CentralClearingOption.FinTransCentralClearingOption |
| [0..1] | I_FinTransCntrlClrgStatus | _CentralClearingStatus | $projection.FinTransCentralClearingStatus = _CentralClearingStatus.FinTransCentralClearingStatus |
| [0..*] | I_CentralClearingAccount | _CentralClearingAccount | $projection.CompanyCode = _CentralClearingAccount.CompanyCode and $projection.CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount |
| [0..*] | I_FinTransContractActivity | _ContractActivity | $projection.CompanyCode = _ContractActivity.CompanyCode and $projection.FinancialTransaction = _ContractActivity.FinancialTransaction |
| [0..1] | I_FinTransActivity | _CurrentActivity | $projection.CompanyCode = _CurrentActivity.CompanyCode and $projection.FinancialTransaction = _CurrentActivity.FinancialTransaction and $projection.FinInstrLastActiveActivity = _CurrentActivity.FinancialInstrumentActivity |
| [0..1] | I_FinTransSecurity | _Security | $projection.CompanyCode = _Security.CompanyCode and $projection.FinancialTransaction = _Security.FinancialTransaction |
| [0..*] | I_FinTransInterest | _Interest | $projection.CompanyCode = _Interest.CompanyCode and $projection.FinancialTransaction = _Interest.FinancialTransaction |
| [0..*] | I_FinTransNominal | _Nominal | $projection.CompanyCode = _Nominal.CompanyCode and $projection.FinancialTransaction = _Nominal.FinancialTransaction |
| [0..*] | I_FinTransActivity | _TabActivity | $projection.CompanyCode = _TabActivity.CompanyCode and $projection.FinancialTransaction = _TabActivity.FinancialTransaction |
| [0..*] | I_FinTransFlow | _TabFlow | $projection.CompanyCode = _TabFlow.CompanyCode and $projection.FinancialTransaction = _TabFlow.FinancialTransaction |
| [0..*] | I_FinTransCondition | _TabCondition | $projection.CompanyCode = _TabCondition.CompanyCode and $projection.FinancialTransaction = _TabCondition.FinancialTransaction |
| [0..1] | I_LetterOfCredit | _LetterOfCredit | $projection.CompanyCode = _LetterOfCredit.CompanyCode and $projection.FinancialTransaction = _LetterOfCredit.FinancialTransaction and $projection.FinInstrLastActiveActivity = _LetterOfCredit.FinancialInstrumentActivity |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.sqlViewName | IFINTRAN | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.internalName | #LOCAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Financial Transaction | view | |
| ObjectModel.representativeKey | FinancialTransaction | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #BASIC | view |
Fields (119)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | vtbfha | bukrs | |
| KEY | FinancialTransaction | vtbfha | rfha | |
| TreasuryFinancialObject | vtbfha | objnr | ||
| CreatedByUser | vtbfha | cruser | ||
| FinTransCreationDate | ||||
| FinTransCreationTime | vtbfha | tcrtim | ||
| LastChangedByUser | ||||
| LastChangeDate | vtbfha | dupdat | ||
| FinInstrumentLastChangedTime | vtbfha | tuptim | ||
| TreasuryContractType | vtbfha | rantyp | ||
| FinancialInstrProductCategory | ||||
| FinancialInstrumentProductType | vtbfha | sgsart | ||
| FinInstrTransactionCategory | vtbfha | sfgtyp | ||
| FinancialInstrTransactionType | ||||
| FinTransProcessingCategory | vtbfha | abwtyp | ||
| TermStartDate | vtbfha | dblfz | ||
| TermStartDateIsInclusive | ||||
| FinTransNoticePeriod | vtbfha | akuend | ||
| FinTransNoticePeriodUnit | vtbfha | skuend | ||
| FinTransFactoryCalendar1 | vtbfha | skalid | ||
| FinTransFactoryCalendar2 | vtbfha | skalid2 | Calendar 2 | |
| Counterparty | ||||
| FinancialInstrumentGuarantor | vtbfha | rgarant | ||
| Portfolio | vtbfha | rportb | ||
| TreasuryFinanceProject | vtbfha | zuonr | ||
| FinancialInstrumentAssignment | ||||
| FinancialInstrumentReference | ||||
| FinancialInstrCharacteristic | ||||
| TreasuryValuationClass | vtbfha | rcomvalcl | ||
| BusinessArea | vtbfha | rbusa | ||
| ControllingArea | _CompanyCode | ControllingArea | ||
| CostCenter | vtbfha | rcntr | ||
| HedgingClassification | vtbfha | hedge_class | ||
| HedgeRequestIdentifier | ||||
| ProfitCenter | vtbfha | prctr | ||
| WBSElementInternalID | ||||
| TreasuryFacilityCompanyCode | vtbfha | facilitybukrs | ||
| TreasuryFacility | vtbfha | facilitynr | ||
| FinancialInstrumentStatus | vtbfha | saktiv | ||
| FinTransReleaseStatus | vtbfha | sfrgzust | ||
| TransactionCurrency | vtbfha | wgschft | ||
| FinInstrumentOutgoingCurrency | vtbfha | wgschft1 | ||
| FinInstrumentIncomingCurrency | vtbfha | wgschft2 | ||
| TradedCurrency | vtbfha | traded_currency | ||
| SecurityClass | ||||
| SecurityClassIntlScrtyIdnNmbr | vtbfha | isin | ||
| ClassificationOfFinInstr | vtbfha | cfi_code | ||
| SecurityAccount | ||||
| FuturesAccount | vtbfha | posacc | ||
| FinTransCentralClearingOption | vtbfha | clearing_option | ||
| FinTransCentralClearingStatus | vtbfha | clearing_status | ||
| FinTransCentralClearingDate | vtbfha | clearing_date | ||
| FinTransCntrlClrgActualDate | vtbfha | clear_date_act | ||
| CentralClearingAccount | vtbfha | ext_account | ||
| FinTransIsRiskMitigating | vtbfha | risk_mitigating | ||
| FinInstrLastActiveActivity | ||||
| TermEndDate | vtbfha | delfz | ||
| Segment | vtbfha | fb_segment | ||
| OnBehalfOfCompany | vtbfha | behalf_of_company | ||
| MarketIdentifierCode | vtbfha | mic | ||
| FinTransRoundingCategory | vtbfha | srndng | ||
| FinTransGeneralValuationClass | vtbfha | rcomvalcl | ||
| Fund | vtbfha | fund | ||
| GrantID | vtbfha | grant_nbr | ||
| FinTransAuthorizationGroup | vtbfha | tbegru | ||
| BusinessPlace | vtbfha | bupla | ||
| FunctionalArea | vtbfha | fkber | ||
| TrsyPosCustomDiffntnTerm1 | vtbfha | custom_diff_term_1 | ||
| TrsyPosCustomDiffntnTerm2 | vtbfha | custom_diff_term_2 | ||
| TrsyPosCustomDiffntnTerm3 | vtbfha | custom_diff_term_3 | ||
| TrsyPosCustomDiffntnTerm4 | vtbfha | custom_diff_term_4 | ||
| TrsyPosCustomDiffntnTerm5 | vtbfha | custom_diff_term_5 | ||
| _CompanyCode | _CompanyCode | |||
| _ContractType | _ContractType | |||
| _FinancialInstrProdCat | _FinancialInstrProdCat | |||
| _FinancialInstrProdType | _FinancialInstrProdType | |||
| _FinInstrTransCat | _FinInstrTransCat | |||
| _FinancialInstrTransType | _FinancialInstrTransType | |||
| _ProcessingCategory | _ProcessingCategory | |||
| _NoticePeriodUnit | _NoticePeriodUnit | |||
| _Calendar | _Calendar | |||
| _Calendar2 | _Calendar2 | |||
| _Counterparty | _Counterparty | |||
| _Guarantor | _Guarantor | |||
| _Portfolio | _Portfolio | |||
| _Assignment | _Assignment | |||
| _Reference | _Reference | |||
| _Characteristics | _Characteristics | |||
| _ValuationClass | _ValuationClass | |||
| _ControllingArea | _ControllingArea | |||
| _CostCenter | _CostCenter | |||
| _CostCenter_2 | _CostCenter_2 | |||
| _BusinessArea | _BusinessArea | |||
| _TreasuryHedgingClassfctn | _TreasuryHedgingClassfctn | |||
| _ProfitCenter | _ProfitCenter | |||
| _ProfitCenter_2 | _ProfitCenter_2 | |||
| _WBSElement | _WBSElement | |||
| _FacilityCompanyCode | _FacilityCompanyCode | |||
| _Status | _Status | |||
| _ReleaseStatus | _ReleaseStatus | |||
| _Currency | _Currency | |||
| _OutgoingCurrency | _OutgoingCurrency | |||
| _IncomingCurrency | _IncomingCurrency | |||
| _TradedCurrency | _TradedCurrency | |||
| _SecurityClass | _SecurityClass | |||
| _SecurityAccount | _SecurityAccount | |||
| _FuturesAccount | _FuturesAccount | |||
| _CentralClearingOption | _CentralClearingOption | |||
| _CentralClearingStatus | _CentralClearingStatus | |||
| _CentralClearingAccount | _CentralClearingAccount | |||
| _ContractActivity | _ContractActivity | |||
| _CurrentActivity | _CurrentActivity | |||
| _Security | _Security | |||
| _Interest | _Interest | |||
| _Nominal | _Nominal | |||
| _TabActivity | _TabActivity | |||
| _TabFlow | _TabFlow | |||
| _TabCondition | _TabCondition | |||
| _LetterOfCredit | _LetterOfCredit |
// 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA